DELETE `t1`
FROM `channel_snapshots` AS `t1`
LEFT JOIN (
SELECT MAX(`snapshot_time`) AS `time`, `channel_id`
FROM `channel_snapshots`
GROUP BY `channel_id`
) AS `t2` ON `t2`.`time` = `t1`.`snapshot_time` AND `t2`.`channel_id` = `t1`.`channel_id`
WHERE `t1`.`snapshot_time` < NOW() - INTERVAL 12 HOUR
AND `t2`.`channel_id` IS NULLSELECT `f`.*
FROM `FruitsTABLE` AS `f`
JOIN `FruitTagTABLE` AS `ft1` ON `ft1`.`tag` = :tag1 AND `ft1`.`id` = `f`.`id`
JOIN `FruitTagTABLE` AS `ft2` ON `ft2`.`tag` = :tag2 AND `ft1`.`id` = `f`.`id`SELECT `b`.`*`, `i`.`count`
FROM (
SELECT `ib`.`id_brand` AS `brand`, COUNT(*) AS `count`
FROM `item_brand` AS `ib`
JOIN `item` AS `i` ON `i`.`enabled` = 1
AND `i`.`id_category` IN (21,317,318)
AND `i`.`id` = `ib`.`id_item`
GROUP BY `ib`.`id_brand`
) AS `i`
JOIN `brand` AS `b` ON `b`.`id` = `i`.`id_brand`
ORDER BY `i`.`count` DESCSELECT to_char(c.date, 'YYYY-MM-dd HH24:MI:ss') as day,
c.title, c.email, c.price, c.pages
FROM (
SELECT MIN(date) AS date, email FROM customer GROUP BY email
) AS t
JOIN customer AS c ON c.date = t.date AND c.email = d.emailBIT_COUNT(HEX(:value1) ^ HEX(:value2))