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