Все новости
SELECT `i`.`id`, `i`.`title`, `i`.`alias`, `i`.`catid`, `i`.`tmcat`, `i`.`introtext`, `i`.`fulltext`, `i`.`video`, `i`.`vslink`, `i`.`created_by_alias`, `i`.`publish_up`, `i`.`image`, `i`.`hits`
FROM `jos_k2_items` as `i`
INNER JOIN `jos_k2_categories` as `c` ON `i`.`catid` = `c`.`id`
WHERE `c`.`parent` IN (SELECT `id` FROM `jos_k2_categories` WHERE `parent`=53) AND `i`.`published` = 1 AND `i`.`trash` = 0 AND `i`.`access` = 0 AND `tmcat` <> 9 AND `i`.`lang` = 1 ORDER BY `i`.`publish_up` DESC
LIMIT 10
9 Смотреть видео
