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/taurage'

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/taurage') 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/taurage') 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`<71) AND (`rgt`>72) 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`<71) AND (`rgt`>72) 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`=42) 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`=54)))

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`=42) 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`=54))) 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 (925, 926, 927, 928, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 2746, 2872, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3332)

SELECT * FROM `catalog_product_price_index` WHERE `id_catalog_product` IN (925, 926, 927, 928, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 2746, 2872, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3332)

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`=42) 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`=54)))

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`=42 ORDER BY `catalog_category_feature`.`position`

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 * FROM `menu` WHERE (`status`=1) AND (`menu_name`='MAIN')

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 (`lft`>1) AND (`rgt`<112) AND (`root`=1) AND (`menu`.`status`=1) AND (`lang_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`='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`='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`='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`='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`='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`='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`='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`='704'

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`='465'

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`='713'

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`='721'

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`='870'

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`='691'

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`='420'

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`='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`='93'

SELECT COUNT(*) FROM `remotemenu_pages` WHERE `status`=1

SELECT * FROM `remotemenu_pages` WHERE `status`=1

SELECT * FROM `menu` WHERE (`status`=1) AND (`menu_name`='MOBILE')

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 (`lft`>1) AND (`rgt`<2) AND (`root`=6) AND (`menu`.`status`=1) AND (`lang_status`=1) ORDER BY `lft`

SELECT COUNT(*) FROM `remotemenu_pages` WHERE `status`=1

SELECT * FROM `remotemenu_pages` WHERE `status`=1

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`='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`='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'