IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:08; TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 2:0:0'),ci.imei, ev.`addr`, ev.`GeoX`, ev.`GeoY` from tms_events ev left join wm_car_info ci on ev.deviceloginname=ci.imei where ev.deviceloginname in (2973) AND ev.date>='2024-02-04 22:00:00' AND ev.date<='2024-02-08 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:14; TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 2:0:0'),ci.imei, ev.`addr`, ev.`GeoX`, ev.`GeoY` from tms_events ev left join wm_car_info ci on ev.deviceloginname=ci.imei where ev.deviceloginname in (2973) AND ev.date>='2024-02-04 22:00:00' AND ev.date<='2024-02-08 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:32; TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 2:0:0'),ci.imei, ev.`addr`, ev.`GeoX`, ev.`GeoY` from tms_events ev left join wm_car_info ci on ev.deviceloginname=ci.imei where ev.deviceloginname in (2535) AND ev.date>='2024-02-04 22:00:00' AND ev.date<='2024-02-08 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:33; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49541/57.2958) + COS(GeoX/57.2958) * COS(34.49541/57.2958) * COS(49.54028/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:34; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.09811/57.2958) + COS(GeoX/57.2958) * COS(34.09811/57.2958) * COS(49.5818/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:35; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.64044/57.2958) + COS(GeoX/57.2958) * COS(33.64044/57.2958) * COS(49.96365/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:35; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.62934/57.2958) + COS(GeoX/57.2958) * COS(33.62934/57.2958) * COS(49.96357/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:36; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61599/57.2958) + COS(GeoX/57.2958) * COS(33.61599/57.2958) * COS(49.96104/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:37; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.618/57.2958) + COS(GeoX/57.2958) * COS(33.618/57.2958) * COS(49.96207/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:37; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61852/57.2958) + COS(GeoX/57.2958) * COS(33.61852/57.2958) * COS(49.96407/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:38; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61213/57.2958) + COS(GeoX/57.2958) * COS(33.61213/57.2958) * COS(49.96534/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:38; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61137/57.2958) + COS(GeoX/57.2958) * COS(33.61137/57.2958) * COS(49.9659/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:39; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60669/57.2958) + COS(GeoX/57.2958) * COS(33.60669/57.2958) * COS(49.96606/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:40; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60583/57.2958) + COS(GeoX/57.2958) * COS(33.60583/57.2958) * COS(49.96605/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:40; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60049/57.2958) + COS(GeoX/57.2958) * COS(33.60049/57.2958) * COS(49.97891/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:41; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61211/57.2958) + COS(GeoX/57.2958) * COS(33.61211/57.2958) * COS(49.97423/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:41; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61317/57.2958) + COS(GeoX/57.2958) * COS(33.61317/57.2958) * COS(49.96103/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:42; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61581/57.2958) + COS(GeoX/57.2958) * COS(33.61581/57.2958) * COS(49.96101/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:42; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61256/57.2958) + COS(GeoX/57.2958) * COS(33.61256/57.2958) * COS(49.95433/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:43; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49561/57.2958) + COS(GeoX/57.2958) * COS(34.49561/57.2958) * COS(49.54099/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:44; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49547/57.2958) + COS(GeoX/57.2958) * COS(34.49547/57.2958) * COS(49.54108/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:44; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49589/57.2958) + COS(GeoX/57.2958) * COS(34.49589/57.2958) * COS(49.54116/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:45; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49473/57.2958) + COS(GeoX/57.2958) * COS(34.49473/57.2958) * COS(49.5393/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:45; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.38692/57.2958) + COS(GeoX/57.2958) * COS(34.38692/57.2958) * COS(49.58109/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:46; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.62364/57.2958) + COS(GeoX/57.2958) * COS(33.62364/57.2958) * COS(49.93988/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:46; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.62045/57.2958) + COS(GeoX/57.2958) * COS(33.62045/57.2958) * COS(49.94975/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:47; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.62848/57.2958) + COS(GeoX/57.2958) * COS(33.62848/57.2958) * COS(49.94987/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:48; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.62412/57.2958) + COS(GeoX/57.2958) * COS(33.62412/57.2958) * COS(49.95219/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:48; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61673/57.2958) + COS(GeoX/57.2958) * COS(33.61673/57.2958) * COS(49.954/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:49; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61255/57.2958) + COS(GeoX/57.2958) * COS(33.61255/57.2958) * COS(49.95434/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:49; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61232/57.2958) + COS(GeoX/57.2958) * COS(33.61232/57.2958) * COS(49.96146/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:50; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60677/57.2958) + COS(GeoX/57.2958) * COS(33.60677/57.2958) * COS(49.96669/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:50; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.6094/57.2958) + COS(GeoX/57.2958) * COS(33.6094/57.2958) * COS(49.98281/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:51; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.59641/57.2958) + COS(GeoX/57.2958) * COS(33.59641/57.2958) * COS(49.98116/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:51; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.59089/57.2958) + COS(GeoX/57.2958) * COS(33.59089/57.2958) * COS(49.9872/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:52; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.59306/57.2958) + COS(GeoX/57.2958) * COS(33.59306/57.2958) * COS(49.98259/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:52; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60623/57.2958) + COS(GeoX/57.2958) * COS(33.60623/57.2958) * COS(49.96666/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:53; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60588/57.2958) + COS(GeoX/57.2958) * COS(33.60588/57.2958) * COS(49.96569/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:54; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49555/57.2958) + COS(GeoX/57.2958) * COS(34.49555/57.2958) * COS(49.54103/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:54; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49554/57.2958) + COS(GeoX/57.2958) * COS(34.49554/57.2958) * COS(49.54094/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:55; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49531/57.2958) + COS(GeoX/57.2958) * COS(34.49531/57.2958) * COS(49.54096/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:56; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49556/57.2958) + COS(GeoX/57.2958) * COS(34.49556/57.2958) * COS(49.54128/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:56; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49571/57.2958) + COS(GeoX/57.2958) * COS(34.49571/57.2958) * COS(49.54112/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.51939/57.2958) + COS(GeoX/57.2958) * COS(33.51939/57.2958) * COS(49.8711/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.63434/57.2958) + COS(GeoX/57.2958) * COS(33.63434/57.2958) * COS(49.95699/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.64911/57.2958) + COS(GeoX/57.2958) * COS(33.64911/57.2958) * COS(49.9638/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.6338/57.2958) + COS(GeoX/57.2958) * COS(33.6338/57.2958) * COS(49.97957/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:59; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.71791/57.2958) + COS(GeoX/57.2958) * COS(33.71791/57.2958) * COS(50.06053/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:03:59; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.63102/57.2958) + COS(GeoX/57.2958) * COS(33.63102/57.2958) * COS(50.09648/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:00; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.63107/57.2958) + COS(GeoX/57.2958) * COS(33.63107/57.2958) * COS(50.09761/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:00; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.53798/57.2958) + COS(GeoX/57.2958) * COS(33.53798/57.2958) * COS(49.99202/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:01; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.3282/57.2958) + COS(GeoX/57.2958) * COS(33.3282/57.2958) * COS(49.99225/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:02; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.27631/57.2958) + COS(GeoX/57.2958) * COS(33.27631/57.2958) * COS(49.94512/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:02; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60215/57.2958) + COS(GeoX/57.2958) * COS(33.60215/57.2958) * COS(49.9514/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:03; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60223/57.2958) + COS(GeoX/57.2958) * COS(33.60223/57.2958) * COS(49.9514/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:03; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.60658/57.2958) + COS(GeoX/57.2958) * COS(33.60658/57.2958) * COS(49.97037/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:04; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.61082/57.2958) + COS(GeoX/57.2958) * COS(33.61082/57.2958) * COS(49.94236/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:04; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49556/57.2958) + COS(GeoX/57.2958) * COS(34.49556/57.2958) * COS(49.541/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:05; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.55524/57.2958) + COS(GeoX/57.2958) * COS(34.55524/57.2958) * COS(49.58655/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:05; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49533/57.2958) + COS(GeoX/57.2958) * COS(34.49533/57.2958) * COS(49.54041/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:06; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.09807/57.2958) + COS(GeoX/57.2958) * COS(34.09807/57.2958) * COS(49.58181/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:06; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98145/57.2958) + COS(GeoX/57.2958) * COS(33.98145/57.2958) * COS(49.72902/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:54; TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 2:0:0'),ci.imei, ev.`addr`, ev.`GeoX`, ev.`GeoY` from tms_events ev left join wm_car_info ci on ev.deviceloginname=ci.imei where ev.deviceloginname in (352353085645312) AND ev.date>='2024-01-28 22:00:00' AND ev.date<='2024-02-02 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:55; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.39225/57.2958) + COS(GeoX/57.2958) * COS(34.39225/57.2958) * COS(50.13583/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:55; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.30476/57.2958) + COS(GeoX/57.2958) * COS(34.30476/57.2958) * COS(50.24025/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:56; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26494/57.2958) + COS(GeoX/57.2958) * COS(34.26494/57.2958) * COS(50.23833/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.03185/57.2958) + COS(GeoX/57.2958) * COS(34.03185/57.2958) * COS(50.21032/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.0391/57.2958) + COS(GeoX/57.2958) * COS(34.0391/57.2958) * COS(50.34021/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.17188/57.2958) + COS(GeoX/57.2958) * COS(34.17188/57.2958) * COS(50.3698/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.17297/57.2958) + COS(GeoX/57.2958) * COS(34.17297/57.2958) * COS(50.37013/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.1753/57.2958) + COS(GeoX/57.2958) * COS(34.1753/57.2958) * COS(50.37117/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:04:59; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.17578/57.2958) + COS(GeoX/57.2958) * COS(34.17578/57.2958) * COS(50.37114/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:00; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.99541/57.2958) + COS(GeoX/57.2958) * COS(33.99541/57.2958) * COS(50.37992/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:00; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.99898/57.2958) + COS(GeoX/57.2958) * COS(33.99898/57.2958) * COS(50.35751/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:01; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98413/57.2958) + COS(GeoX/57.2958) * COS(33.98413/57.2958) * COS(50.36746/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:01; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.99174/57.2958) + COS(GeoX/57.2958) * COS(33.99174/57.2958) * COS(50.37001/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:02; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98881/57.2958) + COS(GeoX/57.2958) * COS(33.98881/57.2958) * COS(50.37239/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:02; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98639/57.2958) + COS(GeoX/57.2958) * COS(33.98639/57.2958) * COS(50.37144/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:03; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98804/57.2958) + COS(GeoX/57.2958) * COS(33.98804/57.2958) * COS(50.3697/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:04; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97651/57.2958) + COS(GeoX/57.2958) * COS(33.97651/57.2958) * COS(50.37544/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:04; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97629/57.2958) + COS(GeoX/57.2958) * COS(33.97629/57.2958) * COS(50.37167/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:05; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97642/57.2958) + COS(GeoX/57.2958) * COS(33.97642/57.2958) * COS(50.37032/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:06; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97897/57.2958) + COS(GeoX/57.2958) * COS(33.97897/57.2958) * COS(50.35595/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:06; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.53787/57.2958) + COS(GeoX/57.2958) * COS(34.53787/57.2958) * COS(49.59322/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:07; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.22906/57.2958) + COS(GeoX/57.2958) * COS(34.22906/57.2958) * COS(49.26865/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:08; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.55588/57.2958) + COS(GeoX/57.2958) * COS(34.55588/57.2958) * COS(50.01185/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:08; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.56275/57.2958) + COS(GeoX/57.2958) * COS(34.56275/57.2958) * COS(50.02451/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:09; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.55408/57.2958) + COS(GeoX/57.2958) * COS(34.55408/57.2958) * COS(49.98882/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:10; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.58098/57.2958) + COS(GeoX/57.2958) * COS(34.58098/57.2958) * COS(49.96026/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:10; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.58521/57.2958) + COS(GeoX/57.2958) * COS(34.58521/57.2958) * COS(49.95811/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:11; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.58624/57.2958) + COS(GeoX/57.2958) * COS(34.58624/57.2958) * COS(49.95773/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:12; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.59097/57.2958) + COS(GeoX/57.2958) * COS(34.59097/57.2958) * COS(49.95573/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:12; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.5895/57.2958) + COS(GeoX/57.2958) * COS(34.5895/57.2958) * COS(49.9592/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:13; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.59858/57.2958) + COS(GeoX/57.2958) * COS(34.59858/57.2958) * COS(49.95819/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:13; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.61705/57.2958) + COS(GeoX/57.2958) * COS(34.61705/57.2958) * COS(49.95769/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:14; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.60408/57.2958) + COS(GeoX/57.2958) * COS(34.60408/57.2958) * COS(49.95835/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:15; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.60414/57.2958) + COS(GeoX/57.2958) * COS(34.60414/57.2958) * COS(49.95763/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:15; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.56898/57.2958) + COS(GeoX/57.2958) * COS(34.56898/57.2958) * COS(49.74161/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:16; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.51501/57.2958) + COS(GeoX/57.2958) * COS(34.51501/57.2958) * COS(49.66341/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:16; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.49994/57.2958) + COS(GeoX/57.2958) * COS(34.49994/57.2958) * COS(49.59279/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:17; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26017/57.2958) + COS(GeoX/57.2958) * COS(34.26017/57.2958) * COS(49.25875/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:17; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26443/57.2958) + COS(GeoX/57.2958) * COS(34.26443/57.2958) * COS(49.26018/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:18; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.22908/57.2958) + COS(GeoX/57.2958) * COS(34.22908/57.2958) * COS(49.26876/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:19; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.48923/57.2958) + COS(GeoX/57.2958) * COS(34.48923/57.2958) * COS(49.59756/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:19; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.48383/57.2958) + COS(GeoX/57.2958) * COS(34.48383/57.2958) * COS(49.58813/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:20; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.5851/57.2958) + COS(GeoX/57.2958) * COS(34.5851/57.2958) * COS(49.95835/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:20; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.88774/57.2958) + COS(GeoX/57.2958) * COS(33.88774/57.2958) * COS(50.22445/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:20; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.88866/57.2958) + COS(GeoX/57.2958) * COS(33.88866/57.2958) * COS(50.22561/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:21; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.93064/57.2958) + COS(GeoX/57.2958) * COS(33.93064/57.2958) * COS(50.3125/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:22; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98529/57.2958) + COS(GeoX/57.2958) * COS(33.98529/57.2958) * COS(50.36611/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:22; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.9833/57.2958) + COS(GeoX/57.2958) * COS(33.9833/57.2958) * COS(50.37628/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:23; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97961/57.2958) + COS(GeoX/57.2958) * COS(33.97961/57.2958) * COS(50.38678/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:23; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98122/57.2958) + COS(GeoX/57.2958) * COS(33.98122/57.2958) * COS(50.38135/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:24; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97935/57.2958) + COS(GeoX/57.2958) * COS(33.97935/57.2958) * COS(50.38116/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:24; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97475/57.2958) + COS(GeoX/57.2958) * COS(33.97475/57.2958) * COS(50.38479/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:25; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97324/57.2958) + COS(GeoX/57.2958) * COS(33.97324/57.2958) * COS(50.37804/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:26; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.9769/57.2958) + COS(GeoX/57.2958) * COS(33.9769/57.2958) * COS(50.37556/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:26; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.97625/57.2958) + COS(GeoX/57.2958) * COS(33.97625/57.2958) * COS(50.37068/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:27; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.53783/57.2958) + COS(GeoX/57.2958) * COS(34.53783/57.2958) * COS(49.59336/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:27; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.22898/57.2958) + COS(GeoX/57.2958) * COS(34.22898/57.2958) * COS(49.26875/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:28; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.66234/57.2958) + COS(GeoX/57.2958) * COS(33.66234/57.2958) * COS(50.19761/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:28; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.66402/57.2958) + COS(GeoX/57.2958) * COS(33.66402/57.2958) * COS(50.23523/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:29; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.73248/57.2958) + COS(GeoX/57.2958) * COS(33.73248/57.2958) * COS(50.27504/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:29; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.73523/57.2958) + COS(GeoX/57.2958) * COS(33.73523/57.2958) * COS(50.35983/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:30; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.7498/57.2958) + COS(GeoX/57.2958) * COS(33.7498/57.2958) * COS(50.3749/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:31; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.75085/57.2958) + COS(GeoX/57.2958) * COS(33.75085/57.2958) * COS(50.37415/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:31; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.75505/57.2958) + COS(GeoX/57.2958) * COS(33.75505/57.2958) * COS(50.40147/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:32; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98395/57.2958) + COS(GeoX/57.2958) * COS(33.98395/57.2958) * COS(50.36975/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:33; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.98796/57.2958) + COS(GeoX/57.2958) * COS(33.98796/57.2958) * COS(50.36726/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:33; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.9905/57.2958) + COS(GeoX/57.2958) * COS(33.9905/57.2958) * COS(50.37191/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:34; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.99334/57.2958) + COS(GeoX/57.2958) * COS(33.99334/57.2958) * COS(50.35937/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:35; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.99746/57.2958) + COS(GeoX/57.2958) * COS(33.99746/57.2958) * COS(50.35781/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:35; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.58495/57.2958) + COS(GeoX/57.2958) * COS(34.58495/57.2958) * COS(49.95807/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:36; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26446/57.2958) + COS(GeoX/57.2958) * COS(34.26446/57.2958) * COS(49.26005/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:36; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.229/57.2958) + COS(GeoX/57.2958) * COS(34.229/57.2958) * COS(49.26867/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:37; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26175/57.2958) + COS(GeoX/57.2958) * COS(34.26175/57.2958) * COS(49.25723/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:38; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26461/57.2958) + COS(GeoX/57.2958) * COS(34.26461/57.2958) * COS(49.2599/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:38; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.22918/57.2958) + COS(GeoX/57.2958) * COS(34.22918/57.2958) * COS(49.26862/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:39; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.20511/57.2958) + COS(GeoX/57.2958) * COS(34.20511/57.2958) * COS(49.14923/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:39; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.22927/57.2958) + COS(GeoX/57.2958) * COS(34.22927/57.2958) * COS(49.26866/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:39; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26197/57.2958) + COS(GeoX/57.2958) * COS(34.26197/57.2958) * COS(49.25732/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:40; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.26434/57.2958) + COS(GeoX/57.2958) * COS(34.26434/57.2958) * COS(49.26014/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:40; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.2292/57.2958) + COS(GeoX/57.2958) * COS(34.2292/57.2958) * COS(49.26865/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-08 11:05:41; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.56316/57.2958) + COS(GeoX/57.2958) * COS(34.56316/57.2958) * COS(49.62331/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;