(SELECT `id`, `amount`
FROM `table`
WHERE `group` = 0)
UNION
(SELECT MIN(`id`), SUM(`amount`)
FROM `table`
WHERE `group` != 0
GROUP BY `group`)UPDATE `table` SET `updated` = 0;
INSERT INTO `table` (..., `updated`) VALUES (..., 1)
ON DUPLICATE KEY UPDATE ..., `updated` = 1;
DELETE FROM `table` WHERE `updated` = 0;SELECT ...
FROM `products` AS `p`
JOIN `product_attributes` AS `pa1` ON `pa1`.`attribute_id` = :attr1
AND `pa1`.`attribute_value` = :val1 AND `pa1`.`product_id` = `p`.`id`
JOIN `product_attributes` AS `pa2` ON `pa2`.`attribute_id` = :attr2
AND `pa2`.`attribute_value` = :val2 AND `pa2`.`product_id` = `p`.`id`Запрос выполняется 8-10 секунд. Причем если меняю GROUP BY CEIL(`timestamp` / 864000) на просто GROUP BY `timestamp`, то запрос выполняется меньше чем за 1 секунду.
COUNT(DISTINCT `IP`)
SELECT COUNT(DISTINCT `p`.`id`)
FROM `product` AS `p`
JOIN `product_to_category` AS `p2c` ON `p`.`id` = `p2c`.`product_id`
AND `p`.`publish` = 1
AND `p2c`.`category_id` IN (917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950)
JOIN `city` AS `c` ON `c`.`id` = `p`.`city_id`
AND (`c`.`id` = 108 OR `c`.`parent_id` = 108)UPDATE `table` SET `updating` = NOW() WHERE ... AND `updating` IS NULL AND @id := `id` LIMIT 1;
SELECT * FROM `table` WHERE `id` = @id;SELECT `deck_id`
FROM `deck_card`
WHERE `card_id` IN (2, 3)
GROUP BY `deck_id`
HAVING COUNT(*) = 2