{"post":"[]","brand_id":0,"qry":"\n\tSELECT \n\n`p_meta_gps`.`meta_id`, `p_meta_gps`.`post_id`,\n substring_index(p_meta_gps.meta_value,',',1) AS `lat`,\nsubstring_index(p_meta_gps.meta_value,',',-1 ) AS `lng`,            \n            `post_table`.`post_title`,   `p_meta_zip`.`meta_value` AS `zip_value`,\n3956 * 2 * ASIN(SQRT(POWER(SIN((zz.lat-substring_index(p_meta_gps.meta_value,',',1)) * pi()\/180 \/ 2), 2) +COS(zz.lat * pi()\/180) *COS( substring_index(p_meta_gps.meta_value,',',1) * pi()\/180) *POWER(SIN((zz.lng -substring_index(p_meta_gps.meta_value,',',-1 )) * pi()\/180 \/ 2), 2) )) as distanceFROM ,\n\nSQRT(\nPOWER((zz.lat-substring_index(p_meta_gps.meta_value,',',1)), 2)\n + \nPOWER((zz.lng -substring_index(p_meta_gps.meta_value,',',-1 )), 2) ) as calc,\np_meta_country.meta_value as country\n\n            FROM  `wp_vdhr8X5cFgxHS_postmeta` AS `p_meta_gps`\n            JOIN `wp_vdhr8X5cFgxHS_posts` AS `post_table` ON `p_meta_gps`.`post_id` = `post_table`.`ID`  and p_meta_gps.meta_key ='gps' and p_meta_gps.meta_value!=','\n            JOIN `wp_vdhr8X5cFgxHS_postmeta` AS `p_meta_zip` ON `post_table`.`ID` = `p_meta_zip`.`post_id` and p_meta_zip.meta_key ='zip'\n            JOIN `wp_vdhr8X5cFgxHS_postmeta` AS `p_meta_brand` ON `post_table`.`ID` = `p_meta_brand`.`post_id`             \n          \n           AND (p_meta_brand.meta_value LIKE CONCAT('%:\"',0,'\";%') or  p_meta_brand.meta_value LIKE CONCAT('%:\"',,'\";%'))\n           \n            LEFT JOIN `wp_vdhr8X5cFgxHS_postmeta` AS `p_meta_country` ON `post_table`.`ID` = `p_meta_country`.`post_id` AND p_meta_country.meta_key='country' \n            \n            \n            join (select lat,lng from y_zip where id='3001' limit 1) as zz on 1=1\n            WHERE post_status='publish' and post_type='sales_points'           \n            ORDER BY `distanceFROM` ASC\n            LIMIT 8;\t\n\t","points":[]}