sql_1.sql

SELECT
	DISTINCT w.name,
	w.categoryId,
	c.name as category
FROM
	work w
JOIN
	category c
ON
	c.id = w.categoryId
INNER JOIN
	(
		SELECT
			GROUP_CONCAT
				(w.id ORDER BY w.id DESC) grouped
			FROM
				work w
			GROUP BY
				categoryId
			ORDER BY
				w.id ASC
	) AS works
WHERE
	FIND_IN_SET(w.id, works.grouped ) BETWEEN 1 AND ?
ORDER BY
	categoryId ASC,
	w.id DESC