Július
h
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 = '1' AND Active = 10
01
k
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 = '1' AND Active = 10
02
sze
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 = '1' AND Active = 10
03
cs
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 = '1' AND Active = 10
04
p
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 = '1' AND Active = 10
05
szo
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 = '1' AND Active = 10
06
v
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 = '1' AND Active = 10
07
h
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 = '1' AND Active = 10
08
k
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 = '1' AND Active = 10
09
sze
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 = '1' AND Active = 10
10
cs
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 = '1' AND Active = 10
11
p
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 = '1' AND Active = 10
12
szo
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 = '1' AND Active = 10
13
v
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 = '1' AND Active = 10
14
h
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 = '1' AND Active = 10
15
k
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 = '1' AND Active = 10
16
sze
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 = '1' AND Active = 10
17
cs
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 = '1' AND Active = 10
18
p
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 = '1' AND Active = 10
19
szo
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 = '1' AND Active = 10
20
v
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 = '1' AND Active = 10
21
h
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 = '1' AND Active = 10
22
k
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 = '1' AND Active = 10
23
sze
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 = '1' AND Active = 10
24
cs
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 = '1' AND Active = 10
25
p
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 = '1' AND Active = 10
26
szo
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 = '1' AND Active = 10
27
v
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 = '1' AND Active = 10
28
h
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 = '1' AND Active = 10
29
k
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 = '1' AND Active = 10
30
sze
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 = '1' AND Active = 10
31
Augusztus
cs
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 = '1' AND Active = 10
01
p
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 = '1' AND Active = 10
02
szo
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 = '1' AND Active = 10
03
v
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 = '1' AND Active = 10
04
h
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 = '1' AND Active = 10
05
k
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 = '1' AND Active = 10
06
sze
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 = '1' AND Active = 10
07
cs
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 = '1' AND Active = 10
08
p
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 = '1' AND Active = 10
09
szo
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 = '1' AND Active = 10
10
v
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 = '1' AND Active = 10
11
h
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 = '1' AND Active = 10
12
k
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 = '1' AND Active = 10
13
sze
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 = '1' AND Active = 10
14
cs
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 = '1' AND Active = 10
15
p
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 = '1' AND Active = 10
16
szo
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 = '1' AND Active = 10
17
v
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 = '1' AND Active = 10
18
h
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 = '1' AND Active = 10
19
k
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 = '1' AND Active = 10
20
sze
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 = '1' AND Active = 10
21
cs
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 = '1' AND Active = 10
22
p
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 = '1' AND Active = 10
23
szo
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 = '1' AND Active = 10
24
v
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 = '1' AND Active = 10
25
h
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 = '1' AND Active = 10
26
k
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 = '1' AND Active = 10
27
sze
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 = '1' AND Active = 10
28
cs
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 = '1' AND Active = 10
29
p
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 = '1' AND Active = 10
30
szo
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 = '1' AND Active = 10
31
Szeptember
v
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 = '1' AND Active = 10
01
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-02 00:00:00' AND DateTime_program < '2019-09-02 23:59:59' AND Lang = '1' AND Active = 10
02
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-03 00:00:00' AND DateTime_program < '2019-09-03 23:59:59' AND Lang = '1' AND Active = 10
03
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-04 00:00:00' AND DateTime_program < '2019-09-04 23:59:59' AND Lang = '1' AND Active = 10
04
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-05 00:00:00' AND DateTime_program < '2019-09-05 23:59:59' AND Lang = '1' AND Active = 10
05
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-06 00:00:00' AND DateTime_program < '2019-09-06 23:59:59' AND Lang = '1' AND Active = 10
06
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-07 00:00:00' AND DateTime_program < '2019-09-07 23:59:59' AND Lang = '1' AND Active = 10
07
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-08 00:00:00' AND DateTime_program < '2019-09-08 23:59:59' AND Lang = '1' AND Active = 10
08
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-09 00:00:00' AND DateTime_program < '2019-09-09 23:59:59' AND Lang = '1' AND Active = 10
09
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-10 00:00:00' AND DateTime_program < '2019-09-10 23:59:59' AND Lang = '1' AND Active = 10
10
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-11 00:00:00' AND DateTime_program < '2019-09-11 23:59:59' AND Lang = '1' AND Active = 10
11
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-12 00:00:00' AND DateTime_program < '2019-09-12 23:59:59' AND Lang = '1' AND Active = 10
12
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-13 00:00:00' AND DateTime_program < '2019-09-13 23:59:59' AND Lang = '1' AND Active = 10
13
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-14 00:00:00' AND DateTime_program < '2019-09-14 23:59:59' AND Lang = '1' AND Active = 10
14
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-15 00:00:00' AND DateTime_program < '2019-09-15 23:59:59' AND Lang = '1' AND Active = 10
15
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-16 00:00:00' AND DateTime_program < '2019-09-16 23:59:59' AND Lang = '1' AND Active = 10
16
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-17 00:00:00' AND DateTime_program < '2019-09-17 23:59:59' AND Lang = '1' AND Active = 10
17
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-18 00:00:00' AND DateTime_program < '2019-09-18 23:59:59' AND Lang = '1' AND Active = 10
18
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-19 00:00:00' AND DateTime_program < '2019-09-19 23:59:59' AND Lang = '1' AND Active = 10
19
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-20 00:00:00' AND DateTime_program < '2019-09-20 23:59:59' AND Lang = '1' AND Active = 10
20
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-21 00:00:00' AND DateTime_program < '2019-09-21 23:59:59' AND Lang = '1' AND Active = 10
21
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-22 00:00:00' AND DateTime_program < '2019-09-22 23:59:59' AND Lang = '1' AND Active = 10
22
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-23 00:00:00' AND DateTime_program < '2019-09-23 23:59:59' AND Lang = '1' AND Active = 10
23
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-24 00:00:00' AND DateTime_program < '2019-09-24 23:59:59' AND Lang = '1' AND Active = 10
24
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-25 00:00:00' AND DateTime_program < '2019-09-25 23:59:59' AND Lang = '1' AND Active = 10
25
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-26 00:00:00' AND DateTime_program < '2019-09-26 23:59:59' AND Lang = '1' AND Active = 10
26
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-27 00:00:00' AND DateTime_program < '2019-09-27 23:59:59' AND Lang = '1' AND Active = 10
27
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-28 00:00:00' AND DateTime_program < '2019-09-28 23:59:59' AND Lang = '1' AND Active = 10
28
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-29 00:00:00' AND DateTime_program < '2019-09-29 23:59:59' AND Lang = '1' AND Active = 10
29
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-09-30 00:00:00' AND DateTime_program < '2019-09-30 23:59:59' AND Lang = '1' AND Active = 10
30
Október
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-01 00:00:00' AND DateTime_program < '2019-10-01 23:59:59' AND Lang = '1' AND Active = 10
01
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-02 00:00:00' AND DateTime_program < '2019-10-02 23:59:59' AND Lang = '1' AND Active = 10
02
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-03 00:00:00' AND DateTime_program < '2019-10-03 23:59:59' AND Lang = '1' AND Active = 10
03
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-04 00:00:00' AND DateTime_program < '2019-10-04 23:59:59' AND Lang = '1' AND Active = 10
04
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-05 00:00:00' AND DateTime_program < '2019-10-05 23:59:59' AND Lang = '1' AND Active = 10
05
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-06 00:00:00' AND DateTime_program < '2019-10-06 23:59:59' AND Lang = '1' AND Active = 10
06
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-07 00:00:00' AND DateTime_program < '2019-10-07 23:59:59' AND Lang = '1' AND Active = 10
07
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-08 00:00:00' AND DateTime_program < '2019-10-08 23:59:59' AND Lang = '1' AND Active = 10
08
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-09 00:00:00' AND DateTime_program < '2019-10-09 23:59:59' AND Lang = '1' AND Active = 10
09
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-10 00:00:00' AND DateTime_program < '2019-10-10 23:59:59' AND Lang = '1' AND Active = 10
10
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-11 00:00:00' AND DateTime_program < '2019-10-11 23:59:59' AND Lang = '1' AND Active = 10
11
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-12 00:00:00' AND DateTime_program < '2019-10-12 23:59:59' AND Lang = '1' AND Active = 10
12
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-13 00:00:00' AND DateTime_program < '2019-10-13 23:59:59' AND Lang = '1' AND Active = 10
13
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-14 00:00:00' AND DateTime_program < '2019-10-14 23:59:59' AND Lang = '1' AND Active = 10
14
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-15 00:00:00' AND DateTime_program < '2019-10-15 23:59:59' AND Lang = '1' AND Active = 10
15
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-16 00:00:00' AND DateTime_program < '2019-10-16 23:59:59' AND Lang = '1' AND Active = 10
16
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-17 00:00:00' AND DateTime_program < '2019-10-17 23:59:59' AND Lang = '1' AND Active = 10
17
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-18 00:00:00' AND DateTime_program < '2019-10-18 23:59:59' AND Lang = '1' AND Active = 10
18
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-19 00:00:00' AND DateTime_program < '2019-10-19 23:59:59' AND Lang = '1' AND Active = 10
19
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-20 00:00:00' AND DateTime_program < '2019-10-20 23:59:59' AND Lang = '1' AND Active = 10
20
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-21 00:00:00' AND DateTime_program < '2019-10-21 23:59:59' AND Lang = '1' AND Active = 10
21
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-22 00:00:00' AND DateTime_program < '2019-10-22 23:59:59' AND Lang = '1' AND Active = 10
22
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-23 00:00:00' AND DateTime_program < '2019-10-23 23:59:59' AND Lang = '1' AND Active = 10
23
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-24 00:00:00' AND DateTime_program < '2019-10-24 23:59:59' AND Lang = '1' AND Active = 10
24
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-25 00:00:00' AND DateTime_program < '2019-10-25 23:59:59' AND Lang = '1' AND Active = 10
25
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-26 00:00:00' AND DateTime_program < '2019-10-26 23:59:59' AND Lang = '1' AND Active = 10
26
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-27 00:00:00' AND DateTime_program < '2019-10-27 23:59:59' AND Lang = '1' AND Active = 10
27
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-27 00:00:00' AND DateTime_program < '2019-10-27 23:59:59' AND Lang = '1' AND Active = 10
27
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-28 00:00:00' AND DateTime_program < '2019-10-28 23:59:59' AND Lang = '1' AND Active = 10
28
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-29 00:00:00' AND DateTime_program < '2019-10-29 23:59:59' AND Lang = '1' AND Active = 10
29
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-30 00:00:00' AND DateTime_program < '2019-10-30 23:59:59' AND Lang = '1' AND Active = 10
30
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-10-31 00:00:00' AND DateTime_program < '2019-10-31 23:59:59' AND Lang = '1' AND Active = 10
31
November
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-01 00:00:00' AND DateTime_program < '2019-11-01 23:59:59' AND Lang = '1' AND Active = 10
01
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-02 00:00:00' AND DateTime_program < '2019-11-02 23:59:59' AND Lang = '1' AND Active = 10
02
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-03 00:00:00' AND DateTime_program < '2019-11-03 23:59:59' AND Lang = '1' AND Active = 10
03
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-04 00:00:00' AND DateTime_program < '2019-11-04 23:59:59' AND Lang = '1' AND Active = 10
04
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-05 00:00:00' AND DateTime_program < '2019-11-05 23:59:59' AND Lang = '1' AND Active = 10
05
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-06 00:00:00' AND DateTime_program < '2019-11-06 23:59:59' AND Lang = '1' AND Active = 10
06
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-07 00:00:00' AND DateTime_program < '2019-11-07 23:59:59' AND Lang = '1' AND Active = 10
07
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-08 00:00:00' AND DateTime_program < '2019-11-08 23:59:59' AND Lang = '1' AND Active = 10
08
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-09 00:00:00' AND DateTime_program < '2019-11-09 23:59:59' AND Lang = '1' AND Active = 10
09
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-10 00:00:00' AND DateTime_program < '2019-11-10 23:59:59' AND Lang = '1' AND Active = 10
10
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-11 00:00:00' AND DateTime_program < '2019-11-11 23:59:59' AND Lang = '1' AND Active = 10
11
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-12 00:00:00' AND DateTime_program < '2019-11-12 23:59:59' AND Lang = '1' AND Active = 10
12
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-13 00:00:00' AND DateTime_program < '2019-11-13 23:59:59' AND Lang = '1' AND Active = 10
13
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-14 00:00:00' AND DateTime_program < '2019-11-14 23:59:59' AND Lang = '1' AND Active = 10
14
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-15 00:00:00' AND DateTime_program < '2019-11-15 23:59:59' AND Lang = '1' AND Active = 10
15
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-16 00:00:00' AND DateTime_program < '2019-11-16 23:59:59' AND Lang = '1' AND Active = 10
16
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-17 00:00:00' AND DateTime_program < '2019-11-17 23:59:59' AND Lang = '1' AND Active = 10
17
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-18 00:00:00' AND DateTime_program < '2019-11-18 23:59:59' AND Lang = '1' AND Active = 10
18
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-19 00:00:00' AND DateTime_program < '2019-11-19 23:59:59' AND Lang = '1' AND Active = 10
19
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-20 00:00:00' AND DateTime_program < '2019-11-20 23:59:59' AND Lang = '1' AND Active = 10
20
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-21 00:00:00' AND DateTime_program < '2019-11-21 23:59:59' AND Lang = '1' AND Active = 10
21
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-22 00:00:00' AND DateTime_program < '2019-11-22 23:59:59' AND Lang = '1' AND Active = 10
22
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-23 00:00:00' AND DateTime_program < '2019-11-23 23:59:59' AND Lang = '1' AND Active = 10
23
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-24 00:00:00' AND DateTime_program < '2019-11-24 23:59:59' AND Lang = '1' AND Active = 10
24
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-25 00:00:00' AND DateTime_program < '2019-11-25 23:59:59' AND Lang = '1' AND Active = 10
25
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-26 00:00:00' AND DateTime_program < '2019-11-26 23:59:59' AND Lang = '1' AND Active = 10
26
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-27 00:00:00' AND DateTime_program < '2019-11-27 23:59:59' AND Lang = '1' AND Active = 10
27
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-28 00:00:00' AND DateTime_program < '2019-11-28 23:59:59' AND Lang = '1' AND Active = 10
28
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-29 00:00:00' AND DateTime_program < '2019-11-29 23:59:59' AND Lang = '1' AND Active = 10
29
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-11-30 00:00:00' AND DateTime_program < '2019-11-30 23:59:59' AND Lang = '1' AND Active = 10
30

