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`='acm-lauko-ekranai/joniskis'

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`='acm-lauko-ekranai/joniskis') 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`='acm-lauko-ekranai/joniskis') 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`<119) AND (`rgt`>120) AND (`root`=1) AND (`status`=1) AND (`level`=1) ORDER BY `level` DESC, `lft`, `lft` LIMIT 1