select i.country_code,c.countries_id,i.state,i.city from ip2location_us i left join countries c on i.country_code=c.countries_iso_code_2 where 309622501>=i.ip_num_start and 309622501<=i.ip_num_end /*and i.country_code!='-'*/ - MySQL server has gone away