 |
We are currently building this section. Check back soon.
SELECT subscriptions.productid, subscriptions.subscription_enddate, Customer.Name, Customer.AltContact, dir_cats.dircat_name, dir_cats.dircat_ID
FROM ((dir_cats INNER JOIN dir_links ON dir_cats.dircat_id = dir_links.dircat_id) INNER JOIN dir_users ON dir_links.diruser_id = dir_users.diruser_id) INNER JOIN ((subscriptions INNER JOIN merchants ON subscriptions.merchantid = merchants.merchantid) INNER JOIN Customer ON merchants.listid = Customer.ListID) ON dir_users.merchantid = merchants.merchantid
WHERE (((subscriptions.productid)=9) AND ((subscriptions.subscription_enddate)>{ts '2008-08-27 17:54:16'}) AND ((Customer.AltContact) Is Not Null) AND ((merchants.merchant_active)=1))
ORDER BY dir_cats.dircat_name, Customer.Name;
|
|
