SELECT cat.name,u.keyword, (6371 * acos( cos( radians(catgry.latitude) ) * cos( radians( 29.47000000 ) ) * cos( radians( 77.70000000 ) - radians(catgry.longitude) ) + sin( radians(catgry.latitude) ) * sin( radians( 29.47000000 ) ) ) ) as distance FROM agl_category_description cat join agl_url_alias u ON CONCAT('category_id=',cat.category_id) = u.query join agl_category catgry ON catgry.category_id = cat.category_id WHERE catgry.status ='1' AND cat.category_id != 2366 AND catgry.cate_type IN ('6') group by cat.name HAVING distance > 0 ORDER by distance ASC LIMIT 0, 2