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 ('A2 F026407203','A8 332 595','C4 J1312021','A9 F026407203','A1 OC466','C9 ADT32114','B7 OP629/2/AG','B1 BLPADF122105','C9 F026407203','A5 115502','C4 F026407203','A1 WOF259','B7 SM143','A1 WOF1862','C9 7143220014','A5 432463','E6 FL1018','A1 10-0L-L09ASK','B1 BOS0986452044','A1 F026407203','E6 FL1042','B7 H90W27','A1 OC988','C4 0986452044','C4 S 3253 R','C4 0451103363','A5 43729','C9 FE109139','A1 OC235','A1 J1312015HB','C4 H319W','B7 H90W30','B1 BLPADT32108','C9 FO-L09S','A5 361686','A8 370 404','B1 HENH14W32','A2 J1312015','B1 PURLS359','B1 FEB108977','A3 JAP FO-279S','A8 365 937','A1 OC244','A1 OC478','A1 W712/73','B7 OP 618/IP','A8 920 093','C9 SP-994','A2 UFI 23.413.00','A3 JAP FO-215S','B1 CHACOF100182S','A1 J1312011HB','D1 BP ADT32103','C4 W 712/73','A1 0986452002','C9 FO-279S','A1 0451103363','A5 174740','A8 325 297','B1 HENH90W27','D1 BP ADJ132113','A8 374 862','A8 918 263','C4 J1312015','C4 O0583DREIS','A9 0986452044','C4 F026407225','B1 MANW712/73','C9 ADT32103','A3 BOS F026407203','B1 BOS0451103363','C9 LS359','B1 VAI25-0145','A8 303 046','B7 OP 629/2/IP','A1 OC 478','A9 OC988','A2 OC478','A1 OC1063','A2 OC1014','A1 OC1014','A9 J1312021','A3 VAC V70-0016','A1 LS357PU','A8 365 896','C4 OC 466','B1 HENH319W','A2 0451103363','A9 J1312015','A9 FI OP618','B1 VAI70-0016','A5 174792','C4 OC 988','A1 C182','A9 FI OP629/2','C4 S 3413 R','A2 FI OP629/2','B1 VAL586083','B1 FEB109220','C9 W712/83','A2 OC1063','C9 LS357','A8 320 522','A9 UFI 23.477.00','C4 LS357PU','A3 MHL OC478','D1 BP ADT32114','A2 J1312021','C4 H14W32','C9 ADF122105','A1 LS359PU','B1 BOSF026407203','A3 BOS 0451103363','C9 DO339','C9 0986452044','A5 62149','A5 206442','A9 OC1014','B1 BLPADJ132113','A3 FLT OP618','C9 ADT32108','A3 MNN W712/83','C9 H90W27','B1 BLPADT32103','A8 921 296','C9 W712/73','A2 KN HP-1002','C4 H90W27','A9 OC1063','A5 136639','A9 W712/73','B7 SM113','C9 SP-1423','A3 MNN W712/73','B1 BLPADT32114','A5 110506','B7 OP618/AG','A3 MHL OC988','C9 FE27147','A9 UFI 23.413.00','A2 W712/73','C9 DO911','C9 7143220017','B1 PURLS357','C9 30-143220011','C4 W 712/83','A5 337785','C9 F026407225','C9 0451103363','A9 UFI 23.253.00','C4 OC 1063','B1 BOSF026407225','A3 VAC V25-0145','A1 WOF1868','A3 MHL OC1014','A1 27147 FE','A9 W712/83','A5 500318','B1 FEB27147','A2 W712/83','A9 F026407225','A3 FLT OP629/2','D1 BP ADT32108','C9 DO910','A8 328 205','A8 360 975','A5 250170','A9 OC478','A1 10-02-215ASK','A2 UFI 23.477.00','A8 360 057','C9 FO-215S','A1 0986452044','B1 VAL586073','A2 OC988','B7 H14W32','A2 UFI 23.253.00','C4 27147F','A9 0451103363','A3 JAP FO-L09S','A9 KN HP-1002','B1 FTROP629/2','C9 ADJ132113','A1 10-02-279ASK','A3 BOS 0986452044','B1 MANW712/83','B7 W712/83/AG','C9 50013820','A8 328 206','A1 W712/83','B1 FTROP618','A2 OC466','A2 F026407225','A8 312 820','A2 0986452044','A3 MHL OC1063','A2 FI OP618','B1 FEB109139','C9 H14W32','D1 BP ADF122105','A1 J1313021HB','A1 LS188BPU','A5 169850','A8 389 804','B1 BLPADM52111','B1 BLPADM52118','B1 KAMF119001','B1 KNEOC1014','B1 KNEOC1063','B1 PURLS188B','B1 VAL586047','C9 ADM52118','C9 OF-1072','D1 BP ADM52111','D1 BP ADM52118','E6 FL1209')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #