| 0.0009 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0011 |
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.0005 |
SELECT *
FROM `ttp_report_warehouse`
WHERE `Published` = 1
|
| 0.0008 |
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.0004 |
SELECT *
FROM `ttp_report_categories`
WHERE `Alias` = 'hoa-chau-thiet-ke'
LIMIT 1
|
| 0.0007 |
SELECT *
FROM `auc_products_category_properties`
WHERE `cate_id` = '538'
|
| 0.0004 |
SELECT *
FROM `ttp_report_properties`
WHERE `ID` = '38'
|
| 0.0002 |
SELECT *
FROM `ttp_report_properties`
WHERE `ID` = '96'
|
| 0.0002 |
SELECT *
FROM `ttp_report_properties`
WHERE `ID` = '47'
|
| 0.0249 |
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`.`OrdersCat` DESC, `p`.`ID` DESC
LIMIT 300
|
| 0.0006 |
SELECT DISTINCT *
FROM `ttp_report_trademark` `tm`
WHERE `ID` IN('1')
AND `Published` = '1'
AND `ID` != 7
|
| 0.0010 |
SELECT *
FROM `ttp_report_categories`
WHERE `Special` = 1
AND `ParentID` = 0
ORDER BY `STT` ASC
|
| 0.0003 |
SELECT *
FROM `ttp_report_categories`
WHERE `ParentID` = '538'
ORDER BY `STT` ASC
|
| 0.0097 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '39'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0067 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '40'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0069 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '41'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0054 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '42'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '43'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0073 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '44'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0058 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '45'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0070 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '46'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0091 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '107'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0086 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '97'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0087 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '98'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0090 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '99'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0083 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '100'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0088 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '101'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0088 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '102'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '103'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0084 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '104'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0094 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '105'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0069 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '56'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0063 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '57'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0055 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '59'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '61'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '62'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0052 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '63'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '64'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '65'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0050 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '67'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '69'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '70'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '72'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0058 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '73'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0055 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '74'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0050 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '75'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0054 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '76'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '77'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0057 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '80'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0061 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '81'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0096 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '82'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0091 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '86'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0100 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '88'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0093 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '106'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0087 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '108'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0091 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '125'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0089 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '126'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0088 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '127'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0093 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '128'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
|
| 0.0072 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '39'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0066 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '40'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0066 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '41'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '42'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '43'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0072 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '44'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0059 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '45'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0067 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '46'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0084 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '107'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0085 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '97'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0087 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '98'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0085 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '99'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0084 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '100'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0085 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '101'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0086 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '102'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0050 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '103'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0094 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '104'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0097 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '105'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0068 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '56'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0077 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '57'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0073 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '59'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0060 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '61'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0079 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '62'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0078 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '63'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0073 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '64'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0059 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '65'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0062 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '67'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0061 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '69'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0060 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '70'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0056 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '72'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0061 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '73'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0056 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '74'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '75'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0056 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '76'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0052 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '77'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0054 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '80'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0052 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '81'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0048 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '82'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0049 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '86'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0056 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '88'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '106'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0051 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '108'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0049 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '125'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0062 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '126'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0053 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '127'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0049 |
SELECT `p`.`CategoriesID`
FROM `ttp_report_products` as `p`
LEFT JOIN `ttp_report_product_properties` as `pp` ON `pp`.`ProductsID` = `p`.`ID`
WHERE `pp`.`PropertiesID` = '128'
AND `p`.`Published` = 1
AND `p`.`Status` = 1
AND `p`.`PrimaryImage` != ""
|
| 0.0005 |
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
_800x800.jpg)
_800x800.png)
Email Đặt Hàng:
webshop@dalathasfarm.com
Hotline:
1800 1143
Hỏi đáp & cảm nhận người dùng