"SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.date_upd FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (37721, 37800, 30242, 30183, 37620))) AND cp.id_category='1584' AND p.visibility IN ('both', 'catalog') AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_upd DESC, p.id_product DESC LIMIT 0, 12 ◀"
0 of 0array:12 [▼ 0 => array:1 [▶ "id_product" => "347516" ] 1 => array:1 [▶ "id_product" => "347357" ] 2 => array:1 [▶ "id_product" => "347289" ] 3 => array:1 [▶ "id_product" => "347198" ] 4 => array:1 [▶ "id_product" => "347197" ] 5 => array:1 [▶ "id_product" => "347196" ] 6 => array:1 [▶ "id_product" => "347195" ] 7 => array:1 [▶ "id_product" => "347194" ] 8 => array:1 [▶ "id_product" => "347193" ] 9 => array:1 [▶ "id_product" => "347190" ] 10 => array:1 [▶ "id_product" => "347188" ] 11 => array:1 [▶ "id_product" => "346822" ] ]
"return"
Filtros activos
Fundas Smartphones
Fundas Smartphones
Fundas Smartphones
Fundas Smartphones
Fundas Smartphones
Fundas Smartphones