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