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 ('B1 CIF822-557-0','A2 05P1512','B1 CIF822-557-3','A5 73076','C4 16503F','C4 23794.200.9','A5 57792','C9 0986494118','A1 598640','C4 FDB1773','A1 0986494118','C4 LP1956','A3 TEX 2379401','C9 PA-0048AF','A2 23794 203 05','A3 TEX 2379481','C9 ADB114205','D1 BP ADB114205','A8 224 631','C9 GDB1559','A8 230 221','C9 23794-20,3','B1 FEB16503','A1 FDB1773','C9 FDB1773','A1 13.0460-7176.2','B1 ZIM23794.200.9','B7 1052.00/REM','C4 1170078','A9 T 2379481','C9 VAL598640','C9 13.0460-7216.2','A1 0986424822','B7 23794.200.9','A2 FE FDB1773','B7 23794.200.2','A9 23794 203 05','A2 RH 21052.00','A5 73229','C4 GDB1559','C4 2379401TX','A3 DLP LP1956','E1 20 91 6503','A9 23794.200.9','A3 FER FDB1773','A2 ADB114205','A3 BOS 0986494118','A9 ADB114205','C4 607176','C9 VAL301640','B7 23794.200.1','A2 23794.200.9','B1 ZIM23794.200.2','A2 T 2379481','A5 165426','B1 LUCGDB1559','A2 GDB1559','A9 0986494118','A1 13.0460-7216.2','B1 ZIM23794.200.1','C4 607216','A1 573151JC JRD','A2 13.04607176.2','B1 VAL301640','C4 05P1512','C9 0252409620','A2 LP1956','A1 WBP558','A1 573187JC JRD','A9 13.04607216.2','B1 BOS0986494958','A5 348443','A1 LP1956','C9 13.0460-7176.2','C4 0986494118','A1 16503 FE','A1 2379401 TEX','B1 BOS0986494118','A3 CIF 822-557-0','A1 GDB1559','A9 13.04607176.2','A8 221 250','C9 2379401','B1 BLPADB114205','C4 KRO1559','A2 0986494118','C9 0986424822','B1 ATE13.0460-7176','C4 23794.200.1','A3 ROA 2105200','B1 ATE13.0460-7216','A9 GDB1559','C9 23794-20,3 EPAD','C9 0986494958','B1 ABS37409','A9 RH 21052.00','C9 23794 00 701 00','A2 13.04607216.2','A1 13.0470-7216.2','A1 GDB1559DTE','A1 GDB1662','A1 LP1794','A1 WBP440','A2 13.04707216.2','A2 GDB1559DTE','A2 LP1794','A2 Q109-1644','A2 QWS0218A','A2 QWS0224A','A2 QWS0250A','A2 QWS0259A','A2 QWS0270A','A2 QWS0289A','A2 QWS0317A','A2 QWS0324A','A2 RH 21052.10','A3 QUI WS0218A','A3 QUI WS0224A','A3 QUI WS0250A','A3 QUI WS0259A','A3 QUI WS0289A','A3 QUI WS0294A','A3 QUI WS0317A','A3 ROA 2105210','A5 139951','A8 234 087','A8 524 100','A8 524 102','A8 524 105','A8 524 150','A8 524 166','A8 562 880','A9 13.04707216.2','A9 GDB1559DTE','A9 GDB1662','A9 Q109-1644','A9 QWS0218A','A9 QWS0224A','A9 QWS0250A','A9 QWS0259A','A9 QWS0270A','A9 QWS0289A','A9 QWS0292A','A9 QWS0317A','A9 QWS0324A','A9 RH 21052.10','B1 ATE13.0470-7216','B1 KAMJQ1013546','B1 LUCGDB1559DTE','B1 LUCGDB1662','B1 QB109-1644','B1 QBWS0218A','B1 QBWS0224A','B1 QBWS0250A','B1 QBWS0259A','B1 QBWS0270A','B1 QBWS0289A','B1 QBWS0317A','B1 QBWS0324A','B7 1052.10/REM','B7 B110982/DKM','C4 GDB1559DTE','C4 GDB1662','C4 LD7216','C4 LP1794','C4 LP3630','C9 13.0470-7216.2','C9 GDB1559DTE','C9 GDB1662','C9 QB109-1644','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)) #