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 ('A1 698868','C9 80000330','C9 H279WK','A1 0450906442','A2 KL43','A2 CUK2358','B7 M110730/DKM','C9 PF-1257','B1 KNELX1947','B7 AP 102/4/IP','C4 S 5072 PE','A3 FLT OE683','A3 DLP HDF579','B1 KAMF108001','A9 SF KF9482','B1 VAL586550','C9 SP-1257','B1 HENE11H D117','A8 373 047','C9 FA-436S','C9 FO-ECO021','C9 BCF211','C4 H279WK','A3 BOS F026400232','B7 HC-8114/KAVO','A1 J1314016HB','B7 1ECO021/JAPKO','A1 J1324050HB','B1 DENDCF561P','B7 E11H D117','A9 F026407070','B1 CORCC1179','A3 MHL KL43','A3 FLT K1187','B7 30L02/JAPKO','A2 CC1179','A5 49300','A9 FI AP102/4','A9 FI PP978','A3 MHL OX153/7D1','B1 BOSF026400232','A9 CUK2358','C9 MD-8318','A2 F026407070','C4 F026400232','A1 KL43','C4 J1334036','B7 HO-828/KAVO','C9 F026400232','B7 21H011/JAPKO','B1 CORCP1179','A8 334 929','B1 KAMF411301','A3 KAP HA-8650','C9 AF-8318','A9 UFI 25.072.00','A2 698868','A9 1987432166','C4 CUK 2358','B7 K1187/AG','B1 KAMF316701','C4 E11H D117','A2 UFI 25.072.00','C9 1987432166','C9 E11HD117','A9 KL43','A3 MHL LA216','A8 362 454','C4 E2990LI','A2 CP1179','A1 J1344010HB','A9 J1334036','A3 JAP FAA-H011','A2 J1344010','A2 FI K1187','A2 OX153/7D1','C4 LX 1947','C9 31-123190008','A9 LA216','C9 FAA-H011','B1 FTRK1187','C9 VAL698868','C9 31-123190012','C9 OF-549','A9 J1344014','B1 BOS1987432166','A9 J1314017','B1 KAMF225401','C4 LA 216','A8 366 102','C9 0450906442','A9 LX1947','B1 FTRAP102/4','A3 JAP FO-ECO021','A8 381 686','A1 30-0L-L02ASK','A1 WOF298','A2 FI AP102/4','C4 K0490DREIS','B7 A120248/DKM','B1 CHACOF100572E','B7 PP 978/IP','A1 LA216','A2 K225/235.28','C9 NC2206','A2 FI PP978','B1 VAL587546','B7 E1198L','A2 SF OF0768','C4 E1198L','C4 OX 153/7D1','A1 F026407070','A8 366 977','A9 0450906442','A2 J1344014','A5 49652','A1 XE572','A9 FI OE683','C9 KF-6291','C9 FC-L02S','C4 1987432166','A1 21-H0-H011ASK','B7 E2990LI','A1 CUK2358','B7 SH4063P','A9 J1324057','B1 BOSF026407070','A8 350 856','A2 FI OE683','A2 1987432166','B7 K 1187/IP','A2 UFI 30.380.00','A1 LX1947','B1 DELHDF579','A8 351 253','A3 FLT PP978','A8 920 431','C9 80000404','A3 KAP HC-8114','A5 250093','A5 62745','B1 BOS0450906442','B1 HENE2990LI','A3 JAP FA-436S','B7 A210570/DKM','A2 J1314017','A1 20-04-436ASK','A3 BOS 0450906442','A9 OX153/7D1','B1 VAL698868','A3 KAP HO-828','B7 OE 683/IP','C4 J1344014','A1 WFF107','B7 HA-8650/KAVO','A2 J1334036','B1 MANCUK2358','B1 KNELA216','B7 SA1205','B7 PP978/AG','C4 J1344010','A2 LA216','C4 F026407070','B7 H279WK','A2 J1324057','A8 344 226','B1 KNEKL43','C4 0450906442','A9 UFI 30.380.00','A2 0450906442','A2 SF KF9482','C9 31-143220001','C4 DCF561P','A1 F026400232','A9 J1344010','C9 HDF579','C4 J1324057','A9 F026400232','A5 88878','B1 HENE1198L','A8 359 755','A3 MHL LX1947','A8 370 009','A3 KAP HF-8965','A3 BOS F026407070','C9 CUK2358','B7 A141337/DKM','B1 FTRPP978','B7 20436/JAPKO','B7 AP102/4/AG','A3 JAP FC-L02S','A2 LX1947','A1 WCF513','A2 F026400232','A8 366 202','C9 F026407070','B1 FTROE683','A8 335 967','B1 HENH279WK','C4 KL 43','A1 OX153/7D1','A3 FLT AP102/4','A9 FI K1187','B7 HF-8965/KAVO','A3 BOS 1987432166','A3 MNN CUK2358','A9 SF OF0768','B7 OE683/AG','A1 10-ECO021ASK','C4 J1314017','A1 1987432166')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #