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