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` IS NULL OR `language`.`default` = '1' ORDER BY `language`.`default` ASC LIMIT 1

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

SHOW FULL COLUMNS FROM `pages`

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

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

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '1' AND `page`.`url` = '/media' AND `page`.`status` = '1' ORDER BY `page`.`lvl` DESC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `page`.`scope` = '1' AND `lft` > 12 AND `rgt` < 13 AND `scope` = 1 AND `lvl` = 3 ORDER BY `lft` DESC

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

SHOW FULL COLUMNS FROM `gallery_categories`

SELECT `gallery_category`.* FROM `gallery_categories` AS `gallery_category` ORDER BY `gallery_category`.`id` DESC

SHOW FULL COLUMNS FROM `gallery`

SELECT COUNT(*) AS `records_found` FROM `gallery` AS `gallery` LEFT JOIN `gallery_categories` AS `gallery_category` ON (`gallery_category`.`id` = `gallery`.`gallery_category_id`) WHERE `gallery`.`gallery_category_id` = '2' AND `status` = '1'

SELECT `gallery_category`.`title` AS `gallery_category:title`, `gallery_category`.`alias` AS `gallery_category:alias`, `gallery_category`.`created` AS `gallery_category:created`, `gallery_category`.`updated` AS `gallery_category:updated`, `gallery`.* FROM `gallery` AS `gallery` LEFT JOIN `gallery_categories` AS `gallery_category` ON (`gallery_category`.`id` = `gallery`.`gallery_category_id`) WHERE `gallery`.`gallery_category_id` = '2' AND `status` = '1' ORDER BY `gallery`.`order` DESC LIMIT 6

SELECT `gallery_category`.`id` AS `gallery_category:id`, `gallery_category`.`title` AS `gallery_category:title`, `gallery_category`.`alias` AS `gallery_category:alias`, `gallery_category`.`created` AS `gallery_category:created`, `gallery_category`.`updated` AS `gallery_category:updated`, `gallery`.* FROM `gallery` AS `gallery` LEFT JOIN `gallery_categories` AS `gallery_category` ON (`gallery_category`.`id` = `gallery`.`gallery_category_id`) WHERE `gallery`.`gallery_category_id` = '1' AND `status` = '1' ORDER BY `gallery`.`order` DESC