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 H319W','C9 FO-322S','A2 ADM52123','A8 920 551','A1 10-03-394ASK','C4 H90W27','C4 W 7020','B7 H90W31','A5 250065','A8 328 205','A9 OC1063','A8 918 310','A3 FLT OP629/2','A9 F026407225','B1 BOSF026407005','A9 ADM52123','B1 BLPADM52123','B1 FTROP532/2','E6 FL1203','A1 OC1014','A1 F026407085','A5 136639','A9 F026407085','A3 MHL OC1063','A5 341962','A2 W712/73','C9 H90W27','A8 360 691','A2 W7061','A8 333 082','A9 F026407203','A3 MNN W7020','C9 ADJ132113','A3 BOS F026407005','B7 OP532/2/AG','C4 F026407203','D1 BP ADM52118','A2 OC466','B1 BOSF026407203','A8 921 296','A1 W712/73','B1 FTROP629/2','A8 332 595','A9 FI OP629/2','B1 BLPADM52118','A2 0451103363','C4 F026407225','B1 BLPADM52111','C9 LS357','A8 918 263','A2 OC1014','C4 OC 466','A3 MNN W712/73','B1 MANW7020','A5 246884','A3 MHL OC1014','A1 OC1182','B1 HENH90W33','A3 BOS F026407203','A9 0451103363','B7 OP 629/2/IP','C9 F026407085','C9 0451103363','B7 H90W33','B1 MANW7061','A8 365 575','A5 174740','C9 F026407005','A2 F026407085','A3 JAP FO-322S','A8 919 221','A2 UFI 23.473.00','A1 W7061','D1 BP ADM52123','A1 LS357PU','A1 OC466','B1 PURLS357','A1 W7020','A1 WOF259','A9 OC1014','C4 0451103363','D1 BP ADF122105','C9 ADM52123','A8 918 079','A2 FI OP629/2','B7 OP629/2/AG','C4 W 7061','E6 FL1209','C9 F026407225','B1 BOSF026407225','A2 F026407005','C4 H90W33','A1 0451103363','A8 325 297','A1 F026407203','A9 UFI 23.473.00','A2 F026407203','A3 MHL OC1182','A9 W712/73','A9 FI OP532/2','C9 W7020','C4 F026407005','A9 W7061','A1 OC1063','B7 OP 532/2/IP','A2 OC1182','A1 F026407005','B1 MANW712/73','C4 W 712/73','C9 ADM52111','C9 W712/73','B1 BOSF026407085','A2 F026407225','C9 ADF122105','C9 ADM52118','B1 BLPADJ132113','B1 HENH90W27','C4 F026407085','C9 W7061','A9 F026407005','A5 361686','B7 H90W27','A5 174792','A9 OC1182','B1 BLPADF122105','B1 BOS0451103363','A3 FLT OP532/2','A2 FI OP532/2','C4 OC 1063','D1 BP ADM52111','A3 BOS 0451103363','C9 F026407203','A2 OC1063','B1 HENH319W','A1 J1313021HB','A5 432477','A3 JAP FO-394S','D1 BP ADJ132113','C9 FO-394S','A1 OC244','C4 LS357PU','B1 VAL586083','A8 374 862','A1 50013081','A1 C182','A1 W68/3','A1 W7015','A1 W712/80','A2 FI OP597/1','A2 J1313021','A2 UFI 23.413.00','A2 W68/3','A2 W7015','A2 W712/80','A3 FLT OP597/1','A3 JAP FO-279S','A5 202449','A5 202450','A5 43729','A8 300 023','A8 341 028','A8 365 937','A8 372 532','A8 378 012','A9 J1313021','A9 UFI 23.413.00','A9 W68/3','A9 W7015','A9 W712/80','B1 CHACOF100182S','B1 FEB108977','B1 FEB109220','B1 FTROP597/1','B1 KAMF113001','B1 KAMF119001','B1 KNEOC1014','B1 KNEOC1063','B1 KNEOC1182','B1 MANW68/3','B1 MANW7015','B1 MANW712/80','B1 VAL586073','B7 A210414/DKM','B7 MO-534/KAVO','B7 SM143','B7 SM196','B7 W7015/AG','C4 J1313021','C4 O0547DREIS','C4 O0550DREIS','C4 S 3413 R','C4 W 68/3','C4 W 7015','C4 W 712/80','C9 7143220014','C9 7143220017','C9 FE109139','C9 FO-279S','C9 OF-1072','C9 OF-223','C9 SP-1296','C9 SP-1423','C9 W68/3','C9 W7015','C9 W712/80')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #