Re: Requête SQL - groupe d'utilisateur
Date: jeudi 9 octobre 2008 03:33:31
Pour connaitre les tables d'OF il faut faire un export ;-)
Voici une requête qui affiche les groupes
SELECT
last_name AS Nom,
first_name AS Prenom,
DATE_FORMAT(subscription, '%d %m %Y' ) AS Date,
member_pool.name AS Groupe
FROM authentication
LEFT JOIN member ON member.id = authentication.id
LEFT JOIN member_pool_join ON member_pool_join.member_id = member.id
LEFT JOIN member_pool ON member_pool.id = member_pool_join.member_pool_id
WHERE YEAR(subscription) >= $year
ORDER BY Groupe, Nom, Prenom