|
Lodging / Camping in Missouri |
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='f0b2d74c8894e318ebc3347cd5d81d61' and c.state_id = '635734df042abcd4a24b60d66dcd5460'
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))
| |
