Database Queries

SELECT * FROM `config` WHERE (`module`='lang') AND (`cfg_name`='DEFAULT_LANGID')

SELECT * FROM `lang` WHERE `id_lang`=1

SELECT * FROM `lang` ORDER BY `position` DESC

SELECT `menu`.*, `menu_lang`.`title`, `menu_lang`.`alias`, `menu_lang`.`page_path`, `menu_lang`.`rn_params_lang`, `menu_lang`.`link`, `menu_lang`.`lang_status`, `menu_lang`.`id_lang` FROM `menu` LEFT JOIN `menu_lang` ON `menu`.id_menu=`menu_lang`.id_menu and `menu_lang`.id_lang=1 WHERE (`menu`.`status`=1) AND (`lang_status`=1) AND (`level` > 0)

SELECT `menu`.*, `menu_lang`.`title`, `menu_lang`.`alias`, `menu_lang`.`page_path`, `menu_lang`.`rn_params_lang`, `menu_lang`.`link`, `menu_lang`.`lang_status`, `menu_lang`.`id_lang` FROM `menu` LEFT JOIN `menu_lang` ON `menu`.id_menu=`menu_lang`.id_menu and `menu_lang`.id_lang=1 WHERE `page_path`='reklamos-stendu-nuoma/pagrindiniai-keliai'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE (`page_path`='reklamos-stendu-nuoma/pagrindiniai-keliai') AND (`inner_status`=1)

SELECT `catalog_category`.*, `catalog_category_lang`.`title`, `catalog_category_lang`.`alias`, `catalog_category_lang`.`page_path`, `catalog_category_lang`.`content`, `catalog_category_lang`.`short_content`, `catalog_category_lang`.`rn_params_lang`, `catalog_category_lang`.`lang_status`, `catalog_category_lang`.`id_lang` FROM `catalog_category` LEFT JOIN `catalog_category_lang` ON `catalog_category`.id_catalog_category=`catalog_category_lang`.id_catalog_category and `catalog_category_lang`.id_lang=1 WHERE (`page_path`='reklamos-stendu-nuoma/pagrindiniai-keliai') AND (`status`=1)

SELECT `catalog_category`.*, `catalog_category_lang`.`title`, `catalog_category_lang`.`alias`, `catalog_category_lang`.`page_path`, `catalog_category_lang`.`content`, `catalog_category_lang`.`short_content`, `catalog_category_lang`.`rn_params_lang`, `catalog_category_lang`.`lang_status`, `catalog_category_lang`.`id_lang` FROM `catalog_category` LEFT JOIN `catalog_category_lang` ON `catalog_category`.id_catalog_category=`catalog_category_lang`.id_catalog_category and `catalog_category_lang`.id_lang=1 WHERE `catalog_category`.`id_catalog_category`=1

SELECT * FROM `catalog_category` WHERE (`lft`<89) AND (`rgt`>90) AND (`root`=1) AND (`status`=1) AND (`level`=1) ORDER BY `level` DESC, `lft`, `lft` LIMIT 1

SELECT `gmap_map`.*, `gmap_map_lang`.`title`, `gmap_map_lang`.`rn_params_lang`, `gmap_map_lang`.`lang_status`, `gmap_map_lang`.`id_lang` FROM `gmap_map` LEFT JOIN `gmap_map_lang` ON `gmap_map`.id_gmap_map=`gmap_map_lang`.id_gmap_map and `gmap_map_lang`.id_lang=1 WHERE (`gmap_map`.`status`=1) AND (`lang_status`=1) AND (`gmap_map`.`id_gmap_map`=2)

SELECT `gmap_map`.*, `gmap_map_lang`.`title`, `gmap_map_lang`.`rn_params_lang`, `gmap_map_lang`.`lang_status`, `gmap_map_lang`.`id_lang` FROM `gmap_map` LEFT JOIN `gmap_map_lang` ON `gmap_map`.id_gmap_map=`gmap_map_lang`.id_gmap_map and `gmap_map_lang`.id_lang=1 WHERE `gmap_map`.`id_gmap_map`=2

SELECT `catalog_feature`.*, `catalog_feature_lang`.`title`, `catalog_feature_lang`.`alias`, `catalog_feature_lang`.`content`, `catalog_feature_lang`.`rn_params_lang`, `catalog_feature_lang`.`lang_status`, `catalog_feature_lang`.`id_lang` FROM `catalog_feature` LEFT JOIN `catalog_feature_lang` ON `catalog_feature`.id_catalog_feature=`catalog_feature_lang`.id_catalog_feature and `catalog_feature_lang`.id_lang=1 WHERE `catalog_feature`.`id_catalog_feature`=8

SELECT `value`, count(*) as kiek FROM `catalog_product_feature_int` INNER JOIN `catalog_product` ON `catalog_product`.id_catalog_product=`catalog_product_feature_int`.id_catalog_product WHERE (`id_catalog_feature`=8) AND (`catalog_product`.`status`=1) AND (`catalog_product_feature_int`.`id_catalog_product` IN (SELECT `model_id` FROM `gmap_marker` WHERE (`status`=1) AND (`model_class`='common\\modules\\catalog\\models\\Product') AND (`id_gmap_map` IN ('', 2)))) GROUP BY `value`

SELECT `catalog_feature_option`.*, `catalog_feature_option_lang`.`title`, `catalog_feature_option_lang`.`alias`, `catalog_feature_option_lang`.`content`, `catalog_feature_option_lang`.`rn_params_lang`, `catalog_feature_option_lang`.`lang_status`, `catalog_feature_option_lang`.`id_lang` FROM `catalog_feature_option` LEFT JOIN `catalog_feature_option_lang` ON `catalog_feature_option`.id_catalog_feature_option=`catalog_feature_option_lang`.id_catalog_feature_option and `catalog_feature_option_lang`.id_lang=1 WHERE (`catalog_feature_option`.`status`=1) AND (`lang_status`=1) AND (`catalog_feature_option`.`id_catalog_feature`=8) ORDER BY `position`

SELECT `catalog_feature`.*, `catalog_feature_lang`.`title`, `catalog_feature_lang`.`alias`, `catalog_feature_lang`.`content`, `catalog_feature_lang`.`rn_params_lang`, `catalog_feature_lang`.`lang_status`, `catalog_feature_lang`.`id_lang` FROM `catalog_feature` LEFT JOIN `catalog_feature_lang` ON `catalog_feature`.id_catalog_feature=`catalog_feature_lang`.id_catalog_feature and `catalog_feature_lang`.id_lang=1 WHERE `catalog_feature`.`id_catalog_feature`=1

SELECT `value`, count(*) as kiek FROM `catalog_product_feature_int` INNER JOIN `catalog_product` ON `catalog_product`.id_catalog_product=`catalog_product_feature_int`.id_catalog_product WHERE (`id_catalog_feature`=1) AND (`catalog_product`.`status`=1) AND (`catalog_product_feature_int`.`id_catalog_product` IN (SELECT `model_id` FROM `gmap_marker` WHERE (`status`=1) AND (`model_class`='common\\modules\\catalog\\models\\Product') AND (`id_gmap_map` IN ('', 2)))) GROUP BY `value`

SELECT `catalog_feature_option`.*, `catalog_feature_option_lang`.`title`, `catalog_feature_option_lang`.`alias`, `catalog_feature_option_lang`.`content`, `catalog_feature_option_lang`.`rn_params_lang`, `catalog_feature_option_lang`.`lang_status`, `catalog_feature_option_lang`.`id_lang` FROM `catalog_feature_option` LEFT JOIN `catalog_feature_option_lang` ON `catalog_feature_option`.id_catalog_feature_option=`catalog_feature_option_lang`.id_catalog_feature_option and `catalog_feature_option_lang`.id_lang=1 WHERE (`catalog_feature_option`.`status`=1) AND (`lang_status`=1) AND (`catalog_feature_option`.`id_catalog_feature`=1) ORDER BY `position`

