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

Carl J. Jensen – David H. McElreath – Melissa Graves: Bevezetés a hírszerzésbe

Kiadási év: 2017
Ár: 3500 Ft
Szállítási költség: 950 Ft

A nagy tapasztalatokkal rendelkező amerikai szerzőtrió e kötetben foglalja össze mindazt, amit a hírszerzés elméletéről és gyakorlatáról tudni érdemes. Könyvük a fogalmi meghatározásokat követően vezeti be az olvasót a hírszerző közösségek és a hírszerzési módszerek, eljárások világába, a megszerzett információk elemzésének és értékelésének fogásaiba, a jelentések elkészítésének módjába, de szól az elhárításról, a fedett műveletekről, a katonai és a bűnügyi hírszerzésről is, összegezi a hírszerzés előtt álló kihívásokat, valamint körvonalazza a hírszerzés jövőjét. 

A kötetet elsősorban a társadalomtudományi, illetve a nemzetközi kapcsolatokkal foglalkozó tanulmányokat folytató egyetemi hallgatóknak ajánljuk, de hasznos olvasmány lehet azoknak a döntéshozóknak is, akik a hírszerzés eredményeit, a hírszerzői jelentéseket felhasználják, illetve mindenkinek, aki az információszerzés- és feldolgozás területén mélyebb ismereteket akar szerezni.  

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.

ALFRED ROLINGTON: HÍRSZERZÉS A 21. SZÁZADBAN - A MOZAIKMÓDSZER

Kiadási év: 2015
Ár: 2000 Ft
Szállítási költség: 725 Ft

A magánélet és a munka területén egyaránt jelen lévő digitalizáció egyre növekvő adatmennyiségeket (Big Data) eredményez. Az összekapcsolódó és kölcsönös függőségeken alapuló globalizált világ, az internet biztosította szabadság (Deep Web, Dark Web) és a 24 órás hírtelítettség új korszakot nyitott a hírszerzés területén is. Alfred Rolington a 21. század kihívásaira válaszoló, szoros nemzetközi együttműködésen alapuló stratégiát ismertet.

A szerző – olyan nagy múltú szakemberek bevonásával, mint Sir Colin McColl (MI6), R. James Woolsey (CIA) és Sir David Phillips – könyvében a hírszerzés elmúlt korszakait ismerteti és elemzi. Szó esik a 20. századi világháborúk vagy épp a hidegháború formálta hírszerzési szemléletváltásokról, egészen a 9/11 kiváltotta legújabb helyzetig, melynek bemutatása a szerző által javasolt stratégia, a mozaikmódszer ismertetésével zárul.

Alfred Rolington: Hírszerzésre szakosodott biztonságpolitikai szakértő, aki az elmúlt harminc évben tanácsadóként szolgált mind a katonai – NATO, CIA, MI6 – és kereskedelmi hírszerzés, mind a bűnüldözés területén.

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.

 

Roland Dannreuther: Nemzetközi biztonság

Kiadási év: 2016
Ár: 3400 Ft
Szállítási költség: 950 Ft

Roland Dannreuther Nemzetközi biztonság című könyve a hidegháború utáni világ új, vagy legalábbis új formában megjelenő biztonsági kihívásait tekinti át. 
A kézikönyvként is jól használható mű legfőbb jellemzője, hogy az eltérő megközelítések szintézisére törekszik, hidat képezve a klasszikus racionalista, valamint a kritikai elméletek között, bemutatva a legfontosabb gyakorlati kérdések különböző értelmezéseinek értékét. 
A biztonsági tanulmányokat jellemző alapvető viták bemutatásán és értékelésén túl, minden egyes fejezet és minden egyes témakör esetében megjelenik a szerző markáns, egyedinek mondható álláspontja, amely miatt a kötet szemléletmódja valóban újdonságnak tekinthető. 
A témák között a „kemény” illetve a „puha” biztonság kérdései egyaránt szerepelnek: a polgárháborúk, a katonai intervenciók, a terrorizmus, a tömegpusztító fegyverek elterjedésének problémája mellett helyet kapott a környezeti biztonság, a migráció és a kiberbiztonság is. 
A szerző a fejezetek végén kérdésekkel, további olvasmányokkal segíti elő a témákban való elmélyedést, így a kötet tankönyvként és szakkönyvként is kiváló olvasmány lehet a biztonságpolitika alapfogalmainak problémaközpontú megközelítéséhez.

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.