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 - ÚJDONSÁGOK

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.

Richard Susskind–Daniel Susskind: A szakmák jövője

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

A szerzőpáros lenyűgöző összefoglalását adja annak a folyamatnak, ahogy a – nem is távoli – jövőben a technológiai fejlődés következtében valamennyi szakma átalakul. Fokozatos változás szemtanúi lehetünk: napjainkban a szakértelem megszerzése és a társadalomban való szétosztása is alapjaiban módosul, és ez a hagyományos szakmák felbomlásához vezet. Ez a tézis első pillantásra ijesztőnek tűnhet, épp ezért a szerzők új gondolkodásmódot szorgalmaznak, és felvillantanak számos, a változásban rejlő lehetőséget.

Richard Susskind korábban több könyvet is publikált a jogi szolgáltatások jövőjével kapcsolatban, és az elmúlt csaknem két évtizedben a világ számos pontján tartott előadásokat a témában. A visszajelzések meggyőzték arról, hogy elmélete nemcsak a jogász szakmára érvényes, hanem az orvosok, könyvvizsgálók, építészek, újságírók, tanárok és más szakmák képviselőinek munkájára is. Kutatását kiterjesztette, így ez a kötet bármely más szakember számára hasznos és elgondolkodtató olvasmány.

Jakub J. Grygiel, A. Wess Mitchell: Nyugtalan határvidék

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

Miközben az Egyesült Államok az utóbbi években globális külpolitikai visszavonulót fújt, a Balti-tengertől a Dél-kínai-tengerig terjedő sávban három autoriter állam – Oroszország, Irán és Kína – egyre magabiztosabban próbálja újraéleszteni egykori birodalmát. A három feltörekvő hatalom, a régi dicsőség visszaszerzése közben, az Egyesült Államok – az amerikai befolyási övezet határvidékén elhelyezkedő – szövetségesei felé fordult.
Jakub Grygiel és Wess Mitchell a közelmúlt egyes külpolitikai történéseit, így Krím-félsziget orosz megszerzését új szemszögből értelmező könyve amellett érve, hogy a felemelkedő, revizionista hatalmak abban a reményben gyakorolnak nyomást a határvidék országaira – így például Oroszország Ukrajnára, Lengyelországra vagy éppen Magyarországra –, hogy Amerika valóban hanyatlik, ezért nem tesz érdemi válaszlépéseket, a szövetségesek pedig az egykori szuperhatalomban csalódva közeledni kezdenek feltörekvő szomszédjaik felé.
A nyugtalan határvidék egy új, átfogó, aktív amerikai külpolitikai stratégia szükségessége mellett teszi le a voksát. Egy olyan stratégia mellett, mely kelet-európai, közel-keleti és kelet-ázsiai szövetségesek hálózatával riasztja el a feltörekvő hatalmakat az agressziótól, és nem adja meg magát egy új, multipoláris világrend önbeteljesítő jóslatának. 

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.