provider: PrestaShop\Module\FacetedSearch\Product\SearchProvider
query: PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery
products: PrestaShop\Module\FacetedSearch\Filters\Products
adapter: PrestaShop\Module\FacetedSearch\Adapter\MySQL
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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (978, 975, 970, 965))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (21, 22, 18, 19, 11) GROUP BY p.id_productSELECT p.id_product, sa.out_of_stock 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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (978, 975, 970, 965))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (21, 22, 18, 19, 11) GROUP BY p.id_product) p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 ) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 0) ASC, p.position ASC, p.id_product DESCSELECT 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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (978, 975, 970, 965))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_productSELECT 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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (978, 975, 970, 965))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (978, 975, 970, 965))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>3 AND c.nright<150 GROUP BY cp.id_categorySELECT 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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (21, 22, 18, 19, 11) GROUP BY p.id_productSELECT 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, cp.position FROM gf_product p LEFT JOIN gf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN gf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN gf_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 gf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN gf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN gf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN gf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN gf_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category IN (21, 22, 18, 19, 11) GROUP BY p.id_product) p INNER JOIN gf_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=7)) GROUP BY fp.id_feature_value Catalogo prodotti
Mostra più prodotti

Scopri la nostra vasta selezione di libri tecnici progettati specificamente per professionisti. Che tu sia un ingegnere, un architetto, un programmatore o un designer, la nostra categoria di libri offre risorse fondamentali per approfondire le tue competenze e rimanere aggiornato sulle ultime tendenze del settore. Ogni volume è curato nei dettagli, garantendo contenuti di alta qualità e pratiche applicazioni. Esplora le nostre più recenti pubblicazioni e trova gli strumenti perfetti per accrescere la tua carriera e i tuoi progetti. Approfitta delle nostre offerte speciali e acquista oggi stesso i tuoi libri tecnici!

Prodotto aggiunto ai preferiti