gistfile1.txt

(SELECT count( * ) -1  as count , a.rut_int,a.rut2_int,a.apa_int,a.nom_int,a.ama_int,a.com_int,a.ciu_int,a.fon_int,a.dir_int,a.mail1_int,a.mail2_int FROM integrantes a   LEFT OUTER JOIN turnos_sol b  ON b.rut_tursol=a.rut2_int where a.rut2_int LIKE '%%' AND DATE_FORMAT(b.fec_tursol,'%Y-%m-%d') >= '2011-04-15'  AND DATE_FORMAT(b.fec_tursol,'%Y-%m-%d') <= '2011-05-15'  and a.estado_int=1 GROUP BY a.rut2_int,a.rut2_int,a.apa_int,a.nom_int,a.ama_int,a.com_int,a.ciu_int,a.fon_int,a.dir_int,a.mail1_int,a.mail2_int ORDER BY count(*) asc limit 10);