| 0.0008 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0009 |
SELECT `sl`.*, `d`.`title` as `name`, `c`.`Title` as `cityName`
FROM `ttp_report_store_location` `sl`
JOIN `ttp_report_warehouse` as `w` ON `w`.`Shortcut` = `sl`.`store`
LEFT JOIN `ttp_report_district` as `d` ON `d`.`ID` = `sl`.`district_id`
LEFT JOIN `ttp_report_city` as `c` ON `c`.`ID` = `sl`.`city_id`
WHERE `sl`.`published` = 1
GROUP BY `sl`.`id`
|
| 0.0008 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
ORDER BY `STT` ASC
|
| 0.0003 |
SELECT DISTINCT *
FROM `auc_cart`
WHERE `store` = 'a5'
AND `session_id` IS NULL
|
| 0.0006 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0009 |
SELECT `sl`.*, `d`.`title` as `name`, `c`.`Title` as `cityName`
FROM `ttp_report_store_location` `sl`
JOIN `ttp_report_warehouse` as `w` ON `w`.`Shortcut` = `sl`.`store`
LEFT JOIN `ttp_report_district` as `d` ON `d`.`ID` = `sl`.`district_id`
LEFT JOIN `ttp_report_city` as `c` ON `c`.`ID` = `sl`.`city_id`
WHERE `sl`.`published` = 1
GROUP BY `sl`.`id`
|
| 0.0014 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = 585
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`ID` DESC
LIMIT 8
|
| 0.0003 |
SELECT DISTINCT *
FROM `auc_cart`
WHERE `store` = 'a5'
AND `session_id` IS NULL
|
| 0.0007 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
AND `show_home_block` = 1
ORDER BY `STT` ASC
|
| 0.0005 |
SELECT *
FROM `ttp_banner`
WHERE `Published` = 1
ORDER BY `Sort`
|
| 0.0008 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
ORDER BY `STT` ASC
|
| 0.0004 |
SELECT *
FROM `ttp_define`
WHERE `group` = 'webshop'
AND `type` = 'event'
AND `code` = 'EVENT_BANNER'
|
| 0.0427 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '235'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 15
|
| 0.0130 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '538'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 15
|
| 0.0065 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '535'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 10
|
| 0.0080 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '587'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 8
|
| 0.0028 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '588'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 10
|
| 0.0030 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '589'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 5
|
| 0.0044 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '576'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 5
|
| 0.0021 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '578'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 5
|
| 0.0012 |
SELECT DISTINCT `p`.`ID`, `p`.`MaSP`, `p`.`Title`, `p`.`CategoriesID`, `p`.`properties_id`, `p`.`Donvi`, `p`.`Description`, `p`.`MetaTitle`, `p`.`MetaKeywords`, `p`.`MetaDescription`, `p`.`Content`, `p`.`PrimaryImage`, `p`.`AlbumImage`, `p`.`Alias`, `p`.`TrademarkID`, `p`.`PutcartNegative`, `p`.`TypeProducts`, `pr`.`sat_opening_qty` as `quantity`, `pr`.`sat_regular_price` as `Price`, `pr`.`sat_promo_price` as `SocialPrice`
FROM `ttp_report_products` `p`
LEFT JOIN `ttp_report_products_categories` `c` ON `c`.`ProductsID` = `p`.`ID`
LEFT JOIN `auc_prices_mag008` `pr` ON `pr`.`item_id` = `p`.`MaSP`
WHERE `c`.`CategoriesID` = '585'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
ORDER BY `p`.`sort_sale` DESC, `p`.`ID` DESC
LIMIT 10
|
| 0.0006 |
SELECT *
FROM `ttp_define`
WHERE `group` = 'system'
AND `type` = 'cookie_version_require'
|
About Dalat Hasfarm
Tin nổi bật
Tìm cửa hàng
Thẻ thành viên
Hỗ trợ
Đăng nhập
nn_800x800.jpg)
Email Đặt Hàng:
webshop@dalathasfarm.com
Hotline:
1800 1143
Hỏi đáp & cảm nhận người dùng