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

Making sense of Japan’s New Immigration Policy

On November 27, Japan’s Lower House passed the long disputed new regulation about letting more foreign workers into the country. Passed, or rather forced through, for the opposition parties went to extremes to prevent the law to get accepted. A strange concept indeed: the liberal leaning opposition is against a new immigration law, and the conservative ruling party forces it through. What might be the problem with the bill?

The proposed new visa system has been criticized heavily by the opposition parties and experts, even though it seemingly tries to act on the severe labour force shortage due to the rapidly aging society and falling birth rate. The plan is targeting blue collar-workers in 14 sectors for two kinds of visa statuses, allowing hundreds of thousands to spend either 5 or 10 years in Japan. So far, only highly skilled professionals has been granted long term visas, such as those in the medical sector, but now newly accepted professions include analysts (not specified), consultants, R&D professionals, trade and finance professionals, financial product developers, construction workers, agricultural workers, healthcare professionals. These sectors have been identified as sectors suffering the most from labour shortage.

 

The Lower House of the Japanese National Diet

Source: Shutterstock

 

According to analysts, many questions are looming with this new policy. For one, exact numbers are yet to be confirmed, which causes concern, especially if social infrastructure is taken into account. There have been cases in the past, when rushed immigration policies placed a heavy burden on local communities and foreigners alike due to the lack of social infrastructure. A notable case is the major influx of nikkeijins in the 1990s. Nikkeijin is a term used for South American citizens of Japanese descent, who formed diaspora communities mainly in Brazil and Peru. The 1990 regulation provided a favourable visa for those having Japanese bloodline to work and settle down in Japan. The unforeseen amount of migrant workers going to Japan, however, met with issues upon arriving, as the educational system was not prepared for nikkeijin children. The lack of language teaching (not to mention the inability to socially include them) became an apparent problem for the families. This case might be a good indication for the current government, noting that the newly introduced plan involves a visa for a 10-year long period that allows family members to join the applicant. The ruling party, however, is yet to address this issue.

Another complaint that came from the critics is connected to the many problems that the already existing trainee programme bears. There has been growing awareness about the exploitation and mistreatment foreign nationals are experiencing in the Technical Intern Trainee Program that Japan employs. Such abuse manifests itself in considerable overtime work, underpaid foreign employees, and the holding back of contracts or even passports. Similarly unsuccessful situation has arose during the final years of the 2000s, when the Japanese government established a programme for accepting healthcare professionals, mostly nurses and caretakers to replenish the healthcare sector dwindling in number. The applicants in this programme had to go through several extensive examinations, but when accepted, the local hospitals and medical institutions restricted their scope of activity, and allowed them to do only those procedures that falls way behind their expertise, and the tasks during their examinations.  

However, not every labour-related programme had misgivings. The JET programme (Japan Exchange and Teaching Programme) outdone itself in this regard, as it now has an internationally good reputation. The programme provides opportunity for foreigners to teach the English language in Japan’s many educational institutions including kindergartens and high schools. Japan accepts applications from 40 countries, and the programme has been successful for decades.

 

A Japanese Immigration Card

Source: Shutterstock

 

The current immigration bill is yet to prove that the above consequences were considered when proposing the plan. The deliberation process was exceptionally fast: 17 hours and 15 minutes (including the periods when the opposition party member boycotted the committee meetings), instead of the minimum 20 hours. There was a data mishap too: the Justice Ministry provided false statistics about foreign trainees during the sessions and about why they left their jobs, which urged the opposition to raise their voices by placing a no-confidence motion against Justice Minister Yamashita Takashi, who was in charge of the bill. The ruling Liberal Democratic Party voted down the motion, therefore, the bill passed. The new visa structure will be implemented in April 2019.

It is undeniable that Japan is in dire need of a solution for the labour shortage and aging society, and that the solution is most likely to be foreign workforce, but concerns about labour rights regarding this vague construction are real and valid. As the date of the 2020 Tokyo Summer Olympics is getting closer, it is no wonder that the Abe administration is in rush to relieve the labour market, but the method and way of execution will play a prominent part.