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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT p.id_product, p.id_product_attribute 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417)))

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417)))

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((pac.id_attribute IN (32, 35))) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417)))

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417)))

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND p.date_add>'2025-01-18 00:00:00'

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 6) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-03-18 10:55:18' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-03-18 10:55:18' <= sp.to) ) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417)))

SELECT psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM c83cap_product p INNER JOIN c83cap_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND cg.id_group='1' AND c.level_depth<=5 AND c.nleft>131 AND c.nright<132 GROUP BY cp.id_category

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN c83cap_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((fp_2.id_feature_value IN (7387392, 7387417))) GROUP BY pac.id_attribute

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN c83cap_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY pac.id_attribute

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=39)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=40)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=65)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=43)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=42)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=41)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=94)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=95)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=97)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=98)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=96)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) GROUP BY p.id_manufacturer

SELECT MIN(p.weight) as min, MAX(p.weight) as max FROM c83cap_product p INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=56)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=57)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=59)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=60)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=58)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=51)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=52)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=61)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=55)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=63)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=73)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=69)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=54)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=74)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=64)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=68)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=50)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product

SELECT 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, pa.id_product_attribute, cp.position FROM c83cap_product p LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 c83cap_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN c83cap_category_product cp ON (p.id_product = cp.id_product) INNER JOIN c83cap_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN c83cap_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN c83cap_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN c83cap_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN c83cap_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (32, 35))) AND ((fp_2.id_feature_value IN (7387392, 7387417))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=131 AND c.nright<=132 GROUP BY p.id_product) p INNER JOIN c83cap_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN c83cap_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN c83cap_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN c83cap_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 ) LEFT JOIN c83cap_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN c83cap_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=67)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (32, 35))) AND ((fp_3.id_feature_value IN (7387392, 7387417))) GROUP BY fp.id_feature_value

Zapatos Deportivos Hombre Comprar | Bozoom
Zapatos Deportivos Hombre Comprar | Bozoom

Los zapatos deportivos de hombre son un complemento a tener en cuenta para apostar por la comodidad. Convertirlos en parte indispensable de tu imagen personal es tan fácil como se expone en los siguientes apartados.

Filtros activos

  • Disponibilidad: En stock
  • Talla: 41
  • Talla: 44
  • Caracteristica 5: MARRÓN
  • Caracteristica 5: VERDE
Volver arriba