Január
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-01 00:00:00' AND DateTime_program < '2019-01-01 23:59:59' AND Lang = '1' AND Active = 10
01
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-02 00:00:00' AND DateTime_program < '2019-01-02 23:59:59' AND Lang = '1' AND Active = 10
02
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-03 00:00:00' AND DateTime_program < '2019-01-03 23:59:59' AND Lang = '1' AND Active = 10
03
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-04 00:00:00' AND DateTime_program < '2019-01-04 23:59:59' AND Lang = '1' AND Active = 10
04
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-05 00:00:00' AND DateTime_program < '2019-01-05 23:59:59' AND Lang = '1' AND Active = 10
05
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-06 00:00:00' AND DateTime_program < '2019-01-06 23:59:59' AND Lang = '1' AND Active = 10
06
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-07 00:00:00' AND DateTime_program < '2019-01-07 23:59:59' AND Lang = '1' AND Active = 10
07
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-08 00:00:00' AND DateTime_program < '2019-01-08 23:59:59' AND Lang = '1' AND Active = 10
08
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-09 00:00:00' AND DateTime_program < '2019-01-09 23:59:59' AND Lang = '1' AND Active = 10
09
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-10 00:00:00' AND DateTime_program < '2019-01-10 23:59:59' AND Lang = '1' AND Active = 10
10
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-11 00:00:00' AND DateTime_program < '2019-01-11 23:59:59' AND Lang = '1' AND Active = 10
11
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-12 00:00:00' AND DateTime_program < '2019-01-12 23:59:59' AND Lang = '1' AND Active = 10
12
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-13 00:00:00' AND DateTime_program < '2019-01-13 23:59:59' AND Lang = '1' AND Active = 10
13
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-14 00:00:00' AND DateTime_program < '2019-01-14 23:59:59' AND Lang = '1' AND Active = 10
14
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-15 00:00:00' AND DateTime_program < '2019-01-15 23:59:59' AND Lang = '1' AND Active = 10
15
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-16 00:00:00' AND DateTime_program < '2019-01-16 23:59:59' AND Lang = '1' AND Active = 10
16
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-17 00:00:00' AND DateTime_program < '2019-01-17 23:59:59' AND Lang = '1' AND Active = 10
17
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-18 00:00:00' AND DateTime_program < '2019-01-18 23:59:59' AND Lang = '1' AND Active = 10
18
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-19 00:00:00' AND DateTime_program < '2019-01-19 23:59:59' AND Lang = '1' AND Active = 10
19
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-20 00:00:00' AND DateTime_program < '2019-01-20 23:59:59' AND Lang = '1' AND Active = 10
20
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-21 00:00:00' AND DateTime_program < '2019-01-21 23:59:59' AND Lang = '1' AND Active = 10
21
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-22 00:00:00' AND DateTime_program < '2019-01-22 23:59:59' AND Lang = '1' AND Active = 10
22
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-23 00:00:00' AND DateTime_program < '2019-01-23 23:59:59' AND Lang = '1' AND Active = 10
23
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-24 00:00:00' AND DateTime_program < '2019-01-24 23:59:59' AND Lang = '1' AND Active = 10
24
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-25 00:00:00' AND DateTime_program < '2019-01-25 23:59:59' AND Lang = '1' AND Active = 10
25
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-26 00:00:00' AND DateTime_program < '2019-01-26 23:59:59' AND Lang = '1' AND Active = 10
26
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-27 00:00:00' AND DateTime_program < '2019-01-27 23:59:59' AND Lang = '1' AND Active = 10
27
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-28 00:00:00' AND DateTime_program < '2019-01-28 23:59:59' AND Lang = '1' AND Active = 10
28
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-29 00:00:00' AND DateTime_program < '2019-01-29 23:59:59' AND Lang = '1' AND Active = 10
29
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-30 00:00:00' AND DateTime_program < '2019-01-30 23:59:59' AND Lang = '1' AND Active = 10
30
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-01-31 00:00:00' AND DateTime_program < '2019-01-31 23:59:59' AND Lang = '1' AND Active = 10
31
Február
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-01 00:00:00' AND DateTime_program < '2019-02-01 23:59:59' AND Lang = '1' AND Active = 10
01
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-02 00:00:00' AND DateTime_program < '2019-02-02 23:59:59' AND Lang = '1' AND Active = 10
02
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-03 00:00:00' AND DateTime_program < '2019-02-03 23:59:59' AND Lang = '1' AND Active = 10
03
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-04 00:00:00' AND DateTime_program < '2019-02-04 23:59:59' AND Lang = '1' AND Active = 10
04
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-05 00:00:00' AND DateTime_program < '2019-02-05 23:59:59' AND Lang = '1' AND Active = 10
05
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-06 00:00:00' AND DateTime_program < '2019-02-06 23:59:59' AND Lang = '1' AND Active = 10
06
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-07 00:00:00' AND DateTime_program < '2019-02-07 23:59:59' AND Lang = '1' AND Active = 10
07
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-08 00:00:00' AND DateTime_program < '2019-02-08 23:59:59' AND Lang = '1' AND Active = 10
08
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-09 00:00:00' AND DateTime_program < '2019-02-09 23:59:59' AND Lang = '1' AND Active = 10
09
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-10 00:00:00' AND DateTime_program < '2019-02-10 23:59:59' AND Lang = '1' AND Active = 10
10
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-11 00:00:00' AND DateTime_program < '2019-02-11 23:59:59' AND Lang = '1' AND Active = 10
11
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-12 00:00:00' AND DateTime_program < '2019-02-12 23:59:59' AND Lang = '1' AND Active = 10
12
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-13 00:00:00' AND DateTime_program < '2019-02-13 23:59:59' AND Lang = '1' AND Active = 10
13
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-14 00:00:00' AND DateTime_program < '2019-02-14 23:59:59' AND Lang = '1' AND Active = 10
14
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-15 00:00:00' AND DateTime_program < '2019-02-15 23:59:59' AND Lang = '1' AND Active = 10
15
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-16 00:00:00' AND DateTime_program < '2019-02-16 23:59:59' AND Lang = '1' AND Active = 10
16
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-17 00:00:00' AND DateTime_program < '2019-02-17 23:59:59' AND Lang = '1' AND Active = 10
17
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-18 00:00:00' AND DateTime_program < '2019-02-18 23:59:59' AND Lang = '1' AND Active = 10
18
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-19 00:00:00' AND DateTime_program < '2019-02-19 23:59:59' AND Lang = '1' AND Active = 10
19
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-20 00:00:00' AND DateTime_program < '2019-02-20 23:59:59' AND Lang = '1' AND Active = 10
20
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-21 00:00:00' AND DateTime_program < '2019-02-21 23:59:59' AND Lang = '1' AND Active = 10
21
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-22 00:00:00' AND DateTime_program < '2019-02-22 23:59:59' AND Lang = '1' AND Active = 10
22
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-23 00:00:00' AND DateTime_program < '2019-02-23 23:59:59' AND Lang = '1' AND Active = 10
23
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-24 00:00:00' AND DateTime_program < '2019-02-24 23:59:59' AND Lang = '1' AND Active = 10
24
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-25 00:00:00' AND DateTime_program < '2019-02-25 23:59:59' AND Lang = '1' AND Active = 10
25
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-26 00:00:00' AND DateTime_program < '2019-02-26 23:59:59' AND Lang = '1' AND Active = 10
26
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-27 00:00:00' AND DateTime_program < '2019-02-27 23:59:59' AND Lang = '1' AND Active = 10
27
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-02-28 00:00:00' AND DateTime_program < '2019-02-28 23:59:59' AND Lang = '1' AND Active = 10
28
Március
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-01 00:00:00' AND DateTime_program < '2019-03-01 23:59:59' AND Lang = '1' AND Active = 10
01
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-02 00:00:00' AND DateTime_program < '2019-03-02 23:59:59' AND Lang = '1' AND Active = 10
02
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-03 00:00:00' AND DateTime_program < '2019-03-03 23:59:59' AND Lang = '1' AND Active = 10
03
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-04 00:00:00' AND DateTime_program < '2019-03-04 23:59:59' AND Lang = '1' AND Active = 10
04
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-05 00:00:00' AND DateTime_program < '2019-03-05 23:59:59' AND Lang = '1' AND Active = 10
05
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-06 00:00:00' AND DateTime_program < '2019-03-06 23:59:59' AND Lang = '1' AND Active = 10
06
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-07 00:00:00' AND DateTime_program < '2019-03-07 23:59:59' AND Lang = '1' AND Active = 10
07
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-08 00:00:00' AND DateTime_program < '2019-03-08 23:59:59' AND Lang = '1' AND Active = 10
08
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-09 00:00:00' AND DateTime_program < '2019-03-09 23:59:59' AND Lang = '1' AND Active = 10
09
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-10 00:00:00' AND DateTime_program < '2019-03-10 23:59:59' AND Lang = '1' AND Active = 10
10
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-11 00:00:00' AND DateTime_program < '2019-03-11 23:59:59' AND Lang = '1' AND Active = 10
11
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-12 00:00:00' AND DateTime_program < '2019-03-12 23:59:59' AND Lang = '1' AND Active = 10
12
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-13 00:00:00' AND DateTime_program < '2019-03-13 23:59:59' AND Lang = '1' AND Active = 10
13
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-14 00:00:00' AND DateTime_program < '2019-03-14 23:59:59' AND Lang = '1' AND Active = 10
14
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-15 00:00:00' AND DateTime_program < '2019-03-15 23:59:59' AND Lang = '1' AND Active = 10
15
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-16 00:00:00' AND DateTime_program < '2019-03-16 23:59:59' AND Lang = '1' AND Active = 10
16
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-17 00:00:00' AND DateTime_program < '2019-03-17 23:59:59' AND Lang = '1' AND Active = 10
17
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-18 00:00:00' AND DateTime_program < '2019-03-18 23:59:59' AND Lang = '1' AND Active = 10
18
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-19 00:00:00' AND DateTime_program < '2019-03-19 23:59:59' AND Lang = '1' AND Active = 10
19
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-20 00:00:00' AND DateTime_program < '2019-03-20 23:59:59' AND Lang = '1' AND Active = 10
20
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-21 00:00:00' AND DateTime_program < '2019-03-21 23:59:59' AND Lang = '1' AND Active = 10
21
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-22 00:00:00' AND DateTime_program < '2019-03-22 23:59:59' AND Lang = '1' AND Active = 10
22
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-23 00:00:00' AND DateTime_program < '2019-03-23 23:59:59' AND Lang = '1' AND Active = 10
23
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-24 00:00:00' AND DateTime_program < '2019-03-24 23:59:59' AND Lang = '1' AND Active = 10
24
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-25 00:00:00' AND DateTime_program < '2019-03-25 23:59:59' AND Lang = '1' AND Active = 10
25
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-26 00:00:00' AND DateTime_program < '2019-03-26 23:59:59' AND Lang = '1' AND Active = 10
26
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-27 00:00:00' AND DateTime_program < '2019-03-27 23:59:59' AND Lang = '1' AND Active = 10
27
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-28 00:00:00' AND DateTime_program < '2019-03-28 23:59:59' AND Lang = '1' AND Active = 10
28
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-29 00:00:00' AND DateTime_program < '2019-03-29 23:59:59' AND Lang = '1' AND Active = 10
29
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-30 00:00:00' AND DateTime_program < '2019-03-30 23:59:59' AND Lang = '1' AND Active = 10
30
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-03-31 00:00:00' AND DateTime_program < '2019-03-31 23:59:59' AND Lang = '1' AND Active = 10
31
Április
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-01 00:00:00' AND DateTime_program < '2019-04-01 23:59:59' AND Lang = '1' AND Active = 10
01
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-02 00:00:00' AND DateTime_program < '2019-04-02 23:59:59' AND Lang = '1' AND Active = 10
02
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-03 00:00:00' AND DateTime_program < '2019-04-03 23:59:59' AND Lang = '1' AND Active = 10
03
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-04 00:00:00' AND DateTime_program < '2019-04-04 23:59:59' AND Lang = '1' AND Active = 10
04
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-05 00:00:00' AND DateTime_program < '2019-04-05 23:59:59' AND Lang = '1' AND Active = 10
05
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-06 00:00:00' AND DateTime_program < '2019-04-06 23:59:59' AND Lang = '1' AND Active = 10
06
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-07 00:00:00' AND DateTime_program < '2019-04-07 23:59:59' AND Lang = '1' AND Active = 10
07
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-08 00:00:00' AND DateTime_program < '2019-04-08 23:59:59' AND Lang = '1' AND Active = 10
08
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-09 00:00:00' AND DateTime_program < '2019-04-09 23:59:59' AND Lang = '1' AND Active = 10
09
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-10 00:00:00' AND DateTime_program < '2019-04-10 23:59:59' AND Lang = '1' AND Active = 10
10
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-11 00:00:00' AND DateTime_program < '2019-04-11 23:59:59' AND Lang = '1' AND Active = 10
11
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-12 00:00:00' AND DateTime_program < '2019-04-12 23:59:59' AND Lang = '1' AND Active = 10
12
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-13 00:00:00' AND DateTime_program < '2019-04-13 23:59:59' AND Lang = '1' AND Active = 10
13
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-14 00:00:00' AND DateTime_program < '2019-04-14 23:59:59' AND Lang = '1' AND Active = 10
14
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-15 00:00:00' AND DateTime_program < '2019-04-15 23:59:59' AND Lang = '1' AND Active = 10
15
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-16 00:00:00' AND DateTime_program < '2019-04-16 23:59:59' AND Lang = '1' AND Active = 10
16
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-17 00:00:00' AND DateTime_program < '2019-04-17 23:59:59' AND Lang = '1' AND Active = 10
17
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-18 00:00:00' AND DateTime_program < '2019-04-18 23:59:59' AND Lang = '1' AND Active = 10
18
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-19 00:00:00' AND DateTime_program < '2019-04-19 23:59:59' AND Lang = '1' AND Active = 10
19
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-20 00:00:00' AND DateTime_program < '2019-04-20 23:59:59' AND Lang = '1' AND Active = 10
20
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-21 00:00:00' AND DateTime_program < '2019-04-21 23:59:59' AND Lang = '1' AND Active = 10
21
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-22 00:00:00' AND DateTime_program < '2019-04-22 23:59:59' AND Lang = '1' AND Active = 10
22
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-23 00:00:00' AND DateTime_program < '2019-04-23 23:59:59' AND Lang = '1' AND Active = 10
23
sze
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-24 00:00:00' AND DateTime_program < '2019-04-24 23:59:59' AND Lang = '1' AND Active = 10
24
cs
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-25 00:00:00' AND DateTime_program < '2019-04-25 23:59:59' AND Lang = '1' AND Active = 10
25
p
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-26 00:00:00' AND DateTime_program < '2019-04-26 23:59:59' AND Lang = '1' AND Active = 10
26
szo
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-27 00:00:00' AND DateTime_program < '2019-04-27 23:59:59' AND Lang = '1' AND Active = 10
27
v
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-28 00:00:00' AND DateTime_program < '2019-04-28 23:59:59' AND Lang = '1' AND Active = 10
28
h
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-29 00:00:00' AND DateTime_program < '2019-04-29 23:59:59' AND Lang = '1' AND Active = 10
29
k
SELECT * FROM apx_ajtk_programok WHERE DateTime_program > '2019-04-30 00:00:00' AND DateTime_program < '2019-04-30 23:59:59' AND Lang = '1' AND Active = 10
30
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
Könyvkiadás - ÚJDONSÁGOK

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.

Robert M. Gates: A vezetés szenvedélye - A köz szolgálatában eltöltött ötven év tanulságai változásról és reformról (Ford. Kiss Marcell)

Kiadási év: 2018
Ár: 3000 Ft
Szállítási költség: 1550 Ft
Az igazi vezető ritka, mint a fehér holló – állapítja meg Robert M. Gates, és hajlamosak vagyunk hinni neki, mert ötven, közszolgálatban töltött év után teszi ezt a kijelentést. Védelmi miniszterként, CIA-igazgatóként, egy texasi egyetem rektoraként, valamint több nagyvállalat igazgatótanácsi tagjaként maga is alakítója volt az állami (kormányzati) és a magánszektor intézményrendszereinek.
 
Jelen könyvében a vezetői szerepről osztja meg tapasztalatait, reménye szerint elsősorban a közszolgálat iránt érdeklődő fiatalokkal, akik polgártársaik életének javítását tűzik ki célul.
 
Gates nem menedzser-tanácsadó kézikönyvet írt, és nem is az amerikai kormányzat titkait fecsegi ki – inkább egy intézmény sikeres működéséhez ad kulcsot: a vezető személyes adottságain túl milyen feltételei vannak annak, hogy egy bürokratikus szervezetet a belső és külső igények és kényszerek hatására folyamatosan megújítsunk; milyen víziók, taktikák és stratégiák szükségesek a szolgáltatás minőségének javítása érdekében. Legyen az „ügyfelünk” akár az amerikai elnök, egy egyetemi hallgató vagy az egészségbiztosítási kártyájáért sorban álló nyugdíjas.
 
Gates közérthetően és kertelés nélkül járja körül a témát – olyan stílust és értékeket mutat meg, amelyek nemcsak a vezetői posztra pályázóknak lehetnek hasznosak, de bárkinek, aki a társadalom és a társadalomszerveződési kérdések iránt érdeklődik.

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.