Executed Query -> select l.id,l.user_id,l.listing_title,l.room_type,l.list_type,l.property_type,l.instant, l.currency_type,l.nightly_price, (if( l.locality = '', 5, 0 ) + ( if( l.room_type = '1', 3, 0 )) + ( if( l.property_type = '57', 2, 0 ) ) ) as total_score ,( 6371 * acos( cos( radians() ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians() ) + sin( radians()) * sin( radians( latitude ) ) ) ) as distance from tbl_listing as l inner join tbl_users as u on (l.user_id = u.uid and u.status != 'n') where l.id != '1700' and l.list_type ='p' and l.visible='v' and l.approve='y' and l.status='a' group by l.id having distance < 50 order by total_score desc limit 3