SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN tp_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute

SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN tp_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=15)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=12)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=17)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=14)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN tp_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=18)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=13)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=16)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1  AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0))

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=22)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=27)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=24)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=37)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=31)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=34)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=21)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=26)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=25)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=28)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=23)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN tp_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=5)) GROUP BY pac.id_attribute

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=30)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN tp_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=35)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=20)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=9)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0))

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=10)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) WHERE ((sa.quantity>0))

SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p GROUP BY p.id_manufacturer

SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p GROUP BY p.condition

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 15 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.erp_tri ASC, p.id_product DESC

SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `tp_manufacturer` m INNER JOIN tp_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `tp_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC

SELECT SQL_NO_CACHE c.`id_category`, cl.`name`
FROM `tp_category` c
INNER JOIN tp_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tp_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
ORDER BY c.nleft, c.position

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `tp_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `tp_hook_alias` ha
INNER JOIN `tp_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2026-10-29 00:00:00',
INTERVAL 3 DAY
)
) > 0) as new
FROM tp_product p
LEFT JOIN tp_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN tp_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN tp_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (1175,1177,1268,1243,1180,1183,1286,1271,1186,1274,1189,1277,1234,1192,1280,1195,1198,1201,1204,1207,1210,1213,1216,1283,1289,1228,1231,8092,1237,8099,1240,1246,1292,1295,1249,1252,1255,1298,1301,1347,1219,1222,1225,1258,1261,1264)

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `tp_module` m
INNER JOIN tp_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1)
INNER JOIN `tp_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `tp_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `tp_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.nleft>547 AND c.nright<548 GROUP BY cp.id_category

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=29)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 17 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `tp_hook_module` hm
STRAIGHT_JOIN `tp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `tp_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM tp_layered_category
WHERE controller = 'category'
AND id_category = 105
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=36)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 12 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `tp_feature` f  INNER JOIN tp_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `tp_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `tp_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `tp_configuration` c
LEFT JOIN `tp_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=32)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE id, value, state, is_confirmed, is_deleted FROM tp_lappstar_options
WHERE id_customer=0
AND id_option="secret_codeeg" LIMIT 1

SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, p.erp_tri FROM tp_product p LEFT JOIN tp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN tp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN tp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN tp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN tp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN tp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN tp_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=547 AND c.nright<=548 GROUP BY p.id_product) p INNER JOIN tp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=33)) GROUP BY fp.id_feature_value

SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description`
FROM `tp_category` c
INNER JOIN tp_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `tp_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 105
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `tp_attribute_group` ag INNER JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `tp_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `tp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN tp_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `tp_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC

SELECT SQL_NO_CACHE lower(name) as name
FROM `tp_hook` h
WHERE (h.active = 1)

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 16 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 18 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM tp_shop_url su
LEFT JOIN tp_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'evo.tabacpresse.net' OR su.domain_ssl = 'evo.tabacpresse.net')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1298 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1298 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `tp_attribute_group` ag INNER JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `tp_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `tp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN tp_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `tp_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1283
AND pac.`id_product_attribute` = 385
AND agl.`id_lang` = 1

REPLACE INTO tp_layered_filter_block (hash, data) VALUES ("62e4fbcd29bd65c81e603c7983ac6c71", "a:1:{s:7:\"filters\";a:14:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilité\";s:6:\"values\";a:3:{i:2;a:2:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:45;}i:1;a:2:{s:4:\"name\";s:10:\"Disponible\";s:3:\"nbr\";i:46;}i:0;a:2:{s:4:\"name\";s:14:\"Non disponible\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:0:{}i:3;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:2;s:4:\"name\";s:16:\"Taux de nicotine\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:14;a:4:{s:4:\"name\";s:7:\"0 mg/ml\";s:3:\"nbr\";i:43;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"État\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:4:\"Neuf\";s:3:\"nbr\";i:46;}s:4:\"used\";a:2:{s:4:\"name\";s:8:\"Utilisé\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:14:\"Reconditionné\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:3;s:4:\"name\";s:17:\"Format e-liquides\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:21;a:4:{s:4:\"name\";s:5:\"50 ml\";s:3:\"nbr\";i:45;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:12;s:6:\"values\";a:1:{i:2960;a:4:{s:3:\"nbr\";i:45;s:4:\"name\";s:10:\"VAP NATION\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Marque\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:13;s:6:\"values\";a:1:{i:2958;a:4:{s:3:\"nbr\";i:45;s:4:\"name\";s:11:\"PG/VG 50/50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Taux PG/VG\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:15;s:6:\"values\";a:47:{i:2961;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Abricot\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2987;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Agrumes\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3656;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Ananas\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3471;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"Anis\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3006;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Baie De Gojie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3029;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Barbe à Papa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3789;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:10:\"Bubble gum\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3678;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Cactus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3051;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Café\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3700;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Caramel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3073;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Cerise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3722;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Citron Jaune\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3572;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"Classic Blond\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3631;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Classic Brun\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3588;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:14:\"Classic Corsé\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3565;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:14:\"Classic Ricain\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3877;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:16:\"Classic Scottish\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3405;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:14:\"Coco Gourmande\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3095;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"Cola\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3745;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:16:\"Corne de gazelle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3558;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:10:\"Eucalyptus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3139;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:17:\"Figue De Barbarie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3161;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Fraise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3183;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:9:\"Framboise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3512;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:19:\"Fruit de la passion\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3117;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:15:\"Fruit du Dragon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3205;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:17:\"Fruit Du Jacquier\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3227;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:16:\"Fruit du serpent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3249;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:13:\"Fruits rouges\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3271;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Grenade\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3767;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:9:\"Groseille\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3811;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Mangue\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3294;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:19:\"Menthe Chlorophylle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3317;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:15:\"Menthe Glaciale\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3339;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Menthe Verte\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3361;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Mojito\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:8462;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Myrtille\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3383;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Mûre\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27654;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Neutre\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3449;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Noisette\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3427;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Néfle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3833;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Pasteque\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3516;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Pomme\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3855;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Pêche\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3559;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Raisin\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3560;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:9:\"Réglisse\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3899;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Vanille\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:5:\"Goût\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:16;s:6:\"values\";a:1:{i:2962;a:4:{s:3:\"nbr\";i:43;s:4:\"name\";s:6:\"France\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:4:\"Pays\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:18;s:6:\"values\";a:2:{i:2967;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:18:\"Nicotine classique\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2983;a:4:{s:3:\"nbr\";i:34;s:4:\"name\";s:15:\"Sel de nicotine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:16:\"Type de nicotine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:14;s:6:\"values\";a:5:{i:3980;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"NEUTRE\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3564;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:18:\"PARFUMS CLASSIQUES\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3293;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:13:\"PARFUMS FRAIS\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:2959;a:4:{s:3:\"nbr\";i:24;s:4:\"name\";s:15:\"PARFUMS FRUITES\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3028;a:4:{s:3:\"nbr\";i:10;s:4:\"name\";s:17:\"PARFUMS GOURMANDS\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Parfums\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:12;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:1:{i:24;a:2:{s:4:\"name\";s:10:\"VAP\'NATION\";s:3:\"nbr\";i:46;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:17;s:6:\"values\";a:1:{i:2963;a:4:{s:3:\"nbr\";i:45;s:4:\"name\";s:8:\"Origin\'s\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:5:\"Gamme\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8099 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8099 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `tp_category` c
LEFT JOIN `tp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN tp_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 44
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1234) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 1207 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 14 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `tp_attribute_group` ag INNER JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `tp_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `tp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN tp_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `tp_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `tp_attribute_group` ag INNER JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `tp_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `tp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN tp_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `tp_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `tp_meta` m
LEFT JOIN `tp_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1210
ORDER BY `position`

SELECT SQL_NO_CACHE `id_hook`, `name` FROM `tp_hook`

SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `tp_attribute_group` ag INNER JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `tp_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `tp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1)  INNER JOIN tp_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `tp_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 272
AND cp.`id_cart` = 0 AND cp.`id_product` = 1234 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 272
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1234 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1189) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1268
AND pac.`id_product_attribute` = 350
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1175) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1277
AND pac.`id_product_attribute` = 371
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1189 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1189 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc_eg_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_eg_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_eg_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=8099
AND tp_lappstar_products_cpc.id_product_attribute=3655
AND tp_lappstar_products_cpc_eg_details.tarif=6
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_eg_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1252 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1252 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=8099
AND tp_lappstar_products_cpc.id_product_attribute=3655
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1289) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1268 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1268 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1249 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1249 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `tp_stock_available`
WHERE (id_product = 1277) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=8092
AND tp_lappstar_products_cpc.id_product_attribute=3649
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1234 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1234 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `tp_attribute_group` ag  INNER JOIN tp_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `tp_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `tp_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1198
AND pac.`id_product_attribute` = 188
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_category` a0
LEFT JOIN `tp_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 547) AND (a0.`nright` > 548) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 350
AND cp.`id_cart` = 0 AND cp.`id_product` = 1268 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 350
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1268 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 420
AND cp.`id_cart` = 0 AND cp.`id_product` = 1298 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 420
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1298 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 307
AND cp.`id_cart` = 0 AND cp.`id_product` = 1249 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 307
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1249 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1175 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1175 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 167
AND cp.`id_cart` = 0 AND cp.`id_product` = 1189 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 167
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1189 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 216
AND cp.`id_cart` = 0 AND cp.`id_product` = 1210 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 216
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1210 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1189
AND pac.`id_product_attribute` = 167
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1225
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1204 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1204 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1347
AND tp_lappstar_products_cpc.id_product_attribute=0
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 195
AND cp.`id_cart` = 0 AND cp.`id_product` = 1201 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 195
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1201 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1274
AND pac.`id_product_attribute` = 364
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1274 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1274 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1249
AND pac.`id_product_attribute` = 307
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc_eg_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_eg_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_eg_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1347
AND tp_lappstar_products_cpc.id_product_attribute=0
AND tp_lappstar_products_cpc_eg_details.tarif=6
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_eg_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1201 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1201 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1268
ORDER BY `position`

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc_eg_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_eg_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_eg_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=8092
AND tp_lappstar_products_cpc.id_product_attribute=3649
AND tp_lappstar_products_cpc_eg_details.tarif=6
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_eg_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1280 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1280 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 265
AND cp.`id_cart` = 0 AND cp.`id_product` = 1231 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 265
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1231 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1192) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1195
AND pac.`id_product_attribute` = 181
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1207 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1207 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1204
AND pac.`id_product_attribute` = 202
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 188
AND cp.`id_cart` = 0 AND cp.`id_product` = 1198 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 188
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1198 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 378
AND cp.`id_cart` = 0 AND cp.`id_product` = 1280 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 378
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1280 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1277 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1277 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 202
AND cp.`id_cart` = 0 AND cp.`id_product` = 1204 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 202
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1204 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1255
AND pac.`id_product_attribute` = 321
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1225) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1198 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1198 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1175
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 364
AND cp.`id_cart` = 0 AND cp.`id_product` = 1274 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 364
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1274 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1225 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1225 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1252) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1195) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1195 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1195 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1210 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1210 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1210
AND pac.`id_product_attribute` = 216
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1271
ORDER BY `position`

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1283
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1280
AND pac.`id_product_attribute` = 378
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1286
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1228) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 371
AND cp.`id_cart` = 0 AND cp.`id_product` = 1277 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 371
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1277 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1292
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1207
AND pac.`id_product_attribute` = 209
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1298
AND pac.`id_product_attribute` = 420
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 209
AND cp.`id_cart` = 0 AND cp.`id_product` = 1207 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 209
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1207 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1213 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1213 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1289
AND pac.`id_product_attribute` = 399
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1177
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1228 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1228 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1175
AND pac.`id_product_attribute` = 133
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1234
AND pac.`id_product_attribute` = 272
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 8099
AND pac.`id_product_attribute` = 3655
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1180
ORDER BY `position`

SELECT SQL_NO_CACHE v.*, vl.*, IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `tp_feature_value` v LEFT JOIN `tp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `tp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 13 ORDER BY vl.`value` ASC

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 174
AND cp.`id_cart` = 0 AND cp.`id_product` = 1192 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 174
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1192 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1240) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1292 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1292 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1243 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1243 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 153
AND cp.`id_cart` = 0 AND cp.`id_product` = 1183 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 153
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1183 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 272) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1213
AND pac.`id_product_attribute` = 223
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1216 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1216 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1237
AND pac.`id_product_attribute` = 279
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1219) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 342) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1252
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_category` a
LEFT JOIN `tp_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 105) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1213) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM tp_shop_group gs
LEFT JOIN tp_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN tp_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1258
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1201) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 279
AND cp.`id_cart` = 0 AND cp.`id_product` = 1237 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 279
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1237 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 427
AND cp.`id_cart` = 0 AND cp.`id_product` = 1301 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 427
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1301 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1280) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1177) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1207) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1252
AND pac.`id_product_attribute` = 314
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1258) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1295
AND pac.`id_product_attribute` = 413
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1347) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1192 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1192 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1204) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 314
AND cp.`id_cart` = 0 AND cp.`id_product` = 1252 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 314
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1252 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1292
AND pac.`id_product_attribute` = 406
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1183
ORDER BY `position`

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `tp_module` m
LEFT JOIN `tp_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1177 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1177 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1183 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1183 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3649
AND cp.`id_cart` = 0 AND cp.`id_product` = 8092 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3649
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8092 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1246 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1246 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1240 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1240 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1231
AND pac.`id_product_attribute` = 265
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 3655
AND cp.`id_cart` = 0 AND cp.`id_product` = 8099 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3655
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8099 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1298) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1301) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1228
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1183
AND pac.`id_product_attribute` = 153
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1277) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 8092
AND pac.`id_product_attribute` = 3649
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1258 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1258 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1268
AND tp_lappstar_products_cpc.id_product_attribute=350
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1207
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1180 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1180 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1277
AND tp_lappstar_products_cpc.id_product_attribute=371
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1289 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1289 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1283 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1283 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1186
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 385
AND cp.`id_cart` = 0 AND cp.`id_product` = 1283 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 385
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1283 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1261) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 133
AND cp.`id_cart` = 0 AND cp.`id_product` = 1175 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 133
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1175 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1186) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1201
AND pac.`id_product_attribute` = 195
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc.cpc_type as cpc_type,
tp_lappstar_products_cpc_prix_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_prix_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_prix_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1252
AND tp_lappstar_products_cpc.id_product_attribute=314
AND tp_lappstar_products_cpc_prix_details.tarif=1
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_prix_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 251
AND cp.`id_cart` = 0 AND cp.`id_product` = 1225 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 251
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1225 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1225
AND pac.`id_product_attribute` = 251
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1264) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1289
ORDER BY `position`

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1180
AND pac.`id_product_attribute` = 146
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 230
AND cp.`id_cart` = 0 AND cp.`id_product` = 1216 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 230
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1216 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1240
AND pac.`id_product_attribute` = 286
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 328
AND cp.`id_cart` = 0 AND cp.`id_product` = 1258 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 328
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1258 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1222
ORDER BY `position`

SELECT SQL_NO_CACHE tp_lappstar_products_cpc.id as id,
tp_lappstar_products_cpc_eg_details.value as value
FROM tp_lappstar_products_cpc
RIGHT JOIN tp_lappstar_products_cpc_eg_details
ON tp_lappstar_products_cpc.id=tp_lappstar_products_cpc_eg_details.id_cpc
WHERE tp_lappstar_products_cpc.id_product=1268
AND tp_lappstar_products_cpc.id_product_attribute=350
AND tp_lappstar_products_cpc_eg_details.tarif=6
AND tp_lappstar_products_cpc.deleted!=1
AND tp_lappstar_products_cpc_eg_details.deleted!=1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1210) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1261 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1261 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1264 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1264 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8092 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8092 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 244
AND cp.`id_cart` = 0 AND cp.`id_product` = 1222 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 244
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1222 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1198
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 357
AND cp.`id_cart` = 0 AND cp.`id_product` = 1271 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 357
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1271 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1237 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1237 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8099) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1177
AND pac.`id_product_attribute` = 139
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1271 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1271 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 335
AND cp.`id_cart` = 0 AND cp.`id_product` = 1261 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 335
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1261 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 293
AND cp.`id_cart` = 0 AND cp.`id_product` = 1243 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 293
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1243 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1249) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 237
AND cp.`id_cart` = 0 AND cp.`id_product` = 1219 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 237
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1219 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 342
AND cp.`id_cart` = 0 AND cp.`id_product` = 1264 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 342
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1264 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1264
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1231) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 406
AND cp.`id_cart` = 0 AND cp.`id_product` = 1292 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 406
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1292 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1222 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1222 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1286) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1192
AND pac.`id_product_attribute` = 174
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1228
AND pac.`id_product_attribute` = 258
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 286
AND cp.`id_cart` = 0 AND cp.`id_product` = 1240 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 286
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1240 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1301
AND pac.`id_product_attribute` = 427
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1204
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 139
AND cp.`id_cart` = 0 AND cp.`id_product` = 1177 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 139
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1177 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1180) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1198) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 8092
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 392
AND cp.`id_cart` = 0 AND cp.`id_product` = 1286 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 392
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1286 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 413
AND cp.`id_cart` = 0 AND cp.`id_product` = 1295 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 413
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1295 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1301 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1301 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1271) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1186 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1186 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1274) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1243
AND pac.`id_product_attribute` = 293
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1255) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1298
ORDER BY `position`

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1283) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1219 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1219 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1222) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1261
AND pac.`id_product_attribute` = 335
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `tp_image` i
INNER JOIN tp_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `tp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 1261
ORDER BY `position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1231 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1231 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `tp_module` m
LEFT JOIN `tp_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 146
AND cp.`id_cart` = 0 AND cp.`id_product` = 1180 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 146
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1180 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 258
AND cp.`id_cart` = 0 AND cp.`id_product` = 1228 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 258
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1228 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 300
AND cp.`id_cart` = 0 AND cp.`id_product` = 1246 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 300
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1246 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1295 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1295 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1347 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1347 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1286
AND pac.`id_product_attribute` = 392
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 160
AND cp.`id_cart` = 0 AND cp.`id_product` = 1186 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 160
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1186 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `tp_tax_rule` tr
JOIN `tp_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `tp_product_attribute_image` pai
LEFT JOIN `tp_image_lang` il ON (il.`id_image` = pai.`id_image`)
INNER JOIN `tp_image` i ON (i.`id_image` = pai.`id_image`)
WHERE i.`id_product` = 1258 AND il.`id_lang` = 1 ORDER by i.`position`

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 181
AND cp.`id_cart` = 0 AND cp.`id_product` = 1195 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 181
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1195 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1286 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1286 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `tp_cart_product` cp
WHERE cp.`id_product_attribute` = 321
AND cp.`id_cart` = 0 AND cp.`id_product` = 1255 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `tp_cart_product` cp JOIN `tp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `tp_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 321
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1255 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1243) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `tp_attribute` a
LEFT JOIN `tp_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `tp_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `tp_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN tp_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `tp_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `tp_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 1271
AND pac.`id_product_attribute` = 357
AND agl.`id_lang` = 1

SELECT SQL_NO_CACHE *
FROM `tp_product_attribute` a
LEFT JOIN `tp_product_attribute_lang` `b` ON a.`id_product_attribute` = b.`id_product_attribute` AND b.`id_lang` = 1
LEFT JOIN `tp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 230) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `tp_product` a
LEFT JOIN `tp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8092) AND (b.`id_shop` = 1) LIMIT 1