SELECT `id`
FROM `products`
WHERE `id` NOT IN (
SELECT `product_id`
FROM `products_category`
)SELECT @Code=t1.КодТовара, @Итог=t1.Количество, @Имя=t2.Наименование
FROM (
SELECT КодТовара, SUM(Количество) AS Количество
FROM Заказ
WHERE ДатаЗаказа BETWEEN GetDate()-@Интервал AND GetDate()
GROUP BY КодТовара
) AS t1
JOIN Товар AS t2
ON t2.КодТовара = t1.КодТовара
ORDER BY t1.Количество * IF(@ТипРезультата = 1, 1, -1)SELECT `tgid`, SUM(`reward`) AS `reward`
FROM `answer`
WHERE `tgid` IN (
SELECT `tgid`
FROM `question`
WHERE `dateadd` >= CURDATE() - INTERVAL DAYOFMONTH(CURDATE())-1 DAY
) AND `dateadd` >= CURDATE() - INTERVAL DAYOFMONTH(CURDATE())-1 DAY
GROUP BY `tgid`SELECT `Номер участка`, COUNT(*) AS `count`
FROM `table`
ORDER BY `count` DESC
LIMIT 1SELECT `dept_no`, sum(`salary`) AS `sum`
FROM `salaries` AS `s`
JOIN `dept_emp` AS `d`
ON `s`.`emp_no` = `d`.`emp_no`
WHERE `s`.`to_date` = '9999-01-01'
GROUP BY `d`.`dept_no`
ORDER BY `sum` DESC
LIMIT 1