SELECT DISTINCT e.id, e.name, e.high_limit, e.very_high_limit, e.photo, m.vyrms, m.ts_get
FROM equipment as e
INNER JOIN measures as m ON e.id = m.publisher_id
INNER JOIN areas as a ON a.id = e.area_id
INNER JOIN plants as pl ON a.plant_id = pl.id
GROUP BY e.id, e.name, e.high_limit, e.very_high_limit, e.photo, m.vyrms, m.ts_get
ORDER BY m.vyrms DESC
LIMIT 0, 10;