SELECT *FROM (`cle_system`)WHERE `public` = 1ORDER BY `created`
SELECT *FROM (`cle_mconfig`)ORDER BY `order`, `created` desc
SELECT *FROM (`cle_menu_groups`)ORDER BY `created` desc
SELECT *FROM (`cle_menu`)WHERE `groupID` = '3'ORDER BY `order`
SELECT *FROM (`cle_menu`)WHERE `groupID` = '2'ORDER BY `order`
SELECT *FROM (`cle_gallery`)WHERE `public` = 1AND `type` = 'slider'ORDER BY `order`
SELECT `cle_products`.`id`, `cle_products`.`title`, `cle_products`.`slug`, `cle_products`.`price`, `cle_products`.`price_sale`, `cle_products`.`hot`, `cle_products`.`new`, `cle_products`.`sale`, `cle_products`.`image`, `cle_products`.`public`, `cle_products`.`seo_title`, `cle_products`.`seo_description`, `cle_products`.`seo_keywords`, `cle_products`.`category_ID`, `cle_products`.`masp`, `cle_products_categorys`.`name`FROM (`cle_products`)JOIN `cle_products_categorys` ON `cle_products`.`category_ID` = `cle_products_categorys`.`id`WHERE `cle_products`.`public` = 1AND `cle_products`.`sale` = 1LIMIT 20
SELECT *FROM (`cle_footer`)JOIN `cle_footer_language` ON `cle_footer`.`id` = `cle_footer_language`.`post_ID`WHERE `cle_footer_language`.`language` = 'vi'ORDER BY `order`
SELECT *FROM (`cle_widget_page_detail`)JOIN `cle_widget` ON `cle_widget_page_detail`.`widget_ID` = `cle_widget`.`id`WHERE `cle_widget_page_detail`.`page_ID` = 'products_detail'AND `cle_widget_page_detail`.`position` = 'left'ORDER BY `cle_widget_page_detail`.`order`
SELECT *FROM (`cle_widget_page_detail`)JOIN `cle_widget` ON `cle_widget_page_detail`.`widget_ID` = `cle_widget`.`id`WHERE `cle_widget_page_detail`.`page_ID` = 'products_detail'AND `cle_widget_page_detail`.`position` = 'right'ORDER BY `cle_widget_page_detail`.`order`
SELECT *FROM (`cle_widget_page_detail`)JOIN `cle_widget` ON `cle_widget_page_detail`.`widget_ID` = `cle_widget`.`id`WHERE `cle_widget_page_detail`.`page_ID` = 'products_detail'AND `cle_widget_page_detail`.`position` = 'content'ORDER BY `cle_widget_page_detail`.`order`
SELECT *FROM (`cle_products`)WHERE `slug` = 'san-pham'