invalid - SELECT DISTINCT c.Region, c.City, p.City AS ActiveCity, p.Region AS ActiveRegion FROM Cities AS c LEFT OUTER JOIN Property_Listing AS p ON p.Region LIKE CONCAT(c.Region, '%') AND c.City = p.City ORDER BY c.Region, c.City
invalid - SELECT * FROM Property_Listing WHERE Property_Listing_ID='182'