Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select case when cc1.nombre is null then cc2.nombre else cc1.nombre end as Comercializadora,
- case when c1.nombre is null then c2.id_tarifa else c1.id_tarifa end as id_tarifa,
- Medidas_horarias.hora,ROUND(sum(Medidas_horarias.medida),3) as medida
- from Medidas_horarias
- LEFT JOIN Grup_cups c1 ON Medidas_horarias.id_grup_cup = c1.id and Medidas_horarias.id_cup = 0
- LEFT JOIN CUPS c2 ON Medidas_horarias.id_cup = c2.id and Medidas_horarias.id_grup_cup = 0
- LEFT JOIN Clientes cc1 ON c1.id_comercialitzadora = cc1.id
- LEFT JOIN Clientes cc2 ON c2.id_comercializadora = cc2.id
- where cc1.id = ${CLIENTE} or cc2.id = ${CLIENTE}
- group by id_tarifa, Medidas_horarias.fecha,Medidas_horarias.hora
- having year(Medidas_horarias.fecha) = "${ANY}"
- and month(Medidas_horarias.fecha) = "${MES}"
- and day(Medidas_horarias.fecha) = day(date_add(CURDATE(), interval -1 day))
- and id_tarifa = ${TARIFA}
- order by Medidas_horarias.fecha,Medidas_horarias.hora asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement