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 (('a.b.s.','18194'), ('a.b.s.','18117'), ('abakus','231-03-011'), ('abakus','231-03-011-2'), ('abakus','231-03-012'), ('abakus','231-03-012-2'), ('abakus','231-03-135'), ('abakus','231-03-135-2'), ('abakus','231-03-238'), ('abakus','231-03-238-2'), ('abakus','231-04-003'), ('abakus','231-04-003-2'), ('abakus','231-04-011'), ('abakus','231-04-011-2'), ('abakus','231-04-148'), ('abakus','231-04-148-2'), ('abe','c3s012abe'), ('abe','c3w039abe'), ('abe','c3w048abe'), ('abe','c3w048abe-p'), ('abe','c3w061abe'), ('abe','c3w061abe-p'), ('abe','c4a022abe'), ('abe','c4a022abe-p'), ('abe','c4s000abe'), ('abe','c4s000abe-p'), ('abe','c4w012abe'), ('abe','c4w012abe-p'), ('aisin','x6f898s'), ('aisin','x6r901s'), ('aisin','x6r900s'), ('ate','24.0110-0277.1'), ('ate','24.0110-0356.1'), ('ate','24.0110-0420.1'), ('ate','24.0122-0219.1'), ('ate','24.0124-0258.1'), ('ate','24.0125-0145.1'), ('ate','24.0125-0158.1'), ('ate','24.0130-0225.1'), ('ate','24.0310-0277.1'), ('ate','24.0310-0356.1'), ('ate','24.0324-0258.1'), ('ate','24.0325-0145.1'), ('ate','24.0325-0158.1'), ('blue print','adv184326'), ('blue print','adv184372'), ('bosch','0 986 479 c20'), ('bosch','0 986 479 c47'), ('bosch','0 986 479 c90'), ('bosch','0 986 479 e00'), ('bosch','0 986 479 058'), ('bosch','0 986 479 099'), ('bosch','0 986 479 303'), ('bosch','0 986 479 677'), ('bosch','0 986 479 939'), ('brembo','09.c306.11'), ('brembo','09.c306.1s'), ('brembo','09.c306.1x'), ('brembo','09.9145.11'), ('brembo','09.9145.14'), ('brembo','09.9145.1s'), ('brembo','09.9145.1x'), ('brembo','09.9145.75'), ('brembo','09.9772.10'), ('brembo','09.9772.11'), ('brembo','09.9772.1s'), ('brembo','09.9772.1x'), ('brembo','09.9772.75'), ('brembo','08.9502.10'), ('brembo','08.9502.11'), ('brembo','08.9502.1s'), ('brembo','08.9502.1x'), ('brembo','08.9502.75'), ('brembo','08.b413.10'), ('brembo','08.b413.11'), ('brembo','08.b413.1s'), ('brembo','08.b413.1x'), ('brembo','08.b413.75'), ('champion','562614ch'), ('cifam','800-1243c'), ('cifam','800-1248c'), ('cifam','800-1767c'), ('cifam','800-1817c'), ('cifam','800-724c'), ('cifam','800-734c'), ('cifam','800-840c'), ('cifam','800-889c'), ('daco germany','600205'), ('daco germany','604204'), ('daco germany','604784'), ('daco germany','604788'), ('daco germany','604789'), ('daco germany','604789c'), ('delphi','bg3834'), ('delphi','bg3834c'), ('delphi','bg4324'), ('delphi','bg4324c'), ('delphi','bg5019c'), ('delphi','bg9109'), ('delphi','bg9109c'), ('fai autoparts','bd109'), ('fai autoparts','fpbd1129'), ('fai autoparts','fpbd6052s'), ('fast','ft11954'), ('fast','ft11955'), ('fast','ft31161'), ('febi bilstein','36128'), ('febi bilstein','39129'), ('ferodo','ddf1895'), ('ferodo','ddf1895c'), ('ferodo','ddf2000c'), ('fte','9071000'), ('fte','9071055'), ('fte','9072013'), ('fte','9072060'), ('fte','9072071'), ('fte','9072560'), ('fte','9081004'), ('fte','9081017'), ('fte','9081214'), ('fte','9082186'), ('fte','9082261'), ('fte','9082425'), ('fte','9082426'), ('fte','9082437'), ('fte','9082568'), ('fte','9082569'), ('fte','9082592'), ('hella','8dd 355 129-241'), ('hella','8dd 355 112-121'), ('hella','8dd 355 128-451'), ('hella pagid','8dd 355 129-241'), ('hella pagid','8dd 355 112-121'), ('hella pagid','8dd 355 128-451'), ('icer','78bd5615-2'), ('icer','78bd5616-2'), ('icer','78bd5618-2'), ('icer','78bd5640-2'), ('japanparts','di-0907c'), ('japanparts','di0907jm'), ('japanparts','dp-0901c'), ('japanparts','dp0901jm'), ('jpn','30h9025-jpn'), ('jpn','30h9081-jpn'), ('jpn','30h9132-jpn'), ('jpn','40h9011-jpn'), ('jpn','40h9015-jpn'), ('kamoka','103583'), ('lpr','a1003p'), ('lpr','a1003pr'), ('lpr','a1004v'), ('lpr','a1004vr'), ('lpr','a1038p'), ('lpr','a1038pr'), ('lpr','v2010v'), ('lpr','v2010vr'), ('magneti marelli','360406050502'), ('magneti marelli','360406050505'), ('magneti marelli','360406050602'), ('magneti marelli','360406050605'), ('magneti marelli','360406050702'), ('magneti marelli','360406107801'), ('magneti marelli','360406107802'), ('magneti marelli','361302040115'), ('magneti marelli','361302040126'), ('magneti marelli','361302040158'), ('magneti marelli','361302040367'), ('magneti marelli','361302040679'), ('magneti marelli','361302040693'), ('magneti marelli','361302040769'), ('meyle','115 521 1094'), ('meyle','115 523 0012/pd'), ('meyle','115 523 0026'), ('meyle','115 523 0026/pd'), ('meyle','183 521 0008/pd'), ('meyle','183 521 1094/pd'), ('mtr','12108505'), ('mtr','12108508'), ('mtr','12108523'), ('mtr','12135667'), ('nk','2047141'), ('nk','3147141'), ('nk','2047137'), ('nk','3147137'), ('profipower','3b1006'), ('profipower','3b1007'), ('profipower','3b1145'), ('profipower','3b2002'), ('profipower','3b2006'), ('sasic','6106021'), ('sasic','6106184'), ('sasic','6106180'), ('sasic','6106029'), ('skf','vkbd 80005 v2'), ('skf','vkbd 80006 v1'), ('skf','vkbd 80122 v1'), ('skf','vkbd 80292 v1'), ('skf','vkbd 90007 s2'), ('skf','vkbd 90041 s2'), ('srline','s71-0289'), ('srline','s71-1143'), ('srline','s71-1478'), ('swag','30 93 6128'), ('swag','30 93 9129'), ('textar','92229805'), ('textar','92140700'), ('textar','92140703'), ('tomex brakes','tx 74-18'), ('topran','110 073'), ('topran','110 075'), ('topran','110 418'), ('topran','114 027'), ('topran','114 839'), ('topran','116 796'), ('trucktec automotive','07.35.196'), ('trucktec automotive','07.35.258'), ('trucktec automotive','07.35.269'), ('trw','df4276'), ('trw','df4295'), ('trw','df4464s'), ('trw','df6133s'), ('trw','df6903s'), ('trw','df7911'), ('vaico','v10-40077'), ('vaico','v10-40089'), ('vaico','v10-80084'), ('valeo','197242'), ('valeo','197325'), ('valeo','197660'), ('valeo','197677'), ('valeo','672500'), ('valeo','672643'), ('valeo','672769'), ('valeo','672925'), ('valeo','186857'), ('valeo','197139'), ('valeo','197544'), ('valeo','672544'), ('valeo','672546'), ('valeo','672627'), ('valeo','672719'), ('vika','66150026001'), ('vika','66150291301'), ('vika','66150615501'), ('vika','66151595601'), ('vika','66151595801'), ('vika','66151717101'), ('vika','66151720801'), ('vika','66151728801'), ('vika','66151730601'), ('zimmermann','600.3221.20'), ('zimmermann','600.3221.52'), ('zimmermann','600.3221.53'), ('zimmermann','100.3300.20'), ('zimmermann','100.3300.52'), ('zimmermann','100.3300.53'), ('zimmermann','600.3243.20'), ('zimmermann','600.3243.52'), ('zimmermann','600.3243.54'), ('zimmermann','600.3243.55'), ('zimmermann','600.3262.70'), ('zimmermann','600.3241.20'), ('zimmermann','600.3241.52')) GROUP BY tsk.id_tecdoc_supplier, tsk.brand, tsk.reference ORDER BY tsk.price;