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 ('C4 H97W05','B1 BLPADC42126','C9 SP-1094','C9 DO925/A','A9 FI OP545/2','A5 372329','A1 32100 FE','B7 H90W25','C4 OC 194','B1 HENH97W08','C9 LS225','A5 23607','E6 FL1151','A3 MHL OC521','C9 71760123','C9 2143220008','A8 368 390','A8 365 903','C9 FO-198S','B7 OP545/2/AG','B1 PURLS910','C9 FE32100','A3 MHL OC194','C4 OC 986','A3 MHL OC986','A9 H97W05','A5 267387','A1 10-01-198ASK','A3 JAP FO-198S','A2 H90W25','A1 F126','A3 FLT OP545/2','B1 VAI24-0018','C9 H97W05','A3 FLT OP597','A5 174791','A8 318 339','A5 38819','A3 FLT OP575','B1 BOS0986452041','A3 MNN W610/2','E6 FL1222','A2 OC986','A1 LS910PU','A8 365 906','A9 0986452041','A8 360 406','C4 W 610/2','A2 OC521','C9 DO853/A','B1 CHACOF100208S','D3 B13007UN','B1 HENH97W05','A1 J1313016HB','B7 SM103','A1 H90W25','B1 BLPADC42116','B1 BLPADN12111','A5 496739','A9 UFI 23.260.00','A3 VAC V24-0018','A1 WOF131','B1 BLPADL142102','C4 J1311019','A2 OC196','B1 FEB32100','A8 326 553','A1 OC259','A1 10-04-410ASK','C4 J1313002','B1 HENH90W25','C4 H90W25','A3 JAP FO-K02S','A9 OC194','C4 LS910PU','B7 OP 575/IP','B1 BOSF026407325','A1 OC 194','C9 F026407347','A1 OC521','A9 UFI 23.438.00','A3 JAP FO-410S','A2 586013','B1 CHACOF100128S','D1 BP ADC42126','B1 BLPADH22114','A5 82995','C9 ADH22114','C4 S 6900 R','D1 BP ADH22114','C9 FO-307S','E6 FL1045','B1 BLPADM52107','A9 UFI 23.265.00','A2 UFI 23.265.00','C4 OC 196','A2 FI OP575','A9 J1313002','A9 J1311019','A3 BOS 0451103364','C9 FO-410S','C9 DO912','B7 OP575/AG','B7 H97W08','A8 374 429','C4 J1313015','C9 FO-K02S','A8 318 370','A2 FI OP545/2','A3 JAP FO-002S','C9 DO895','D1 BP ADN12111','C4 COF100208S','A8 318 761','A2 J1315024','B7 SM103T','A2 W610/2','A3 BOS 0986452041','C9 LS287','A8 312 866','A1 0451103364','C9 SP-989','C9 0986452041','C9 DO925','A2 OC194','A2 H97W05','C9 ADL142102','A9 FI OP575','A1 0986452555','C4 J1313016','A1 0986AF1061','A1 J1311019HB','A1 10-03-316ASK','C9 H97W02','A9 J1313015','A2 UFI 23.260.00','A1 WOF258','C9 LS910','A1 W610/2','A1 F208','C9 ADN12111','C9 ADM52107','D1 BP ADC42116','B7 OP 597/IP','C4 LS287PU','B7 OP 545/2/IP','C9 H97W08','C9 6143220000','A8 920 430','A2 0986452041','A2 J1313015','A5 294014','B1 FTROP575','C9 F026407325','A1 LS287PU','A8 920 549','A3 BOS 0986AF1061','B1 BOSF026407347','C4 COF100128S','C9 ADC42116','A1 COF102126S','B1 MANW610/2','C9 W610/2','C9 50013109','C4 0986452041','A9 OC986','B1 PURLS287','B1 VAL586013','A2 J1313002','B7 SM104','A3 JAP FO-307S','B1 FEB104333','A1 OC986','D1 BP ADM52107','B1 CHACOF102126S','A5 44074','A2 J1313016','C4 S 4030 R','A1 H97W05','C9 SP-959','C4 S 3261 R','B1 PURLS225','C9 H90W25','A2 FI OP597','B7 OP597/AG','A1 0986452041','A1 OC196','A1 J1313015HB','C9 32-143220006','A9 FI OP597','E6 FL1211','A9 J1313016','C4 J1315024','A9 OC196','A5 200758','C9 FO-022S','B1 MISZ438','C4 LS225PU','B1 FTROP545/2','A1 OC194','A3 JAP FO-022S','A1 J1313002HB','C9 SP-1001','A3 MHL OC196','A2 UFI 23.438.00','A5 288090','C9 71758747','C4 S 3265 R','C4 32100F','B7 H97W05','A8 370 624','A2 J1311019','B1 FTROP597','A3 BOS 0986452555','A9 W610/2','D1 BP ADL142102','B1 VAL586021','A1 LS225PU','A2 O65/86.0','A1 W610/3','A3 JAP FO-315S','A3 MNN W610/3','C9 W610/3','A1 F026407025','A1 WOF380','A2 F026407025','A2 SF OF0054','A3 JAP FO-316S','A5 30172','A5 75071','A8 914 400','A9 F026407025','A9 SF OF0054','B1 BOSF026407025','B1 KAMF101401','B1 KNEOC196','B1 KNEOC986','B1 VAL586040','B7 MO-511/KAVO','C4 F026407025','C9 F026407025','C9 FO-316S','C9 OF-1094','C4 W 610/3')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #