SELECT tsk.*
            FROM ps_tecdoc_stock tsk
            INNER JOIN ps_tecdoc_supplier tsp ON tsk.id_tecdoc_supplier = tsp.id_tecdoc_supplier
            WHERE tsk.stock > 0
            AND tsk.stock >= tsk.minimum_order_quantity
            AND tsk.price > 0
            AND tsk.active = 1
            AND tsp.active = 1
            AND (tsk.brand, tsk.reference) IN (('era','669052'), ('fast','ft83017'), ('mahle','ave 18 000p'), ('mahle','ave 70 000p'), ('meat & doria','k42168'), ('nrf','38533'), ('thermotec','ktt140073')) GROUP BY tsk.id_tecdoc_supplier, tsk.brand, tsk.reference ORDER BY tsk.price;