mar. 2013

SELECT DISTINCT users.id FROM info_members AS members, info_users AS users WHERE (members.anchor LIKE 'category:242') AND (users.active='Y') AND (members.member_type LIKE 'user') AND (users.id = members.member_id)
1146: Table 'sc1actupro2s_info.info_users' doesn't exist

SELECT users.* FROM info_members AS members INNER JOIN info_users AS users WHERE (members.anchor LIKE 'category:242') 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
1146: Table 'sc1actupro2s_info.info_users' doesn't exist