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