SELECT `restaurant_id`
FROM `restaurants_category`
WHERE `cat_id` IN (1, 2)
GROUP BY `restaurant_id`
HAVING COUNT(*) = 2SELECT `i`.`*`
FROM `items` AS `i`
JOIN `items_tags` AS `it` ON `it`.`item_id` = `i`.`id`
JOIN `tags` AS `t1` ON `t1`.`id` = `it`.`item_id`
AND `t1`.`category_id` = 'Цвет'
AND `t1`.`value` IN ('Синий', 'Красный')
JOIN `tags` AS `t2` ON `t2`.`id` = `it`.`item_id`
AND `t2`.`category_id` = 'Длина'
AND `t2`.`value` IN ('Длинный')(SELECT *
FROM `birthday`
WHERE MONTH(`date`) > MONTH(CURDATE())
OR (MONTH(`date`) = MONTH(CURDATE())
AND DAYOFMONTH(`date`) = DAYOFMONTH(CURDATE()))
ORDER BY MONTH(`date`), DAYOFMONTH(`date`)
LIMIT 3)
UNION (SELECT *
FROM `birthday`
WHERE MONTH(`date`) = MONTH(CURDATE())
AND DAYOFMONTH(`date`) = DAYOFMONTH(CURDATE()))
UNION (SELECT *
FROM `birthday`
WHERE MONTH(`date`) < MONTH(CURDATE())
OR (MONTH(`date`) = MONTH(CURDATE())
AND DAYOFMONTH(`date`) < DAYOFMONTH(CURDATE()))
ORDER BY MONTH(`date`) DESC, DAYOFMONTH(`date`) DESC
LIMIT 3)FOREIGN KEY (`patient`)
REFERENCES `patient` (`id_patient`)
ON DELETE CASCADE
ON UPDATE CASCADESELECT ANY_VALUE(`id`), ANY_VALUE(`name`), ANY_VALUE(`age`), COUNT(*)
FROM `student`;SELECT `age`, COUNT(*)
FROM `student`
GROUP BY `age`;+------+----------+
| age | COUNT(*) |
+------+----------+
| 18 | 2 |
| 17 | 1 |
| NULL | 1 |
+------+----------+SELECT `t1`.`name`, `t2`.`name`, COUNT(*) AS `count`
FROM `teacher` AS `t1`
JOIN (
SELECT DISTINCT `teacher_id`, `student_id`
FROM `teacher_student`
) AS `s1` ON `s`.`teacher_id` = `t1`.`id`
JOIN (
SELECT DISTINCT `teacher_id`, `student_id`
FROM `teacher_student`
) AS `s2` ON `s2`.`student_id` = `s1`.`student_id` AND `s2`.`teacher_id` > `s1`.`teacher_id`
JOIN `teacher` AS `t2` ON `t2`.`id` = `s2`.`teacher_id`
GROUP BY `t1`.`id`, `t2`.`id`
ORDER BY `count`
LIMIT 1INSERT INTO `items` (`id`, `id_shop`, `name`, `description`, ...)
SELECT `id`, `id_shop`, `name` AS `new_name`, `description` AS `new_description`, ...
FROM `new_items`
ON DUPLICATE KEY UPDATE `name` = `new_name`, `description` = `new_description`, ...$stmt = mysqli_prepare($connect, "INSERT INTO *** (fio,email,age,anw1,anw2,frequency) VALUES (?, ?, ?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt, "ssssss", $fio, $email, $age, $anw1, $anw2, $frequency);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);