- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
function get_afisha()
{
global $database;
$i=2;
while(count($row)<4)
{
$query='
(
SELECT DISTINCT ae.id, ae.title
FROM afisha.#__afisha_events ae
WHERE ae.published = 1 AND
ae.deleted = 0 AND
ae.type_event = 1 AND
ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
ae.city=1
ORDER BY RAND()
LIMIT 1
)
union
(
SELECT c.id,c.title
FROM night.#__content c
LEFT JOIN night.#__content_afisha_date ca
ON c.id = ca.id_content
WHERE c.state=1 AND
c.access=0 AND
ca.date >= CURDATE() AND
c.catid=5 AND
ae.city=1
GROUP BY c.id, ca.id_content
ORDER BY RAND()
LIMIT 1
)
union
(
SELECT DISTINCT ae.id, ae.title
FROM afisha.#__afisha_events ae
WHERE ae.published = 1 AND
ae.deleted = 0 AND
ae.type_event = 4 AND
ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
ae.city=1
ORDER BY RAND()
LIMIT 1
)
union
(
SELECT DISTINCT ae.id, ae.title
FROM afisha.#__afisha_events ae
WHERE ae.published = 1 AND
ae.deleted = 0 AND
ae.type_event = 2 AND
ae.id IN (SELECT aed.id_event FROM afisha.#__afisha_event_dates aed WHERE aed.date >= CURDATE()) AND
ae.city=1
ORDER BY RAND()
LIMIT 1
)';
$database->setQuery($query);
$row=$database->loadObjectlist();
$i++;
}
return $row;
}
$row=get_afisha();