SELECT * FROM provincia p WHERE EXISTS(SELECT * FROM propiedad pr WHERE p.id_provincia = pr.id_provincia AND id_miembro = '1') ORDER BY p.nom_provincia
MySQL server has gone away