SELECT `s`.`category`, `s`.`template`, `s`.`section_id`, `st`.`lang_id`
FROM `section` as `s`
LEFT JOIN `section_text` as `st` 
 ON `s`.`section_id` = `st`.`section_id`
WHERE `st`.`path` = '' AND
 `s`.`deleted` = '0' 
 AND `status` = '1'

SELECT section_id, lang_id, path 
FROM section_text

SELECT `code`, `value`
FROM `settings`
WHERE `lang_id` = 1

SELECT `s`.`section_id`, `s`.`variant`, `st`.`lang_id` 
FROM `section_text` as `st`
LEFT JOIN `section` as `s`
 ON `st`.`section_id` = `s`.`section_id`
WHERE `st`.`lang_id` = 1 AND
 `st`.`status` = '1' AND
 `s`.`deleted` = '0' AND
 (`s`.`left` > (
SELECT `left` 
FROM section 
WHERE section_id = 23) AND 
 `s`.`right` < (
SELECT `right` 
FROM section 
WHERE section_id = 23) AND
 s.`depth` <= ((
SELECT `depth` 
FROM section 
WHERE section_id = 23) + 1 ) )
ORDER BY `s`.`left` ASC 
LIMIT 0,3

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 19
 AND `lang_id` = 1
LIMIT 0, 1

SELECT *
FROM `file`
WHERE `section_id` = 19
 AND `lang_id` = 1
ORDER BY `code` ASC, `rank` ASC, `file_id` ASC

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 21
 AND `lang_id` = 1
LIMIT 0, 1

SELECT *
FROM `file`
WHERE `section_id` = 21
 AND `lang_id` = 1
ORDER BY `code` ASC, `rank` ASC, `file_id` ASC

SELECT `s`.`section_id`, `s`.`variant`, `st`.`lang_id` 
FROM `section_text` as `st`
LEFT JOIN `section` as `s`
 ON `st`.`section_id` = `s`.`section_id`
WHERE `st`.`lang_id` = 1 AND
 `st`.`status` = '1' AND
 `s`.`deleted` = '0' AND
 (`s`.`left` > (
SELECT `left` 
FROM section 
WHERE section_id = 16) AND 
 `s`.`right` < (
SELECT `right` 
FROM section 
WHERE section_id = 16) AND
 s.`depth` <= ((
SELECT `depth` 
FROM section 
WHERE section_id = 16) + 1 ) )
ORDER BY `s`.`left` ASC 
LIMIT 0,5

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 24
 AND `lang_id` = 1
LIMIT 0, 1

SELECT *
FROM `file`
WHERE `section_id` = 24
 AND `lang_id` = 1
ORDER BY `code` ASC, `rank` ASC, `file_id` ASC

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 17
 AND `lang_id` = 1
LIMIT 0, 1

SELECT *
FROM `file`
WHERE `section_id` = 17
 AND `lang_id` = 1
ORDER BY `code` ASC, `rank` ASC, `file_id` ASC

SELECT `s`.`section_id`, `s`.`parent`, `st`.`lang_id`, `st`.`header`, `st`.`name`, `st`.`path`,
`st`.`menu`, `st`.`menu1`
FROM `section` `s`
LEFT JOIN `section_text` `st` ON (`st`.`section_id`=`s`.`section_id`)
WHERE `st`.`lang_id`='1' AND
 `s`.`deleted`= '0' AND 
 `st`.`status`= '1' AND
 (`st`.`menu1`= '1' OR `st`.`menu`= '1')
ORDER BY `s`.`left` ASC

SELECT `s`.`section_id`, `s`.`parent`, `st`.`lang_id`, `st`.`header`, `st`.`name`, `st`.`path`,
`st`.`menu`, `st`.`menu2`
FROM `section` `s`
LEFT JOIN `section_text` `st` ON (`st`.`section_id`=`s`.`section_id`)
WHERE `st`.`lang_id`='1' AND
 `s`.`deleted`= '0' AND 
 `st`.`status`= '1' AND
 (`st`.`menu2`= '1' OR `st`.`menu`= '1')
ORDER BY `s`.`left` ASC

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 1
 AND `lang_id` = 1
LIMIT 0, 1

SELECT `section_id`
FROM `section`
WHERE `left` <= 1
 AND `right` >= 44
ORDER BY `left` ASC

SELECT `st`.`title_child`, `st`.`section_id`
FROM `section_text` as `st`
LEFT JOIN `section` as `s` ON (`st`.`section_id` = `s`.`section_id`)
WHERE `s`.`section_id` IN (1) AND 
 `st`.`lang_id` = '1'
ORDER BY `s`.`left` ASC

SELECT `st`.`name`, `st`.`header`,`st`.`path`, `st`.`section_id`
FROM `section` as `s`
LEFT JOIN `section_text` as `st`
 ON `s`.`section_id` = `st`.`section_id`
WHERE `s`.`section_id` IN (1) AND
 `st`.`lang_id` = 1 AND
 `st`.`status` = '1' AND
 `s`.`deleted` = '0'
ORDER BY `s`.`left`

SELECT `s`.`section_id`, `s`.`variant`, `st`.`lang_id` 
FROM `section_text` as `st`
LEFT JOIN `section` as `s`
 ON `st`.`section_id` = `s`.`section_id`
WHERE `st`.`lang_id` = 1 AND
 `st`.`status` = '1' AND
 `s`.`deleted` = '0' AND
 (`s`.`left` > (
SELECT `left` 
FROM section 
WHERE section_id = 0) AND 
 `s`.`right` < (
SELECT `right` 
FROM section 
WHERE section_id = 0) AND
 s.`depth` <= ((
SELECT `depth` 
FROM section 
WHERE section_id = 0) + 1 ) ) 
 AND `st`.`menu` = '1' 
ORDER BY `s`.`left` ASC

SELECT `path` 
FROM `section_text`
WHERE `section_id` = 1 AND 
 `lang_id` = 1

SELECT `s`.`section_id`, `s`.`variant`, `st`.`lang_id` 
FROM `section_text` as `st`
LEFT JOIN `section` as `s`
 ON `st`.`section_id` = `s`.`section_id`
WHERE `st`.`lang_id` = 1 AND
 `st`.`status` = '1' AND
 `s`.`deleted` = '0' AND
 (`s`.`left` > (
SELECT `left` 
FROM section 
WHERE section_id = 4) AND 
 `s`.`right` < (
SELECT `right` 
FROM section 
WHERE section_id = 4) AND
 s.`depth` <= ((
SELECT `depth` 
FROM section 
WHERE section_id = 4) + 1 ) )
ORDER BY `st`.`date` desc

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 12
 AND `lang_id` = 1
LIMIT 0, 1

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 13
 AND `lang_id` = 1
LIMIT 0, 1

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 5
 AND `lang_id` = 1
LIMIT 0, 1

SELECT * 
FROM `section` 
WHERE `section_id` = ? 
LIMIT 0, 1

SELECT *
FROM section_text
WHERE `section_id` = 6
 AND `lang_id` = 1
LIMIT 0, 1

SELECT *
FROM `file`
WHERE `section_id` = 12
 AND `lang_id` = 1
ORDER BY `code` ASC, `rank` ASC, `file_id` ASC

SELECT category 
FROM section 
WHERE section_id = 12

SELECT `s`.`category`, `s`.`template`, `s`.`section_id`, `st`.`lang_id`
FROM `section` as `s`
LEFT JOIN `section_text` as `st` 
 ON `s`.`section_id` = `st`.`section_id`
WHERE `st`.`path` = '' AND
 `s`.`deleted` = '0' 
 AND `status` = '1'