SELECT users.* FROM yacs_members AS members INNER JOIN yacs_users AS users WHERE (members.anchor LIKE 'category:5') AND (members.member_type LIKE 'user') AND (users.id = members.member_id) AND (users.active='Y') AND (users.capability IN ('S', 'M', 'A')) GROUP BY users.id ORDER BY users.full_name, users.nick_name LIMIT 0,100
1055: 'qgem6871_cyb.users.active' isn't in GROUP BY
![]() | Protection de la vie privée Edited on Jul. 27 2010 at 05:21 pm GMT, in Pages globales |
![]() | A propos de ce site Edited on Jul. 27 2010 at 05:16 pm GMT, in Pages globales |
Fils d'information Edited on June 1 2010 at 04:56 pm GMT, in Boîtes extra |