|
Lines 1884-1890
sub check_routing {
Link Here
|
| 1884 |
my $sth = $dbh->prepare( |
1884 |
my $sth = $dbh->prepare( |
| 1885 |
"SELECT count(routingid) routingids FROM subscription LEFT JOIN subscriptionroutinglist |
1885 |
"SELECT count(routingid) routingids FROM subscription LEFT JOIN subscriptionroutinglist |
| 1886 |
ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid |
1886 |
ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid |
| 1887 |
WHERE subscription.subscriptionid = ? ORDER BY ranking ASC |
1887 |
WHERE subscription.subscriptionid = ? GROUP BY routingid ORDER BY ranking ASC |
| 1888 |
" |
1888 |
" |
| 1889 |
); |
1889 |
); |
| 1890 |
$sth->execute($subscriptionid); |
1890 |
$sth->execute($subscriptionid); |
| 1891 |
- |
|
|