<%
@records = ActiveRecord::Base.connection.execute("
SELECT
m.name,
ST_X(coordinates::geometry) as lng,
ST_Y(coordinates::geometry) as lat,
l.timestamp
FROM managers m
INNER JOIN users u ON m.id = u.manager_id
INNER JOIN (SELECT MAX(id) AS id, user_Id FROM locations GROUP BY user_id) ml ON u.id = ml.user_id
INNER JOIN locations l ON l.id = ml.id AND l.user_id = u.id
WHERE m.validity = true
ORDER BY m.name
")
%>