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 (('delphi','ft4114-12b1'), ('era','775746a'), ('esen skv','02skv816'), ('srline','e01-1095')) GROUP BY tsk.id_tecdoc_supplier, tsk.brand, tsk.reference ORDER BY tsk.price;