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

MySQL - Registro 0 x Franja horaria

Language: Layout:
absolute service time: 0,32 sec 
edit mode |  history
   fechaContacto franja_horario conteo
1 NULL 08:00:00 - 08:29:59 0
2 NULL 08:30:00 - 08:59:59 0
3 15.03.2017 00:00:00 09:00:00 - 09:29:59 7
4 15.03.2017 00:00:00 09:30:00 - 09:59:59 4
5 15.03.2017 00:00:00 10:00:00 - 10:29:59 2
6 15.03.2017 00:00:00 10:30:00 - 10:59:59 3
7 NULL 11:00:00 - 11:29:59 0
8 NULL 11:30:00 - 11:59:59 0
9 NULL 12:00:00 - 12:29:59 0
10 NULL 12:30:00 - 12:59:59 0
11 NULL 13:00:00 - 13:29:59 0
12 NULL 13:30:00 - 13:59:59 0
13 15.03.2017 00:00:00 14:00:00 - 14:29:59 2
14 15.03.2017 00:00:00 14:30:00 - 14:59:59 5
15 NULL 15:00:00 - 15:29:59 0
16 NULL 15:30:00 - 15:59:59 0
17 NULL 16:00:00 - 16:29:59 0
18 NULL 16:30:00 - 16:59:59 0
19 16.03.2017 00:00:00 17:00:00 - 17:29:59 2
20 16.03.2017 00:00:00 17:30:00 - 17:59:59 1
21 NULL 18:00:00 - 18:29:59 0