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 ('A5 294016','A1 WOF1845','C4 E11H D155','A5 49300','A2 N1311040','A2 OX345/7D','A9 FI OE640/2','C9 FO-ECO021','A1 OX153D3','B7 E11H02 D155','C9 1457429263','A9 OX153/7D','A3 MHL OX345D','A3 MNN HU7010Z','A1 E11HD204','A9 SF OF0369','A2 FI OE640/2','C4 COF100509E','A1 OX153/7D','C9 FO-ECO006','A1 1457437001','B1 VAI40-0092','A9 1457429263','A3 MNN HU718/1K','A2 HU718/5x','A3 TRU 02.18.032','C9 L305','A2 F026407112','A8 359 393','B1 PURL1072','A2 586501','C9 F026407112','B1 VAI30-0860','C4 N1311040','A3 MHL OX153/7D','C9 ADA102102','A1 1457429138','B1 CHACOF100509E','A8 332 464','A5 44042','C4 HU 7010 Z','A3 BOS 1457437001','B7 SH425P','C4 HU 718/1 K','A8 370 790','A2 E11H02D155','B1 BOSF026407112','A5 66018','B7 HU718/1K/AG','A3 FLT OE640/5','A1 XE509','B7 1ECO006/JAPKO','A2 FI OE640/5','B1 VAI30-0931','C9 OF-337C','C4 O0282DREIS','A2 HU718/1k','A1 OX345/7D','C4 1457429263','C9 MD-337D','C4 1457437001','A2 HU7010z','C9 02.18.032','A9 UFI 25.002.00','A5 202355','C4 F026407112','A5 40955','A1 HU718/1K','C4 L305PU','C9 L311','A9 1457437001','B1 MANHU718/1K','A5 271879','A8 320 534','A9 OX345/7D','A2 SF OF0369','B7 OE640/5/AG','A9 E11H D57','B7 E11H D204','A3 JAP FO-ECO006','C9 1457429196','A9 F026407112','A5 202371','A8 350 989','A2 4.64471','A1 L311PU','B1 BOS1457429263','A1 1457429116','A1 1457429263','C9 ML487/A','A1 HU7010Z','A3 VAC V30-0931','A3 MNN HU718/5X','A8 358 642','A9 HU718/1k','B1 MANHU718/5X','A2 UFI 25.002.00','E6 FL1198','A5 266306','A1 1457429196','C9 0140180012','A3 VAC V40-0092','A5 202373','A2 E11H D204','B1 PURL305','A1 E11HD57','C9 MD-337C','A3 BOS 1457429116','A3 VAC V30-0860','B7 OE 640/5/IP','B1 MANHU7010Z','A1 HU718/5X','A2 E11H D57','A9 OX153D3','A8 314 292','D1 BP ADA102102','A9 N1311040','C9 E11H02D155','A2 E11HD155','A3 MHL OX153D3','A9 FI OE640/5','A8 369 855','A3 JAP FO-ECO021','A8 366 137','C4 OX 345/7D','A2 E11HD57','A5 66004','B7 OE 640/2/IP','A2 SF OF0129','C4 E11H D204','A8 318 749','C9 E11H01D50','A1 OX345D','C9 E11HD155','A5 158250','B1 TRU02.18.032','B1 BOS1457437001','C9 1457429116','C9 1457437001','C4 E11H D57','C4 L311PU','A2 1457437001','B1 BLPADA102102','A3 BOS 1457429263','A9 HU718/5x','C9 E11HD204','B1 TRU02.18.140','A1 WOF108','A8 312 989','A8 369 858','C9 HU718/5X','C4 E11H02 D155','C4 OX 153/7D','C4 0986TF0095','A5 372221','A3 TRU 02.18.140','C4 O0276DREIS','B1 KNEOX153/7D','B1 HENE11H D204','B1 PURL311','A1 586501','A3 FLT OE640/2','C9 HU7010Z','A1 WOF1872','A5 36002','A9 HU7010z','A8 369 859','A1 F026407112','C4 O0243DREIS','B1 KAMF108501','A8 307 100','A9 E11H D204','A8 914 278','B1 HENE11H02 D155','A5 272964','C9 0140180010','A9 SF OF0129','B7 E11H D57','B7 OE640/2/AG','A2 1457429263','A2 OX153/7D','A1 L305PU','A3 VAC V30-0859','C9 E11HD57','B1 KNEOX153D3','A3 BOS F026407112','B1 VAI30-0859','A2 OX153D3','B1 FTROE640/2','C4 OX 153D3','B1 HENE11H D155','B1 VAL586556','A3 MHL OX345/7D','C4 HU 718/5 X','C9 50013568','A9 E11HD57','B1 VAL586501','B1 FTROE640/5','B7 E11H D155','C9 1457429138','A1 J1311038HB','A9 4.64471','C9 HU718/1K','B1 HENE11H D57','B7 A210264/DKM','C9 0143220014')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #