Errormessage: SELECT a.id,a.name,a.address,a.postcode,b.name city_name,a.lat,a.lon,count(r.id) totrev, avg(rating) rate
  , p.id photo_id, a.score, g.name parent_city, g.subdomain parent_url, b.subdomain
  FROM companies a JOIN comclass c on a.id = c.comp_id JOIN geo_Locality b on b.id = c.city_id JOIN geo_AdministrativeArea f on b.aa_id = f.id
  LEFT JOIN review r on r.comp_id = a.id AND r.approved = 1
  LEFT JOIN photo p on a.id = p.comp_id AND logo = 1
 LEFT JOIN geo_Locality g on b.parent = g.id  
  
  WHERE c.cat_id = 13018 AND (b.id=20371 OR b.parent=20371) AND a.approved != -1
  GROUP by a.id  ORDER BY score desc, a.name asc LIMIT 0,20;
MySQL server has gone away