Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND LCASE(pa.StreetName) = 'hainford' AND LCASE(pa.City) = 'toronto') AND pa.Pro' at line 18<br />Error No: 1064<br />SELECT
*,
pd.Property_ID,
pd.ParkingSpaceTotal,
IF(n.parent != 0,(SELECT IF(nickname != '',nickname,name) as neighbourhood FROM neighbourhood WHERE neighbourhood_id = n.parent),IF(n.nickname != '',n.nickname,n.name)) as neighbourhood
FROM
`sync_propertyDetails` pd
LEFT JOIN
`sync_property_address` pa ON (pd.Property_ID = pa.Property_ID)
LEFT JOIN
`neighbourhood` n ON (n.neighbourhood_id = pa.neighbourhood_id)
LEFT JOIN
`sync_property_building` pb ON (pd.Property_ID = pb.Property_ID)
LEFT JOIN
`sync_property_agent` pag ON (pd.Property_ID = pag.Property_ID)
LEFT JOIN
`sync_parking` p ON (pd.Property_ID = p.Property_ID)
WHERE 1=1 AND AND LCAS in /home/thearms1/public_html/system/library/db/mysqli.php on line 40