| 0 |
| SQL |
SELECT G.id, G.nom, abreviation, embleme, COUNT(GM2.joueur_id) AS nb_membres, G.description, adresse_forum,
MIN(PRO.id) AS chef_id, MIN(PRO.nom) AS chef_nom
FROM guildes AS G
LEFT JOIN groupes_membres AS GM
ON GM.groupe_id = G.id
LEFT JOIN jeu_profils AS PRO
ON PRO.id=GM.joueur_id
LEFT JOIN groupes_membres AS GM2
ON G.id=GM2.groupe_id
WHERE G.id=4 AND (GM.grade_id=3 OR GM.grade_id is null)
|
| time |
1048238 |
| trace |
#0 /app/guilde.php(15): Database->query() #1 {main} |
| Time |
1.048238 ms |
|