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

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/alytus') 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/alytus') 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`<15) AND (`rgt`>16) 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`<15) AND (`rgt`>16) 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`=13) 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`=26)))

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`=13) 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`=26))) 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 (802, 803, 804, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 3132)

SELECT * FROM `catalog_product_price_index` WHERE `id_catalog_product` IN (802, 803, 804, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 3132)

SHOW FULL COLUMNS FROM `catalog_product_price_index`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'catalog_product_price_index' AND kcu.table_name = 'catalog_product_price_index'

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`=13) 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`=26)))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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'