array(1) {
  [0]=>
  array(54) {
    ["id_product"]=>
    string(1) "1"
    ["id_supplier"]=>
    string(1) "0"
    ["id_manufacturer"]=>
    string(3) "301"
    ["id_category_default"]=>
    string(1) "1"
    ["id_shop_default"]=>
    string(1) "1"
    ["id_tax_rules_group"]=>
    string(1) "1"
    ["on_sale"]=>
    string(1) "0"
    ["online_only"]=>
    string(1) "0"
    ["ean13"]=>
    string(0) ""
    ["isbn"]=>
    string(0) ""
    ["upc"]=>
    string(0) ""
    ["mpn"]=>
    string(0) ""
    ["ecotax"]=>
    string(8) "0.000000"
    ["quantity"]=>
    string(1) "0"
    ["minimal_quantity"]=>
    string(1) "0"
    ["low_stock_threshold"]=>
    NULL
    ["low_stock_alert"]=>
    string(1) "0"
    ["price"]=>
    string(8) "0.000000"
    ["wholesale_price"]=>
    string(8) "0.000000"
    ["unity"]=>
    string(0) ""
    ["unit_price_ratio"]=>
    string(8) "0.000000"
    ["additional_shipping_cost"]=>
    string(8) "0.000000"
    ["reference"]=>
    string(10) "ROAP000338"
    ["supplier_reference"]=>
    string(0) ""
    ["location"]=>
    string(0) ""
    ["width"]=>
    string(8) "0.000000"
    ["height"]=>
    string(8) "0.000000"
    ["depth"]=>
    string(8) "0.000000"
    ["weight"]=>
    string(8) "0.000000"
    ["out_of_stock"]=>
    string(1) "2"
    ["additional_delivery_times"]=>
    string(1) "1"
    ["quantity_discount"]=>
    string(1) "0"
    ["customizable"]=>
    string(1) "0"
    ["uploadable_files"]=>
    string(1) "0"
    ["text_fields"]=>
    string(1) "0"
    ["active"]=>
    string(1) "1"
    ["redirect_type"]=>
    string(0) ""
    ["id_type_redirected"]=>
    string(1) "0"
    ["available_for_order"]=>
    string(1) "1"
    ["available_date"]=>
    string(10) "0000-00-00"
    ["show_condition"]=>
    string(1) "0"
    ["condition"]=>
    string(3) "new"
    ["show_price"]=>
    string(1) "1"
    ["indexed"]=>
    string(1) "1"
    ["visibility"]=>
    string(4) "both"
    ["cache_is_pack"]=>
    string(1) "0"
    ["cache_has_attachments"]=>
    string(1) "0"
    ["is_virtual"]=>
    string(1) "0"
    ["cache_default_attribute"]=>
    string(1) "0"
    ["date_add"]=>
    string(19) "2021-11-08 09:37:05"
    ["date_upd"]=>
    string(19) "2024-04-06 01:57:18"
    ["advanced_stock_management"]=>
    string(1) "0"
    ["pack_stock_type"]=>
    string(1) "0"
    ["state"]=>
    string(1) "1"
  }
}
string(1628) "SELECT 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.date_add 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_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (77, 285) AND c.nleft>=939 AND c.nright<=940 GROUP BY p.id_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 ) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.date_add DESC, p.id_product DESC LIMIT 0, 30"