Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('A1 P06040','B7 24096.200.1','C9 GDB1810','A3 TEX 2409681','A2 T 2379481','A1 P06036','C9 PA-0048AF','A5 73076','A9 0986494117','A1 GDB1559','A5 139951','B1 BREP06040X','A5 73229','C4 0986494118','B1 BOS0986494958','B1 ZIM23794.200.9','A9 13.04707216.2','A9 13.04607176.2','A9 23794.200.9','A8 228 951','C9 VAL301640','C9 QP1970C','C9 VAL598640','E1 20 91 6670','C4 24096.200.1','C9 13.0460-7216.2','B1 FEB16670','B1 KAMJQ1013546','A8 228 718','C9 23794 00 701 00','C9 23794-20,3','A9 GDB1559DTE','C4 FDB1773','A1 13.0460-7216.2','B1 VAI20-8126','C4 LP1960','B1 LUCGDB1559','C9 GDB1559DTE','B7 23794.200.2','B1 BLPADBP420025','A2 GDB1810','A2 0986494007','E1 20 91 6503','A1 0986494117','C9 0986494958','B7 1463601110/JP','C4 1170078','C4 23794.200.1','C9 QP1970','A5 57792','B1 ATE13.0470-7216','C4 05P1512','A2 FE FDB1773','B1 ATE13.0460-7216','C4 LD7216','C9 0986494118','C4 2379401TX','A2 13.04607176.2','A8 221 250','B1 BREP06036X','A3 BOS 0986494118','A3 FER FDB1773','A3 TRU 08.34.110','A9 13.04607216.2','C4 0986494117','A3 VAC V20-8155','C4 2409601TX','C9 13.0460-7176.2','B1 FEB16503','A1 13.0470-7216.2','B1 TOM1509','A8 230 221','C4 0986494007','A2 LP1956','A1 P06036X','A2 0986494117','A3 DLP LP1956','A9 BP06040','C9 QP0556C','A8 236 206','B7 B110982/DKM','A3 TEX 2379481','A3 TEX 2409601','C4 GDB1559','A3 VAC V20-8126','B1 ZIM23794.200.2','A3 BOS 0986494007','B1 CIF822-557-5','A1 0986494007','A2 13.04707216.2','C9 2409601','A5 185320','A1 13.0460-7176.2','C4 KRO1559','C4 23794.200.9','A1 LP1956','C4 16670F','C4 GDB1559DTE','B1 ZIM24096.200.1','B1 BOS0986494007','A1 16503 FE','C9 24096-20,3','A9 T 2379481','C4 GDB1810','A2 13.04607216.2','A8 224 631','B1 VAL301640','A1 LP1960','A1 598640','B1 LUCGDB1559DTE','A2 GDB1559DTE','A1 FDB1773','C9 19-0637','A9 0986494118','C9 24096 00 701 00','B1 BOS0986494118','C9 PF0156','B1 CIF822-557-3','C9 13.0470-7216.2','C9 19-2888','B7 23794.200.1','A9 GDB1810','C9 2409681','A2 BP06040','C9 24096-20,3 EPAD','A9 23794 203 05','A8 233 959','A1 P06040X','A8 221 249','C9 FDB1773','A9 BP06036','A8 234 087','C9 23794-20,3 EPAD','A3 DLP LP1960','A9 GDB1559','C9 0986494117','A5 165426','A2 23794 203 05','C4 16503F','B1 BOS0986494117','B1 ATE13.0460-7176','C4 607216','A1 GDB1559DTE','C4 607176','C9 2379401','A2 23794.200.9','B1 LUCGDB1810','C4 LP1956','B1 VAL302132','A2 LP1960','A1 GDB1810','C9 GDB1559','B1 ZIM23794.200.1','E7 AC0581512D','B1 BREP06036','C9 0986494007','A1 WBP943','A1 16670 FE','A2 T 2409601','C9 PF0507','B1 TRU08.34.110','A3 TEX 2379401','A2 05P1511','A5 348443','A2 0986494118','A2 05P1512','A1 573151JC JRD','A2 GDB1559','B1 BREP06040','A3 BOS 0986494117','A9 T 2409601','A2 BP06036','C4 08.34.110','A1 0986494118','B7 23794.200.9','A1 2379401 TEX','A2 ADB114205','B1 ABS37409','B1 BLPADB114205')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #