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

Magyarics Tamás: AZ EGYESÜLT ÁLLAMOK KÜLPOLITIKÁJÁNAK TÖRTÉNETE

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

Magyarics Tamás könyvének második, jelentősen bővített kiadása nem csupán kézikönyvszerű bevezetés az Egyesült Államok külpolitikájának történetébe, de tudományos igénnyel megírt, élvezetes és problémaközpontú tárgyalása is a ma egyedüli szuperhatalom diplomáciatörténetének. A kötet részletesen bemutatja e hatalmas ország rendkívüli szerepvállalását: nagy háborúit, jelentős békekötéseit, tündöklését és balsikereit a nemzetközi küzdőtéren. A könyvből előlépnek az amerikai külpolitika irányítói, teoretikusai, végrehajtói ― elnökök, külügyminiszterek és diplomaták, George Washingtontól James Monroe elnökön át a két Rooseveltig és a két Bushig, George Kennantól Marshall tábornokon át Zbigniew Brzezinskiig és Henry Kissingerig. Az eredeti, első kiadáshoz képest a szerző lényeges új fejezeteket csatolt a hidegháború utáni időszakról, és külön részben tárgyalja a magyar―amerikai kapcsolatok történetét is. A kötetet számos kitűnő térkép, fotó és a további tájékozódást lehetővé tévő bibliográfia egészíti ki.

A szerző, Magyarics Tamás történész, a budapesti Eötvös Loránd Tudományegyetem Amerikanisztika Tanszékének tanára, a Magyar Külügyi Intézet korábbi igazgatója, 2011-től Magyarország írországi nagykövete.

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.

Marton Péter, Balogh István, Rada Péter: BIZTONSÁGI TANULMÁNYOK ÚJ FOGALMI KERETEK, ÉS TANULSÁGOK A VISEGRÁDI ORSZÁGOK SZÁMÁRA

Kiadási év: 2015
Ár: 2700 Ft

A könyv három szerzője négy kiváló hazai felsőoktatási intézményt képvisel. Közös munkájuk merész intellektuális utazásra invitálja az olvasót a biztonsági tanulmányok területén. A vizsgált területek között szerepel a gazdasági, a társadalmi, a környezeti és a közegészségügyi biztonság. Ezt követi a szervezett erőszak-alkalmazással – illetve annak lehetőségével – összefüggésben a katonai biztonság és a terrorizmus tárgyalása. A globális megközelítés mellett a kötet a visegrádi négyek biztonsági helyzetére koncentrálva szolgál stratégiai jelentőségű megállapításokkal. A kötet szakkönyvként és tanulható tankönyvként egyaránt forgatható, melyet a megértést segítő ábrák és kiemelések tesznek teljessé.

"E kötet izgalmas kísérlet a biztonsági tanulmányok megújítására. A terület hazai művelőinek minden bizonnyal érdemi vonatkoztatási pontként szolgálhat a jövőben. " Tálas Péter

Marton Péter: egyetemi oktató, kutató. Kutatómunkája mellett a Budapesti Corvinus Egyetemen és az Eötvös Loránd Tudományegyetemen tanít. 2012-ben a Junior Prima-díjat, 2013-ban pedig az MTA Bolyai ösztöndíját nyerte el.
Balogh István: a Nemzeti Közszolgálati Egyetem oktatója, a Külgazdasági és Külügyminisztérium Biztonságpolitikai és Non-proliferációs Főosztályának vezetője.
Rada Péter: a Budapesti Kommunikációs és Üzleti Főiskola és az ELTE oktatója, a Corvinus Külügyi és Kulturális Egyesület elnöke, a Külgazdasági és Külügyminisztérium munkatársa.

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.

 

Újhold - A török külpolitika útkeresése a 21. században

Kiadási év: 2016
Ár: 1800 Ft

Nyugati „típusú” szekuláris demokrácia vagy oszmán babérokra törő birodalom? Felemelkedő középhatalom vagy harmadik világbeli ország? Törökország évszázadokon keresztül Európa történelmének egyik meghatározója volt – ereje teljében és gyengeségében egyaránt. Az Oszmán Birodalom romjain létrehozott Török Köztársaság földrajzi helyzeténél fogva régiókat és kontinenseket köt össze, hidat képezve Kelet és Nyugat között. Törökország, lassan száz évvel a köztársaság kikiáltása után – az oszmán múlttal együtt, illetve anélkül – a térség elismert és tudatos regionális hatalmává vált, sajátos érdekekkel, amelyeket képes és akar is érvényesíteni, még ha eddig változó sikerrel is tette azt. 


A tanulmánykötet szerzői és az Antall József Tudásközpont közreműködő munkatársai azt az ambiciózus célt tűzték ki maguk elé, hogy egy kötetben foglalják össze és elemezzék a Török Köztársaság geopolitikai tényezőit. A kötet tankönyvként és kézikönyvként egyaránt használható módon mutatja be az érdeklődők számára, hogy az állam sajátos geopolitikai elhelyezkedésére épülve hogyan alakultak a török külpolitika főbb irányvonalai a 21. század elején. Ehhez a kötet egy általános geopolitikai áttekintést követően megfelelő történeti alapozást biztosít, majd néhány kiemelt politikaterület bemutatása után a két- és többoldalú államközi kapcsolatok bemutatására helyezi a hangsúlyt.

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.