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 FI AP104/4','B7 HA-8644/KAVO','A2 1987432220','A1 WOF160','A3 FLT PP978','C4 COF100560E','B1 FTRAP104/4','A2 FI PP978','A8 920 429','A1 CCF0338','B1 HENE1291L','A1 XE560','B7 H279WK','A9 FI K1198-2X','A8 367 376','B7 21H04/JAPKO','B7 OE 648/4/IP','C4 J1324055','C9 PF-1257','A2 CU2327-2','A3 KAP HC-8113','A9 SF OF0222','B1 KAMF400901','A1 J1324045HB','C9 21652546','A8 373 047','A3 MHL LX1742','A5 44063','B7 1ECO038/JAPKO','A5 109280','B7 OE648/4/AG','B7 PP978/AG','A3 MHL OX163/4D','B1 CORCC1081','C9 80000148','C4 J1344012','B7 SH4788P','B1 DELHDF579','B7 E1906LI','B1 KNEKL43','B1 DENDCF512P','A9 CU2327-2','A9 FI OE648/4','A3 FLT OE648/4','A1 50013621','A3 JAP FC-L02S','A1 WFF107','C4 E22H D88','A1 1457429199','A1 20-04-437ASK','A9 FI PP978','C9 AH220-2','B1 VAL587546','A3 BOS 1987432220','A9 J1314015','A8 336 870','A2 0450906442','B1 VAL586504','C4 CU 2327-2','A8 318 838','A2 SF 2KF9494','A9 1987429178','A1 21-H0-H04ASK','A5 50589','C9 KF-6251','C9 H279WK','B7 HC-8113/KAVO','A8 330 692','C9 ML072','C9 NC2207','A3 MNN CU2327-2','A2 UFI 53.108.00','A1 10-ECO038ASK','A9 1987432220','A1 CU2327-2','B7 AP 104/4/IP','A9 SF 2KF9494','B1 FTRPP978','B7 SA1186','C4 OX 163/4D','A3 DLP HDF579','B1 CORCP1081','A9 J1344012','C4 S 5027 PE','C9 MD-8244','C9 FAA-H04','C9 71758824','A2 FI K1198-2X','C9 AF-8244','C9 BCF173','B1 FTRK1198-2X','B1 MANCU2327-2','C9 1987432220','C9 FO-ECO038','A8 359 639','C9 FC-L02S','A2 J1344012','A3 KAP HA-8644','B7 20437/JAPKO','B7 M110013/DKM','A5 246879','B1 CHACAF100759P','B1 KAMF316701','A1 AH220-2PU','B1 DENDCF113P','C9 31-123190004/S','A2 1987429178','B7 30L02/JAPKO','A2 KL43','A2 LX1742','C9 1987429178','C4 O0323DREIS','B1 CHACOF100560E','B1 KNELX1742','B7 HO-827/KAVO','A9 OX163/4D','A1 LX1742','B7 A120248/DKM','C9 MD-423','B1 CHACCF0338','A3 MNN C3347','A2 FI OE648/4','A1 OX163/4D','A8 926 099','A2 1457429199','A3 FLT K1198-2X','A5 45323','A1 1987429178','A1 0450906442','A1 698735','A2 J1324055','A1 WAF717','A1 30-0L-L02ASK','B1 KAMF104501','A2 CP1081','A8 333 377','A2 698735','C4 1987432220','C9 OF-423','C9 C3347','B7 E1906LI-2','A9 FI AP104/4','B1 HENH279WK','A3 BOS 0450906442','B1 HENE1906LI-2','C9 A1209','A3 BOS 1987429178','B1 MMABCF173','B7 E1291L','C4 J1314015','A2 LA122/S','C4 KL 43','B1 BOS1457429199','B1 PURAH220-2','A8 369 195','A1 C3347','A9 UFI 30.360.00','A1 LA122/S','A1 1987432220','C9 HDF579','C9 VAL698735','C9 CU2327-2','C9 SP-1257','A5 36003','C9 6143220004','A2 SF OF0222','B1 MANC3347','A3 KAP HF-8965','B7 A141338/DKM','A1 J1344006HB','A8 369 954','B1 VAL698735','C9 E22HD88','A2 J1334036','A1 DCF113P','A1 U759','A3 JAP FO-ECO038','C9 1457429199','C4 1457429199','C9 50013621','A3 JAP FA-437S','B1 KNEOX163/4D','A9 J1334036','A9 UFI 25.027.00','A1 KL43','A9 J1324055','B7 E22H D88','A2 UFI 25.027.00','A8 920 437','A8 334 929','A8 366 102','C9 TSP0325141C','A2 CC1081','B1 HENE22H D88','A2 OX163/4D','B7 K1198-2X/AG','A1 J1314015HB','A9 1457429199','A3 JAP FAA-H04','A9 UFI 53.108.00','A9 KL43','C4 0450906442','A2 586504','C9 FA-437S','B7 A210144/DKM','A2 UFI 30.360.00','A9 0450906442','B1 BOS1987429178','B1 BOS1987432220','A1 A1209PU','C4 H279WK','C4 J1334036','B7 PP 978/IP','B1 PURA1209','B7 1218500100/JP','C9 0450906442','A3 MHL KL43','A2 J1314015','A9 LX1742','B1 FTROE648/4','C9 E1906LI','B1 BOS0450906442','B7 HF-8965/KAVO','A3 MHL LA122/S','A3 BOS 1457429199','B7 K 1198-2X/IP','A8 366 160','A3 FLT AP104/4')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #