SELECT `content`.`id`, `content`.`controller`, `content`.`title_pre` AS `title`, IF(LENGTH(`content`.`title_short`) > 0, `content`.`title_short`, `content`.`title_pre`) AS `title_short`, `content`.`text`, `content`.`_path`, `content`.`_parent`, `content`.`_level`, `content`.`_left`, `content`.`_right`, `content`.`hide_from_menu`, `content`.`link`, `content`.`link_direct`, `content`.`link_popup`, `content`.`meta_description`, `content`.`meta_keywords`, `content`.`meta_title`, `content`.`teaser_id1`, `content`.`teaser_id2`, `content`.`teaser_id3`, `content`.`announce_id1`, `content`.`announce_id2`, `content`.`announce_id3`, `content`.`announce_id4`, `content`.`announce_id5`, `content`.`announce_id6`, `content`.`show_widgets`, DATE_FORMAT(_modified,'%Y-%m-%d') AS `last_modified`
FROM `bien_content` AS `content`
WHERE `content`.`_state` = 0 AND (`content`.`_path` IN ('ГЦСИ'))
ORDER BY `content`.`_level` DESC
LIMIT 1