Académicos

Multimedia

SELECT DISTINCT a.*
FROM #__zoo_item AS a LEFT JOIN #__zoo_category_item AS c0 ON a.id = c0.item_id
WHERE a.state = 1
AND a.access IN (1)
AND (a.publish_up = '0000-00-00 00:00:00'
OR a.publish_up <= '2026-07-30 00:52:12')
AND (a.publish_down = '0000-00-00 00:00:00'
OR a.publish_down >= '2026-07-30 00:52:12')
AND EXISTS (SELECT item_id
FROM #__zoo_category_item AS f
WHERE f.category_id = 0
AND f.item_id = a.id)
AND c0.category_id IN (2861)
AND ((a.application_id = 24)
OR (a.application_id = 25))

ORDER BY a.created DESC
LIMIT 3

Total Items: 3