SELECT DISTINCT(adv.adv_id) as ad_id,title,adv_desc,date_posted,city.city,file_name,( 3959 * ACOS( COS( RADIANS( 37.3353 ) ) * COS( RADIANS( latitude ) ) * COS( RADIANS( longitude ) - RADIANS( -121.8938 ) ) + SIN( RADIANS( 37.3353 ) ) * SIN( RADIANS( latitude ) ) ) ) AS distance FROM advertisements AS adv LEFT JOIN zip_codes on zip_codes.zip_id = adv.zip_id LEFT JOIN city on city.city_id = adv.city LEFT JOIN adv_to_images AS advimg ON (adv.adv_id = advimg.adv_id AND advimg.is_default = 1)WHERE status = 1 AND adv.country='1' AND adv.state='102' AND adv_type_id IN (8) having distance<50 ORDER BY distance LIMIT 0,300
MySQL server has gone away