User locations

user warning: Unknown column 'l.eid' in 'field list' query: SELECT u.name, MAX(r.rid) as role, l.eid as uid, l.latitude, l.longitude FROM users u INNER JOIN location l ON u.uid = l.eid LEFT JOIN users_roles r ON l.eid = r.uid WHERE l.type = 'user' AND u.status = 1 AND (l.latitude != 0 OR l.longitude != 0) GROUP BY l.eid in /home/ecentres/public_html/includes/database.mysql.inc on line 172.