SELECT
c.*, DATE_FORMAT(c.CREATE_TIME, '%Y-%m-%d') DATE
FROM
cms_content c
WHERE
1 = 1
AND c.TYPE_KEY = 'firm'
AND (
SELECT
COUNT(*)
FROM
cms_content
WHERE
org_id = c.org_id
AND TYPE_KEY = 'firm'
) < 4
c.*, DATE_FORMAT(c.CREATE_TIME, '%Y-%m-%d') DATE
FROM
cms_content c
WHERE
1 = 1
AND c.TYPE_KEY = 'firm'
AND (
SELECT
COUNT(*)
FROM
cms_content
WHERE
org_id = c.org_id
AND TYPE_KEY = 'firm'
) < 4