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 ('A8 234 087','C9 GDB1810','A1 13.0470-7223.2','A1 0986494117','A2 T 2379381','A1 13.0460-7223.2','A3 TEX 2379481','A8 224 631','A9 ADB114205','A1 13.0460-7216.2','B7 23793.200.1','A9 23794.200.9','C9 23794-20,3 EPAD','A2 ADB114205','B1 ZIM23793.900.1','C9 0986494117','A5 72866','C9 2379301','C9 GDB1559DTE','C4 GDB1559DTE','A1 16503 FE','A1 GDB1559','A3 TEX 2409601','C4 607216','B1 FEB16503','A1 16670 FE','A5 165426','C9 23793-20,3','A9 0986494117','A3 TEX 2379301','B1 VAL301640','B1 BREP06057','C9 VAL598640','B1 ZIM23793.200.1','A2 GDB1810','A9 13.04607216.2','C9 ADB114205','C9 GDB1662','C4 23794.200.9','A9 T 2409601','A1 FDB1773','C9 PA-0048AF','B1 BOS0986494117','C4 23794.200.1','A2 FE FDB1773','C4 LP1956','A9 13.04607223.2','B1 ATE13.0470-7223','A1 WBP943','A8 236 206','C4 GDB1810','B1 ZIM23794.200.9','A9 BP06057','B1 LUCGDB1559','A3 DLP LP1960','A8 227 340','C4 607176','A1 GDB1662','B7 23793.200.9','C4 KRO1559','B7 1052.00/REM','B1 LUCGDB1810','B1 ATE13.0460-7176','A2 T 2379481','C4 16503F','A2 13.04607216.2','A2 T 2379301','C9 GDB1559','C4 GDB1662','A5 57792','C4 16670F','C4 2379401TX','A9 T 2379481','A9 RH 21052.00','A3 ROA 2105210','A1 598640','A8 221 250','A1 GDB1810','A2 BP06057','A5 73229','A9 RH 21052.10','C4 1170078','A1 LP1960','A2 LP1956','A2 23794 203 05','A2 23794.200.9','A9 23794 203 05','C4 LP1960','B7 23794.200.9','B1 ATE13.0460-7216','A1 P06036','B1 BOS0986494118','C9 13.0460-7223.2','A8 228 951','A3 DLP LP1956','C4 GDB1559','A5 185320','B1 ZIM23793.200.9','A5 130790','C9 13.0470-7223.2','C9 13.0460-7176.2','A9 0986494118','A2 RH 21052.10','A9 T 2379301','C4 2379301TX','A3 BOS 0986494117','A2 05P1271','B1 LUCGDB1559DTE','C9 0986494118','A2 13.04607176.2','C9 FDB1773','A1 LP1956','D1 BP ADB114205','B1 FEB16670','B1 LUCGDB1662','C9 23794-20,3','A1 GDB1559DTE','C4 2409601TX','C9 2379401','A9 GDB1559DTE','A3 TEX 2379401','A5 348443','B1 ATE13.0460-7223','C4 0986494118','A1 573151JC JRD','A8 228 208','A8 221 249','C9 23793-20,3 EPAD','A3 FER FDB1773','A1 13.0460-7176.2','A3 ROA 2105200','A2 13.04607223.2','A1 0986494118','A2 T 2409601','B1 BLPADB114205','C4 05P1271','A2 GDB1559','A3 TEX 2379381','C9 24096-20,3','C4 FDB1773','A5 73076','C4 23793.200.1','A2 GDB1662','A9 GDB1559','C4 0986494117','A2 BP06036','B1 BREP06036','A1 P06057','C9 2379381','C9 VAL301640','A9 BP06036','A9 GDB1662','C9 13.0460-7216.2','B1 ZIM23794.200.1','A2 GDB1559DTE','A8 230 221','A2 0986494117','A2 0986494118','A2 LP1960','B7 23793.200.2','A9 13.04607176.2','A2 RH 21052.00','A1 2379401 TEX','C9 2409601','A9 GDB1810','A3 BOS 0986494118','B7 23794.200.1','B1 ZIM23793.200.2','A1 13.0470-7216.2','A1 P06036X','A1 P06040','A1 P06040X','A1 P06057X','A1 P06060','A1 WBP1052','A2 13.04707216.2','A2 BP06040','A2 BP06060','A2 Q109-1751','A2 QWS0218A','A2 QWS0224A','A2 QWS0250A','A2 QWS0259A','A2 QWS0270A','A2 QWS0289A','A2 QWS0317A','A2 QWS0324A','A3 CIF 822-557-0','A3 QUI 109-1751','A3 QUI WS0218A','A3 QUI WS0224A','A3 QUI WS0250A','A3 QUI WS0259A','A3 QUI WS0289A','A3 QUI WS0294A','A3 QUI WS0317A','A5 139951','A8 251 886','A8 524 100','A8 524 102','A8 524 105','A8 524 150','A8 524 166','A8 562 880','A9 13.04707216.2','A9 BP06040','A9 BP06060','A9 Q109-1751','A9 QWS0218A','A9 QWS0224A','A9 QWS0250A','A9 QWS0259A','A9 QWS0270A','A9 QWS0289A','A9 QWS0292A','A9 QWS0317A','A9 QWS0324A','B1 ABS37551','B1 ATE13.0470-7216','B1 BLPADBP420025','B1 BOS0986494705','B1 BREP06036X','B1 BREP06040','B1 BREP06040X','B1 BREP06057X','B1 BREP06060','B1 CIF822-557-0','B1 FEB16825','B1 KAMJQ1013546','B1 QB109-1751','B1 QBWS0218A','B1 QBWS0224A','B1 QBWS0250A','B1 QBWS0259A','B1 QBWS0270A','B1 QBWS0289A','B1 QBWS0317A','B1 QBWS0324A','B1 VAL302132','B1 ZIM24096.200.1','B1 ZIM24697.190.1','B7 1052.10/REM','B7 24697.190.1','B7 B110982/DKM','C4 08.34.110','C4 0986494705','C4 16825F','C4 24096.200.1','C4 24697.190.1','C4 LD7216','C4 LP3534','C9 0252379420','C9 0252379420/PD','C9 0252409620','C9 0986494705','C9 13.0470-7216.2','C9 23794 00 701 00','C9 QB109-1751','C9 QBWS 0218 A','C9 QBWS 0250 A','C9 QBWS 0259 A','C9 QBWS 0289 A','C9 QBWS 0292 A','C9 QBWS 0294 A','C9 QBWS 0324 A','E7 AC0581512D')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #