Property List
QUERY: SELECT `propertyID`, `Ownername`, `phonenumber`, `type`, `address`, `street`, `city`, `state`, `zip`, `email`, `propertyids`, `agent`, `staffphone`, `branch`, `title`, `statustype`, `description`, `category`, `propertytype`, `Area`, `unit`, `bathrooms`, `floor`, `furnished`, `bhk`, `plotarea`, `emailaddress`, `latitude`, `location`, `longitude`, `ageofproperty`, `premiumorhot`, `price`,(3956 * 2 * ASIN(SQRT( POWER(SIN(( - latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(latitude * pi()/180) * POWER(SIN(( - longitude) * pi()/180 / 2), 2) ))) as distance FROM bigproperties where propertyID > 0 and approved=1 and price between '0' and '500000000' and category='Residential' having distance <= 20 order by distance LIMIT 10 OFFSET 0
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 '* pi()/180) * COS(latitude * pi()/180) * POWER(SIN(( - longitude) * pi()/180 / ' at line 1
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 '* pi()/180) * COS(latitude * pi()/180) * POWER(SIN(( - longitude) * pi()/180 / ' at line 1