SELECT * FROM `catalog_category` WHERE (`lft`<89) AND (`rgt`>90) AND (`root`=1) AND (`status`=1) AND (`level`=1) ORDER BY `level` DESC, `lft`, `lft` LIMIT 1

SELECT COUNT(*) FROM `catalog_category_product` LEFT JOIN `catalog_product` ON `catalog_category_product`.`id_catalog_product` = `catalog_product`.`id_catalog_product` LEFT JOIN `catalog_product_lang` ON `catalog_product`.id_catalog_product=`catalog_product_lang`.id_catalog_product and `catalog_product_lang`.id_lang=1 LEFT JOIN `catalog_product_price_index` ON `catalog_product`.`id_catalog_product` = `catalog_product_price_index`.`id_catalog_product` WHERE (`catalog_product`.`status`=1) AND (`catalog_category_product`.`id_catalog_category`=10) AND (`catalog_product`.`id_catalog_product` IN (SELECT `id_catalog_product` FROM `catalog_product_feature_int` WHERE (`catalog_product_feature_int`.`id_catalog_feature`=8) AND (`catalog_product_feature_int`.`value`=63)))

SELECT `catalog_category_product`.* FROM `catalog_category_product` LEFT JOIN `catalog_product` ON `catalog_category_product`.`id_catalog_product` = `catalog_product`.`id_catalog_product` LEFT JOIN `catalog_product_lang` ON `catalog_product`.id_catalog_product=`catalog_product_lang`.id_catalog_product and `catalog_product_lang`.id_lang=1 LEFT JOIN `catalog_product_price_index` ON `catalog_product`.`id_catalog_product` = `catalog_product_price_index`.`id_catalog_product` WHERE (`catalog_product`.`status`=1) AND (`catalog_category_product`.`id_catalog_category`=10) AND (`catalog_product`.`id_catalog_product` IN (SELECT `id_catalog_product` FROM `catalog_product_feature_int` WHERE (`catalog_product_feature_int`.`id_catalog_feature`=8) AND (`catalog_product_feature_int`.`value`=63))) ORDER BY `sku`, `catalog_product`.`priority` DESC, `position` DESC LIMIT 30

SELECT `catalog_product`.*, `catalog_product_lang`.`title`, `catalog_product_lang`.`subtitle`, `catalog_product_lang`.`alias`, `catalog_product_lang`.`content`, `catalog_product_lang`.`short_content`, `catalog_product_lang`.`rn_params_lang`, `catalog_product_lang`.`lang_status`, `catalog_product_lang`.`id_lang` FROM `catalog_product` LEFT JOIN `catalog_product_lang` ON `catalog_product`.id_catalog_product=`catalog_product_lang`.id_catalog_product and `catalog_product_lang`.id_lang=1 WHERE `catalog_product`.`id_catalog_product` IN (2879, 814, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 845, 846, 847, 848, 849, 850, 851, 852, 853, 855, 856, 857, 858, 859, 860, 861)

SELECT * FROM `catalog_product_price_index` WHERE `id_catalog_product` IN (814, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 845, 846, 847, 848, 849, 850, 851, 852, 853, 855, 856, 857, 858, 859, 860, 861, 2879)

SELECT COUNT(*) FROM `catalog_category_product` LEFT JOIN `catalog_product` ON `catalog_category_product`.`id_catalog_product` = `catalog_product`.`id_catalog_product` LEFT JOIN `catalog_product_lang` ON `catalog_product`.id_catalog_product=`catalog_product_lang`.id_catalog_product and `catalog_product_lang`.id_lang=1 LEFT JOIN `catalog_product_price_index` ON `catalog_product`.`id_catalog_product` = `catalog_product_price_index`.`id_catalog_product` WHERE (`catalog_product`.`status`=1) AND (`catalog_category_product`.`id_catalog_category`=10) AND (`catalog_product`.`id_catalog_product` IN (SELECT `id_catalog_product` FROM `catalog_product_feature_int` WHERE (`catalog_product_feature_int`.`id_catalog_feature`=8) AND (`catalog_product_feature_int`.`value`=63)))

