Május
sze
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 = '1' AND Active = 10
01
cs
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 = '1' AND Active = 10
02
p
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 = '1' AND Active = 10
03
szo
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 = '1' AND Active = 10
04
v
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 = '1' AND Active = 10
05
h
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 = '1' AND Active = 10
06
k
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 = '1' AND Active = 10
07
sze
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 = '1' AND Active = 10
08
cs
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 = '1' AND Active = 10
09
p
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 = '1' AND Active = 10
10
szo
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 = '1' AND Active = 10
11
v
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 = '1' AND Active = 10
12
h
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 = '1' AND Active = 10
13
k
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 = '1' AND Active = 10
14
sze
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 = '1' AND Active = 10
15
cs
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 = '1' AND Active = 10
16
p
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 = '1' AND Active = 10
17
szo
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 = '1' AND Active = 10
18
v
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 = '1' AND Active = 10
19
h
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 = '1' AND Active = 10
20
k
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 = '1' AND Active = 10
21
sze
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 = '1' AND Active = 10
22
cs
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 = '1' AND Active = 10
23
p
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 = '1' AND Active = 10
24
szo
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 = '1' AND Active = 10
25
v
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 = '1' AND Active = 10
26
h
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 = '1' AND Active = 10
27
k
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 = '1' AND Active = 10
28
sze
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 = '1' AND Active = 10
29
cs
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 = '1' AND Active = 10
30
p
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 = '1' AND Active = 10
31
Június
szo
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 = '1' AND Active = 10
01
v
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 = '1' AND Active = 10
02
h
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 = '1' AND Active = 10
03
k
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 = '1' AND Active = 10
04
sze
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 = '1' AND Active = 10
05
cs
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 = '1' AND Active = 10
06
p
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 = '1' AND Active = 10
07
szo
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 = '1' AND Active = 10
08
v
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 = '1' AND Active = 10
09
h
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 = '1' AND Active = 10
10
k
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 = '1' AND Active = 10
11
sze
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 = '1' AND Active = 10
12
cs
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 = '1' AND Active = 10
13
p
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 = '1' AND Active = 10
14
szo
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 = '1' AND Active = 10
15
v
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 = '1' AND Active = 10
16
h
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 = '1' AND Active = 10
17
k
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 = '1' AND Active = 10
18
sze
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 = '1' AND Active = 10
19
cs
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 = '1' AND Active = 10
20
p
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 = '1' AND Active = 10
21
szo
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 = '1' AND Active = 10
22
v
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 = '1' AND Active = 10
23
h
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 = '1' AND Active = 10
24
k
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 = '1' AND Active = 10
25
sze
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 = '1' AND Active = 10
26
cs
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 = '1' AND Active = 10
27
p
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 = '1' AND Active = 10
28
szo
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 = '1' AND Active = 10
29
v
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 = '1' AND Active = 10
30
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
Könyvkiadás - TANKÖNYVEK

Csoma Mózes: Korea története

Kiadási év: 2018
Ár: 4500 Ft

Az elmúlt években a Koreai-félsziget helyzete a nemzetközi politika egyik kiemelt ügyévé vált. Dr. Csoma Mózes Korea-kutató monográfiája a kezdetektől a legutóbbi fejleményekig mutatja be a félsziget történetét, az egyes korszakok tárgyalásánál pedig részletesen kiemeli a dél-koreai és az észak-koreai történelemszemlélet közti különbözőségeket.

A hidegháborús megosztottság ugyanis a félsziget ókori, középkori és újkori történelmének értelmezésére is rányomta bélyegét: a Koreai Köztársaság és a KNDK tankönyvei más-más módon mutatják be az egyes korszakokat és a történelmi szereplőket.

A 20. századi fejlemények tárgyalásakor a szerző nagy számban használt fel eddig publikálatlan levéltári forrásokat, amelyek sok új információt tartalmaznak a Koreai-félsziget viszonyainak alakulásáról. A monográfia elkészítéséhez a szerző több volt diplomatával és egyéb szemtanúval készített interjút, akik az elmúlt évtizedek során forrásértékű megfigyeléseket tettek a koreai politikai folyamatokról.

Marton Péter: A KÜLPOLITIKA ELEMZÉSE – FOGALMAK ÉS MÓDSZEREK A KÜLPOLITIKA FORRÁSAINAK FELTÁRÁSÁRA

Kiadási év: 2014
Ár: 2600 Ft

Az államok határain átívelő politikai, gazdasági, kulturális és társadalmi kapcsolatok intenzitásának és összetettségének gyors növekedése mára aláásta a külpolitika elsődlegességének elvét mind a nemzetközi, mind pedig a hazai politikai döntéshozatalban. Ezek a változások azonban éppenséggel növelték az átgondolt külpolitikai elemzés jelentőségét, hiszen a sikeres külpolitikai döntéshozatal egy állam számára döntő fontosságú lehet napjaink komplex globális versengésében. Marton Péter hiánypótló könyve rendkívül olvasmányosan, a korszerű nemzetközi irodalom elméleti eredményeit és azok jelentőségét megvilágító számos külföldi és hazai tapasztalati példa finom egyensúlyozásával vezeti végig az olvasót a külpolitikai elemzés dilemmáin és módszerein. A döntéshozatali folyamatok belső mechanizmusainak és külső kontextusának elemzésére szolgáló fogalmak, eszközök és módszerek precíz és világos bemutatása, valamint használatuk demonstrálása hasznos és azonnal alkalmazható ismereteket szolgáltat a külpolitikát a gyakorlatban űzők és az e gyakorlatot tanulmányozók számára egyaránt. A külpolitika elemzése ideális tankönyv egyetemi hallgatók számára – gyakorló kérdésekkel a fejezetek végén –, de egyúttal ajánlott olvasmány mindenkinek, akit valaha is töprengésre sarkallt a világpolitika és a magyar külpolitika működése. (Friedmann Viktor)

A könyv kedvezményes áron irodánkban megvásárolható (1093 Budapest, Czuczor u. 2.), vagy megrendelhető a konyv@ajtk.hu     e-mail címen.

Tibor Frank - Tamás Magyarics: Handouts for U.S. History- A Study Guide and Workbook

Kiadási év: 2018
Ár: 5500 Ft

Frank Tibor és Magyarics Tamás először 1995-ben, majd 1999-ben kiadott angol nyelvű tankönyve közel tíz év után újra megjelenik. A harmadik, javított, bővített kiadás öt újabb fejezetet tartalmaz, amelyek az elmúlt évek történéseivel egészítik ki a hiánypótló kiadványt.

A kötet az Amerikai Egyesült Államok történelmét és annak sok kultúrájú társadalmát mutatja be kezdetektől napjainkig; a világhatalmat és azt, hogy miként befolyásolta a föld többi országának történelmét.  A nagy tudású szerzők a felfedezések és az első telepesek korától indulva a polgárháború idején át a világháborúkig és azon túl a hidegháború eseményein keresztül egészen a multikulturalizmusig elemzik az USA mindennapjait, a kortárs politikai, gazdasági és kulturális folyamatok alakulásait is boncolgatva. Mindketten bíznak abban, hogy eddig is népszerű tankönyvük harmadik kiadása diákokat és történelem iránt érdeklődőket egyaránt vonz majd, átfogó áttekintést nyújtva arról az államról, amely oly sok éven át alakította nemcsak a maga, hanem a világ országainak sorsát.

Az olvasót térképek, függelékek és bőséges bibliográfia segíti a további eligazodásban.