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 S 1530 R','C9 SP-977','A1 OC82','B1 VAL586023','B7 OP 629/IP','A1 J1313020HB','B1 VAI25-0058','C4 LI 779/43','A9 FI OP629','A2 H14W23','C4 LS285PU','A8 313 510','B1 BLPADM52109','C9 SP-945','A5 337787','C4 S 8540 R','B7 H14W23','B1 PURLS907','B1 BLPADM52117','A9 UFI 23.416.00','A1 J1313022HB','A5 169850','A5 44219','C4 S 3416 R','C9 ADM52110','A3 BOS 0451103227','B1 BOS0451103907','A1 C165','B1 VAL586028','C4 OC 203','C9 FE27138','C4 0451103259','C4 W 719/27','C9 0451103298','A8 313 810','A2 J1313020','C9 7143220001','A3 JAP FO-913S','A3 VAC V25-0057','A3 BOS 0451104523','B1 BOS0451103301','C9 FE27289','C9 0451103304','D1 BP ADM52110','A3 MHL OC988','C4 J1313020','C9 ADM52117','C4 0451103227','C4 LS801PU','A9 W719/27','A1 0451104500','A8 393 166','A9 OC606','C9 0451103307','B7 SM110','A5 169853','C9 LS907','A3 BOS 0451104505','A9 UFI 23.242.00','B1 HENH14W23','B1 VAL586030','A5 206442','A8 338 888','D1 BP ADM52117','A2 UFI 23.242.00','B1 PURLS188B','A1 0451104505','C9 DO217','A1 OC266','A1 0451103227','A3 VAC V25-0101','C4 O0615DREIS','A1 27138 FE','B1 FEB27138','C9 H14W23','C9 DO1802','A2 FI OP629','A3 BOS 0451103304','A8 305 553','C9 0451103301','A1 OC203','A2 0451103298','A1 LS285PU','A2 OC203','C9 SP-892','C4 OC 606','C9 FO-913S','A1 0451104523','A1 A271','B1 VAI25-0057','C9 0451103907','A2 OC988','A3 VAC V25-0058','B7 OP629/AG','C9 7143220002','A1 27289 FE','A8 319 339','B1 FEB27289','C9 71760806','A3 MNN W719/27','A1 0451103247','A1 OC52','A2 0451103227','A3 MHL OC203','A1 0451103307','B7 H90W19','B1 HENH90W19','A8 365 941','B1 PURLS801','A3 BOS 0451103307','A1 0451103304','A1 0451103075','C9 SP-949','A1 WOF123','A1 0451103048','A1 10-09-913ASK','C4 0451103907','C9 SP-1072','A9 UFI 23.440.00','A1 WOF144','C9 7143220000','B1 BOS0451103307','A2 W719/27','A1 WOF112','A3 BOS 0451103907','A1 LS188BPU','A2 UFI 23.440.00','C4 LS907PU','A9 0451103227','A2 0451103259','C9 DO899','B1 BOS0451103259','A1 OC988','A1 0451103298','A2 0451103907','B1 HENH14W20','B1 FTROP629','A9 UFI 23.188.00','C9 H14W20','C4 H14W20','B1 VAI25-0101','A1 W719/27','C9 50013097','C9 0451103259','A1 10-03-394ASK','A8 370 398','A8 365 887','A9 OC203','A1 OC606','A9 0451103259','B1 BOS0451103298','C4 LS188BPU','C9 FE27136','A8 389 804','C9 H90W06','A3 MHL OC606','A3 FLT OP629T','C4 H14W23','C4 S 0320 R','B7 W719/27/AG','A5 40937','A1 0451103259','A9 OC988','A8 365 824','B1 BLPADM52110','A9 UFI 23.131.00','A8 313 497','A1 C204','A2 OC52','C4 0451103298','A2 OC606','A8 365 184','A1 OC235','C4 COF100165S','A3 HEN H14W20','A5 208497','C9 H90W05','A2 586030','A1 27136 FE','A2 586023','A3 BOS 0451103247','A3 MHL OC52','C9 LS285','C9 LS188B','A3 BOS 0451103298','D1 BP ADM52109','A8 365 951','C9 0451103227','B1 PURLS285','C9 H90W19','C4 OC 988','B7 SM137','A1 LS907PU','A5 40940','B1 CHACOF100165S','C9 DO848','A3 BOS 0451103259','A2 H14W20','C9 DO261','B1 BOS0451103304','C9 LS801','A1 LS801PU','B1 MANW719/27','A8 370 610','C9 ADM52109','A2 UFI 23.131.00','C4 H90W19','A5 189440','C9 W719/27','A1 0451103907','A1 0451103073','A1 C20480102000/GRX','A3 FLT OP629','A3 BOS 0451103301','B1 BOS0451103227','C9 SP-1244','A9 0451103298','A2 UFI 23.416.00','A1 0451103301','B1 FEB27136','B7 H14W20','A2 UFI 23.188.00','A1 38813 FE','A2 SF OF0126','A9 SF OF0126','B1 BLPADM52122','B1 FEB38813','B1 KAMF102301','B1 KNEOC988','B1 VAL586005','C4 MO-540','C9 ADM52122','C9 FE38813','C9 OF-821','D1 BP ADM52122')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #