<br />
<b>Fatal error</b>:  <p>Query error</p><p>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 '*,
(3693 - 13 * SIN(RADIANS('0.000000'))) * 2 * ASIN(LEAST(1, SQRT(POW(SIN((RADI' at line 4</p><p><code>SELECT
SQL_CALC_FOUND_ROWS
*,
*,
(3693 - 13 * SIN(RADIANS('0.000000'))) * 2 * ASIN(LEAST(1, SQRT(POW(SIN((RADIANS('0.000000') - RADIANS(property.latitude))/2), 2) + COS(RADIANS(property.latitude)) * COS(RADIANS('0.000000')) * POW(SIN((RADIANS('0.000000') - RADIANS(property.longitude))/2), 2)))) AS distance
FROM property
INNER JOIN property_propertyCategory ON property.id = property_propertyCategory.property
INNER JOIN propertyCategory ON property_propertyCategory.propertyCategory = propertyCategory.id
WHERE (property.active = 'Yes' && property.saleStatus != 'Sold')
AND (propertyCategory.active = 'Yes')
AND (property.id != '31')
AND (property.latitude != 0 AND property.longitude != 0)
GROUP BY property.id
ORDER BY distance,
property.name
LIMIT 200</code>< in <b>/usr/home/commint/websites/provincetownrealestate.com/common/include/framework/cxError.php.inc</b> on line <b>18</b><br />