SELECT `catalog_feature`.*, `catalog_feature_lang`.`title`, `catalog_feature_lang`.`alias`, `catalog_feature_lang`.`content`, `catalog_feature_lang`.`rn_params_lang`, `catalog_feature_lang`.`lang_status`, `catalog_feature_lang`.`id_lang` FROM `catalog_feature` LEFT JOIN `catalog_feature_lang` ON `catalog_feature`.id_catalog_feature=`catalog_feature_lang`.id_catalog_feature and `catalog_feature_lang`.id_lang=1 INNER JOIN `catalog_category_feature` ON `catalog_category_feature`.id_catalog_feature=`catalog_feature`.id_catalog_feature WHERE `catalog_category_feature`.`id_catalog_category`=10 ORDER BY `catalog_category_feature`.`position`

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=2879) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=2879

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=2879

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=814) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=814

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=814

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=831) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=831

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=831

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=832) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=832

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=832

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=833) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=833

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=833

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=834) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=834

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=834

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=835) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=835

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=835

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=836) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=836

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=836

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=837) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=837

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=837

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=838) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=838

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=838

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=839) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=839

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=839

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=840) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=840

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=840

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=841) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=841

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=841

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=842) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=842

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=842

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=845) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=845

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=845

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=846) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=846

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=846

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=847) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=847

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=847

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=848) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=848

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=848

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=849) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=849

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=849

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=850) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=850

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=850

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=851) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=851

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=851

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=852) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=852

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=852

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=853) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=853

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=853

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=855) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=855

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=855

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=856) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=856

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=856

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=857) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=857

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=857

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=858) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=858

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=858

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=859) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=859

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=859

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=860) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=860

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=860

SELECT * FROM `catalog_product_feature_int` WHERE (`id_catalog_product`=861) AND (`is_multi`=FALSE)

SELECT * FROM `catalog_product_feature_varchar` WHERE `id_catalog_product`=861

SELECT * FROM `catalog_product_feature_text` WHERE `id_catalog_product`=861

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`=94

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE (`lft` > 1337) AND (`rgt` < 1348) AND (`level` <= 3) AND (`status`=1) AND (`outer_status`=1) ORDER BY `lft`

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='342'

SELECT `menu`.*, `menu_lang`.`title`, `menu_lang`.`alias`, `menu_lang`.`page_path`, `menu_lang`.`rn_params_lang`, `menu_lang`.`link`, `menu_lang`.`lang_status`, `menu_lang`.`id_lang` FROM `menu` LEFT JOIN `menu_lang` ON `menu`.id_menu=`menu_lang`.id_menu and `menu_lang`.id_lang=1 WHERE (`menu`.`status`=1) AND (`lang_status`=1) AND (`level` > 0)

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='343'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='344'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='336'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='345'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='416'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='417'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='412'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='548'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='668'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='864'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1088'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='965'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='731'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='877'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='774'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1030'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='917'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1089'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1091'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1092'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='1095'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='261'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='25'

SELECT `article_cat`.*, `article_cat_lang`.`title`, `article_cat_lang`.`subtitle`, `article_cat_lang`.`alias`, `article_cat_lang`.`page_path`, `article_cat_lang`.`inner_content`, `article_cat_lang`.`outer_content`, `article_cat_lang`.`rn_params_lang`, `article_cat_lang`.`lang_status`, `article_cat_lang`.`id_lang` FROM `article_cat` LEFT JOIN `article_cat_lang` ON `article_cat`.id_article_cat=`article_cat_lang`.id_article_cat and `article_cat_lang`.id_lang=1 WHERE `article_cat`.`id_article_cat`='93'