Database Queries

SELECT `short_code`, `id` FROM `admin_lang`

SELECT `item`.`id`, `item`.`nav_id`, `item`.`title`, `item`.`description`, `item`.`keywords`, `item`.`image_id`, `item`.`is_url_strict_parsing_disabled`, `item`.`alias`, `item`.`title_tag`, `item`.`timestamp_create`, `item`.`timestamp_update`, `item`.`create_user_id`, `item`.`update_user_id`, `nav`.`is_home`, `nav`.`parent_nav_id`, `nav`.`sort_index`, `nav`.`is_hidden`, `item`.`nav_item_type`, `item`.`nav_item_type_id`, `nav_container`.`alias` AS `container` FROM `cms_nav_item` `item` LEFT JOIN `cms_nav` `nav` ON nav.id=item.nav_id LEFT JOIN `cms_nav_container` `nav_container` ON nav_container.id=nav.nav_container_id WHERE ((`nav`.`is_deleted`=FALSE) AND (`item`.`lang_id`='2') AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE)) AND ((`publish_from` IS NULL) OR (`publish_from` <= 1775308903)) AND ((`publish_till` IS NULL) OR (`publish_till` >= 1775308903)) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`

SELECT `value`, `name` FROM `cms_config`

SELECT * FROM `cms_redirect`