Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SELECT
  2. `saenger_statuschange`.*,
  3. `SCP`.*
  4. FROM `saenger_statuschange`
  5. INNER JOIN `SCP` ON (`saenger_statuschange`.`scp_id` = `SCP`.`id`)
  6. INNER JOIN
  7. (SELECT
  8. scp_id,
  9. MAX(date) AS max_date
  10. FROM saenger_statuschange
  11. WHERE date <= CURRENT_DATE
  12. GROUP BY scp_id) grouped
  13. ON saenger_statuschange.scp_id = grouped.scp_id
  14. AND saenger_statuschange.date = grouped.max_date
  15. WHERE `saenger_statuschange`.`scp_id` IN (73, 74)
  16. ORDER BY `saenger_statuschange`.`date` ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement