|
Community Interest in West Virginia |
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='180d5217f49e7d51917a5fbcf9c2a546' and c.state_id = '783789a8fe36cb174d61049f8a4704d4'
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))
| |
