Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select
- mc.fecha as fecha,
- mc.hora,
- sum((CASE WHEN ac.fecha_fin is not null
- THEN (CASE WHEN (mc.fecha between ac.fecha_ini and ac.fecha_fin)
- THEN (CASE WHEN (date_add(mc.fecha, interval 1 year) between ac.fecha_ini and ac.fecha_fin)
- THEN 0
- ELSE round(-mc.medida,3) END)
- ELSE (CASE WHEN (date_add(mc.fecha, interval 1 year) between ac.fecha_ini and ac.fecha_fin)
- THEN round(mc.medida,3)
- ELSE 0 END)
- END)
- ELSE (CASE WHEN (mc.fecha >= ac.fecha_ini)
- THEN 0
- ELSE (CASE WHEN (date_add(mc.fecha, interval 1 year) >= ac.fecha_ini)
- THEN round(mc.medida,3)
- ELSE 0 END)
- END)
- END)) as 'Medida_cups'
- from Medidas_horarias_cups mc
- inner join Asignacion_cups ac on ac.id_cup=mc.id_cup
- where year(fecha) = "${ANY}"
- and month(fecha) = "${MES}"
- and ac.id_comercializadora= ${CLIENTE}
- and ac.id_tarifa= ${TARIFA}
- group by mc.fecha, mc.hora
- order by mc.fecha, mc.hora asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement