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

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
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

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.