|
The Arts in Wyoming |
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='5837b9131f530031b60bcaca9e3762b4' and c.state_id = '83ab39cfa2c80523905c9eb454cf5b4e'
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))
| |
