Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

count events by 2 shift cycles using derived table

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 77, absolute service time: 0,19 sec 
edit mode |  history  | discussion
   CurYRshift_1_8hr CurYRshift_2_8hr CurYRshift_3_8hr PreYRshift_1_8hr PreYRshift_2_8hr PreYRshift_3_8hr DiffShift_1_8hr DiffShift_2_8hr DiffShift_3_8hr CurYRshift_1_12Hr CurYRshift_2_12Hr PreYRshift_1_12Hr PreYRshift_2_12Hr DiffShift_1_12hr DiffShift_2_12hr
1 0 26 13 11 14 13 -11 12 0 22 17 21 17 1 0