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

Elements of the Whole Puzzle

In general, fossil fuels are in the focus of attention as the most demanded raw materials, even though non-energy raw materials, such as rare earth materials, also have a key implication on the raw material supply chessboard. In our new miniseries, we will introduce the most important problems related to these lesser-known but all the more important chemical elements to you. The topic will be further discussed at our yearly international sustainable development conference “SUSCO BUDAPEST 2019 – Resource Competition: ON” focusing on the sustainable use of the natural resources which are becoming the driving force behind global development.

 

Source: Shutterstock

 

It is hard to go a day without using rare earth elements (REEs). Let’s just think about smartphones, televisions, or computers. Compared to how difficult it is to produce rare earths, it is surprisingly easy to find them: contrary to what their name indicates, their occurrence is not that uncommon—although economically mineable deposits can be quite rare. Some of them are essential for today’s manufacturing technology: with the advancement of science, the improvement of information technology, transport, household tools, and robotics, the use of different materials and elements became indispensable. The first thing which usually might come to one’s mind is that we need a bunch of plastic, some aluminium and silicon for the chips, copper for the wires, and we are ready. Of course, reality is much more complicated. There is hardly any element in the periodic system that would not be used to produce our everyday high-tech equipment and our pocket-sized gadgets. The strongest demand for rare earths is in the permanent magnet sector, as they are essential components of cell phones, flat-screen televisions, computer chips, automobiles, wind turbines, nuclear power, aircraft, to name a few. Their widespread use in high-technology products and also in low-carbon technologies is also due to their exceptional luminescent, catalytic, and electrochemical properties.

 

Rare earth elements uses, 2017

Source of data: Natural Resources Canada, licence: non-commercial reproduction

 

It is very interesting to realise that there are so many components in the devices around us; however, this astonishment turns serious when it becomes clear that rare earths are practically mined only in China. More than 80% of world production comes from there, and the country is less and less willing to serve the global industry’s needs but would rather keep the majority of the supplies to itself. Disruptions to supply and increase in costs of imports is constantly fuelling uncertainty around the topic. Rare earth elements are generally subdivided into light (LREE) and heavy elements (HREE). Among the 17 rare earth elements, light REEs include lanthanum, cerium, praseodymium, neodymium, promethium, samarium, europium, gadolinium and scandium: they are considered to be produced in global abundance and are in surplus supply. Heavy REEs, such as terbium, dysprosium, holmium, erbium, thulium, ytterbium, lutetium and yttrium, are produced mainly in China and are in limited supply.

 

Scandium is found in most rare earth element deposits and is classified as a rare earth element as well

 

Unlike most of the well-known elements (copper, silver, gold), rare earths do not clump together in single-element lumps. They have a similar chemical composition (15 of the 17 rare earth elements occupy consecutive places on the periodic table), and due to this, they bond easily with one another in minerals. Turning these minerals into useful material is costly and complicated: to get rare earths from the ore that contains them, the material has to be dissolved in solutions of acids over and over again, then it has to be filtered and dissolved again. “The goal is not so much to remove rare earths from the mix as to remove everything else,” writes David S. Abraham, author of the book The Elements of Power.

In general, western countries have not viewed REEs as strategic commodities. The term “strategic” used for a primary commodity usually reflects a nation’s perception of exposure and vulnerability to supply disruptions. If the needed raw material does not have many or economically feasible substitutes, and it primarily comes from foreign countries, a disrupted supply chain needs to be rethought and revised rapidly to protect the exposed nation’s industries from the consequences of a loss of supplies. For example, the production of semiconductors (of which RREs are integral components as well) is one of the most important drivers of economic growth in the electronics value chain. Since the beginning of the 2000s, nearly 10% of global GDP has been generated by producing and trading electrical systems related to semiconductors in some form. So now, electronics manufacturers, electric automakers, clean energy technology industry leaders might have growing concerns, not even mentioning leaders of the military–industrial complexes: as said, China mines about 80% of the 17 elements that appear on the periodic table and are essential for the most modern weapon systems. Plus, the country is the leading global producer of around 40 mineral raw materials, at either the mining or the processing stage.

Countries of the European Union also need to relaunch the assessment, exploration, and evaluation of strategic mineral resource stocks within the continent. It had been claimed in expert reports for years, but the concept of a circular economy model only became widely known when the European Union’s Circular Economy Package was adopted in December 2015. The issue of critical raw materials is one of the five priority areas of the Circular Economy Package. (The main idea of the circular economy model is an economy which is regenerative by design, and where products and services are traded in closed loops with the aim to retain as much value as possible).

 

World REEs supply, 1987–2017

Source: Natural Resources Canada, licence: non-commercial reproduction (the reproduction is a copy of an official work that is published by the Government of Canada and has not been produced in affiliation with or with the endorsement of the Government of Canada)

 

However, mining is one of the most highly polluting of all human activities, and stocks often coexist with radioactive elements, e.g., uranium and thorium, which require separate treatments and procedures. As mentioned, a rare earth ore goes through separation procedures a dozen times. The whole process is expensive, complex, and dangerous, and in the end, it produces a number of awful chemical byproducts, making rare earth mining and refining, indisputably, one of the most dangerous and most damaging environmental activities in the world. The Chinese mines alone are estimated to produce ca. ten million tonnes of acidic radioactive waste yearly. The area of the “rare earth’s capital,” Baotou, a larger resource hinterland of China, converted into a lunar landscape in a few years: the vegetation disappeared and the population of the neighbouring villages was displaced after inhabitants began to lose their hair massively due to the toxic substances leaking into the drinking water of the area.

 

A lunar landscape at Baotou

Source: Shutterstock

 

Until the 1980s, the US had an actual dominance in the rare earth supply, providing the world with these elements, all extracted in Mountain Pass, California. With China’s appearing on the market, Mountain Pass was not able to keep up with the depressed prices and closed its doors at the beginning of the 2000s. However, there are many other reasons for keeping production overseas—unfortunately, they are all the “usual ones”: cheap labour costs and the Chinese willingness to overlook environmental damage. Yet it is also a fact that rare earth production in China is often combined with other mining operations, and rare earths appear as byproducts of more lucrative extraction processes. So in most cases, Chinese producers have the advantage of escaping the swings of the market as they are not reliant on a single product. However, Mountain Pass restarted in January 2018, and, under the current plans and according to the official version, the aim is to process rare earths for domestic use in the clean energy sector.

But for all that, the increasing Chinese monopoly in the worldwide supply chain might have important implications for the manipulation of the global trade chessboard.