SELECT `g`.`name` AS `group_name`,`m`.`name` AS `merchant_name`,`g`.*,`m`.*,`s`.*,
ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN((35.051510*PI()/180-`s`.`lat`*PI()/180)/2),2)+COS(35.051510*PI()/180)*COS(`s`.`lat`*PI()/180)*POW(SIN((118.347870*PI()/180-`s`.`long`*PI()/180)/2),2)))*1000) AS juli
FROM `lyx_group` `g`,`lyx_merchant` `m`,`lyx_group_store` `gs`,`lyx_merchant_store` `s` WHERE ( `m`.`city_id`='2255' AND `g`.`mer_id`=`m`.`mer_id` AND `g`.`status`='1' AND `g`.`type`='1' AND `m`.`status`='1' AND `g`.`end_time`>'1591435067' AND `s`.`have_group`=1 AND `g`.`cat_id`='2' AND `g`.`group_id` = `gs`.`group_id` AND `gs`.`store_id`=`s`.`store_id` AND `m`.`mer_id`=`s`.`mer_id` ) GROUP BY `g`.`group_id`, `m`.`mer_id` ORDER BY `g`.`sort` DESC,`g`.`group_id` DESC LIMIT 0,0