mysql> SELECT      u.idutilisateur AS id,     IF( MAX( IF(a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW(), 1, 0)) = 1, TRUE, FALSE) AS subscriber,     u.nom AS nom,      u.prenom AS prenom, IF (u.sexe='M', 'Homme', 'Femme') AS sexe,     ch.libeleFR AS cheveux,     y.libeleFR AS yeux,  ta.libeleFR AS age,     p.nom AS pays,     GROUP_CONCAT( DISTINCT             l.nom_fr,    ': ',             ELT(cl.niveau, 'notion', 'courant', 'bilingue')             ORDER BY l.nom_fr             SEPARATOR ' - '     ) AS langues      FROM     utilisateur u     JOIN comedien c ON u.idutilisateur=c.idutilisateur     LEFT JOIN adhesion a ON c.idutilisateur=a.idutilisateur     JOIN trancheAge ta ON c.idtrancheAge=ta.idtrancheAge     JOIN couleurCheveux ch ON ch.idcouleurCheveux=c.idcouleurCheveux     JOIN couleurYeux y ON y.idcouleurYeux = c.idcouleurYeux     JOIN pays p ON p.idpays = u.idpays     LEFT JOIN comedien_has_langue cl ON cl.idutilisateur=c.idutilisateur  LEFT JOIN langue l ON l.idlangue = cl.idlangue WHERE a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW() AND u.prenom='Olivier' AND u.sexe = 'M' AND (SELECT count(l.idlangue) FROM langue l JOIN comedien_has_langue cal USING(idlangue) WHERE cal.idutilisateur=u.idutilisateur AND l.idlangue = 2) > 0 GROUP BY     id ORDER BY     subscriber DESC,     u.nom,     u.prenom,     u.idutilisateur LIMIT 0, 10;
Empty set (0.00 sec)

mysql> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    3
Current database: myTest

+---------------------+
| Tables_in_myTest    |
+---------------------+
| adhesion            |
| comedien            |
| comedien_has_langue |
| couleurCheveux      |
| couleurYeux         |
| langue              |
| pays                |
| trancheAge          |
| utilisateur         |
+---------------------+
9 rows in set (0.02 sec)