|
DISCOUNTS in Massachusetts |
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='cea1b1fa63583f764c6a6dd88d48ec6a' and c.state_id = 'd429907f8fad8de61eed79786629c962'
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))
| |
