SELECT *
FROM (
SELECT `id`, MAX(`date`) AS `max_date`
FROM `tab2`
GROUP BY `id`
) AS `max`
JOIN `tab2` ON `tab2`.`id` = `max`.`id`
AND `tab2`.`date` = `max`.`max_date`
JOIN `tab1` ON `tab1_id` = `tab2_id`SELECT *
FROM (
SELECT DISTINCT FIRST_VALUE(`id`) OVER `win` AS `id`,
FIRST_VALUE(`date`) OVER `win` AS `date`,
FIRST_VALUE(`loc`) OVER `win` AS `loc`
FROM `tab2`
WINDOW `win` AS (PARTITION BY `id` ORDER BY `date` DESC)
) AS `t2`
JOIN `tab1` ON `tab1`.`id` = `t2`.`id`SELECT COUNT(*) + 1 AS `position`
FROM `users`
WHERE `balance` > (
SELECT `balance`
FROM `users`
WHERE id = :userId
)SELECT `e`.`id`, `e`.`name` as `event_name`, `e`.`country_id`, `e`.`description`,
`c`.`name` as `country_name`, `l`.`links`, `i`.`images`
FROM `events` AS `e`
JOIN `countries` AS `c`
ON `c`.`id` = `e`.`country_id`
LEFT JOIN (
SELECT `event_id`, GROUP_CONCAT(`link`) AS `links`
FROM `links`
GROUP BY `event_id`
) AS `l`
ON `l`.`event_id` = `e`.`id`
LEFT JOIN (
SELECT `event_id`, GROUP_CONCAT(`name`) AS `images`
FROM `images`
GROUP BY `event_id`
) AS `i`
ON `i`.`event_id` = `e`.`id`
ORDER BY `e`.`id` DESC
LIMIT :start, :maxON t2.site_id = t1.site_id AND t2.tag = t1.tag
SELECT `t`.`id`, ROUND(`t`.`views`/(2020 - `t`.`releaseDate` + 1)*100/`m`.`max`) AS `pop`
FROM `manga` AS `t`
JOIN (
SELECT MAX(ROUND(`views`/(2020 - `releaseDate` + 1))) AS `max`
FROM `manga`
) AS `m`
WHERE `t`.`active` = 1
ORDER BY `pop` DESC
LIMIT 10SELECT *
FROM `table` AS `t1`
JOIN `table` AS `t2`
ON `t2`.`key` = `t1`.`key`
AND `t1`.`domain` = 'первый'
AND `t2`.`domain` = 'второй'
AND `t2`.`value` != `t1`.`value`SELECT `p`.`PROD` AS `PROD`, `l`.`ID` AS `LIST_ID`,
IF(`m`.`PROD` IS NULL, NULL, `l`.`LIST_VAL`) AS `LIST_VAL`
FROM (
SELECT DISTINCT `PROD`
FROM `main`
) AS `p`
JOIN `list` AS `l`
LEFT JOIN `main` AS `m`
ON `m`.`PROD` = `p`.`PROD` AND `m`.`LIST_ID` = `l`.`ID`
ORDER BY `p`.`PROD`, `l`.`ID`