September
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-01 00:00:00' AND DateTime_program < '2022-09-01 23:59:59' AND Lang = '2' AND Active = 10
01
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-02 00:00:00' AND DateTime_program < '2022-09-02 23:59:59' AND Lang = '2' AND Active = 10
02
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-03 00:00:00' AND DateTime_program < '2022-09-03 23:59:59' AND Lang = '2' AND Active = 10
03
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-04 00:00:00' AND DateTime_program < '2022-09-04 23:59:59' AND Lang = '2' AND Active = 10
04
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-05 00:00:00' AND DateTime_program < '2022-09-05 23:59:59' AND Lang = '2' AND Active = 10
05
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-06 00:00:00' AND DateTime_program < '2022-09-06 23:59:59' AND Lang = '2' AND Active = 10
06
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-07 00:00:00' AND DateTime_program < '2022-09-07 23:59:59' AND Lang = '2' AND Active = 10
07
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-08 00:00:00' AND DateTime_program < '2022-09-08 23:59:59' AND Lang = '2' AND Active = 10
08
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-09 00:00:00' AND DateTime_program < '2022-09-09 23:59:59' AND Lang = '2' AND Active = 10
09
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-10 00:00:00' AND DateTime_program < '2022-09-10 23:59:59' AND Lang = '2' AND Active = 10
10
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-11 00:00:00' AND DateTime_program < '2022-09-11 23:59:59' AND Lang = '2' AND Active = 10
11
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-12 00:00:00' AND DateTime_program < '2022-09-12 23:59:59' AND Lang = '2' AND Active = 10
12
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-13 00:00:00' AND DateTime_program < '2022-09-13 23:59:59' AND Lang = '2' AND Active = 10
13
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-14 00:00:00' AND DateTime_program < '2022-09-14 23:59:59' AND Lang = '2' AND Active = 10
14
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-15 00:00:00' AND DateTime_program < '2022-09-15 23:59:59' AND Lang = '2' AND Active = 10
15
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-16 00:00:00' AND DateTime_program < '2022-09-16 23:59:59' AND Lang = '2' AND Active = 10
16
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-17 00:00:00' AND DateTime_program < '2022-09-17 23:59:59' AND Lang = '2' AND Active = 10
17
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-18 00:00:00' AND DateTime_program < '2022-09-18 23:59:59' AND Lang = '2' AND Active = 10
18
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-19 00:00:00' AND DateTime_program < '2022-09-19 23:59:59' AND Lang = '2' AND Active = 10
19
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-20 00:00:00' AND DateTime_program < '2022-09-20 23:59:59' AND Lang = '2' AND Active = 10
20
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-21 00:00:00' AND DateTime_program < '2022-09-21 23:59:59' AND Lang = '2' AND Active = 10
21
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-22 00:00:00' AND DateTime_program < '2022-09-22 23:59:59' AND Lang = '2' AND Active = 10
22
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-23 00:00:00' AND DateTime_program < '2022-09-23 23:59:59' AND Lang = '2' AND Active = 10
23
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-24 00:00:00' AND DateTime_program < '2022-09-24 23:59:59' AND Lang = '2' AND Active = 10
24
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-25 00:00:00' AND DateTime_program < '2022-09-25 23:59:59' AND Lang = '2' AND Active = 10
25
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-26 00:00:00' AND DateTime_program < '2022-09-26 23:59:59' AND Lang = '2' AND Active = 10
26
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-27 00:00:00' AND DateTime_program < '2022-09-27 23:59:59' AND Lang = '2' AND Active = 10
27
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-28 00:00:00' AND DateTime_program < '2022-09-28 23:59:59' AND Lang = '2' AND Active = 10
28
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-29 00:00:00' AND DateTime_program < '2022-09-29 23:59:59' AND Lang = '2' AND Active = 10
29
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-09-30 00:00:00' AND DateTime_program < '2022-09-30 23:59:59' AND Lang = '2' AND Active = 10
30
October
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-01 00:00:00' AND DateTime_program < '2022-10-01 23:59:59' AND Lang = '2' AND Active = 10
01
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-02 00:00:00' AND DateTime_program < '2022-10-02 23:59:59' AND Lang = '2' AND Active = 10
02
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-03 00:00:00' AND DateTime_program < '2022-10-03 23:59:59' AND Lang = '2' AND Active = 10
03
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-04 00:00:00' AND DateTime_program < '2022-10-04 23:59:59' AND Lang = '2' AND Active = 10
04
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-05 00:00:00' AND DateTime_program < '2022-10-05 23:59:59' AND Lang = '2' AND Active = 10
05
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-06 00:00:00' AND DateTime_program < '2022-10-06 23:59:59' AND Lang = '2' AND Active = 10
06
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-07 00:00:00' AND DateTime_program < '2022-10-07 23:59:59' AND Lang = '2' AND Active = 10
07
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-08 00:00:00' AND DateTime_program < '2022-10-08 23:59:59' AND Lang = '2' AND Active = 10
08
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-09 00:00:00' AND DateTime_program < '2022-10-09 23:59:59' AND Lang = '2' AND Active = 10
09
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-10 00:00:00' AND DateTime_program < '2022-10-10 23:59:59' AND Lang = '2' AND Active = 10
10
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-11 00:00:00' AND DateTime_program < '2022-10-11 23:59:59' AND Lang = '2' AND Active = 10
11
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-12 00:00:00' AND DateTime_program < '2022-10-12 23:59:59' AND Lang = '2' AND Active = 10
12
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-13 00:00:00' AND DateTime_program < '2022-10-13 23:59:59' AND Lang = '2' AND Active = 10
13
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-14 00:00:00' AND DateTime_program < '2022-10-14 23:59:59' AND Lang = '2' AND Active = 10
14
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-15 00:00:00' AND DateTime_program < '2022-10-15 23:59:59' AND Lang = '2' AND Active = 10
15
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-16 00:00:00' AND DateTime_program < '2022-10-16 23:59:59' AND Lang = '2' AND Active = 10
16
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-17 00:00:00' AND DateTime_program < '2022-10-17 23:59:59' AND Lang = '2' AND Active = 10
17
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-18 00:00:00' AND DateTime_program < '2022-10-18 23:59:59' AND Lang = '2' AND Active = 10
18
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-19 00:00:00' AND DateTime_program < '2022-10-19 23:59:59' AND Lang = '2' AND Active = 10
19
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-20 00:00:00' AND DateTime_program < '2022-10-20 23:59:59' AND Lang = '2' AND Active = 10
20
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-21 00:00:00' AND DateTime_program < '2022-10-21 23:59:59' AND Lang = '2' AND Active = 10
21
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-22 00:00:00' AND DateTime_program < '2022-10-22 23:59:59' AND Lang = '2' AND Active = 10
22
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-23 00:00:00' AND DateTime_program < '2022-10-23 23:59:59' AND Lang = '2' AND Active = 10
23
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-24 00:00:00' AND DateTime_program < '2022-10-24 23:59:59' AND Lang = '2' AND Active = 10
24
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-25 00:00:00' AND DateTime_program < '2022-10-25 23:59:59' AND Lang = '2' AND Active = 10
25
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-26 00:00:00' AND DateTime_program < '2022-10-26 23:59:59' AND Lang = '2' AND Active = 10
26
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-27 00:00:00' AND DateTime_program < '2022-10-27 23:59:59' AND Lang = '2' AND Active = 10
27
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-28 00:00:00' AND DateTime_program < '2022-10-28 23:59:59' AND Lang = '2' AND Active = 10
28
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-29 00:00:00' AND DateTime_program < '2022-10-29 23:59:59' AND Lang = '2' AND Active = 10
29
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-30 00:00:00' AND DateTime_program < '2022-10-30 23:59:59' AND Lang = '2' AND Active = 10
30
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-30 00:00:00' AND DateTime_program < '2022-10-30 23:59:59' AND Lang = '2' AND Active = 10
30
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-10-31 00:00:00' AND DateTime_program < '2022-10-31 23:59:59' AND Lang = '2' AND Active = 10
31
November
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-01 00:00:00' AND DateTime_program < '2022-11-01 23:59:59' AND Lang = '2' AND Active = 10
01
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-02 00:00:00' AND DateTime_program < '2022-11-02 23:59:59' AND Lang = '2' AND Active = 10
02
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-03 00:00:00' AND DateTime_program < '2022-11-03 23:59:59' AND Lang = '2' AND Active = 10
03
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-04 00:00:00' AND DateTime_program < '2022-11-04 23:59:59' AND Lang = '2' AND Active = 10
04
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-05 00:00:00' AND DateTime_program < '2022-11-05 23:59:59' AND Lang = '2' AND Active = 10
05
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-06 00:00:00' AND DateTime_program < '2022-11-06 23:59:59' AND Lang = '2' AND Active = 10
06
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-07 00:00:00' AND DateTime_program < '2022-11-07 23:59:59' AND Lang = '2' AND Active = 10
07
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-08 00:00:00' AND DateTime_program < '2022-11-08 23:59:59' AND Lang = '2' AND Active = 10
08
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-09 00:00:00' AND DateTime_program < '2022-11-09 23:59:59' AND Lang = '2' AND Active = 10
09
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-10 00:00:00' AND DateTime_program < '2022-11-10 23:59:59' AND Lang = '2' AND Active = 10
10
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-11 00:00:00' AND DateTime_program < '2022-11-11 23:59:59' AND Lang = '2' AND Active = 10
11
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-12 00:00:00' AND DateTime_program < '2022-11-12 23:59:59' AND Lang = '2' AND Active = 10
12
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-13 00:00:00' AND DateTime_program < '2022-11-13 23:59:59' AND Lang = '2' AND Active = 10
13
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-14 00:00:00' AND DateTime_program < '2022-11-14 23:59:59' AND Lang = '2' AND Active = 10
14
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-15 00:00:00' AND DateTime_program < '2022-11-15 23:59:59' AND Lang = '2' AND Active = 10
15
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-16 00:00:00' AND DateTime_program < '2022-11-16 23:59:59' AND Lang = '2' AND Active = 10
16
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-17 00:00:00' AND DateTime_program < '2022-11-17 23:59:59' AND Lang = '2' AND Active = 10
17
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-18 00:00:00' AND DateTime_program < '2022-11-18 23:59:59' AND Lang = '2' AND Active = 10
18
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-19 00:00:00' AND DateTime_program < '2022-11-19 23:59:59' AND Lang = '2' AND Active = 10
19
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-20 00:00:00' AND DateTime_program < '2022-11-20 23:59:59' AND Lang = '2' AND Active = 10
20
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-21 00:00:00' AND DateTime_program < '2022-11-21 23:59:59' AND Lang = '2' AND Active = 10
21
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-22 00:00:00' AND DateTime_program < '2022-11-22 23:59:59' AND Lang = '2' AND Active = 10
22
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-23 00:00:00' AND DateTime_program < '2022-11-23 23:59:59' AND Lang = '2' AND Active = 10
23
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-24 00:00:00' AND DateTime_program < '2022-11-24 23:59:59' AND Lang = '2' AND Active = 10
24
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-25 00:00:00' AND DateTime_program < '2022-11-25 23:59:59' AND Lang = '2' AND Active = 10
25
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-26 00:00:00' AND DateTime_program < '2022-11-26 23:59:59' AND Lang = '2' AND Active = 10
26
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-27 00:00:00' AND DateTime_program < '2022-11-27 23:59:59' AND Lang = '2' AND Active = 10
27
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-28 00:00:00' AND DateTime_program < '2022-11-28 23:59:59' AND Lang = '2' AND Active = 10
28
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-29 00:00:00' AND DateTime_program < '2022-11-29 23:59:59' AND Lang = '2' AND Active = 10
29
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-11-30 00:00:00' AND DateTime_program < '2022-11-30 23:59:59' AND Lang = '2' AND Active = 10
30
December
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-01 00:00:00' AND DateTime_program < '2022-12-01 23:59:59' AND Lang = '2' AND Active = 10
01
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-02 00:00:00' AND DateTime_program < '2022-12-02 23:59:59' AND Lang = '2' AND Active = 10
02
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-03 00:00:00' AND DateTime_program < '2022-12-03 23:59:59' AND Lang = '2' AND Active = 10
03
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-04 00:00:00' AND DateTime_program < '2022-12-04 23:59:59' AND Lang = '2' AND Active = 10
04
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-05 00:00:00' AND DateTime_program < '2022-12-05 23:59:59' AND Lang = '2' AND Active = 10
05
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-06 00:00:00' AND DateTime_program < '2022-12-06 23:59:59' AND Lang = '2' AND Active = 10
06
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-07 00:00:00' AND DateTime_program < '2022-12-07 23:59:59' AND Lang = '2' AND Active = 10
07
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-08 00:00:00' AND DateTime_program < '2022-12-08 23:59:59' AND Lang = '2' AND Active = 10
08
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-09 00:00:00' AND DateTime_program < '2022-12-09 23:59:59' AND Lang = '2' AND Active = 10
09
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-10 00:00:00' AND DateTime_program < '2022-12-10 23:59:59' AND Lang = '2' AND Active = 10
10
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-11 00:00:00' AND DateTime_program < '2022-12-11 23:59:59' AND Lang = '2' AND Active = 10
11
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-12 00:00:00' AND DateTime_program < '2022-12-12 23:59:59' AND Lang = '2' AND Active = 10
12
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-13 00:00:00' AND DateTime_program < '2022-12-13 23:59:59' AND Lang = '2' AND Active = 10
13
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-14 00:00:00' AND DateTime_program < '2022-12-14 23:59:59' AND Lang = '2' AND Active = 10
14
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-15 00:00:00' AND DateTime_program < '2022-12-15 23:59:59' AND Lang = '2' AND Active = 10
15
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-16 00:00:00' AND DateTime_program < '2022-12-16 23:59:59' AND Lang = '2' AND Active = 10
16
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-17 00:00:00' AND DateTime_program < '2022-12-17 23:59:59' AND Lang = '2' AND Active = 10
17
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-18 00:00:00' AND DateTime_program < '2022-12-18 23:59:59' AND Lang = '2' AND Active = 10
18
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-19 00:00:00' AND DateTime_program < '2022-12-19 23:59:59' AND Lang = '2' AND Active = 10
19
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-20 00:00:00' AND DateTime_program < '2022-12-20 23:59:59' AND Lang = '2' AND Active = 10
20
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-21 00:00:00' AND DateTime_program < '2022-12-21 23:59:59' AND Lang = '2' AND Active = 10
21
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-22 00:00:00' AND DateTime_program < '2022-12-22 23:59:59' AND Lang = '2' AND Active = 10
22
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-23 00:00:00' AND DateTime_program < '2022-12-23 23:59:59' AND Lang = '2' AND Active = 10
23
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-24 00:00:00' AND DateTime_program < '2022-12-24 23:59:59' AND Lang = '2' AND Active = 10
24
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-25 00:00:00' AND DateTime_program < '2022-12-25 23:59:59' AND Lang = '2' AND Active = 10
25
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-26 00:00:00' AND DateTime_program < '2022-12-26 23:59:59' AND Lang = '2' AND Active = 10
26
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-27 00:00:00' AND DateTime_program < '2022-12-27 23:59:59' AND Lang = '2' AND Active = 10
27
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-28 00:00:00' AND DateTime_program < '2022-12-28 23:59:59' AND Lang = '2' AND Active = 10
28
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-29 00:00:00' AND DateTime_program < '2022-12-29 23:59:59' AND Lang = '2' AND Active = 10
29
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-30 00:00:00' AND DateTime_program < '2022-12-30 23:59:59' AND Lang = '2' AND Active = 10
30
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2022-12-31 00:00:00' AND DateTime_program < '2022-12-31 23:59:59' AND Lang = '2' AND Active = 10
31
January
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-01 00:00:00' AND DateTime_program < '2023-01-01 23:59:59' AND Lang = '2' AND Active = 10
01
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-02 00:00:00' AND DateTime_program < '2023-01-02 23:59:59' AND Lang = '2' AND Active = 10
02
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-03 00:00:00' AND DateTime_program < '2023-01-03 23:59:59' AND Lang = '2' AND Active = 10
03
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-04 00:00:00' AND DateTime_program < '2023-01-04 23:59:59' AND Lang = '2' AND Active = 10
04
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-05 00:00:00' AND DateTime_program < '2023-01-05 23:59:59' AND Lang = '2' AND Active = 10
05
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-06 00:00:00' AND DateTime_program < '2023-01-06 23:59:59' AND Lang = '2' AND Active = 10
06
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-07 00:00:00' AND DateTime_program < '2023-01-07 23:59:59' AND Lang = '2' AND Active = 10
07
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-08 00:00:00' AND DateTime_program < '2023-01-08 23:59:59' AND Lang = '2' AND Active = 10
08
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-09 00:00:00' AND DateTime_program < '2023-01-09 23:59:59' AND Lang = '2' AND Active = 10
09
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-10 00:00:00' AND DateTime_program < '2023-01-10 23:59:59' AND Lang = '2' AND Active = 10
10
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-11 00:00:00' AND DateTime_program < '2023-01-11 23:59:59' AND Lang = '2' AND Active = 10
11
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-12 00:00:00' AND DateTime_program < '2023-01-12 23:59:59' AND Lang = '2' AND Active = 10
12
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-13 00:00:00' AND DateTime_program < '2023-01-13 23:59:59' AND Lang = '2' AND Active = 10
13
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-14 00:00:00' AND DateTime_program < '2023-01-14 23:59:59' AND Lang = '2' AND Active = 10
14
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-15 00:00:00' AND DateTime_program < '2023-01-15 23:59:59' AND Lang = '2' AND Active = 10
15
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-16 00:00:00' AND DateTime_program < '2023-01-16 23:59:59' AND Lang = '2' AND Active = 10
16
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-17 00:00:00' AND DateTime_program < '2023-01-17 23:59:59' AND Lang = '2' AND Active = 10
17
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-18 00:00:00' AND DateTime_program < '2023-01-18 23:59:59' AND Lang = '2' AND Active = 10
18
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-19 00:00:00' AND DateTime_program < '2023-01-19 23:59:59' AND Lang = '2' AND Active = 10
19
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-20 00:00:00' AND DateTime_program < '2023-01-20 23:59:59' AND Lang = '2' AND Active = 10
20
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-21 00:00:00' AND DateTime_program < '2023-01-21 23:59:59' AND Lang = '2' AND Active = 10
21
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-22 00:00:00' AND DateTime_program < '2023-01-22 23:59:59' AND Lang = '2' AND Active = 10
22
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-23 00:00:00' AND DateTime_program < '2023-01-23 23:59:59' AND Lang = '2' AND Active = 10
23
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-24 00:00:00' AND DateTime_program < '2023-01-24 23:59:59' AND Lang = '2' AND Active = 10
24
w
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-25 00:00:00' AND DateTime_program < '2023-01-25 23:59:59' AND Lang = '2' AND Active = 10
25
thu
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-26 00:00:00' AND DateTime_program < '2023-01-26 23:59:59' AND Lang = '2' AND Active = 10
26
f
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-27 00:00:00' AND DateTime_program < '2023-01-27 23:59:59' AND Lang = '2' AND Active = 10
27
sat
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-28 00:00:00' AND DateTime_program < '2023-01-28 23:59:59' AND Lang = '2' AND Active = 10
28
sun
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-29 00:00:00' AND DateTime_program < '2023-01-29 23:59:59' AND Lang = '2' AND Active = 10
29
m
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-30 00:00:00' AND DateTime_program < '2023-01-30 23:59:59' AND Lang = '2' AND Active = 10
30
tue
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2023-01-31 00:00:00' AND DateTime_program < '2023-01-31 23:59:59' AND Lang = '2' AND Active = 10
31

SUSCO Budapest 2016

2016.11.16, Wednesday, 09:00
Akvárium Klub
12 Erzsébet Square, 1051 Budapest

 

The SUSCO Budapest Conference is the biggest event organised by the Sustainable Development Office. The long-term aim of the conference is to establish a Central European sustainable development network. Such a network provides an opportunity to discuss challenges and best practices, as well as exchange experiences and find common solutions for the region. In this spirit, the annual SUSCO Budapest Conference facilitates dialogue among regional, governmental, academic, corporate, and civil spheres.

Sustainable development is one of the most urgent and relevant issues of our time, probably the crucial condition for the future of mankind. The decision whether we want our children to inherit a more liveable world is ours. With the Antall József Knowledge Centre’s conference series on sustainable development – SUSCO Budapest - we would like to call attention to the absolute necessity of setting economic and social objectives while always keeping the environment in mind.

The third instalment of the conference series, SUSCO Budapest 2016, offered an insight into the Habitat III process on integrated urban water management fundamental to the health and equity of cities, why water is an engine for development and is essential to the inclusive, safe, resilient, and sustainable cities that are called for in the Sustainable Development Goals, the key factors influencing water governance in cities, city examples of urban water management and planning, and smart and innovative solutions of the business sector. By showcasing public policies and state-of-the-art solutions, panellists explained how these ideas can assist in tackling the urban water challenge, as well as create more liveable, resilient cities and reduce the vulnerability of populations and city systems to water-stress.

 

Opening Remarks

 

The first opening remark was delivered by Deputy Director Dr Ádám Kégler, on behalf of Mr Péter Antall, director of the Antall József Knowledge Centre. He highlighted that urban areas currently are home to approximately 50% of the global population, projected to reach over 60% by 2050. In this period, water demand will increase globally by 55% and around 4 billion people will live in water-stressed areas.  Therefore, if current tendencies are not changed, water security will be increasingly jeopardised.

To emphasise the key role of water in our everyday lives, as well as in science and urban lifestyles, he described the crystal structure of snowflakes, in which water molecules attach themselves to the six points of the hexagon forming the six arms of a snowflake. While this code of symmetry has inspired mathematicians, physicists, and computer scientists, we should also treat it as a key design element of cities.

Mr Frank Spengler, Resident Representative of the Konrad-Adenauer-Stiftung in Hungary, talked about how access to water and sanitation is a basic human right and the basis of life. He said we have to do everything to provide the appropriate services to citizens and society in general and that in poor regions, water shortage is already a serious problem due to climate change and social changes.

The presentation of Dr Gábor Náray-Szabó, co-president of National Council for Sustainable Development, dealt with shrinking resources, environmental pollution and greenhouse gas emission, climate change, endangered species, and the drying up of the Aral Sea (1977-2013) To solve these problems, he said, we have to reduce consumption and create circular economy, i.e. recycle and reuse waste, and decouple different waste streams. Today, cities represent the centres of these innovative processes.

 

Panel I

 

The moderation of the first panel was carried out by Dr János Zlinszky, director of the Sustainable Development Academy of the Regional Environmental Center for Central and Eastern Europe (REC). The panel concentrated on the review of the international water management policies and initiatives.

 

In his presentation, Mr Faraj El-Awar, head of the Global Water Operators’ Partnerships Alliance Secretariat, highlighted the fact that water is an engine for development and is essential to the inclusive, safe, resilient, and sustainable cities that are called for in the SDGs. The global community should reaffirm the Human Right to Water and Sanitation, adopted by the UN General Assembly in resolution 64/292 on 28 July 2010, and the Sustainable Development Goals, adopted in resolution 70/1 on 25 September 2015. Integrated urban water management is fundamental to the health and equity of cities, and it is critical that water and sanitation services be universally accessible and affordable, in particular for vulnerable populations. He emphasised that water and sanitation services should be viewed beyond the notion of basic services, because water is a fundamental necessity for human life and dignity.

Mr Faraj El-Awar stated that there is a definite need for change in water management and that there is an opportunity for such change in cities due to their nature, metabolism, density (cost-effectiveness), and knowledge base. Numerous tools for policy development in the right direction have been developed recently.  For example, the newly adopted New Urban Agenda at the United Nations Conference on Housing and Sustainable Urban Development (Habitat III) held from 17 to 20 October 2016 in Quito, Ecuador, the most important political commitment by all countries. The Global Water Operators' Partnerships Alliance welcomed the news that, with regard to “urban waters,” the New Urban Agenda calls for equitable access to water and sanitation services, integration of water management approaches at the city level, coordination between all relevant urban institutions for water management, looking at cities within their basins (urban-rural connection), and strengthening of public water utilities through peer-to-peer exchange and support mechanisms.

Ms Oriana Romano, policy analyst within the OECD Water Governance Programme, set the scene by showing the current trends on water demand, which will increase by 55% by 2050 due to growing demand from manufacturing, thermal electricity generation, and domestic use. Water governance is the set of rules, practices, and processes through which decisions for the management of water resources and services are taken and implemented, and decision-makers are held accountable. The OECD points out that the current levels of water security and service delivery in developed, industrialised economies should not be taken for granted and action is needed on three fronts: infrastructure, institution, and information. Water management is not just a pressing issue for cities in developing countries: while cities in the OECD area are able to provide high-quality water services, they cannot rely on current infrastructure to manage too much, too little, and too polluted water now and in the future. Water-related risks are likely to have a strong impact on citizens’ well-being and sustainable growth. Local governments and policymakers should initiate joint action to be prepared for future climate, urban and demographic trends, and the pressures they exert on water resources.

Ms Romano presented the key findings of the OECD report ‘Water Governance in Cities,’ which shows the progress achieved in urban water management in recent decades: among 48 cities surveyed, the average share of wastewater treated was 90% in 2012 compared to 82% in 1990; per capita domestic water consumption decreased by 20% between 2000 and 2012, while 98% of the population had access to drinking water in 2012, compared to 94% in 1990. However, there are still low access rates to sanitation services among select surveyed cities, as in Belo Horizonte (75%) and Veracruz (79%), while some targeted groups (e.g. poor people and those living in disadvantaged areas) are still in need of solutions to achieve affordability. The study concludes by suggesting policy responses around the “3Ps” coordination framework: Policies to allow for coherence across water and other sectors, People to engage stakeholders, and Places for complementarities across cities and surroundings.

The last speaker of the second panel, Martina Zupan, regional chair at Global Water Partnership CEE, pointed out that settlements already face problems such as water stress, limited access to water supply and sanitation, and damage caused by stormwater, while water consumption will expectedly be doubled by 2020. A possible solution could be the Integrated Urban Water Management. Cities have to use different water sources, recycle water, set up institutions and adopt a coherent legislation when it comes to basin and city management. In CEE countries, 30 % of the population live in settlements of less than 2000 inhabitants, therefore policies should focus on housing, land use, and agriculture separately. Ljubljana is a positive example – it has recently been awarded the title of the green capital of Europe.

During the discussion, Dr El-Awar recommended for city administrations and national authorities to secure equitable and sustainable access to water and sanitation, given that it is a human right. Dr Zlinszky emphasised that the Sustainable Development Goals are a value-based system. Ms Romano added that increasing efficiency involves fixing the institutions as for the gaps, overlaps, responsibility, information-sharing, transparency and reboosting the governmental frameworks is necessary.

 

Panel II

 

The second panel involving representatives of Leeuwarden (NL), Bratislava (SK), Bilbao (ES), and Budapest (HU) focused on the water management aspects of a city administration, its challenges, and best practices.  The follow-up discussion was moderated by Gábor Ungvári, Senior Research Associate at the Regional Centre for Energy Policy Research (REKK).

 

The first presentation was jointly delivered by Petra Eszter Katona, researcher at KWR Watercycle Research Institute, and Mr Vereijken, Director of the European Water Stewardship. Ms Katona talked about the City Blueprint Approach describing its two parts. City Blueprint is a quick method to implement a performance framework with 24 indicators in order to create a spiderweb model. The Blue City Index, on the other hand, is governance capacity framework with 27 indicators and 9 conditions that contains suggestions as to what a city should focus on. Mr Vereijken stated that the European Commission is aiming to address these challenges by defining a European “Urban Water Agenda 2030”, which sets water management objectives that European cities should achieve by 2030. This process was launched early this year by the conference ‘Cities & Water’ in Leeuwarden, The Netherlands, where a first draft of the Agenda was presented. The recent conference on urban water management in Bratislava (25 October) was another milestone in the process, which should lead to the signing of the Agenda by a large number of European cities at a conference in Porto in September 2017. A leading methodology to enable cities to achieve the objectives in the Agenda and measure their progress throughout the years is the City Water Stewardship (CWS), built on the European Water Stewardship and the City Blueprint.

According to Mr Stefan Stanko, vice-rector for Education and Head of Department of Sanitary and Environmental Engineering at Slovak University of Technology, despite the fact that Bratislava is a small city, it serves as a good example of urban water management. The challenges the city faces are similar to that of other Central European cities including flood protection, urban heat island effect due to climate change, and water source protection. Measures to solve the problem are also being implemented such as the greening of the city and integrated water management. The Slovak Water Plan covers the water management planning of Bratislava, and the Blue Green Dream initiative provides a range of leading edge software tools to help optimise the design of blue green infrastructure installations.

Afterwards, Asier Abaunza, councillor for urban planning at Bilbao City Council, recounted the water-related evolution of the city. The main changes took place after the 1980s when factories were closed. The city administration had to preserve competitive industries, but remove them from the centre, improve urban design, integrate water into the city look, build promenades, and create new plans to foster clear economic progress (There was an artificial peninsula of industries in the middle of the city, abandoned and polluted. However, famous architect Zaha Hadid is now planning to reconstruct it as an urban technopark.) Her intention is to gather knowledge, tech, art and design at the same place, to find new uses to old buildings, and to build energy efficient houses and an urban beach. As the river is clean again, fish have returned and the bird population is growing. Environmental conditions have improved, so water for consumption is available from the river. Meanwhile, these changes have increased the economic competitiveness of the country, which contributed to them becoming the greenest people in Europe.

According to Szabolcs Sidó, Head of the City Management Department at the Budapest City Council, the main water-related challenges for the city are flood prevention and wastewater management. Budapest has a long-term urban development concept (until 2030), which covers complex integrated wastewater collection projects. Due to the recent improvements wastewater treatment reached now the 100% mark, while the quality of tap water has also greatly increased.

The discussion shed light on the relationship between citizen involvement and development. Mr Abaunza explained that in the case of Bilbao the people accepted the changes as it was the only option for them, while later on they saw the benefits of it and therefore finally they started to actively support it. Hence city changes must be attractive, because people are generally afraid of changes. It is also important to maintain the level of support and enthusiasm for the given project and to start the work with the appropriate political, financial, technological background. If the first steps are close to perfect, the implementer can argue in favour of the changes, but if they are not then nobody will want those changes. According to Tom Vereijken water management is an urgent matter and we have not much time left. There is a reason that big companies invest in environment protection, as it is also profitable for them – he added. In Ms Katona’s opinion, customer involvement in these issues is also a key issue.

 

Panel III

 

The third panel was about finding smart and innovative urban management solutions in the water industry. The panel was moderated by Mr Károly Kovács, President of European Water Association and Hungarian Water Cluster, a member of the EIP Water Steering Group.

 

In the panel, Mr Péter Kereszturi, a representative of Budapest Sewage Works Ltd. and technical director of Veolia Water Hungary, highlighted the challenges of urban water management in Budapest: wastewater treatment and intensive rainfalls. After introducing the sewage system, pipe network, and pumping stations of the city, he defined the primary tasks of the Sewage Works: making new pumping stations, increasing collecting capacity, natural flashing (green solution), as well as delaying the runoff of rainwater by building raingardens (also around households) and green roofs. Dr Zsolt Edgár Rasztovits, Treatment Growth Center Manager at Xylem Inc., described the wide range of industrial solutions at Xylem for fulfilling the requirements of productivity, quality, and resilience.  The third presentation was held by Dr Richard Elelman, Head of Public Administrations at Eurecat-CTM, who summarised the conclusions of the ‘BlueSCities – Making water smart’ project, and showed the audience how to implement integrated water management in cities while also involving citizens and politicians. Mr János Prikk, S&D Energy and Utility Sector Sales Leader at IBM, offered the audience a glimpse into the future, talking about how the smart city concept can contribute to urban water management with the help of smart IT solutions such as metering, monitoring, controlling water-related processes, hyperpersonalised weather forecast and so on. 

Answering to the question of Mr Kovács, Mr. Elelman told the audience that smart technologies are suitable to reach a lot of people with the water issue. But this process should not be faceless, and personal encounters should never be lost in favour of smart technologies. According to Mr Kereszturi, there are open days in treatment plants which are also helpful, however starting the awareness raising with children is a long-term mission, nevertheless due to the urgent character of the issue we also have to come up with quick solutions. Dr Rasztovits shared his opinion that in addition to new technological solutions social responsibility programs are also needed, as the greatest challenge is to make citizens smarter, while they have to realise that they also have to be part of the development process before it is too late. The other challenge is to convince politicians to step up for water, for example their re-election program can be “sexier” if it focuses on such an issue as water.

Closing remarks

Dr Gábor Baranyai, Ministerial Commissioner for the Sustainable Management of Transboundary Natural Resources at Ministry of Justice, summarised the main thoughts and messages of the conference. He expressed his appreciation to AJTK for its long dedication to water related questions. He believes the development of water management is an unstoppable process, while there are also good news in this area: there are solid international frameworks, such as the Budapest Water Summit, SDGs, UN Urban Agenda – Habitat III, OECD and the Leeuwarden Process. According to him there is an unfolding global water crisis we have to address urgently. Although technology will be the key issue – not just the pipes but the smart city implementation and the IT solutions – it will not be a solution on its own, but complemented with the involvement of citizens. As OECD highlighted, this is a crisis of governance too, therefore wide partnership and cooperation is necessary. We all have to know the real values and pay the real price, otherwise we will not be aware of the appropriate treatment of water. Dr Baranyai closed the event with the message that human rights have to be assured for everybody.

 

We hereby express our gratitude to the participants for contributing to the successful realisation of the SUSCO Budapest 2016 conference. We hope that we will have the opportunity to welcome you at other events organised by the Knowledge Centre in the future too.