SELECT `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 ('Длинный')ALTER TABLE `таблица` AUTO_INCREMENT = максимальное_значение+1;(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 CASCADE