SELECT `t2`.`id`, IFNULL(`t2`.`field1`, `t1`.`field1`), IFNULL(`t2`.`field2`, `t1`.`field2`), ...
FROM `table1` AS `t1`
LEFT JOIN `table2` AS `t2` ON `t2`.`id` = `t1`.`id` AND `t2`.`date` = :date
WHERE `t1`.`id` = :idSELECT `c`.`date`, `t2`.`id`, IFNULL(`t2`.`field1`, `t1`.`field1`), IFNULL(`t2`.`field2`, `t1`.`field2`), ...
FROM `calendar` AS `c`
LEFT JOIN `table1` AS `t1` ON `t1`.`id` = :id
LEFT JOIN `table2` AS `t2` ON `t2`.`id` = :id AND `t2`.`date` = `c`.`date`
WHERE `c`.`date` BETWEEN :start_date AND :end_dateSET @id = 0;
UPDATE `test` SET `lock` = 1 WHERE @id := `id` AND `lock` = 0 ORDER BY `time` LIMIT 1;
SELECT @id;SELECT DISTINCT `t3b`.`table1_id`
FROM `table3` AS `t3a`
JOIN `table3` as `t3b` ON `t3b`.`table2_id` = `t3a`.`table2_id`
AND `t3b`.`table1_id` != `t3a`.`table1_id`
WHERE `t3a`.`table1_id` = :idUPDATE `public`.`users`
SET `id` = :id, `surname` = :surname::varchar(20)
WHERE `surname` = :surname::varchar(20)SELECT `a`.`name`, IFNULL(`d`.`count`, 0) AS `count`
FROM `authors` AS `a`
LEFT JOIN (
SELECT `author`, COUNT(*) AS `count`
FROM `docs`
GROUP BY `author`
) AS `d` ON `d`.`author` = `a`.`id`
UNION (SELECT CONCAT('Неизвестный ', IFNULL(`d`.`author`, '')), `d`.`count`
FROM `authors` AS `a`
RIGHT JOIN (
SELECT `author`, COUNT(*) AS `count`
FROM `docs`
GROUP BY `author`
) AS `d` ON `d`.`author` = `a`.`id`
WHERE `a`.`id` IS NULL)
ORDER BY `count` DESCSELECT `actor`.`name`
FROM `actor`
LEFT JOIN (
SELECT DISTINCT `id_actor`
FROM `film_actor`
) AS `infilm` ON `infilm`.`id_actor` = `actor`.`id`
WHERE `infilm`.`id_actor` IS NULLORDER BY FIELD(`id`, 1, 7, 2, 8, 3)
ORDER BY FIND_IN_SET(`id`, '1, 7, 2, 8, 3')SELECT `t1`.`name`, `t1`.`val`, `t1`.`date`
FROM `table` AS `t1`
JOIN (
SELECT `name`, MAX(`date`) AS `date`
FROM `table`
GROUP BY `name`
) AS `t2` ON `t2`.`name` = `t1`.`name` AND `t2`.`date` = `t1`.`date`SELECT id
FROM places p
JOIN (
SELECT place_id
FROM example
WHERE equi_id IN (1, 2, 3)
GROUP BY place_id
HAVING COUNT(place_id) = 3
) e ON e.place_id = p.id
WHERE p.param1 = 1 AND p.param2 = 2SELECT `t1`.`id`
FROM (SELECT DISTINCT `id` FROM `table` WHERE `cat` = 1) AS `t1`
JOIN (SELECT DISTINCT `id` FROM `table` WHERE `cat` = 2) AS `t2` ON `t2`.`id` = `t1`.`id`
JOIN (SELECT DISTINCT `id` FROM `table` WHERE `cat` = 10) AS `t3` ON `t3`.`id` = `t1`.`id`SELECT `id`
FROM `table`
WHERE `cat` IN (1, 2, 10)
GROUP BY `id`
HAVING COUNT(`id`) >= 3SELECT RIGHT(`phone`, 10) AS `num`, COUNT(*)
FROM `table`
GROUP BY `num`