MySQL - Ayuda con consulta MySQL

SELECT `cr`.`concepto`, COUNT(`c`.`id`) AS `renta` FROM `catalago_rentas` AS `cr` LEFT JOIN `rentas` AS `r` ON `cr`.`id` = `r`.`id_catalago_rentas` WHERE `r`.`id_catalago_rentas` > 0 AND `r`.`fecha` > 1541052000768 AND `r`.`fecha` < 1543644000768 GROUP BY `cr`.`id`

SELECT `cr`.`concepto`,`c`.`id`

FROM `catalago_rentas` AS `cr` LEFT JOIN `rentas` AS `r` ON `cr`.`id` = `r`.`id_catalago_rentas`

WHERE `r`.`id_catalago_rentas` > 0 AND `r`.`fecha` > 1541052000768 AND `r`.`fecha` < 1543644000768

with catalago_rentas AS (

select 1 as id, y1 as concepto

union

select 2, y2

union

select 3, y3

),

rentas as (

select 1 as id_catalago_rentas, {fecha1} as fecha

union

select 2 , {fecha2}

union

select 3 , {fecha3}

union

select 4 , {fecha4}

)

SELECT `cr`.`concepto`, COUNT(`c`.`id`) AS `renta`

FROM `catalago_rentas` AS `cr`

LEFT JOIN `rentas` AS `r` ON `cr`.`id` = `r`.`id_catalago_rentas`

WHERE `r`.`id_catalago_rentas` > 0

AND `r`.`fecha` > 1541052000768

AND `r`.`fecha` < 1543644000768

GROUP BY `cr`.`id`