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 MedidasHorariasCups mc
- inner join AsignacionCups ac on ac.id_cup = mc.id_cup
- where year(mc.fecha) = "2016"
- and month(mc.fecha) = "01"
- and ac.id_comercializadora= 8
- and ac.id_tarifa= 1
- group by mc.fecha, mc.hora
- order by mc.fecha, mc.hora asc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement