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 OC259','A5 80960','A3 MNN W68','C9 ADN12111','A8 349 511','A5 288090','C9 W610/6','D1 BP ADN12111','C4 OC 986','A5 24791','B1 BOS0986452036','A2 W610/7','A1 WOF191','A1 W610/2','A2 W814/80','A8 349 237','B1 MANW67','A2 H97W05','A3 MNN W67','A5 496739','C9 ADL142102','C4 O0539DREIS','B1 MANW610/7','A9 W814/80','A8 302 039','C9 0451103111','B1 MANW610/6','A1 J1311019HB','B1 KNEOC196','A5 200758','C9 LS287','A1 OC195','C4 0986452036','A5 44074','C9 DO912','A3 MHL OC195','A5 372329','B7 SM104','A2 J1313016','C9 0986452036','C4 J1315024','C9 LS225','A2 UFI 23.265.00','A8 914 400','A9 UFI 23.265.00','B1 BLPADC42116','A9 0986452041','B1 FTROP545/2','E6 FL1211','C9 W814/80','A5 75071','A1 10-04-410ASK','A2 J1315024','A1 10-01-198ASK','A5 40935','C9 FO-410S','B1 MANW610/9','A1 W610/3','C4 W 610/81','A1 0986452041','A2 OC196','C4 O0537DREIS','A3 MHL OC196','A1 W610/7','A5 23607','B7 OP 575/IP','A1 OC196','A3 BOS F026407025','B1 PURLS301','C4 W 610/2','A2 0451103111','A8 368 390','A1 J1313016HB','A2 W610/2','A8 312 866','C4 LS225PU','C4 LS287PU','B1 FTROP575','C9 H97W05','C4 W 610/7','A2 FI OP575','A1 0451103111','A1 W610/6','A1 OC521','C4 J1313016','A5 284765','A2 W67','C9 W610/3','C4 J1310303','A3 MNN W610/2','A9 0986452036','A2 J1310303','C4 J1311019','A8 318 761','C9 ADM52107','A5 174791','C9 FO-198S','B1 BLPADM52107','A9 FI OP575','A8 374 429','A8 349 831','A3 BOS 0451103111','A3 FLT OP545/2','C9 W610/7','B1 BLPADN12111','A8 318 339','C4 F026407025','C9 SP-1094','C9 W68','A3 MHL OC521','A9 0451103111','A3 JAP FO-K02S','A3 JAP FO-198S','A3 MNN W610/3','A9 W67','A1 WOF380','A1 WOF258','A8 920 549','A5 202446','A1 F026407025','A9 J1311019','A8 365 906','A9 UFI 23.438.00','C9 F026407025','A1 J1313002HB','A2 W68','A3 MNN W610/6','A5 40950','A3 MNN W610/7','A1 LS301PU','C9 H13W03','A5 82995','A3 BOS 0986452041','A3 BOS 0986452036','D1 BP ADL142102','A2 W610/3','A5 38819','B1 HENH97W05','C4 J1313002','C4 986452041','A8 313 523','A1 H97W05','A9 F026407025','C9 SP-989','A2 0986452041','A5 267387','C4 W 814/80','A9 W610/3','A9 OC196','C9 W610/9','C4 S 3265 R','B1 BOS0451103111','A1 0451103364','C4 0451103111','A2 W610/6','A1 W68','A3 BOS 0451103364','A1 0986AF1038','A1 W610/9','B7 OP 545/2/IP','A1 LS225PU','A2 OC986','C4 451103111','C4 W 610/3','A8 313 487','B1 MANW610/3','C4 O0543DREIS','A9 OC986','A2 F026407025','A3 MNN W610/9','C9 W610/2','A9 FI OP545/2','C9 DO925/A','C4 W 610/9','A1 0986AF1034','E6 FL1045','B1 KNEOC115','A1 LS287PU','A8 360 406','A9 W610/9','A2 UFI 23.438.00','C9 FO-K02S','A8 327 960','A5 208501','B1 MANW68','C9 0986452041','A8 370 624','A3 MNN W814/80','A1 0986452036','A2 J1311019','A9 OC195','C9 DO853/A','C9 H97W02','C9 H97W08','A1 LS910PU','D1 BP ADC42116','A2 W610/9','A3 MHL OC986','C4 H97W05','E6 FL1222','C4 OC 195','A3 JAP FO-002S','A8 326 553','A9 J1313016','C4 0986452041','A9 W610/7','A2 J1313002','C4 S 4030 R','B1 BLPADL142102','B1 MANW610/2','C9 ADC42116','C9 DO895','C4 OC 196','A1 10-03-316ASK','C9 W67','A8 302 460','A1 OC986','B1 BOSF026407025','A8 300 081','C4 LS910PU','A9 J1313002','C4 W 67','C9 LS910','B1 PURLS910','A9 J1310303','C4 S 6900 R','C9 DO925','B1 MANW814/80','B1 BOS0986452041','B1 KNEOC521','A9 H97W05','C4 W 68','A2 OC195','A2 0986452036','C4 986452036','A2 FI OP545/2','A3 JAP FO-410S','A9 W610/6','A1 0986AF1039','B7 OP575/AG','C9 LS301','B1 HENH97W08','B1 PURLS287','A3 FLT OP575','A1 W814/80','B7 OP545/2/AG','A9 W610/2','C4 W 610/6','B7 H13W03','A9 W68','B1 KNEOC986','B1 PURLS225','C4 O0546DREIS','B7 H97W08','A1 WOF197','A1 WOF131','B7 H97W05','B7 W610/3/AG','A1 W67','D1 BP ADM52107','A2 OC521','A1 32100 FE','A1 J1311018HB','A2 SF OF0054','A8 360 056','A8 919 224','A9 SF OF0054','B1 BLPADM52101','B1 CHACOF100128S','B1 CHACOF100208S','C9 2143220008','C9 ADM52101','C9 FE32100','C9 OF-0410','C9 OF-1094','D1 BP ADM52101','E6 FL1052')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #