Prevenir client rupture de stock fini

$query='SELECT a.*, b.* FROM '.hikashop_table('waitlist').' a INNER JOIN '.hikashop_table('product').' b ON a.product_id = b.product_id '.'WHERE product_quantity > 0 OR product_quantity = -1 ORDER BY a.product_id ASC, a.date ASC;';

$query='SELECT a.*, b.* FROM '.hikashop_table('waitlist').' AS a '. ' INNER JOIN '.hikashop_table('product').' AS b ON (a.product_id = b.product_id)'. ' LEFT JOIN '.hikashop_table('product').' AS c ON (c.product_id = b.product_parent_id)'. ' WHERE (b.product_quantity > 0) OR (b.product_quantity = -1 AND b.product_type = '.$db->Quote('main').') '. ' OR (b.product_type = '.$db->Quote('variant').' AND b.product_quantity = -1 AND (c.product_quantity > 0 OR c.product_quantity = -1))'. ' ORDER BY a.product_id ASC, a.date ASC;';