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 OC 983','A3 VAC V24-0344','A3 VAC V46-0086','A5 80171','A3 VAC V24-7178','A3 FLT OP620/2','C4 0451103111','B1 KNEOC272','B7 A210010/DKM','A1 0451103354','C4 F026408900','A1 LS280APU','C9 0451103261','D1 BP ADL142104','A2 OC503','A8 929 360','A1 F112','A5 37627','B1 VAI46-0086','C9 H14W29','A2 UFI 23.434.00','A8 318 355','B1 CHACOF100112S','C4 S 6210 R','C4 OC 976','C4 H90W15','B1 HENH14W28','C4 W 714/4','C9 DO870','A1 WOF190','A1 OC983','B7 NO-2232/KAVO','B7 H90W15','A9 OC983','A8 371 109','B1 VAL586000','B1 BOS0451103354','A1 OC272','A2 OC976','A3 MHL OC976','A2 FI OP545','C9 DO1837','A9 SF OF0033','B7 H90W13','A1 OC503','A2 W714/4','A3 VAC V42-0050','B1 CHACOF100107S','A9 FI OP545','B7 A210025/DKM','A8 318 259','B1 FTROP545','C9 50013386','A9 OC503','A2 SF OF0003','A1 F133','C9 DO1801','B1 PURLS296','A8 315 284','B1 VAI24-0344','A2 0451103300','C4 H90W13','A8 315 293','A3 MHL OC100','A2 F026408900','C4 OC 503','C9 0451103111','C9 OF-986','A1 0451103300','C4 0451103300','A3 FLT OP545','A3 BOS 0451103300','C9 LS280A','C9 OF-940','A8 370 607','A1 F026408900','B1 HENH14W29','A2 H90W15','C4 LS715PU','B7 SM187','A3 MHL OC272','B7 OP 545/IP','B1 VAL586012','B7 H14W28','A8 305 885','B7 MO-445/KAVO','A9 W7058','A3 VAL 586012','A5 86383','C4 LS346PU','B1 KAMF102901','C9 DO289','A2 0451103261','A2 0451103111','A9 W712/16','B1 VAI24-0047','A3 JAP FO-699S','C9 LS296','A5 80527','A1 J1311023HB','B7 1518500300/JP','B1 MANW712/16','A8 312 828','C4 H14W28','A3 MHL OC983','A8 365 958','C4 LS867BPU','A1 W7058','A8 338 889','C9 H90W13','A2 UFI 23.449.00','A5 40950','A8 370 401','A1 OC100','A5 40932','A2 OC983','B1 VAL586109','B1 BOSF026408900','B1 VAL586051','B1 BLPADL142104','A8 315 169','A5 80443','C9 ADL142104','A8 315 285','A1 0451103111','B7 SM131','B1 FTROP537/1','A8 313 812','B1 HENH90W15','B7 OP 537/1/IP','C9 LS715','A3 VAC V24-0047','B1 HP720 801','B7 SM158','C4 OC 272','C4 0451103261','A2 0S 3530 R','A1 LS867BPU','A3 BOS 0451103261','A9 SF OF0003','A2 W712/16','B7 W7058/AG','A8 319 024','A2 H14W28','C9 W7058','A9 UFI 23.449.00','B1 CHACOF100122S','A2 SF OF0117','A1 50013386','B7 OP537/1/AG','C9 FO-189S','B7 SM168','C9 LS346','C4 S 3293 R','C4 O0600DREIS','B1 KAMF105101','B7 OP 540/1/IP','C9 H14W28','A1 WOF128','C9 0451103300','B7 OP540/1/AG','A2 0S 6210 R','A3 JAP FO-189S','B1 VAL586037','C9 71760811','A2 FI OP537/1','A1 WOF118','A8 926 329','C9 DO930','A9 UFI 23.293.00','A9 FI OP537/1','A1 OC287','C4 S 9150 R','C9 H90W15','A9 OC976','C4 W 7058','A2 SF OF0033','B1 VAI24-7178','B1 KNEOC503','A3 FLT OP537/1','C9 0451103354','A1 WOF238','B1 BOS0451103261','A1 LS296PU','A1 W714/4','A1 0451103261','A8 313 487','A3 BOS 0451103111','B1 KAMF101301','C9 50013545','A8 336 231','C9 DO818','B1 KAMF100401','A1 LS346PU','A2 UFI 23.293.00','A2 OC272','A9 SF OF0117','C4 OC 100','B1 HENH90W13','A1 F106','B7 A210008/DKM','C9 50013361','B7 A210274/DKM','A9 FI OP540/1','B7 OP545/AG','B1 CHACOF100118S','C4 O0563DREIS','A1 OC976','A2 0451103354','B1 PURLS867B','B1 VAI42-0125','A2 OC287','C9 FO-699S','B7 10189/JAPKO','B1 MANW714/4','A1 50013386/10','C9 W714/4','B1 PSAE149130','A9 W714/4','C4 COF100118S','A3 VAC V42-0125','A9 UFI 23.414.00','B1 PURLS346','A5 43667','C9 LS867B','A9 0451103111','C9 71760124','A3 BOS 0451103354','B1 BOS0451103300','A5 37628','A9 OC272','C9 OF-1076','A2 62 93 1300','A1 WOF198','C9 W712/16','B1 FTROP540/1','A3 MNN W714/4','A2 OC100','A3 MNN W712/16','C9 71760130','C4 H14W29','B7 H14W29','C4 COF100107S','B1 PURLS715','A9 0451103261','A9 0451103354','B1 KNEOC976','C9 DO912','C9 OF-888','B1 MANW7058','A1 WOF146','A2 W7058','A3 MHL OC287','A3 MHL OC503','A1 LS715PU','A3 FLT OP540/1','A5 82090','A1 W712/16','C4 W 712/16','B1 KNEOC983','B7 A210064/DKM','B1 BOS0451103111','A3 BOS F026408900','A9 0451103300','A5 202462','C9 F026408900','C4 LS296PU','A2 O79/100.9','B1 VAI42-0050','C9 DO1815','C4 LS280APU','B1 PURLS280A','B7 SM113','A5 38179','C4 0451103354','A1 10-01-189ASK','A5 372328','A3 KAP MO-445','A2 UFI 23.414.00','A5 200757','C9 2145970000','A2 FI OP540/1','C4 S 0130 R','A1 W7053','A1 W716/1','A2 W7053','A5 202456','A8 303 186','A9 W7053','B1 MANW7053','B7 W7053/AG','C4 O0601DREIS','C4 W 7053','C9 2143220002','C9 W7053')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #