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 N1313033','B7 MO-542/KAVO','C4 N1313033','A9 N1313033','A2 33140FEBI','A3 MNN W920/7','A2 0986452001','A9 UFI 23.127.05','A9 FI OP533','A3 MNN W930/7','A1 WOF350','B1 HENH340W','A9 0986452003','C4 LS285PU','D9 16510-60B11 50db','A9 J1312001','A1 LS498CPU','C4 LS900PU','C9 71760788','B1 PURLS285','A8 361 320','B1 FTROP563','B7 OP 618/IP','C4 W 920','D9 16510-60B11 10db','A8 318 253','A2 FI OP675/1','A8 318 372','C9 LS582','A9 SF OF0183','B7 A210963/DKM','C9 FO-097S','A9 FI OP576','A9 0451104065','C4 H340W','C4 W 717/2','C9 LS188B','A2 FI OP563','A2 UFI 23.127.00','A3 FLT OP618','B7 OP 533/IP','B7 OP 562/IP','B7 OP576/AG','B7 OP 534/IP','D1 BP ADT32103','A9 W940/24','B1 MANW7035','C9 F026407256','A9 FI OP563','C4 W 940/18','A3 BOS 0451103062','A1 W818/84','A2 UFI 23.168.00','C9 OF-994','A3 TRU 04.18.006','B7 A210003/DKM','A5 374956','C9 LS900','C9 DO271','C4 LS908PU','C9 OF-0390','C9 SP-920','C9 DO262/B','A9 UFI 23.257.00','B1 HENH10W08','A9 OC23OF','A9 0451104014','C9 0451104065','C9 30-143220004','B1 MANW920/80','B7 A210292/DKM','B1 BOS0986452003','B1 BOS0451103029','A5 477541','B7 A210052/DKM','A9 F026407235','A5 206442','B7 10800/JAPKO','B1 HENH10W01','A2 F026408903','C9 LS947','A3 MNN W940/18','C9 H90W20','B7 1118504909/JP','B7 OP675/1/AG','B1 KNEOC23OF','B1 PURLS582','A8 368 402','A9 FI OP534','B1 BLPADB112118','C9 DO223','A9 0451103029','A9 0451103062','A9 H17W06','C9 ADT32103','C4 O0583DREIS','A9 UFI 23.127.02','C4 W 713/36','A1 OC615','C4 W 920/80','B7 ST784','A5 40939','B1 MANW940/24','C4 O0684DREIS','A8 360 027','B1 BOS0451103062','C4 S 1600 R','C9 ADM52120','A3 KAP TO-130','B1 BOS0451203178','A5 62149','A9 OC23','D9 16510-60B11','A1 LS908PU','C4 W 916/1','A9 UFI 23.253.00','B1 KNEOC235','A5 324900','B1 MANC18004','A2 J1312021','C9 30-143220003','B1 BLPADT32103','A8 365 896','A1 F026408903','C9 FO-279S','B7 H10W01','B7 H14W12','C4 0451104066','A3 MHL OC23OF','C4 J1312021','A9 H10W02','A2 OC23','B1 PURLS149','B7 W712/83/AG','A9 UFI 23.298.00','C9 F026407235','B1 VAL586164','C4 OC 501','A3 BOS 0986452001','A2 OC615','A3 HEN H10W01','C4 OC 23','A1 0451203178','A1 OC477','A3 JAP FO-097S','A9 FI OP618','B1 KAMF104801','B1 PURLS947','A2 W920/7','C9 0451104066','A2 H10WD01','B1 BOS0986452044','A3 BOS 0451203178','C9 LS285','A1 0451104014','C9 W712/83','C4 0986452001','A1 10-02-201ASK','C4 S 8540 R','C4 OC 615','B1 BOS0986452001','A2 0451104014','A1 OC23','C4 S 3257 R','A9 UFI 23.127.00','A1 H17W06','A2 W940/18','A2 UFI 23.131.00','C9 DO225/B','A8 304 648','A1 OC 18','A8 320 522','B1 HENH17W06','B7 SM143','A8 359 156','C9 0986452044','A9 W712/83','B1 KNEOC477','A5 372726','A3 MHL OC988','C9 FO-201S','A9 W712/21','D1 BP ADM52120','A1 WOF251','A8 318 251','A1 WOF373','C4 S 6100 R','A3 JAP FO-201S','A1 W920/80','A3 MNN W940/24','A3 BOS 0451104066','B7 OP 550/IP','C9 H10W08','C9 DO225','A2 0451104065','C9 50013820','A3 BOS 0451104065','C9 LS359','A3 MNN W920/80','B1 MANW940/18','C9 W712/21','B1 MANW930/7','A1 W712/21','B7 A210109/DKM','A1 OC23O.F.','A1 0986452002','A2 UFI 23.257.00','C9 W920/80','C4 S 3435 R','C9 LS498C','A1 WOF1868','A3 FLT OP550','A3 FLT OP675/1','C4 C 18 004','B1 MANW717/2','A2 UFI 23.253.00','B7 A210972/DKM','C4 LS149PU','B1 TRU04.18.006','A3 KAP TO-138','C9 W717/2','C9 H17W06','A1 WOF270','A1 COF100030S','B1 CHACOF100030S','A8 326 718','A3 BOS 0986452044','A9 OC501','A3 BOS 0451104014','C9 SP-838','C4 0986452003','C9 0986452003','B1 FTROP550','B1 PURLS188B','B7 SM130','A1 27147 FE','B7 OP563/AG','A8 360 057','C4 0451203178','A5 48012','B7 TO-130/KAVO','C4 W 940/24','A2 W712/83','C4 W 920/7','A5 219057','A2 W713/36','A1 33140 FE','A2 OC23OF','A9 W7035','B1 KNEOC23','A1 W940/24','C4 27147F','A9 0451104066','A1 10-02-204ASK','B1 VAI70-0016','B1 MANW920','A3 FLT OP563','A9 W920/7','A3 JAP FO-279S','C9 LS149','B1 PURLS498C','A2 0451104066','A2 UFI 23.127.05','A9 UFI 23.114.01','C9 SP-806','A5 33359','A1 OC 23 O.F.','B1 PURLS908','B1 VAL586084','A8 365 805','A8 370 395','A3 MNN W717/2','A1 WOF271','A1 C18004','C9 W940/18','C9 SP-816','A3 FLT OP576','A9 0986452001','A5 324920','A1 W7035','A8 318 321','B1 BOS0451104014','B1 CHACOF100102S','A8 913 753','C9 OF-4023','B7 10201/JAPKO','A2 UFI 23.298.00','A2 W712/21','B1 FTROP618','C9 H14W12','C9 W713/36','B1 BLPADT32108','A1 C104','A1 W713/36','B7 SM101','A8 370 430','A8 307 715','A8 365 813','B7 H12W01','B1 MANW712/21','B1 FTROP520','A1 10-02-279ASK','C4 S 3253 R','B7 OP520/AG','A2 H10W02','A3 MHL OC501','A1 0451103062','A2 W916/1','A3 MHL OC615','A9 C18004','B7 1118503409/JP','C4 OC 988','A1 H10W02','C9 1000130001','B1 FTROP675/1','A1 C102','D1 BP ADB112118','C4 W 712/83','A3 MNN W712/83','A8 365 185','A5 80216','B7 1218504609/JP','C9 H10W02','C9 W920/7','B1 PURLS1159','A8 328 206','B7 OP 576/IP','A2 FI OP550','A3 VAC V70-0016','C9 ADT32108','B1 FEB34100','A9 0986452044','B1 KNEOC615','C4 LS743PU','B1 VAL586047','A8 369 102','A8 303 363','C9 W940/24','A9 FI OP550','A5 337788','B7 OP533/AG','C4 W 930/7','A2 OC988','B1 FTROP562','B7 OP 520/IP','A1 0451104066','A3 JAP FO-204S','B1 FTROP533','A1 LS285PU','B7 H10W02','A1 W920/7','C9 0451104014','A2 34100FEBI','A3 FLT OP520','B1 HENH10W02','B1 HENHY10WD01','A1 OC18','A1 LS188BPU','A2 FI OP576','C4 W 7035','B1 FTROP534','C4 H90W20','A2 H14W12','A3 FLT OP562','A2 OC501','C9 OF-845','C4 H17W06','A8 304 139','A3 KAP MO-542','D1 BP ADT32108','B1 FTROP576','A2 FI OP562','A9 W916/1','A1 LS743PU','C9 FE27147','B1 HENH14W12','A8 389 804','A2 W920','B1 PURLS359','A2 H17W06','A3 MNN W713/36','A1 OC988','B1 VAI95-0088','C4 H10W02','A8 312 820','A1 0451104065','A2 F026407235','A8 365 824','C4 0986452044','A2 W930/7','A3 HEN H90W20','A2 W940/24','A1 0986452001','B1 BOS0451104066','B7 A210048/DKM','A9 UFI 23.435.00','A8 318 421','A1 LS359PU','A1 WOF359','C4 LI 995/1','A8 304 561','B1 FEB33140','A9 OC615','B1 BOSF026407229','A5 432463','C9 OF-802','C9 SP-845','C9 FO-204S','A3 FLT OP534','A1 OC235','A3 BOS 0451103029','A3 MNN W712/21','A5 102423','A5 80520','B1 MANW713/36','B7 OP618/AG','A1 WOF1862','A2 J1312001','A1 LS900PU','B7 H10WD01','A3 VAC V95-0088','A9 W940/18','A5 200755','A1 W920','B7 SM155','B7 H10W11','A9 FI OP520','A9 OC988','B7 H90W30','B1 BOSF026407256','A1 W717/2','C9 OF-816','A9 FI OP562','A3 MNN C18004','C4 0451104065','B1 HENH10WD01','C9 H10WD01','C9 DO850','B7 H90W20','A8 318 379','A8 302 050','A1 W712/83','B7 10215/JAPKO','B1 PURLS900','B1 MANW920/7','B1 BLPADM52120','A2 W717/2','A8 351 997','A9 UFI 23.168.00','C9 0451103029','A1 OC501','A3 BOS F026408903','C9 50013050','A5 337785','B7 H17W06','B1 VAL586087','C9 W7035','B7 OP534/AG','B7 OP 675/1/IP','A1 0986AF1041','C9 0451103062','A2 FI OP533','C4 W 712/21','A2 SF OF0183','A3 MNN W916/1','C9 LS908','C9 0986452001','A2 FI OP618','C9 SP-836','A2 0986452003','A2 UFI 23.114.01','C9 W916/1','C4 LS188BPU','C9 H12W01','A8 365 946','A1 0451103029','A9 FI OP675/1','C4 H10W01','A9 W717/2','C4 0451104014','A3 MHL OC23','A8 306 512','A2 0451103062','B1 KAMF101901','B7 SM112','B1 KAMF106401','B1 MANW916/1','B1 BOSF026407235','B7 OP 563/IP','A9 J1312021','A2 0986452044','A1 0986452044','A3 FLT OP533','C4 0451103029','C4 S 1270 R','A8 374 282','A2 UFI 23.435.00','A1 LS149PU','A2 FI OP534','A1 34100 FE','A2 0451203178','A8 303 046','C9 0451203178','A5 169850','E6 FL1018','B1 VAL586024','B1 MANW712/83','B7 H10W08','A1 LS582PU','A2 W7035','C4 ELH4246','C9 W930/7','A2 C18004','A9 W930/7','B1 BOS0451104065','A8 318 344','A2 0451103029','B7 10279/JAPKO','C9 C18004','A1 W930/7','A2 UFI 23.127.02','C9 H10W11','B1 KNEOC501','B1 PURLS743','A1 W940/18','C9 LS743','B7 SM133','C9 71758737','B7 OP550/AG','A3 MNN W920','A8 365 184','B7 10204/JAPKO','B7 TO-138/KAVO','A5 189440','B1 KNEOC988','A3 VAC V25-0102','A9 UFI 23.131.00','A2 FI OP520','B1 VAL586073','C9 W920','A9 W920','A9 W713/36','A2 2.32170','A1 W916/1','A5 43729','B1 VAI25-0102','B1 FEB27147','A1 0986452003','A1 0986AF1042','A1 WOF537','C9 DO339','A8 365 924','A3 BOS 0986452003','B1 HENH90W20','A8 313 501','A2 UFI 23.171.01','C9 H10W01','A1 OC1051','A1 W7015','A1 W712/73','A1 WOF112','A1 WOF123','A1 WOF147','A2 OC1051','A2 W7015','A2 W712/73','A3 MHL OC1051','A5 202450','A5 206430','A5 500318','A8 325 297','A8 370 404','A8 378 012','A9 OC1051','A9 W7015','A9 W712/73','B1 HENH14W32','B1 KNEOC1051','B1 MANW7015','B1 MANW712/73','B7 H14W32','B7 W7015/AG','C4 H14W32','C4 O0550DREIS','C4 OC 1051','C4 W 7015','C9 OF-478','C9 W7015','C9 W712/73')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #