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 ('C4 H90W13','B7 SM187','A5 80897','C9 16-143220001','A8 365 948','B1 VAI24-0047','A3 MNN W716/1','C9 DO912','A1 W7058','C9 LS923','A3 VAC V46-0086','C9 0451103299','B1 KNEOC503','A3 VAC V24-0047','A9 J1311023','B1 VAI42-0125','C9 W712/47','A2 F026407353','A2 OC976','C9 OF-727','A1 LS867BPU','A5 40946','B7 OP 540/1/IP','B1 BLPADT32116','A3 MHL OC100','C9 F026408900','A9 W712/47','C9 DO1837','C9 H90W13','E3 214 322 0002','C9 W716/1','C4 J1311023','C4 W 7058','B1 VAI46-0086','A5 86383','B1 VAL586002','C9 DO930','C4 W 716/1','B1 BOS0451103261','C9 LS592A','A8 338 889','B1 FTROP540/1','A2 SF OF0003','C9 W7053','A5 80171','A2 FI OP540/1','C9 0451103111','A8 365 933','A2 H90W21','B1 HP720 801','A5 40953','A2 UFI 23.293.00','A8 321 237','C9 H90W21','A2 J1311023','C9 0451103355','C4 S 3293 R','C9 71760130','A5 372328','C4 0451103111','A3 MHL OC976','A3 BOS 0451103355','A9 0451103299','A9 UFI 23.293.00','B1 CHACOF100136S','A8 312 839','A8 929 360','B1 VAI42-0050','C9 LS867B','A3 VAC V25-0144','A2 F026408900','C4 OC 503','C9 DO1801','B1 PURLS592A','B1 BOSF026407353','A1 OC503','A2 OC503','B1 PURLS923','A8 315 293','B1 VAI24-7178','B1 MANW7053','A1 W712/47','A9 W7053','A9 OC503','A2 586002','A2 586027','C4 S 5030 R','A3 JAP FO-189S','B1 PSAE149134','A1 J1311023HB','A3 VAC V24-7178','A3 BOS F026408900','B1 BOS0451103111','A8 313 812','A2 62 93 2223','C9 OF-888','C4 COF100118S','B1 BOSF026408900','A9 SF OF0003','C9 W7058','B7 SO-917A/KAVO','D1 BP ADT32116','C9 ADT32116','A3 FLT OP540/1','C4 0451103261','A8 303 186','A2 W712/47','A1 0451103261','C9 50013386','B1 HP720 803','A3 MNN W712/8','B1 CHACOF100118S','A9 OC976','B1 BOS0451103355','C9 W712/8','B7 1518500300/JP','C9 0451103261','A1 WOF128','B7 MO-429/KAVO','E3 16-14 322 0001','B1 BOS0451103299','A5 40932','A5 202462','A8 371 109','A9 FI OP540/1','A2 0451103299','A1 0451103355','B7 H90W23','A1 LS923PU','B1 HENH90W13','A2 OC100','C4 W 712/8 SD','B7 W7053/AG','C9 FO-189S','A5 202456','B1 VAL586000','B1 KAMF100401','A9 UFI 23.401.00','B7 H90W13','A1 0451103299','C4 W 712/8 (10)','A1 J1312028HB','C4 H90W23','A5 40950','A2 0451103111','B1 PSAE149130','A5 37628','B1 MISZ401','C4 COF100136S','B1 VAL586027','B7 W7058/AG','A9 UFI 23.439.00','C4 F026408900','A2 UFI 23.401.00','A3 BOS 0451103299','C9 OF-943','A9 0451103355','A8 313 487','A2 UFI 23.439.00','C4 LS867BPU','A5 80200','C4 LS923PU','A2 0451103261','A1 W716/1','A3 KAP HO-611','C4 OC 976','A3 BOS 0451103261','A1 OC976','A1 50013386','B7 OP540/1/AG','B1 MANW716/1','B7 HO-611/KAVO','A3 KAP MO-429','B7 H90W21','A8 315 291','C4 S 0130 R','B1 VAI25-0144','B1 MANW712/47','C4 O0601DREIS','C4 W 7053','C9 2143220002','C4 LS592APU','A8 926 329','E3 2 143 220 002','C9 SP-943','A1 LS592APU','A1 WOF180','A2 W7058','A1 0451103111','A9 0451103111','C9 DO884','A1 W7053','C9 50013361','B1 MANW712/8','B1 PURLS867B','A2 0451103355','A1 WOF146','A3 MHL OC503','A8 306 367','A9 W7058','C4 H90W21','C4 0451103299','A3 VAC V42-0125','B1 HENH90W21','A3 BOS 0451103111','A8 315 286','A1 OC100','C4 W 712/8','C9 H90W23','A8 380 014','C9 DO332','B1 HENH90W23','A3 VAC V42-0050','B1 KNEOC976','B7 SM113','A9 0451103261','A3 KAP SO-917A','A1 W712/8','A1 50013386/10','A1 10-01-189ASK','B7 A210008/DKM','C4 0451103355','A2 W7053','C4 W 712/47','B1 MANW7058','A1 F026408900','C4 OC 100','A3 MNN W712/47','A1 W7063','A2 FI OP540/3','A2 W7063','A3 FLT OP540/3','A8 424 971','A8 916 032','A8 920 175','A9 W7063','B1 FTROP540/3','B1 MANW7063','C4 W 7063','C9 00500828','C9 OF-6370','C9 W7063')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #