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 (('bosch','1 987 946 814'), ('bosch','1 987 949 684'), ('continental ctam','ct1167'), ('continental ctam','ct1185'), ('dayco','941060'), ('dayco','941160'), ('fai autoparts','20163'), ('febi bilstein','47885'), ('gates','5680xs'), ('gates','5682xs'), ('hutchinson','163 htdp 20'), ('kamoka','7000071'), ('kamoka','7000077'), ('sasic','1766069'), ('schaeffler ina','536 0388 10'), ('swag','30 94 7885'), ('topran','115 443'), ('topran','117 022'), ('trucktec automotive','07.12.149')) GROUP BY tsk.id_tecdoc_supplier, tsk.brand, tsk.reference ORDER BY tsk.price;