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 ('A5 40935','C9 31-143220006','D1 BP ADS72101','A2 586013','C9 0986452036','A1 H90W25','B1 VAL586013','C4 OC 617','A8 370 624','A5 30117','A1 OC194','A9 J1313015','C9 H97W02','C4 H97W05','A5 372329','A1 32100 FE','A1 0986452036','A8 318 757','A2 F026407077','A9 OC196','A9 J1313016','B7 OP 545/2/IP','A3 FLT OP545/2','C9 71760123','A1 J1313002HB','C9 LS489A','B1 BLPADM52107','B1 VAI24-0018','D1 BP ADC42126','B7 OP575/AG','A3 JAP FO-022S','B1 PURLS225','A3 BOS 0986452041','A1 0986AF1034','A2 0986452041','A8 361 750','A1 J1314010HB','A8 374 429','A5 44074','A1 OC 194','C9 31-143220008','A1 J1314013HB','A1 J1313015HB','B1 MANW610/2','A1 0986452041','C9 ADM52107','B7 OP545/2/AG','A2 J1313016','C9 SP-873','B7 OP 597/IP','A2 0986452036','A5 496739','C9 SP-1094','B7 TO-149/KAVO','B7 H97W05','C4 J1313016','B1 MISZ438','A3 FLT OP557','B7 SM103','A1 F026407077','A2 UFI 23.133.00','C9 ADC42116','A3 BOS 0986452906','A8 368 390','C9 W610/2','A8 318 761','C9 FO-406S','A1 LS910PU','B1 PURLS350','A1 10-01-198ASK','C9 SP-919','A3 JAP FO-410S','A2 UFI 23.159.00','C9 LS225','A8 318 852','C9 2143220008','B7 OP 575/IP','C4 J1313015','B1 BOSF026407077','B7 OP597/AG','C9 LS350','A9 J1311019','C9 FO-022S','A3 MHL OC617','A9 UFI 23.151.00','C9 ADN12111','A8 350 614','A2 J1314010','A9 FI OP557','A2 UFI 23.260.00','A8 318 370','B1 HENH97W08','A8 920 430','A5 174791','D1 BP ADL142102','A1 10-03-316ASK','A1 0986452555','A2 OC196','B7 H97W08','A5 38819','C4 J1313002','A3 JAP FO-307S','A2 FI OP545/2','A9 J1313002','B1 HENH97W05','A1 0986452906','A2 J1314013','C9 ADL142102','A3 JAP FO-498S','A2 OC521','E6 FL1037','C4 S 3261 R','A1 F208','C9 DO925','B1 VAL586062','A3 MHL OC194','A1 50013146','B1 BOS0986452036','A1 WOF258','A1 OC521','A8 365 903','D1 BP ADH22114','C4 OC 986','A5 206439','A8 313 523','C9 ADH22114','A2 FI OP597','C9 SP-989','D1 BP ADN12111','A1 0986452907','A1 OC196','C9 FO-K02S','A3 MNN W610/2','A5 174793','A5 288090','A1 F126','A1 J1314018HB','D1 BP ADC42116','C4 LS350PU','B1 FTROP558/1','B1 CHACOF100208S','A3 FLT OP575','C4 LS489APU','C4 OC 194','C9 6143220000','C4 0986452036','A1 0986AF1061','B1 CHACOF100128S','A5 200758','C4 J1311019','C9 LS490A','A1 10-04-406ASK','A1 WOF131','A3 VAC V24-0018','A8 360 406','A1 OC617','A5 82995','A1 COF102126S','A3 FLT OP597','A2 J1313002','A9 UFI 23.133.00','A3 FLT OP558/1','B1 BLPADC42116','A8 365 829','B7 H90W25','A3 JAP FO-198S','A5 23607','A2 UFI 23.103.00','B7 SM104','A9 W610/2','D1 BP ADM52107','C9 FO-498S','C9 50013146','C4 LS910PU','C4 32100F','A3 BOS 0986452555','A8 326 553','C9 FO-410S','B1 PURLS287','A9 UFI 23.103.00','A3 MHL OC521','B1 BLPADS72101','A8 371 115','B1 FTROP557','A1 0451103364','C9 H90W25','A9 UFI 23.438.00','A2 UFI 23.151.00','B1 FTROP545/2','C9 LS287','C9 H97W08','B1 FTROP597','A9 H97W05','A3 BOS 0986452036','C4 S 3265 R','C9 0986452041','A8 312 866','C9 31-143220005','A8 318 339','A2 H97W05','A2 J1314010F','A9 UFI 23.159.00','C4 J1315024','A2 UFI 23.243.00','A8 907 970','C4 J1314013','A1 W610/2','C4 S 6901 R','A3 MHL OC196','A2 OC617','A9 0986452036','A1 0986452554','A9 UFI 23.265.00','A8 365 888','C9 FO-198S','A9 OC617','A2 H90W25','A9 FI OP545/2','C4 COF100208S','C4 J1314010','A9 J1314013','A8 920 015','C9 FO-307S','A1 OC986','C9 DO912','A2 W610/2','B1 BLPADN12111','C4 H90W25','A1 LS489APU','B1 FTROP575','A1 10-04-498ASK','A8 920 549','A3 BOS F026407077','A2 J1311019','A9 0986452041','E6 FL1151','A3 BOS 0451103364','B1 CHACOF102126S','C9 DO895','A2 FI OP557','A1 LS287PU','A3 JAP FO-406S','C9 DO289','A1 LS490APU','C9 0986452906','A2 UFI 23.438.00','A1 0986452059','A3 JAP FO-002S','A1 OC259','C9 H97W05','D3 B13007UN','C4 F026407077','C9 SP-1001','A3 BOS 0986452554','A1 J1311019HB','A5 294014','A3 JAP FO-K02S','C9 DO324','A2 OC194','B1 BLPADC42126','A5 30105','B1 PURLS910','B1 FEB104333','C4 LS225PU','A9 UFI 23.243.00','C9 71758747','B1 BOS0986452041','E6 FL1045','A2 FI OP575','C9 DO925/A','A5 267387','C9 FE32100','E6 FL1211','A1 H97W05','C4 W 610/2','C9 SP-959','C9 LS910','A2 UFI 23.265.00','B1 FEB32100','A5 162212','A8 365 906','A1 J1313016HB','B1 VAL586021','A9 UFI 23.260.00','A3 VAC V26-0012','A9 J1314010','C9 DO853/A','B1 BLPADH22114','C9 F026407077','B1 HENH90W25','C4 0986452041','A9 OC194','C4 OC 196','C9 SP-934','A9 FI OP597','C4 S 6900 R','C4 COF100128S','A2 J1315024','C4 LS287PU','A2 J1313015','A9 FI OP575','B7 OP557/AG','B7 SM103T','B1 PURLS489A','B1 BLPADL142102','A8 318 330','A3 MHL OC986','C9 ADS72101','B7 OP 557/IP','A1 LS350PU','B7 OP 558/1/IP','E6 FL1222','C4 S 4030 R','C9 50013109','A9 OC986','A9 F026407077','A1 LS225PU','A1 10-04-410ASK','A2 OC986','A3 BOS 0986AF1061','A1 W610/6','C4 W 610/6','C9 W610/6','A2 SF OF0054','A9 SF OF0054','B1 KNEOC617','B1 VAL586017','B1 VAL586060','B7 HO-824/KAVO','C9 OF-0410','A2 W610/6')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #