SELECT users.* FROM yacs_members AS members INNER JOIN yacs_users AS users WHERE (members.anchor LIKE 'category:109') 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
réunion site bonhomme [Apr. 28 2014] Edited on Apr. 28 2014 at 12:01 pm GMT, in Discussions | |
Réunion site bonhomme #4 [Apr. 22 2014] Edited on Apr. 22 2014 at 11:59 am GMT, in Discussions | |
réunion site bonhomme [Apr. 15 2014] Edited on Apr. 15 2014 at 12:27 pm GMT, in Discussions | |
Bonhomme à ressorts 03-04-14 [Apr. 3 2014] Edited on Apr. 3 2014 at 12:21 pm GMT, in Discussions |