Sql to get home page

test.sql

SELECT
			a.*, c.categoryName as articleCategoryName
		FROM
			ctms_article a
		LEFT JOIN ctms_article b ON a.articleCategoryId = b.articleCategoryId
			AND a.lastModified < b.lastModified
			LEFT JOIN ctms_article_category c ON a.articleCategoryId = c.articleCategoryId
		WHERE
			a.state = 1
		GROUP BY
			a.articleCategoryId,
			a.lastModified
		HAVING
			count(b.articleId) < 3
		ORDER BY
			a.articleCategoryId,
			a.lastModified DESC;