Home Page | Home Search |
select latitude, longitude, subdivision, county, mlsno, addrnum, nsew, addrname, street_suffix, streetdirsuffix, unit, city, state, zip, url from ntreis_homes_similar left join latitude_longitude on (mlsno=mls_number_lat) left join ntreis_images on (ntreis_homes_similar.matrix_unique_id=ntreis_images.mls_no and ntreis_images.photonum='1') where mlsno='20600082' SELECT *, min(3956 * 2 * ASIN(SQRT( POWER(SIN(( -abs( lat)) * pi()/180 / 2),2) + COS(32 * pi()/180 ) * COS( abs(lat) * pi()/180) * POWER(SIN(( - lng) * pi()/180 / 2), 2) ))) as distance FROM login, address, specialties, mls where username=agent_username and mls=which_mls and mls_state='' and () and username=address_username and active='yes' group by address_username ORDER BY distance limit 1
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') and username=address_username and active='yes' group by address_username OR...' at line 1 in /sites/default/data/ntreis/agents_property_request.htm:131
Stack trace:
#0 /sites/default/data/ntreis/agents_property_request.htm(131): mysqli_query()
#1 /sites/default/data/ntreis/property_request.asp(79): include('...')
#2 {main}
thrown in /sites/default/data/ntreis/agents_property_request.htm on line 131