Kína jogrendszerének reformja: 40 év távlatából

workshop

2019.05.29 | AJTK Előadóterem | ÁZSIAI ÉS AFRIKAI KAPCSOLATOK IRODÁJA |

Az Antall József Tudásközpont és a Kína-KKE Intézet közös szervezésében került megrendezésre a Kína jogrendszerének reformja: 40 év távlatából című workshop 2019. május 27-én. Az eseményen a Kínai Társadalomtudományi Akadémia (CASS) Nemzetközi Jogi Intézetének szakértői tartottak előadásokat arról, hogy a reform és nyitás politikájának negyven éve hogyan alakította át Kína jogrendszerét. 

A rendezvényt Csepregi Zsolt, az AJTK nemzetközi koordinátora nyitotta meg. A workshop első előadója Dr. Mo Jihong, a CASS Nemzetközi Jogi Intézetének igazgatója volt, aki a mai államszervezet kialakulásához vezető utat ismertette. Előadásában nagy hangsúlyt kapott a Kínai Népköztársaság megalakulása óta elfogadott négy alkotmány és azok különböző módosításai, különös tekintettel a 2018 márciusában megrendezett 13. Országos Népi Gyűlés és a 13. Kínai Népi Politikai Tanácskozó Testület ülésén megszavazott legutóbbi alkotmánymódosítás.

Dr. Liao Fan professzor Kína reform és nyitás politikájának meghirdetése óta bekövetkezett fontosabb, országon belüli jogi változásokról, valamint az országba áramló közvetlen külföldi tőkebefektetésekre (FDI) vonatkozó törvények fejlődéséről beszélt. Dr. Huang Jin egyetemi docens a nemzetbiztonsági kérdéseket érintő jogi szabályozások fejlődését mutatta be beszédében. Őt követte Dr. Wang Tianyu egyetemi docens, aki a kínai gazdaság és az e-kereskedelem fejlődésének kihívásaira adott munkajogi válaszokat elemezte, valamint a humán erőforrás menedzsment új jogi keretrendszerét mutatta be. A workshop utolsó előadójaként Dr. Jiang Xiaohong professzor előadásában az „Övezet és Út” kezdeményezés (BRI) egyre növekvő geopolitikai fontosságát emelte ki, valamint a nemzetközi kereskedelmi és befektetési jog fejlődését ismertette.

 

balról jobbra: Dr. Huang Jin, Dr. Liao Fan, Dr. Mo Jihong, Jiang Xiaohong, Dr. Wang Tianyu