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 W1130/2','B1 BOSF026407256','A1 OC62','B1 HENH457W','A1 W940/15N','A2 OC132','A3 FLT OP550','B1 MISZ297','A3 MNN W940/15N','A5 31319','A1 W930','A3 MNN W930/7','A8 920 011','A1 J1312006HB','B1 MANW940/15N','A1 W940/4','A9 OC105','C4 OC 105','C9 W940/4','A1 OC132','C9 DO228','B1 VAL586087','A2 W1130/2','A1 0451203061','B1 MANW930/7','A1 LS186PU','C9 LS186','A8 304 648','A2 W930/7','B7 OP550/AG','C9 DO918','A1 J1311012HB','A3 MHL OC105','C4 W 940/15 N','B1 FTROP550','A2 W930','A9 W1130/2','A8 307 705','A2 W940/15n','A3 MNN W940/4','A1 0986452021','C9 F026407256','B7 OP 550/IP','A8 920 008','B1 PURLS186','B1 MANW930','A2 OC62','A2 W940/4','A1 WOF116','D1 BP ADA102127','C9 0451203061','A3 MNN W1130/2','A3 MHL OC132','A3 MHL OC80','A9 W940/15n','A9 W940/4','A1 OC80','A8 318 344','C9 DO298','A3 MNN W930','C4 S 5600 R','C4 LS186PU','B1 MANW940/4','A2 OC80','B1 BOS0451203061','A2 FI OP550','A1 W1130/2','C4 W 930/7','B1 MANW1130/2','A3 MHL OC62','C9 W930','A1 W930/7','B1 BLPADA102127','C9 W930/7','C9 DO225','A9 W930','A9 FI OP550','C9 W940/15N','C9 ADA102127','A2 OC105','A9 W930/7','C4 W 930','A1 OC105','A3 BOS 0451203061','A1 0451104065','A1 0451203087','A1 C105','A1 C152','A1 H17W01','A1 OC59','A1 W830/1','A1 W930/20','A1 W940','A1 W940/1','A1 W940/81','A1 W950/4','A1 WOF203','A2 0451203087','A2 FI OP549','A2 FI OP563','A2 H17W01','A2 J1311010','A2 J1311012','A2 OC59','A2 UFI 23.102.00','A2 UFI 23.164.00','A2 UFI 23.164.03','A2 UFI 23.241.00','A2 W830/1','A2 W930/20','A2 W940','A2 W940/1','A2 W940/81','A2 W950/4','A3 BOS 0451203087','A3 FLT OP549','A3 FLT OP563','A3 JAP FO-110S','A3 JAP FO-112E','A3 JAP FO-112S','A3 JAP FO-201S','A3 JAP FO-206S','A3 JAP FO-279S','A3 MHL OC59','A5 154655','A5 30182','A5 30197','A5 31655','A5 324887','A5 40933','A5 43729','A5 48012','A8 300 118','A8 303 201','A8 303 523','A8 306 453','A8 312 300','A8 314 417','A8 318 421','A8 318 425','A8 365 788','A8 365 851','A8 365 853','A9 0451103028','A9 0451203087','A9 H17W01','A9 J1311010','A9 J1311012','A9 OC59','A9 UFI 23.102.00','A9 UFI 23.164.00','A9 UFI 23.164.03','A9 UFI 23.241.00','A9 UFI 23.297.00','A9 W830/1','A9 W930/20','A9 W940','A9 W940/1','A9 W940/81','A9 W950/4','B1 BOS0451103028','B1 BOS0451203087','B1 CHACOF100152S','B1 FTROP549','B1 FTROP563','B1 HENH17W01','B1 KAMF101001','B1 KAMF102401','B1 MANW830/1','B1 MANW930/20','B1 MANW940','B1 MANW940/1','B1 MANW940/81','B1 MANW950/4','B1 VAL586056','B1 VAL586065','B1 VAL586073','B7 NO-2224/KAVO','B7 NO-248/KAVO','B7 SM108','B7 SM133','C4 0451203087','C4 H17W01','C4 J1311010','C4 J1311012','C4 O0662DREIS','C4 O0783DREIS','C4 S 3241 R','C4 S 3297 R','C4 S 5601 R','C4 S 5603 R','C4 W 830/1','C4 W 930/20','C4 W 940','C4 W 940/1','C4 W 940/81','C4 W 950/4','C9 0451103028','C9 0451203087','C9 FO-110S','C9 FO-112E','C9 FO-112S','C9 FO-279S','C9 OF-1112','C9 OF-958','C9 OF-994','C9 SP-915','C9 W830/1','C9 W930/20','C9 W940','C9 W940/1','C9 W940/81','C9 W950/4','D9 16510-60B11','D9 16510-60B11 10db','D9 16510-60B11 50db')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #