SELECT f.*, GROUP_CONCAT(fc.cat_id)
FROM film f
LEFT JOIN film_category fc ON fc.film_id = f.id
GROUP BY f.id
SELECT *
FROM oc_product_option
WHERE product_id IN (
SELECT product_id
FROM oc_product_option
GROUP BY product_id
HAVING count(product_id) > 1
)
SELECT
question_id,
SUM(points < 1) AS 'Incorrect',
SUM(points >= 1) AS 'Correct'
FROM
`cp_question_student`
GROUP BY
question_id
SELECT `year`, COUNT(*)
FROM (
SELECT YEAR(p.age) AS `year`, p.id
FROM apointments a
JOIN pations p ON p.id = a.idp
GROUP BY p.id
) t
GROUP BY `year`
SELECT u.*, COALESCE(v.v_sum, 0) AS total_views
FROM users u
LEFT JOIN (
SELECT f.entity_id, SUM(f.views) AS v_sum
FROM feeds f
GROUP BY f.entity_id
) AS v ON v.entity_id = u.id
ORDER BY v.v_sum DESC
UPDATE t1
JOIN t2 ON t1.course_name = LEFT(t2.name, LENGTH(t1.course_name))
SET t1.course_id = t2.id;
INSERT INTO `table` (`id`, `count`, `f`)
SELECT * FROM (
(SELECT `id`, 0 AS `count`, 'foo' AS `f` FROM `table2` [куча where])
UNION
(SELECT `id`, `count` AS `count`, 'bar' AS `f` FROM `table3` LIMIT 1)
) AS t;
INSERT INTO `table` (`id`, `count`, `f`)
(SELECT `id`, 0 AS `count`, 'foo' AS `f` FROM `table2` [куча where])
UNION
(SELECT `id`, `count` AS `count`, 'bar' AS `f` FROM `table3` LIMIT 1);