쿼리문 |
select *, (6371 * acos(cos(radians(37.566826005485716)) * cos(radians(`wr_lat`)) * cos(radians(`wr_lng`) - radians(126.9786567859313)) + sin(radians(37.566826005485716)) * sin(radians(`wr_lat`)))) as map_distance from snow_shop where 1 and `wr_view`=1 and is_delete=0 and (`wr_company` like \'%\\\') UNION ALL SELECT NULL#%\' or `wr_area` like \'%\\\') UNION ALL SELECT NULL#%\' or `wr_subject` like \'%\\\') UNION ALL SELECT NULL#%\' or replace(`wr_phone`,\'-\',\'\') like \'%\') UNION ALL SELECT NULL#%\') and `wr_service_good_pay`>=curdate() order by map_distance asc limit 0, 15 |