|
Trek Food in Indiana |
Categories
SELECT DISTINCT SC.subcategory_id, SC.subcategory_name
FROM subcategories SC, listing_subcategories ls, cities c
LEFT JOIN listings l ON l.listing_id = ls.listing_id
LEFT JOIN city_listing_assoc cl ON cl.listing_id = ls.listing_Id
WHERE SC.category_id='47abd52ce425912b1990fc325cc613c5' and c.state_id = '3e5dc7cc6205e02028cfe8dce95f0e7c'
AND ls.subcategory_id = SC.subcategory_id AND
((cl.listing_id=ls.listing_id AND cl.city_Id = c.city_id)
OR (l.listing_id=ls.listing_id AND l.city_id = c.city_id))
| |