Június
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-01 00:00:00' AND DateTime_program < '2018-06-01 23:59:59' AND Lang = '1' AND Active = 10
01
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-02 00:00:00' AND DateTime_program < '2018-06-02 23:59:59' AND Lang = '1' AND Active = 10
02
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-03 00:00:00' AND DateTime_program < '2018-06-03 23:59:59' AND Lang = '1' AND Active = 10
03
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-04 00:00:00' AND DateTime_program < '2018-06-04 23:59:59' AND Lang = '1' AND Active = 10
04
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-05 00:00:00' AND DateTime_program < '2018-06-05 23:59:59' AND Lang = '1' AND Active = 10
05
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-06 00:00:00' AND DateTime_program < '2018-06-06 23:59:59' AND Lang = '1' AND Active = 10
06
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-07 00:00:00' AND DateTime_program < '2018-06-07 23:59:59' AND Lang = '1' AND Active = 10
07
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-08 00:00:00' AND DateTime_program < '2018-06-08 23:59:59' AND Lang = '1' AND Active = 10
08
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-09 00:00:00' AND DateTime_program < '2018-06-09 23:59:59' AND Lang = '1' AND Active = 10
09
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-10 00:00:00' AND DateTime_program < '2018-06-10 23:59:59' AND Lang = '1' AND Active = 10
10
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-11 00:00:00' AND DateTime_program < '2018-06-11 23:59:59' AND Lang = '1' AND Active = 10
11
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-12 00:00:00' AND DateTime_program < '2018-06-12 23:59:59' AND Lang = '1' AND Active = 10
12
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-13 00:00:00' AND DateTime_program < '2018-06-13 23:59:59' AND Lang = '1' AND Active = 10
13
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-14 00:00:00' AND DateTime_program < '2018-06-14 23:59:59' AND Lang = '1' AND Active = 10
14
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-15 00:00:00' AND DateTime_program < '2018-06-15 23:59:59' AND Lang = '1' AND Active = 10
15
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-16 00:00:00' AND DateTime_program < '2018-06-16 23:59:59' AND Lang = '1' AND Active = 10
16
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-17 00:00:00' AND DateTime_program < '2018-06-17 23:59:59' AND Lang = '1' AND Active = 10
17
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-18 00:00:00' AND DateTime_program < '2018-06-18 23:59:59' AND Lang = '1' AND Active = 10
18
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-19 00:00:00' AND DateTime_program < '2018-06-19 23:59:59' AND Lang = '1' AND Active = 10
19
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-20 00:00:00' AND DateTime_program < '2018-06-20 23:59:59' AND Lang = '1' AND Active = 10
20
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-21 00:00:00' AND DateTime_program < '2018-06-21 23:59:59' AND Lang = '1' AND Active = 10
21
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-22 00:00:00' AND DateTime_program < '2018-06-22 23:59:59' AND Lang = '1' AND Active = 10
22
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-23 00:00:00' AND DateTime_program < '2018-06-23 23:59:59' AND Lang = '1' AND Active = 10
23
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-24 00:00:00' AND DateTime_program < '2018-06-24 23:59:59' AND Lang = '1' AND Active = 10
24
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-25 00:00:00' AND DateTime_program < '2018-06-25 23:59:59' AND Lang = '1' AND Active = 10
25
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-26 00:00:00' AND DateTime_program < '2018-06-26 23:59:59' AND Lang = '1' AND Active = 10
26
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-27 00:00:00' AND DateTime_program < '2018-06-27 23:59:59' AND Lang = '1' AND Active = 10
27
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-28 00:00:00' AND DateTime_program < '2018-06-28 23:59:59' AND Lang = '1' AND Active = 10
28
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-29 00:00:00' AND DateTime_program < '2018-06-29 23:59:59' AND Lang = '1' AND Active = 10
29
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-06-30 00:00:00' AND DateTime_program < '2018-06-30 23:59:59' AND Lang = '1' AND Active = 10
30
Július
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-01 00:00:00' AND DateTime_program < '2018-07-01 23:59:59' AND Lang = '1' AND Active = 10
01
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-02 00:00:00' AND DateTime_program < '2018-07-02 23:59:59' AND Lang = '1' AND Active = 10
02
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-03 00:00:00' AND DateTime_program < '2018-07-03 23:59:59' AND Lang = '1' AND Active = 10
03
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-04 00:00:00' AND DateTime_program < '2018-07-04 23:59:59' AND Lang = '1' AND Active = 10
04
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-05 00:00:00' AND DateTime_program < '2018-07-05 23:59:59' AND Lang = '1' AND Active = 10
05
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-06 00:00:00' AND DateTime_program < '2018-07-06 23:59:59' AND Lang = '1' AND Active = 10
06
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-07 00:00:00' AND DateTime_program < '2018-07-07 23:59:59' AND Lang = '1' AND Active = 10
07
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-08 00:00:00' AND DateTime_program < '2018-07-08 23:59:59' AND Lang = '1' AND Active = 10
08
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-09 00:00:00' AND DateTime_program < '2018-07-09 23:59:59' AND Lang = '1' AND Active = 10
09
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-10 00:00:00' AND DateTime_program < '2018-07-10 23:59:59' AND Lang = '1' AND Active = 10
10
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-11 00:00:00' AND DateTime_program < '2018-07-11 23:59:59' AND Lang = '1' AND Active = 10
11
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-12 00:00:00' AND DateTime_program < '2018-07-12 23:59:59' AND Lang = '1' AND Active = 10
12
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-13 00:00:00' AND DateTime_program < '2018-07-13 23:59:59' AND Lang = '1' AND Active = 10
13
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-14 00:00:00' AND DateTime_program < '2018-07-14 23:59:59' AND Lang = '1' AND Active = 10
14
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-15 00:00:00' AND DateTime_program < '2018-07-15 23:59:59' AND Lang = '1' AND Active = 10
15
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-16 00:00:00' AND DateTime_program < '2018-07-16 23:59:59' AND Lang = '1' AND Active = 10
16
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-17 00:00:00' AND DateTime_program < '2018-07-17 23:59:59' AND Lang = '1' AND Active = 10
17
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-18 00:00:00' AND DateTime_program < '2018-07-18 23:59:59' AND Lang = '1' AND Active = 10
18
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-19 00:00:00' AND DateTime_program < '2018-07-19 23:59:59' AND Lang = '1' AND Active = 10
19
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-20 00:00:00' AND DateTime_program < '2018-07-20 23:59:59' AND Lang = '1' AND Active = 10
20
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-21 00:00:00' AND DateTime_program < '2018-07-21 23:59:59' AND Lang = '1' AND Active = 10
21
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-22 00:00:00' AND DateTime_program < '2018-07-22 23:59:59' AND Lang = '1' AND Active = 10
22
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-23 00:00:00' AND DateTime_program < '2018-07-23 23:59:59' AND Lang = '1' AND Active = 10
23
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-24 00:00:00' AND DateTime_program < '2018-07-24 23:59:59' AND Lang = '1' AND Active = 10
24
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-25 00:00:00' AND DateTime_program < '2018-07-25 23:59:59' AND Lang = '1' AND Active = 10
25
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-26 00:00:00' AND DateTime_program < '2018-07-26 23:59:59' AND Lang = '1' AND Active = 10
26
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-27 00:00:00' AND DateTime_program < '2018-07-27 23:59:59' AND Lang = '1' AND Active = 10
27
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-28 00:00:00' AND DateTime_program < '2018-07-28 23:59:59' AND Lang = '1' AND Active = 10
28
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-29 00:00:00' AND DateTime_program < '2018-07-29 23:59:59' AND Lang = '1' AND Active = 10
29
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-30 00:00:00' AND DateTime_program < '2018-07-30 23:59:59' AND Lang = '1' AND Active = 10
30
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-07-31 00:00:00' AND DateTime_program < '2018-07-31 23:59:59' AND Lang = '1' AND Active = 10
31
Augusztus
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-01 00:00:00' AND DateTime_program < '2018-08-01 23:59:59' AND Lang = '1' AND Active = 10
01
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-02 00:00:00' AND DateTime_program < '2018-08-02 23:59:59' AND Lang = '1' AND Active = 10
02
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-03 00:00:00' AND DateTime_program < '2018-08-03 23:59:59' AND Lang = '1' AND Active = 10
03
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-04 00:00:00' AND DateTime_program < '2018-08-04 23:59:59' AND Lang = '1' AND Active = 10
04
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-05 00:00:00' AND DateTime_program < '2018-08-05 23:59:59' AND Lang = '1' AND Active = 10
05
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-06 00:00:00' AND DateTime_program < '2018-08-06 23:59:59' AND Lang = '1' AND Active = 10
06
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-07 00:00:00' AND DateTime_program < '2018-08-07 23:59:59' AND Lang = '1' AND Active = 10
07
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-08 00:00:00' AND DateTime_program < '2018-08-08 23:59:59' AND Lang = '1' AND Active = 10
08
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-09 00:00:00' AND DateTime_program < '2018-08-09 23:59:59' AND Lang = '1' AND Active = 10
09
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-10 00:00:00' AND DateTime_program < '2018-08-10 23:59:59' AND Lang = '1' AND Active = 10
10
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-11 00:00:00' AND DateTime_program < '2018-08-11 23:59:59' AND Lang = '1' AND Active = 10
11
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-12 00:00:00' AND DateTime_program < '2018-08-12 23:59:59' AND Lang = '1' AND Active = 10
12
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-13 00:00:00' AND DateTime_program < '2018-08-13 23:59:59' AND Lang = '1' AND Active = 10
13
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-14 00:00:00' AND DateTime_program < '2018-08-14 23:59:59' AND Lang = '1' AND Active = 10
14
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-15 00:00:00' AND DateTime_program < '2018-08-15 23:59:59' AND Lang = '1' AND Active = 10
15
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-16 00:00:00' AND DateTime_program < '2018-08-16 23:59:59' AND Lang = '1' AND Active = 10
16
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-17 00:00:00' AND DateTime_program < '2018-08-17 23:59:59' AND Lang = '1' AND Active = 10
17
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-18 00:00:00' AND DateTime_program < '2018-08-18 23:59:59' AND Lang = '1' AND Active = 10
18
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-19 00:00:00' AND DateTime_program < '2018-08-19 23:59:59' AND Lang = '1' AND Active = 10
19
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-20 00:00:00' AND DateTime_program < '2018-08-20 23:59:59' AND Lang = '1' AND Active = 10
20
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-21 00:00:00' AND DateTime_program < '2018-08-21 23:59:59' AND Lang = '1' AND Active = 10
21
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-22 00:00:00' AND DateTime_program < '2018-08-22 23:59:59' AND Lang = '1' AND Active = 10
22
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-23 00:00:00' AND DateTime_program < '2018-08-23 23:59:59' AND Lang = '1' AND Active = 10
23
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-24 00:00:00' AND DateTime_program < '2018-08-24 23:59:59' AND Lang = '1' AND Active = 10
24
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-25 00:00:00' AND DateTime_program < '2018-08-25 23:59:59' AND Lang = '1' AND Active = 10
25
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-26 00:00:00' AND DateTime_program < '2018-08-26 23:59:59' AND Lang = '1' AND Active = 10
26
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-27 00:00:00' AND DateTime_program < '2018-08-27 23:59:59' AND Lang = '1' AND Active = 10
27
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-28 00:00:00' AND DateTime_program < '2018-08-28 23:59:59' AND Lang = '1' AND Active = 10
28
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-29 00:00:00' AND DateTime_program < '2018-08-29 23:59:59' AND Lang = '1' AND Active = 10
29
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-30 00:00:00' AND DateTime_program < '2018-08-30 23:59:59' AND Lang = '1' AND Active = 10
30
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-08-31 00:00:00' AND DateTime_program < '2018-08-31 23:59:59' AND Lang = '1' AND Active = 10
31
Szeptember
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-01 00:00:00' AND DateTime_program < '2018-09-01 23:59:59' AND Lang = '1' AND Active = 10
01
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-02 00:00:00' AND DateTime_program < '2018-09-02 23:59:59' AND Lang = '1' AND Active = 10
02
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-03 00:00:00' AND DateTime_program < '2018-09-03 23:59:59' AND Lang = '1' AND Active = 10
03
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-04 00:00:00' AND DateTime_program < '2018-09-04 23:59:59' AND Lang = '1' AND Active = 10
04
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-05 00:00:00' AND DateTime_program < '2018-09-05 23:59:59' AND Lang = '1' AND Active = 10
05
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-06 00:00:00' AND DateTime_program < '2018-09-06 23:59:59' AND Lang = '1' AND Active = 10
06
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-07 00:00:00' AND DateTime_program < '2018-09-07 23:59:59' AND Lang = '1' AND Active = 10
07
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-08 00:00:00' AND DateTime_program < '2018-09-08 23:59:59' AND Lang = '1' AND Active = 10
08
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-09 00:00:00' AND DateTime_program < '2018-09-09 23:59:59' AND Lang = '1' AND Active = 10
09
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-10 00:00:00' AND DateTime_program < '2018-09-10 23:59:59' AND Lang = '1' AND Active = 10
10
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-11 00:00:00' AND DateTime_program < '2018-09-11 23:59:59' AND Lang = '1' AND Active = 10
11
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-12 00:00:00' AND DateTime_program < '2018-09-12 23:59:59' AND Lang = '1' AND Active = 10
12
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-13 00:00:00' AND DateTime_program < '2018-09-13 23:59:59' AND Lang = '1' AND Active = 10
13
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-14 00:00:00' AND DateTime_program < '2018-09-14 23:59:59' AND Lang = '1' AND Active = 10
14
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-15 00:00:00' AND DateTime_program < '2018-09-15 23:59:59' AND Lang = '1' AND Active = 10
15
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-16 00:00:00' AND DateTime_program < '2018-09-16 23:59:59' AND Lang = '1' AND Active = 10
16
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-17 00:00:00' AND DateTime_program < '2018-09-17 23:59:59' AND Lang = '1' AND Active = 10
17
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-18 00:00:00' AND DateTime_program < '2018-09-18 23:59:59' AND Lang = '1' AND Active = 10
18
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-19 00:00:00' AND DateTime_program < '2018-09-19 23:59:59' AND Lang = '1' AND Active = 10
19
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-20 00:00:00' AND DateTime_program < '2018-09-20 23:59:59' AND Lang = '1' AND Active = 10
20
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-21 00:00:00' AND DateTime_program < '2018-09-21 23:59:59' AND Lang = '1' AND Active = 10
21
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-22 00:00:00' AND DateTime_program < '2018-09-22 23:59:59' AND Lang = '1' AND Active = 10
22
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-23 00:00:00' AND DateTime_program < '2018-09-23 23:59:59' AND Lang = '1' AND Active = 10
23
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-24 00:00:00' AND DateTime_program < '2018-09-24 23:59:59' AND Lang = '1' AND Active = 10
24
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-25 00:00:00' AND DateTime_program < '2018-09-25 23:59:59' AND Lang = '1' AND Active = 10
25
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-26 00:00:00' AND DateTime_program < '2018-09-26 23:59:59' AND Lang = '1' AND Active = 10
26
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-27 00:00:00' AND DateTime_program < '2018-09-27 23:59:59' AND Lang = '1' AND Active = 10
27
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-28 00:00:00' AND DateTime_program < '2018-09-28 23:59:59' AND Lang = '1' AND Active = 10
28
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-29 00:00:00' AND DateTime_program < '2018-09-29 23:59:59' AND Lang = '1' AND Active = 10
29
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-09-30 00:00:00' AND DateTime_program < '2018-09-30 23:59:59' AND Lang = '1' AND Active = 10
30
Október
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-01 00:00:00' AND DateTime_program < '2018-10-01 23:59:59' AND Lang = '1' AND Active = 10
01
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-02 00:00:00' AND DateTime_program < '2018-10-02 23:59:59' AND Lang = '1' AND Active = 10
02
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-03 00:00:00' AND DateTime_program < '2018-10-03 23:59:59' AND Lang = '1' AND Active = 10
03
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-04 00:00:00' AND DateTime_program < '2018-10-04 23:59:59' AND Lang = '1' AND Active = 10
04
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-05 00:00:00' AND DateTime_program < '2018-10-05 23:59:59' AND Lang = '1' AND Active = 10
05
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-06 00:00:00' AND DateTime_program < '2018-10-06 23:59:59' AND Lang = '1' AND Active = 10
06
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-07 00:00:00' AND DateTime_program < '2018-10-07 23:59:59' AND Lang = '1' AND Active = 10
07
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-08 00:00:00' AND DateTime_program < '2018-10-08 23:59:59' AND Lang = '1' AND Active = 10
08
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-09 00:00:00' AND DateTime_program < '2018-10-09 23:59:59' AND Lang = '1' AND Active = 10
09
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-10 00:00:00' AND DateTime_program < '2018-10-10 23:59:59' AND Lang = '1' AND Active = 10
10
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-11 00:00:00' AND DateTime_program < '2018-10-11 23:59:59' AND Lang = '1' AND Active = 10
11
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-12 00:00:00' AND DateTime_program < '2018-10-12 23:59:59' AND Lang = '1' AND Active = 10
12
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-13 00:00:00' AND DateTime_program < '2018-10-13 23:59:59' AND Lang = '1' AND Active = 10
13
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-14 00:00:00' AND DateTime_program < '2018-10-14 23:59:59' AND Lang = '1' AND Active = 10
14
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-15 00:00:00' AND DateTime_program < '2018-10-15 23:59:59' AND Lang = '1' AND Active = 10
15
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-16 00:00:00' AND DateTime_program < '2018-10-16 23:59:59' AND Lang = '1' AND Active = 10
16
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-17 00:00:00' AND DateTime_program < '2018-10-17 23:59:59' AND Lang = '1' AND Active = 10
17
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-18 00:00:00' AND DateTime_program < '2018-10-18 23:59:59' AND Lang = '1' AND Active = 10
18
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-19 00:00:00' AND DateTime_program < '2018-10-19 23:59:59' AND Lang = '1' AND Active = 10
19
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-20 00:00:00' AND DateTime_program < '2018-10-20 23:59:59' AND Lang = '1' AND Active = 10
20
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-21 00:00:00' AND DateTime_program < '2018-10-21 23:59:59' AND Lang = '1' AND Active = 10
21
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-22 00:00:00' AND DateTime_program < '2018-10-22 23:59:59' AND Lang = '1' AND Active = 10
22
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-23 00:00:00' AND DateTime_program < '2018-10-23 23:59:59' AND Lang = '1' AND Active = 10
23
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-24 00:00:00' AND DateTime_program < '2018-10-24 23:59:59' AND Lang = '1' AND Active = 10
24
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-25 00:00:00' AND DateTime_program < '2018-10-25 23:59:59' AND Lang = '1' AND Active = 10
25
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-26 00:00:00' AND DateTime_program < '2018-10-26 23:59:59' AND Lang = '1' AND Active = 10
26
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-27 00:00:00' AND DateTime_program < '2018-10-27 23:59:59' AND Lang = '1' AND Active = 10
27
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-28 00:00:00' AND DateTime_program < '2018-10-28 23:59:59' AND Lang = '1' AND Active = 10
28
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-28 00:00:00' AND DateTime_program < '2018-10-28 23:59:59' AND Lang = '1' AND Active = 10
28
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-29 00:00:00' AND DateTime_program < '2018-10-29 23:59:59' AND Lang = '1' AND Active = 10
29
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-30 00:00:00' AND DateTime_program < '2018-10-30 23:59:59' AND Lang = '1' AND Active = 10
30
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2018-10-31 00:00:00' AND DateTime_program < '2018-10-31 23:59:59' AND Lang = '1' AND Active = 10
31
Könyvkiadás - TANKÖNYVEK

Csoma Mózes: Korea története

Kiadási év: 2018
Ár: 4500 Ft
Szállítási költség: 1550 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.

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

Kiadási év: 2018
Ár: 5500 Ft
Szállítási költség: 1550 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.

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

Kiadási év: 2016
Ár: 1800 Ft
Szállítási költség: 950 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.