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 ('A9 OX153D3','A1 1457429263','A9 FI OE640/5','A3 MHL OX153D3','C4 OX 153D3','B7 1ECO006/JAPKO','A5 44042','A3 FLT OE677/4','A1 10-ECO021ASK','C9 1457437001','A8 314 292','A3 BOS 1457429116','A2 F026407112','A9 E11HD57','C9 MD-683','C4 1457437001','A2 UFI 25.159.00','A1 OX153D3','A8 320 534','C4 O0282DREIS','B7 OE640/5/AG','C9 E11HD204','A9 1457429263','A2 UFI 25.002.00','A2 HU7010z','C4 E11H D57','A9 HU718/5x','B1 HENE11H02 D155','A3 VAC V30-0931','A8 357 460','C9 FO-ECO021','A9 FI OE640/2','A2 FI OE677/4','A2 FI OE640/2','C9 0140180012','A8 312 989','C4 HU 7010 Z','C9 L305','A3 MNN HU7010Z','A8 369 855','A2 E11H02D155','B1 HENE11H D57','A3 BOS F026407112','B1 BOS1457429263','A1 1457429138','B1 VAI40-0092','A5 272964','A2 N1311040','C9 F026407112','B1 MANHU718/1K','A1 XE508','A1 OX92D','C9 FE24661','B1 VAL586501','A1 L311PU','A9 N1311040','A5 266306','C4 OX 153/7D2','B1 TRU02.18.032','A3 VAC V30-0859','C9 MD-337D','A2 1457437001','C9 OF-337D','A1 HU718/5X','B1 FEB24661','C9 E11HD155','B1 KNEOX153D3','C9 71758815','B1 BOS1457437001','A5 202355','A2 24661FEBI','B1 PURL311','A9 FI OE677/4','A8 366 137','A3 VAC V30-0860','A2 HU718/5x','C4 S 5013 PE','B7 A210073/DKM','B7 OE 640/2/IP','B1 FTROE677/4','A2 1457429263','A8 931 589','C9 FO-ECO006','A3 TRU 02.18.032','A5 36002','A1 10-ECO006ASK','B1 VAI30-0860','A5 294016','A5 202373','A1 E11HD204','C9 SH425/1P','A1 F026407112','C9 E11H01D50','B7 E11H D57','A5 158250','C9 MD-337C','A9 E11H D204','C9 L509','B7 1ECO021/JAPKO','A8 369 859','A2 E11H D57','B1 KAMF103501','B1 MANHU7010Z','A8 370 790','C9 1457429116','A9 OX92D','C4 E11H D155','A9 1457437001','C4 N1311040','B7 HU718/1K/AG','B7 OE640/2/AG','A8 914 278','A9 HU7010z','A8 332 464','C4 O0276DREIS','A3 MNN HU718/5X','A9 HU718/1k','C4 L311PU','B1 PURL509','A2 E11HD57','A3 MHL OX92D','C4 E11H D204','A9 SF OF0129','A9 UFI 25.013.00','A2 UFI 25.013.00','A5 91665','B7 E11H D204','A2 SF OF0129','A1 E11HD57','C4 HU 718/5 X','A1 WOF1845','B1 HENE11H D155','B7 OE677/4/AG','B7 E11H D155','A5 202371','C9 02.18.032','B1 HENE11H D204','A3 VAC V40-0092','B1 CHACOF100508E','C4 HU 718/1 K','A3 MNN HU718/1K','A2 HU718/1k','A2 FI OE640/5','A5 40955','C9 1457429263','A1 HU7010Z','A2 OX153D3','A1 1457429116','A5 185004','C9 ML479/A','A8 358 642','A2 OX153/7D','A8 375 535','B7 OE 640/5/IP','A5 66004','C9 HU718/1K','C4 O0243DREIS','A1 J1311038HB','A8 366 149','C9 1457429138','C4 COF100508E','A2 E11HD155','A3 MHL OX153/7D','A3 FLT OE640/5','A9 4.64471','A1 HU718/1K','A8 307 100','A3 JAP FO-ECO021','A5 372221','A1 1457437001','A8 369 858','C4 1457429263','A3 FLT OE640/2','C4 L305PU','A8 318 749','A1 WOF1872','B1 FTROE640/2','A9 OX153/7D','C9 HU718/5X','B1 MANHU718/5X','B1 BOSF026407112','A1 24661 FE','A1 OX153/7D','C9 E11HD57','C9 HU7010Z','C4 E11H02 D155','A2 4.64471','C9 L311','B1 PURL305','A1 OX153/7D2','A1 586501','A1 WOF108','C4 24661F','B1 VAI30-0931','A3 BOS 1457429263','A5 49300','B1 VAI30-0859','A9 E11H D57','A2 OX153/7D2','A9 UFI 25.159.00','C4 F026407112','A3 TRU 02.18.140','A3 JAP FO-ECO006','B1 FTROE640/5','A8 350 989','B1 TRU02.18.140','B7 OE 677/4/IP','A3 BOS 1457437001','C4 OX 153/7D','A2 586501','A9 F026407112','A1 L305PU','C9 E11H02D155','C9 50013570','B7 E11H02 D155','A2 OX92D','A3 MHL OX153/7D2','A9 UFI 25.002.00','A2 E11H D204','A9 OX153/7D2','C9 1001150000')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #