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 ('A3 MNN W712/21','B1 MANW712/43','A1 0451103907','A1 W711/80','A5 62149','A9 W712/43','A9 OC981','C4 W 712/80','A3 MNN W712/81','B1 BOS0451103907','A9 W930','A8 303 111','C4 986452044','C9 ADM52109','A1 H97W05','C4 W 1130/1','C9 H90W05','A9 W930/7','B1 MANW1130/2','C4 451103907','A1 OC235','A2 OC606','A1 WOF209','A1 OC606','A1 W712/21','A5 169850','B1 HENH90W12','A3 HEN H10W01','B7 OP629/1/AG','C9 W712/83','C9 W712/22','A1 OC231','A1 0986452058','C4 0986452044','C9 DO217','C4 W 916/1','A1 W920/21','C4 LS934PU','B7 H90W12','C9 DO942','C4 W 712/21','A1 0451103048','A3 BOS 0451103298','A2 W930/7','A3 MNN W712/80','A3 MNN W712/54','B1 KNEOC501','A1 W713/4','A8 365 924','A2 J1317003','A9 FI OP629','C9 SP-945','A8 302 050','A9 OC606','A2 0451103351','C4 LS285PU','A1 W712/38','B7 OP 629T/IP','A8 307 705','C9 F026407005','A1 OC55','C4 451203154','B7 W712/43/AG','A8 389 804','D1 BP ADM52109','A1 W930/7','B1 KNEOC217/6','A5 288070','C4 H97W05','A1 0451103073','C4 F026407005','A3 MNN W712/22','A8 300 118','B7 OP 629/IP','B1 BOS0451203154','A1 LS245PU','C9 W712/80','B1 BOS0451103351','A1 LS922PU','A8 307 715','A1 WOF1868','C4 LI 779/43','A1 C108','A1 27138 FE','A1 W714/2','A1 0451103351','C9 W916/1','A5 189440','B1 HENH97W05','C4 H90W19','A9 W920/21','C4 W 950/4','C4 O0684DREIS','A1 WOF112','A3 MHL OC981','C9 0986452044','B7 H90W19','C9 W1126','B1 MANW930','A9 W1130/2','A3 MNN W1130/1','A1 LS188BPU','C4 OC 981','A3 FLT OP629/1','A3 FLT OP629T','A3 MHL OC74','C9 W712/54','A1 OC981','A9 W712/80','A1 W712/83','C4 H10W01','C9 W718','A3 HEN H90W12','B1 KNEOC988','A2 OC78','A1 WOF123','A5 432463','B1 FTROP629T','A8 300 028','C9 H90W22','A3 BOS F026407005','C9 SP-892','B1 MANW930/7','A9 FI OP629T','A8 304 648','A1 OC52','A2 W950/4','C9 0451103351','A2 W1130/1','A1 W712/54','C9 LS285','A2 W712/80','A3 MNN W930','A1 W930','A2 0986452058','B7 H97W05','A8 338 888','C4 451103298','A8 303 046','C9 H10W01','A2 W714/2','B7 OP629/AG','A2 OC52','A3 MNN W930/7','A1 0451103124','A1 LS934PU','C9 W714/3','B1 PURLS934','B7 H10W01','A2 OC981','C9 0451103907','A8 313 810','A8 313 985','B1 BOS0451103307','A2 0451203154','A9 J1317003','A9 FI OP629/1','B1 PURLS245','B1 PURLS922','B1 PURLS188B','B1 KNEOC981','C4 W 714/2','A2 UFI 23.131.00','A2 W920/21','B1 BOS0451103298','C4 S 3416 R','C9 W712/21','A8 312 820','C9 H90W06','C4 W 712/54','A2 W712/21','A5 44776','A8 312 833','B1 MANW712/21','A1 WOF284','A1 LS277PU','A9 0986452058','A3 MNN W1126','C9 H90W12','A1 0451104523','A2 W916/1','C4 P550580','A9 W714/3','A2 FI OP629','A9 W950/4','A3 MNN W714/2','B1 BOSF026407267','A5 50039','A8 321 209','A3 BOS 0451103351','A5 372493','B1 KNEOC606','C4 W 714/3','A1 W714/3','C9 DO941','A2 W714/3','A2 UFI 23.416.00','A1 W1130/2','C4 O0572DREIS','B1 MANW714/3','A1 0451103307','C4 W 1126','B7 OP 629/1/IP','C4 J1313021','B1 MANW714/2','A8 370 624','C9 DO223','B1 PURLS285','C4 P550299','B1 FTROP629','C9 LS188B','A2 H97W05','A9 UFI 23.131.00','A1 OC82','C4 W 712/43','A1 W718','C4 W 920/21','A8 308 725','A8 353 103','B7 SM110','A9 W712/54','A3 MNN W950/4','A9 J1313021','B1 MANW1130/1','C4 S 3413 R','A1 0451103262','A3 BOS 0451103907','C9 LS922','A1 0451103298','A9 0451103298','A2 UFI 23.298.00','C9 LS245','B1 MANW920/21','A3 BOS 0451103307','C4 W 712/22','B1 HENH10W01','A8 370 610','A1 F026407005','B1 BOSF026407005','A1 0986452044','A3 MHL OC55','A8 353 104','A2 UFI 23.117.00','C4 O0583DREIS','B1 BOSF026407078','B7 W712/83/AG','C4 986452058','C9 H90W19','B1 MANW712/54','C9 0451203154','A9 W1126','A1 F026407078','C4 OC 606','A9 W714/2','B1 HENH90W19','A3 MNN W1130/2','A3 BOS 0986452044','A1 J1313022HB','A2 F026407078','C4 451103351','B7 H90W22','A2 J1313021','C9 0986452058','A2 W930','C9 W712/43','A8 305 890','B1 MANW712/80','A9 F026407005','A3 MNN W712/83','A5 496739','A2 W712/54','C4 0986452058','C4 0451103907','A9 UFI 23.413.00','A3 MHL OC52','A2 W712/83','C9 W712/38','A9 F026407078','A1 W712/22','C4 F026407078','A1 OC74','A3 MNN W920/21','A8 365 824','A1 W1130/1','A2 W1130/2','A8 341 028','A8 360 691','C4 LS922PU','B1 BOS0986452044','A9 W916/1','A1 0451104500','A9 W718','A2 F026407005','C4 J1317003','A3 MHL OC606','B1 BOS0986452058','A8 365 941','C4 0451203154','A8 312 855','A1 WOF491','B1 MANW718','C9 W1130/2','A9 W712/21','A2 0451103298','A1 C142','A1 W712/43','C9 DO261','A1 W950/4','A3 FLT OP629','C4 O0783DREIS','C9 W920/21','A2 FI OP629T','A3 MHL OC78','B1 FEB27138','B1 MANW1126','A9 W712/83','C9 W1130/1','A2 W718','A3 BOS 0451104523','B1 BLPADM52109','A9 0451203154','B1 FTROP629/1','C9 0451103307','A8 365 937','C9 DO899','C4 0451103298','C4 O0462DREIS','C9 W930','C4 O0577DREIS','A2 0986452044','B1 MANW950/4','C4 W 712/2','A2 FI OP629/1','A3 MNN W718','A1 WOF157','C4 W 930','C9 W950/4','A1 OC78','A2 UFI 23.188.00','A1 W1126','B1 MANW916/1','C9 W714/2','C9 F026407078','A1 0451203154','C4 W 712/83','C4 S 8540 R','A2 UFI 23.413.00','A3 MNN W714/3','A9 UFI 23.416.00','C4 W 930/7','A3 BOS 0986452058','C4 W 712/54 SD','A1 LS285PU','A3 BOS F026407078','A3 BOS 0451203154','A9 0986452044','C9 FE27138','A2 OC55','C9 DO850','A5 40940','A9 0451103351','A2 0451103907','A9 UFI 23.188.00','C9 LS934','A2 W712/43','A1 W712/80','C4 LS188BPU','A5 43661','A2 W1126','C9 W930/7','A1 0451103075','C9 0451103298','C4 W 712/43 (10)','B1 KNEOC215','A1 W712/81','A9 UFI 23.117.00','A9 UFI 23.298.00','C9 H97W05','C4 S 3428 R','B1 KNEOC1051','A1 W916/1','A9 H97W05','B1 MANW712/83','A3 MNN W712/43','A5 44642','A3 MNN W916/1','A8 365 184','C4 0451103351','A1 38813 FE','A1 C119','A1 C137','A1 J1313021HB','A1 W7008','A2 W7008','A8 348 232','A8 360 057','A9 W7008','B1 BLPADM52111','B1 BLPADM52122','B1 BLPADT32108','B1 CHACOF102119S','B1 FEB37422','B1 FEB37425','B1 FEB38813','B1 FEB39759','B1 FEB39760','B1 FEB39763','B1 KAMF102301','B1 MANW7008','B7 TO-138/KAVO','C4 O0549DREIS','C4 W 7008','C6 000012','C9 ADM52122','C9 ADT32108','C9 FE109139','C9 FE38813','C9 W7008','D1 BP ADM52111','D1 BP ADM52122','D1 BP ADT32108','E6 FL1209')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #