Lines Matching full:as

80             SELECT `id` AS `uid`,
81                    `username` AS `user`,
82                    `name` AS `name`,
83                    `password` AS `hash`,
84                    `email` AS `mail`
95               p.id AS `gid`,
98                   FROM `' . $prefix . 'usergroups` AS xp
100               ) AS `group`
101               FROM `' . $prefix . 'user_usergroup_map` AS m,
102                    `' . $prefix . 'usergroups` AS g,
103                    `' . $prefix . 'usergroups` AS p
113             SELECT n.id AS `gid`, GROUP_CONCAT(p.`title` ORDER BY p.lft SEPARATOR \'/\') as `group`
114               FROM `' . $prefix . 'usergroups` AS n, `' . $prefix . 'usergroups` AS p
123             SELECT s.`username` as `user`
124               FROM `' . $prefix . 'session` AS s,
125                    `' . $prefix . 'users` AS u