Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- `saenger_statuschange`.*,
- `SCP`.*
- FROM `saenger_statuschange`
- INNER JOIN `SCP` ON (`saenger_statuschange`.`scp_id` = `SCP`.`id`)
- INNER JOIN
- (SELECT
- scp_id,
- MAX(date) AS max_date
- FROM saenger_statuschange
- WHERE date <= CURRENT_DATE
- GROUP BY scp_id) grouped
- ON saenger_statuschange.scp_id = grouped.scp_id
- AND saenger_statuschange.date = grouped.max_date
- WHERE `saenger_statuschange`.`scp_id` IN (73, 74)
- ORDER BY `saenger_statuschange`.`date` ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement