Biography Ildar Neverov

SHOW FULL COLUMNS FROM `settings`

SELECT `setting`.* FROM `settings` AS `setting` LIMIT 1

SHOW FULL COLUMNS FROM `languages`

SELECT `language`.* FROM `languages` AS `language` WHERE `language`.`alias` = 'en' OR `language`.`default` = '1' ORDER BY `language`.`default` ASC LIMIT 1

SELECT `setting`.* FROM `settings` AS `setting` WHERE `language_id` = '2' LIMIT 1

SHOW FULL COLUMNS FROM `pages`

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '2' AND `alias` = 'main' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '2' AND `lft` > 1 AND `rgt` < 10 AND `scope` = 2 AND `lvl` = 2 AND `status` = '1' AND `menu_show` = '1' ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '2' AND `page`.`alias` = 'biography' AND `page`.`status` = '1' ORDER BY `page`.`lvl` DESC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '2' AND `lft` > 8 AND `rgt` < 9 AND `scope` = 2 AND `lvl` = 3 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '2' AND `lft` <= 8 AND `rgt` >= 9 AND `scope` = 2 AND `lft` != 1 ORDER BY `lft` ASC