| 0 |
| SQL |
SELECT G.id, G.nom, abreviation, embleme, G.icone, COUNT(GM2.joueur_id) AS nb_membres,
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 GM.grade_id=3
GROUP BY G.id
ORDER BY G.nom
|
| time |
1896022 |
| trace |
#0 /app/guildes.php(11): Database->query() #1 {main} |
| Time |
1.896022 ms |
|