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önyvkiadás - ÚJDONSÁGOK

Szálkai Kinga, Baranyi Tamás Péter, Szarka E. Luca: Biztonságpolitikai Corvinák

Kiadási év: 2019
Ár: 4550 Ft

A közel ezeroldalas könyv olyan tanulmányokat fog össze, amelyek globális és regionális biztonságpolitikai kérdéseket járnak körbe, bemutatva azokat az elmozdulásokat, amelyek a 21. századi világunkat alakítják.
Az első kötetben az energiabiztonság, a terrorizmus, a kényszervándorlás tárgyköréből olvashatók tanulmányok, majd olyan írások következnek, amelyek a Föld egyes térségeit érintő biztonsági témákat tárják az olvasó elé. Feltérképezik például az Európai Unió lehetőségeit, a kontinensek, országok területi vitáit, válaszaikat a nukleáris fegyverkezésre, a gazdasági és demográfiai tendenciákra, válságokra és nagyhatalmi befolyásra egyaránt. A második kötet a nemzetközi biztonsági intézményeket veszi sorra, tárgyalja történelmi hátterüket, stratégiájukat, működésüket, zárásként pedig szót ejt Magyarország biztonságpolitikájáról az 1990-es választásokat megelőzően, a rendszerváltoztatás után, illetve a NATO és a V4-ek kötelékében.
A könyv a 2008-ban megjelent Biztonságpolitikai Corvinák című kiadványt tartja mintájának, szándéka szerint összefoglaló mű a biztonsági tanulmányok iránt érdeklődő alap- és mesterszakos hallgatóknak. Célkitűzése, hogy tankönyvként is megállja a helyét, és a későbbi kutatásokhoz is alapot szolgáltasson.

A kötet 30% kedvezménnyel, 6500 Ft helyett 4550 Ft-ért rendelhető meg e-mailben (konyv@ajtk.hu)!
A feltüntetett ár nem tartalmazza a postaköltséget.

Az AJTK kiadványai az alábbi könyvesboltokban vásárolhatók meg:
Anima könyvesbolt | Bookline webáruház | Írók Boltja | Libri Könyvesboltok | Líra Könyv

Henry Kissinger: Fehér házi éveim

Kiadási év: 2019
Ár: 6930 Ft

„Könyvem óhatatlanul az én szemüvegemen keresztül látott és látta­tott történelem – annak leírása, amit én láttam, gondoltam és tettem…”

Így vall Henry Kissinger arról az emlékiratról, amelynek három kötete beiktatásától kezdődően dolgozza fel a Nixon-kormány nemzetbizton­sági, külügyi, diplomáciai mindennapjait, stratégiáit egészen a vietná­mi békekötésig. Mindezek hátterében végig ott munkálnak a belföldi történések, hivatali harcok, amelyeket a szerző úgy képes felvillantani, hogy az adott időszak – természetesen a fenti idézet alapján – saját szemüvegén keresztül látott teljességét ábrázolja.
Henry Kissinger 1923. május 27-én a bajoror­szági Fürthben született, családja 1938-ban New Yorkba emigrált. Több mint tíz éve tanított a Harvard Egyetemen, amikor felké­rést kapott, hogy legyen nemzetbiztonsági tanácsadó Richard Nixon mellett. Elvállalta a feladatot, és ezzel – ebben a szerepében, majd ké­sőbb külügyminiszterként is – megosztó alakja óriási hatást gyakorolt mind az Amerikai Egyesült Államok, mind az egész világ történelmére. Memoárja izgalmas, lebilincselő olvasmány, ez a nagy formátumú em­ber nemcsak politikusként, hanem íróként is jelentőset alkotott.
Emlékirata hatalmas anyag, amely eredetileg White House Years, Years of Upheaval és Years of Renewal címen jelent meg. Az első könyv, a White House Years magyar fordítását az Antall József Tudásközpont Könyvműhelye adta ki, melynek bemutatójára a XXVI. Budapesti Nemzetközi Könyvfesztiválon került sor.

A kötet 30% kedvezménnyel, 9900 Ft helyett 6930 Ft-ért rendelhető meg e-mailben (konyv@ajtk.hu)!
A feltüntetett ár nem tartalmazza a postaköltséget.
Az AJTK kiadványai az alábbi könyvesboltokban vásárolhatók meg:
Anima könyvesbolt | Bookline webáruház | Írók Boltja | Libri Könyvesboltok | Líra Könyv

 

Daniel Yergin: A küldetés - Energia, biztonság és a modern világ újraalkotása (Ford. Kiss Marcell)

Kiadási év: 2019
Ár: 3850 Ft
Éghajlatváltozás, környezetvédelmi aggodalmak, csökkenő erőforrások és a világ egyre növekvő energiaétvágya – hogyan hat mindez a jövőnkre?
Daniel Yergin könyve erre a kérdésre keresi a választ: A küldetés az energia története. A szerző a kötet lapjain az összes olyan tényezőt – politikai felfordulást, katonai konfliktust, a globális gazdaságban tapasztalható jelentős elmozdulást, technológiai áttörést vagy éppen az árképzés és a szabályozás megváltozását – áttekinti, amely alapvetően módosíthatja az energia helyzetét a világban. Bár a megújuló, illetve az alternatív források egyre meghatározóbbak, az mégis aggasztó, hogy a világ energiaszükségletének biztosítása válság és összecsapások nélkül szinte lehetetlen küldetésnek tűnik.
Daniel Yergin vezető szaktekintély az energia, a nemzetközi politika és a közgazdaság területén. Előző könyvét (A zsákmány) húsz nyelvre fordították le, Pulitzer-díjjal jutalmazták, és elnyerte az Eccles-díjat is mint a legjobb nagyközönség számára készült gazdasági témájú könyv.
 
A kötet 30% kedvezménnyel, 5500 Ft helyett 3850 Ft-ért rendelhető meg e-mailben (konyv@ajtk.hu)!
A feltüntetett ár nem tartalmazza a postaköltséget.
 
Az AJTK kiadványai az alábbi könyvesboltokban vásárolhatók meg:
Anima könyvesbolt | Bookline webáruház | Írók Boltja | Libri Könyvesboltok | Líra Könyv