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 ('A2 UFI 23.159.00','A3 VAC V30-1338','A2 UFI 23.243.00','A2 0986452041','A3 JAP FO-406S','A5 44074','B1 BLPADM52107','B7 SM103T','C9 ADC42116','A2 W610/6','A2 OC196','C4 LS287PU','C9 SP-919','B1 MANW610/7','C9 DO912','C4 W 610/6','A9 OC495','A9 UFI 23.438.00','A1 J1311019HB','A2 UFI 23.265.00','A1 OC617','B1 MANW67','B7 SM103','C9 H90W25','A9 J1313015','B1 CHACOF100122S','A1 LS490APU','C4 OC 196','C9 31-143220006','A1 F208','C9 H97W11','A3 MHL OC521','E6 FL1151','A2 F026407025','C9 ADH22114','A2 0986452036','C4 LS910PU','A3 VAC V26-0012','C4 H90W25','A2 OC986','A1 0986452041','C4 H97W05','B1 MANW610/6','A8 312 866','C9 ADM52107','A8 365 979','A1 10-04-410ASK','C4 S 4030 R','C9 H97W08','A3 JAP FO-H05S','C4 OC 617','A9 OC986','C4 J1315026','E6 FL1222','C4 H313W','A8 318 852','C9 FO-498S','A3 BOS F026407025','C9 SP-934','C4 32100F','A5 288090','A8 361 750','C9 DO289','A2 UFI 23.260.00','A5 40935','A9 UFI 23.103.00','A1 0986452555','A2 UFI 23.479.00','A3 BOS 0986452554','A9 J1314010','B1 CHACOF102126S','A2 J1315026','B1 HENH97W05','A3 MNN W610/7','A9 F026407025','C4 0986452041','A2 UFI 23.103.00','A1 J1315026HB','B1 BOSF026407025','A2 J1313002','C9 SP-989','B1 PURLS287','B1 BOS0986452041','A9 W67','A8 914 400','A5 23607','A2 OC521','C9 DO324','C9 FO-307S','E6 FL1045','A8 326 553','A5 200758','A2 UFI 23.151.00','A1 F122','A9 OC617','C4 OC 495','A2 J1313015','A9 W610/6','A3 JAP FO-K02S','A1 0451103372','A8 302 460','A3 JAP FO-307S','C9 FO-410S','A3 MNN W610/6','B1 PURLS225','A9 J1314013','C4 J1313016','C9 DO895','A1 F126','D1 BP ADM52107','A2 W610/3','D1 BP ADC42126','A8 349 831','C4 J1314010','A1 0986AF1061','A1 J1313015HB','A1 OC259','C4 COF100208S','C4 W 67','C9 W610/7','C9 50013146','B1 MISZ438','A1 WOF258','A1 10-04-498ASK','A3 MHL OC196','B1 BOS0451103372','A3 MNN W610/3','C4 J1311019','C4 0986452036','A5 82995','A5 174791','A5 38819','A9 UFI 23.243.00','C4 LS489APU','A2 UFI 23.133.00','C9 F026407025','A8 920 430','A8 920 015','A5 202446','C9 FO-H05S','A8 370 624','C9 ADL142102','C9 H97W05','A1 LS489APU','A8 907 970','A5 30117','E6 FL1211','A5 267387','A3 BOS 0986452041','B1 CHACOF100208S','B1 BLPADG02165','A1 J1310507HB','A8 360 406','A8 350 614','B1 BOS0986452036','B1 HENH97W11','A3 JAP FO-022S','C4 W 610/7','C9 31-143220008','A9 UFI 23.479.00','A9 W610/3','E6 FL1037','A2 J1311019','A3 JAP FO-498S','A1 10-04-406ASK','B1 MANW610/3','A9 J1311019','B1 PURLS350','A1 OC495','C9 2143220008','A9 H97W05','A1 J1314010HB','D1 BP ADH22114','C4 O0537DREIS','C4 COF100128S','A1 J1314013HB','C9 32-143220004','A1 10-01-198ASK','C4 S 6901 R','C9 ADN12111','A3 BOS 0451103372','A3 JAP FO-002S','D1 BP ADN12111','B1 BOSF026407077','B1 FEB104333','A8 920 549','C9 LS910','A5 75071','C4 J1315024','B7 H97W05','A3 BOS 0986452036','A5 250139','A1 H97W05','C9 LS287','B7 H97W11','C9 0986452041','A5 30105','C4 J1314013','A2 J1314013','D1 BP ADS72101','C9 LS489A','C4 J1313015','A1 0986452906','A5 372329','C9 SP-1001','A9 UFI 23.260.00','B7 TO-149/KAVO','C4 F026407025','A2 J1315024','B7 W610/3/AG','A2 J1314010','C9 ADS72101','A2 J1314010F','A1 32100 FE','A1 F026407077','A1 WOF380','A3 BOS 0986AF1061','B1 BLPADN12111','A1 F026407025','C9 FE32100','A2 F026407077','A1 LS350PU','A3 MHL OC495','C9 LS225','C9 W67','A2 OC617','A3 MNN W67','C4 H97W11','C9 DO925','C4 0451103372','A2 OC495','C4 S 6900 R','A5 206439','A1 OC986','A5 162212','A9 F026407077','C4 O0543DREIS','A2 H90W25','A5 284765','A5 496739','A1 0451103364','A8 371 115','C9 LS490A','D1 BP ADC42116','B7 SM104','A3 MHL OC617','A8 370 630','A9 OC196','A1 COF102126S','A8 370 542','A3 MHL OC986','B1 PURLS489A','C9 FO-K02S','B1 VAL586013','A1 0986452059','A9 UFI 23.151.00','B1 VAI30-1338','A5 294014','D1 BP ADG02165','A3 BOS 0986452906','A3 BOS F026407077','B7 H90W25','A2 W610/7','A9 UFI 23.265.00','C9 DO853/A','C9 FO-M01S','B7 H313W','A2 UFI 23.438.00','A1 0986452554','C9 W610/3','C9 SP-873','B1 VAL586062','A1 OC196','A1 0986452036','A1 OC521','A5 174793','A9 0986452036','A8 365 888','B1 BLPADC42126','D1 BP ADL142102','B1 HENH97W08','A1 10-03-316ASK','C9 F026407077','A3 BOS 0986452555','A1 WOF131','A3 JAP FO-M01S','C9 H97W02','C4 F026407077','A9 J1313016','B1 FEB32100','A3 VAC V24-0018','C9 FO-198S','C4 S 3261 R','A1 LS287PU','C9 FO-406S','C4 W 610/3','A8 368 390','A3 JAP FO-410S','B1 HENH313W','A8 365 903','C9 37-143220005','A9 W610/7','A1 0986452907','A8 365 906','C9 0986452906','B7 H97W08','A1 50013146','B1 VAI24-0018','C9 W610/6','A1 H90W25','A9 J1313002','A1 WOF197','A8 313 523','A9 UFI 23.133.00','A2 586013','C9 50013109','B1 CHACOF100128S','A1 J1313002HB','B1 BLPADC42116','A1 J1313016HB','A2 H97W05','A8 365 829','C4 S 3479 R','B1 BLPADL142102','A1 W610/6','A1 W610/7','A1 W610/3','C9 0986452036','A2 0451103372','B1 PURLS910','B1 BLPADH22114','A1 WOF260','A9 0451103372','A2 J1313016','C9 0451103372','A1 W67','A8 374 429','A3 JAP FO-198S','C9 FO-022S','B1 HENH90W25','A9 UFI 23.159.00','A9 0986452041','A1 J1314018HB','A1 10-0H-005ASK','A8 327 960','C9 SP-1094','A8 349 237','A3 BOS 0451103364','C9 DO925/A','C4 OC 986','C4 LS350PU','C9 6143220000','C9 LS350','C9 SP-959','C4 J1313002','A1 LS910PU','C4 S 3265 R','C9 31-143220005','C4 LS225PU','C4 O0539DREIS','A2 W67','B1 BLPADS72101','A1 10-M0-001ASK','A1 LS225PU','A1 J1311018HB','A8 358 666','A8 360 056','A8 919 224','B1 BLPADG02109','B1 BLPADM52101','B1 BLPADM52106','C9 ADG02109','C9 ADM52101','C9 ADM52106','D1 BP ADG02109','D1 BP ADM52101','D1 BP ADM52106','E6 FL1015','E6 FL1052')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #