Wednesday, 11 September 2013

how to write complex sub query in cake php i.e sub query is in from clause

how to write complex sub query in cake php i.e sub query is in from clause

SELECT AM.m,
COUNT(JRC.id) FROM
(SELECT 1 AS m
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT 7
UNION ALL SELECT 8
UNION ALL SELECT 9
UNION ALL SELECT 10
UNION ALL SELECT 11
UNION ALL SELECT 12
) AS AM
LEFT JOIN `candidates` AS `JRC`
ON AM.m = MONTH(JRC.created) AND (JRC.jr_id = 58)
GROUP BY AM.m
it will result month wise user count for 12 months

No comments:

Post a Comment