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 7143220017','C9 OF-1072','B1 VAL586023','B1 PURLS188B','A3 MNN W712/80','A1 W712/80','A1 OC1063','B1 PURLS934','B1 VAL586083','A1 10-0L-L09ASK','A1 0986AF1060','C4 F026407005','C9 W712/80','C4 W 7015','A9 FI OP532/2','A8 360 691','A1 50013081','B1 VAL586039','B7 10L09/JAPKO','A3 HEN H90W12','A2 FI OP629/2','A1 0986452068','B1 HENH90W27','C9 DO942','C9 FO-279S','A2 OC466','B1 PURLS357','A2 SF OF0126','A1 OC466','A9 W712/80','B1 KNEOC981','C9 FO-L09S','A1 WOF259','B7 W7015/AG','A5 43729','C4 0451103363','A8 918 263','B1 BOSF026407005','C4 0986452044','A1 10-02-279ASK','B7 H90W12','B1 FTROP532/2','C4 H319W','C4 F026407203','B1 HENH90W12','A3 MHL OC1063','A8 332 595','C4 W 712/73','A2 OC981','A1 0986AF1041','C4 OC 981','A1 LS357PU','A8 374 862','A9 SF OF0126','A2 UFI 23.298.00','C4 W 712/80','A8 921 296','A5 288070','C9 50013919','B7 H90W31','A1 0451103363','A3 MNN W712/73','A9 FI OP629/2','B7 SM110','A8 328 205','C9 LS245','A1 OC981','A3 BOS F026407203','B7 OP 629/2/IP','A9 UFI 23.413.00','B7 SM143','C9 0451103363','A9 F026407005','C4 F026407225','A8 920 551','A2 OC1063','C4 H90W27','A2 586023','A2 F026407203','C9 F026407005','A3 FLT OP532/2','A8 365 937','C4 LS357PU','A1 WOF1868','B1 HENH319W','C4 LS934PU','C9 FE109139','C4 OC 1063','A2 W712/80','C9 302134595','C4 LS188BPU','B1 KAMF113001','A2 FI OP532/2','C9 F026407225','A2 F026407005','A3 JAP FO-279S','C4 S 3413 R','A3 VAC V25-0145','A2 0986452068','A3 MHL OC981','A9 SF OF0078','B7 OP 532/2/IP','A5 361686','B1 FTROP629/2','A2 0986452044','A2 UFI 23.413.00','A3 FLT OP629/2','A8 378 012','A9 0451103363','A8 312 820','C9 0986452044','A9 0986452044','A1 LS188BPU','C9 DO850','C9 H90W27','A1 J1313021HB','B7 A210414/DKM','C9 LS357','A1 LS934PU','C9 7143220014','A8 353 104','A1 F026407005','B1 KNEOC1063','A8 325 297','C9 LS934','A5 174740','A3 BOS F026407005','B1 CHACOF100182S','A2 F026407225','A9 W712/73','A9 F026407225','A8 389 804','B1 VAI25-0145','A3 JAP FO-L09S','A2 W7015','B1 BOSF026407203','C9 OF-7129','A9 F026407203','A2 W712/73','A5 62149','B7 H90W27','A3 BOS 0986452044','A1 0986452044','B1 BOS0986452044','C9 LS188B','A8 341 028','B1 PURLS245','A9 OC981','C9 SP-1423','A9 OC1063','B1 BOSF026407225','B1 BOS0451103363','A1 F026407203','B7 OP629/2/AG','A1 OC235','C9 SP-1296','C9 SP-1067','C9 F026407203','B1 MANW712/73','A5 169850','A8 365 924','A3 BOS 0451103363','B7 10279/JAPKO','A2 0451103363','B1 MANW712/80','A2 SF OF0078','A1 LS245PU','C9 71758791','C9 W712/73','A8 333 082','C4 O0550DREIS','A9 W7015','A5 110506','B1 FEB109139','B7 OP532/2/AG','C4 OC 466','A1 W7015','A1 C182','A1 W712/73','B1 MANW7015','A5 202450','A9 UFI 23.298.00','A5 174792','C9 W7015','C9 H90W12','A2 586039','A1 OC1051','A1 W7008','A1 WOF147','A2 FI OP629/1','A2 OC1051','A2 SF OF0138','A2 W7008','A3 FLT OP629/1','A3 MHL OC1051','A5 206430','A8 348 232','A8 353 103','A9 OC1051','A9 SF OF0138','A9 W7008','B1 FTROP629/1','B1 HENH315W','B1 KNEOC1051','B1 MANW7008','B7 A210074/DKM','B7 H315W','B7 OP629/1/AG','C4 H315W','C4 O0549DREIS','C4 OC 1051','C4 W 7008','C9 W7008')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #