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

Cybersecurity Challenges and Possible Solutions from a European Perspective

As part of the path of development hallmarked by sustainable and inclusive growth, digitalization and networking, similarly to almost every major change in world history, have raised numerous, previously unknown problems of an increasingly complex nature. As a result, the issue of cyberthreats has become more and more important, which, taking into account the cross-border nature of the challenges, has raised not only an opportunity but rather a necessity for the members of the international community to increase their commitment towards taking joint action. In compliance with this trend, the European Union’s General Data Protection Regulation (GDPR), adopted in 2016, can be seen as a forward-looking achievement both at regional and global level. However, the upcoming European parliamentary elections may bring further changes to the management of the new sources of security threats.

Source: Shutterstock

 

As a result of technological innovation and information revolution accelerated by globalization, the internet has begun to pervade almost each and every field of our lives. By responding to communication challenges deriving from absolute and relative distances, the importance of interpersonal relations developed through the web has started to grow exponentially. However, the overall impact of this tendency is quite dubious. For instance, in connection with the social aspect of negative implications, the question of anonymity raises serious doubts, since it almost entirely diminishes the accountability of internet users, thus enabling a much freer—and consequently, a more offensive or abusive—way of expression, which can facilitate the spread of new forms of persecution and harassment, such as cyberbullying.

Because of the cross-border nature of the emerging challenges, it has become crucial to improve the existing crisis management toolkit, which requires the re-examination and modernization of the normative framework of the prevailing economic and legal regulatory environment, intensifying this way the need for a firm and unified action in key areas that fall under the sovereign jurisdiction of states. Although harmonization can be considered as the guiding principle within these sovereignty-sensitive policy areas, the degree of interdependence of the entities concerned has gradually expanded through the process of preventive and reactive capacity building, thus heightening the willingness of governmental and non-governmental actors to cooperate.

Besides territorial scope, its diversified system of targets and instruments further augment the complexity of problems caused by cybercrime, posing a great threat to (intangible) assets connected to the economic, social, and financial background of actors from both public and private sector. According to a report released in 2018, cybercrime had generated an estimated USD 600 billion loss to the world, representing about 0.8% of the global GDP. Compared to the first version of the report from 2014, these results show a significant growth worth nearly USD 100 billion, which can especially be attributed to the fast adaptability of cybercriminals and to the limited sphere of authority of law enforcement agencies. In addition, the report emphasizes the correlation between the number of losses originating from cybercrime and the economic performance of states, stating that losses are increasing in line with the degree of the wealth of a given country. For instance, concerning the European aspect of the region-specific approach of the analysis, the incidence rate of online frauds and cybercrimes in the United Kingdom can be considered as outstanding, amounting to more than 5.5 million offences annually.

 

Some of the most important data security threats, including malicious software, hacking, and online fraud

Source: Shutterstock

 

By reason of the above-mentioned impact of damages, fight against cybercrime and its negative consequences requires the application of a holistic approach, where both the horizontal and the vertical dimension of the threats has an equally important role. In the present instance, “horizontal” refers to the territorial expansion, while “vertical” indicates the different types and layers of cybercrime. This multifaceted method of analysis is reflected, inter alia, in the Europol’s Internet Organised Crime Threat Assessment (IOCTA), in which a considerable weight was given to the presentation of the wide scale of challenges and possible solutions. According to the latest analysis published in 2018, ransomware remained one of the most decisive means of cybercrime, to which the growing number of subjects affected by the threat and the proliferation of online criminal markets have contributed significantly. In relation to the latter, the document identifies the issue of child sexual exploitation as a further priority area, since the amount and availability of illegal contents on the internet have increased dramatically during recent years. The simultaneity of disparities and overlaps within the nature of threats and abuses thus justifies the strengthening of the international and regional cooperation, including the cybersecurity aspect of European integration as well.

 

Although the European Union adopted the General Data Protection Regulation in May 2016, it became applicable only after the expiry of a two-year grace period on 25 May 2018.

Source: Shutterstock

 

The General Data Protection Regulation (GDPR), applicable since 24 May 2018, became one of the latest milestones in the development of defence and crisis management capabilities against cyberattacks by introducing significant changes, particularly in the field of obtaining, storing, and managing personal data. As a novelty of the Regulation replacing the 95/46/EC data protection directive, the territorial scope of the provisions, as well as the range of penalties that can be imposed in the event of infringement or omission, have been extended. On the one hand, the Regulation separates the obligations and the accountability of data controllers or processors from the place of data management, while on the other hand, it lays down different principles in respect of personal data processing (whether the place of business is in the EU or not). Besides these provisions, infringements committed by the entities concerned shall—in accordance with the principle of proportionality—be subject to administrative fines up to EUR 20 million, or , or in the case of an undertaking, up to 4% of the total worldwide annual turnover of the preceding financial year, whichever is higher. Moreover, in order to ensure and enforce fundamental rights related to the protection of personal data, the Regulation entitles the data subjects to rectify or erase data concerning them, as well as to restrict or object to data processing.

Notwithstanding all of the above-mentioned merits, technological innovation has opened up previously unknown dimensions of the human rights aspect of law enforcement and justice practices that fall outside the spectrum of rights and obligations covered by the Regulation. For instance, the use of automated facial recognition technology (AFR) raises serious questions, on the one hand, about the moral implications of accessing databases related to the freedom of assembly and expression, and on the other hand, in respect of the ability to connect databases held by states and/or companies. Nevertheless, the development potential in the regional and international security and defence systems places challenges akin to AFR in a quite new perspective, focusing primarily on the importance of reciprocity and joint action.

 

Source: Shutterstock

 

Taking into account the efforts made towards reaching compromises and increasing efficiency, the EU has achieved significant progress in the field of cybersecurity, both on the level of member states and institutions. In December 2018, an agreement was reached on the Cybersecurity Act, which, in addition to giving a permanent mandate for the EU Cyber Security Agency (ENISA), establishes a common framework for European Cybersecurity Certificates. According to the latter provision, it will be possible to issue certificates that are valid throughout the EU, which may increase consumer confidence in products and services concerned, and reduce both discrepancies arising from different national regulations and the cost of certification for companies.

Last but not least, in light of the upcoming European parliamentary elections, particular interest was given to the European Commission’s proposal, submitted in January, to establish a “Network of National Coordination Centres” and a “Cybersecurity Industrial, Technology and Research Competence Centre.” The importance of the decision to be taken is twofold; firstly, in case the draft is adopted, it will further deepen cooperation among institutions. Secondly, and more importantly, the Centre would become responsible for implementing the budget for the Digital Europe and Horizon Europe programs, the total value of which amounts to more than EUR 2 billion. All in all, we can say that the results of the elections can bring significant changes to the future of the European cybersecurity, particularly in the view of the wavering balance of powers in the political sphere, which might have a major impact on the pace and depth of the cooperation that has begun in the recent years.