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