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 ('C9 1457429138','A2 1457429119','B1 FEB24661','B1 BOS1457429263','B1 BOS1457429119','C4 24661F','C9 E11HD57','A2 FI OM591/1','A2 OB65/115.0','A1 1457429263','C9 FE27191','B7 OE 649/2/IP','A5 43136','A5 36002','A2 UFI 25.013.00','B7 OE677/AG','B7 OE 677/IP','B7 HU718/1Z/AG','A3 BOS 1457429119','A2 UFI 25.002.00','A8 369 858','C9 ADH22116','B1 FTROM591/1','C9 1457429116','E6 FL1198','A8 369 856','B7 E11H D57','A1 WOF1845','A1 OX153D3','B1 KNEOX345D','C4 1457429263','A8 359 393','A1 E11HD57','C9 FE26688','C4 E11H D57','A1 10-ECO021ASK','A8 318 749','C4 O0279DREIS','A1 WOF108','A1 WOF139','B1 HENE11H D57','B7 OE 640/5/IP','D1 BP ADH22116','B7 SH429','A1 L305PU','A9 OB65/115.0','A3 FLT OE649/2','A5 35956','C4 HU 718/1 Z','E6 FL1178','B1 KNEOX153D3','A9 1457429119','A9 1457429263','C4 26688F','A8 350 989','B7 OM591/1/AG','B7 E11H D50','A9 UFI 25.013.00','B1 PURL307','B1 FEB27191','D1 BP ADA102102','A8 320 514','A5 266306','B1 FTROE677','A8 366 137','B1 PURL305','A3 MHL OX153D2','A8 359 333','C9 L305','B1 FTROE640/5','C9 ADA102110','B1 BLPADH22116','A1 32910 FE','A9 FI OE649/2','C9 L307','B7 SH425P','A8 366 186','B1 FTROE683','A9 UFI 25.001.00','A1 1457429138','A2 UFI 25.001.00','C9 1457429263','B1 BLPADJ132116','A8 344 226','C9 ADJ132116','A2 FI OE640/5','A1 HU718/1Z','A8 312 989','A5 158250','A2 1457429263','A1 1457429196','C9 ADA102105','C4 S 5013 PE','C4 OX 153D3','C9 E11H01D50','C4 E11H D26','C4 L311PU','B1 KAMF105401','B7 E11H D26','C9 FE24661','C4 L305PU','C9 ML479/A','A1 OX345D','A5 266309','A9 FI OE677','B1 FEB26688','B1 FTROE649/2','D1 BP ADA102110','A1 OX153D2','A3 FLT OE640/5','B1 BLPADA102102','A2 FI OE649/2','C9 ADA102102','A8 359 447','B7 OE649/2/AG','A9 FI OM591/1','A1 27191 FE','C9 HU718/1Z','C4 OX 153D2','A3 BOS 1457429116','A5 44042','A8 366 149','B1 PURL311','B1 MANHU718/1Z','B7 1ECO021/JAPKO','A2 E11H D57','C9 1457429119','B7 OE 683/IP','B1 BLPADA102110','A3 MHL OX345D','C4 L307PU','A1 26688 FE','A2 E11HD57','A9 OX153D2','A1 1457429119','A3 FLT OE683','C9 MD-337C','B7 OE683/AG','A8 320 546','A2 FI OE683','A3 FLT OE677','D1 BP ADJ132116','A2 HU718/1z','C9 1457429196','A1 OX153D','A1 L311PU','C4 1457429119','A3 MHL OX153D3','C9 L311','A5 372221','A9 E11HD57','C9 E11HD26','A9 FI OE640/5','B1 FEB32910','D1 BP ADA102105','A8 314 161','A9 HU718/1z','E6 FL1160','A8 305 659','A2 OX153D2','C9 MD-337D','B7 OE640/5/AG','A1 24661 FE','B7 HO-828/KAVO','B7 SH4063P','A9 FI OE683','B1 KAMF103501','A3 MNN HU718/1Z','A1 1457429116','C9 SH425/1P','A3 FLT OM591/1','A2 OX153D3','B1 BLPADA102105','B1 HENE11H D26','A3 BOS 1457429263','A9 OX153D3','A9 E11H D57','B7 OM 591/1/IP','B1 KNEOX153D2','C9 FE32910','A2 FI OE677','A8 351 690','C4 S 5001 PE','A9 UFI 25.002.00','A1 L307PU','A8 366 136','A3 KAP HO-828','A2 24661FEBI','C9 ML479','A3 MNN HU718/1K','D3 BO 1457429116','D3 FM CH9301ECO','D3 MUH HU 718/1 K','D3 PK 125276','D3 PU L25276','A1 586501','A1 HU718/1K','A1 HU718/5X','A1 J1314016HB','A1 XE508','A2 FI OE640/2','A2 HU718/1k','A2 HU718/5x','A2 SF OF0129','A2 SF OF0369','A3 FLT OE640/2','A5 202371','A5 202373','A8 307 100','A8 320 534','A8 332 464','A9 HU718/1k','A9 HU718/5x','A9 SF OF0129','A9 SF OF0369','B1 BLPADH22121','B1 CHACOF100508E','B1 FEB38716','B1 FTROE640/2','B1 KAMF108001','B1 MANHU718/1K','B1 MANHU718/5X','B1 VAI20-0625','B1 VAL586501','B7 A210073/DKM','B7 HU718/1K/AG','C4 HU 718/1 K','C4 HU 718/5 X','C4 O0276DREIS','C4 O0282DREIS','C9 0140180010','C9 0140180012','C9 3141140001','C9 ADH22121','C9 HU718/1K','C9 HU718/5X','A2 OB65/115.2')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #