Lines Matching refs:AS
48 …'mysql']['TablesToLock']= array("users", "users AS u","groups", "groups AS g", "usergroup", "userg…
67 FROM usergroup AS ug
68 JOIN users AS u ON u.uid=ug.uid
69 JOIN groups AS g ON g.gid=ug.gid
85 …uth']['mysql']['getUserInfo'] = "SELECT pass, CONCAT(firstname,' ',lastname) AS name, email AS mail
121 $conf['auth']['mysql']['getUsers'] = "SELECT DISTINCT login AS user
122 FROM users AS u
123 LEFT JOIN usergroup AS ug ON u.uid=ug.uid
124 LEFT JOIN groups AS g ON ug.gid=g.gid";
182 $conf['auth']['mysql']['getUserID'] = "SELECT uid AS id
249 $conf['auth']['mysql']['getGroupID'] = "SELECT gid AS id