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 ('F2 1000375648','C9 W87','F4 DECA210021','C9 OF-922','C4 S 6902 R','F2 1000289455','F4 VAL586017','C9 W811/80','A5 30160','C9 DO912','B1 FTROP617','A2 UFI 23.461.00','F2 1001352780','A9 OC1673','F4 WIXWL7171','A9 UFI 23.133.00','A2 UFI 23.243.00','C4 O0650DREIS','A9 OC115','C4 S 6901 R','A8 327 462','C9 DO925/A','F4 KAOF118901','A9 FI OP536','F2 1004032115','F4 FILOP536','F4 FILOP557','F4 VAL586170','C9 F026407200','A9 OC239','B1 JPN10F9078-JPN','B9 MAN W811/80','A3 KAP HO-605','A3 KAP MO-422','F4 KAVHO-824','A9 N1310510','B7 OP557/AG','F4 ASH10-01-120','A8 370 382','B1 KAMF104701','C4 OC 115','C4 J1314012','B1 PURLS280A','B1 FTROP536','B7 HO-824/KAVO','B7 SM134','F4 MAHOC205','F2 1011556311','A8 327 474','F4 DECA210159','F2 1004032215','C4 OC 239','C9 FO-498S','A2 SF OF0063','A8 315 284','A9 W87','F4 KAOF103301','C9 FO-120S','B1 HENH13W01','B7 SM104','B1 KAMF104001','A9 OC500','B1 KNEOC500','C4 COF100128S','B7 W811/80/AG','C9 OF-934','C9 50013146','A3 VAC V26-0012','F4 MAHOC230','B1 CHACOF100208S','A8 320 521','C9 31-143220005','F2 1000621504','F4 UFI23.461.00','C9 DO828','F4 SCTSM104','F2 1004032105','F4 KAVMO-432','F4 FILOP617','F4 MADFKHYD008','B7 SM121','F4 MAHOC1254','A2 OC1288','A3 MHL OC115','A2 J1314010F','A8 327 389','B1 MANW814/80','A8 926 772','F4 ASH10-07-705','A3 MNN W87','A5 234434','F2 1000743272','F4 KAVMO-422','A2 OC239','B1 PPF1F0058','A5 80527','B7 10498/JAPKO','B1 PPF1F0027','F4 KAVFO-013A','A2 SF OF0066','A3 MHL OC1288','A2 OC1673','A3 KAP HO-824','F4 DECA210023','B7 HO-605/KAVO','C4 COF100208S','F4 UFI23.653.00','F2 1001779527','B7 A210039/DKM','F4 MANW814/80','F4 KBS50013109/3','F4 KAOF101401','B7 OP 536/IP','A8 365 829','F2 1000254999','A9 OC230','A8 926 185','F4 MAD15131','A9 UFI 23.159.00','A5 37986','C9 FO-599S','A8 365 888','C4 W 87','A9 OC205','B7 10120/JAPKO','A3 MHL OC239','A3 MNN W811/80','B1 MANW815/80','F4 KAOF102001','A5 208501','A3 KAP MO-429','B1 KNEOC115','B1 JPN10F7001-JPN','A3 MHL OC500','F4 SCTSM121','A8 345 060','F4 MADFKKIA001','A9 J1317005','F2 1018863529','C9 35-143220002','F4 ASH10-05-599','B7 HO-818/KAVO','C9 SP-1006','A2 N1310510','F4 MAHOC1177','C4 N1310510','C9 OF-1006','F2 1009329333','F4 HENH13W01','F4 KAOF113501','A9 FI OP557','B7 10599/JAPKO','A3 MHL OC205','F2 1018863536','B1 KAMF118901','C9 SP-961','A3 KAP HO-823','B1 VAL586017','A2 J1314012','F4 KBS50013386','B7 MO-432/KAVO','F4 FEB193871','C9 SP-959','B7 FO-013A/KAVO','B1 FTROP557','A8 300 081','C4 OC 205','B7 MO-510/KAVO','C9 OF-961','C9 W814/80','A2 W814/80','A5 27488','A9 SF OF0066','B7 HO-823/KAVO','A3 MHL OC1673','A5 30117','C9 SP-937','F4 UFI23.243.00','A3 KAP MO-432','A8 920 092','C9 OF-0410','F4 KAVMO-429','A2 OC1254','A3 MHL OC1177','C4 J1317004','A5 30187','F4 MANW815/80','A2 W87','C4 J1314010','A5 372458','F4 WIX51064','A2 SF OF0054','B7 H20W07','B1 FASFT38019','A8 371 135','C9 FO-705S','C9 71758747','C4 W 811/80','A9 W814/80','C9 H20W07','A2 UFI 23.259.00','A9 J1317004','A9 SF OF0054','F4 MAHOC1673','B7 OP617/AG','A2 J1317004','A2 J1314010','C9 71758756','B7 MO-422/KAVO','B1 PPF1F0009','A9 OC1288','A2 OC1177','F4 UFI23.133.00','A2 W811/80','A5 27476','F2 1000304101','B9 JAP FO-705S','F4 DECA210039','F2 1000743267','F2 1009296840','F4 MAD15096/1','A5 250135','C9 LS280A','A3 FLT OP536','A8 318 330','B1 JPN10F0303-JPN','A9 J1314010','A9 W811/80','C9 DO854/A','A3 MNN W815/80','C9 DO324','F4 KAVFOF-10006','B1 MANW87','B1 KNEOC1177','B1 JPN10F4001-JPN','B1 CHACOF100128S','B1 PPF1F0152','F2 1009296849','F4 MAD15069','B7 A210021/DKM','A2 UFI 23.159.00','B1 JPN10F7002-JPN','A8 328 894','A2 OC205','B1 VAI32-0018','F4 BOFF026407200','A5 202470','C4 S 6900 R','C4 J1317003','B1 OYO10F7001-OYO','A2 FI OP536','B7 A210023/DKM','B1 PPF1F0017','B7 MO-429/KAVO','F4 MANW87','A5 13603','F2 1003118317','A3 JAP FO-498S','B7 SM125','A2 FI OP617','F4 MAHOC239','C9 DO328','A2 J1317003','B1 CHACOF100110S','C4 H13W01','A9 FI OP617','F4 MAHOC500','B1 KAMF113501','F4 KAVTO-149','A5 385474','A3 VAC V32-0018','B7 SM124','A9 J1314012','A2 J1315015','C9 OF-1094','F4 MADFKHYD013','A2 J1317005','B1 KAMF103301','C9 71758743','F4 KBS50013146','A9 OC1177','F4 MAHOC115','B1 JPN10F3002-JPN','C4 W 815/80','F4 MANW811/80','B1 PPF1F0018','A2 OC500','B7 SM166','C9 71758725','F4 MMA71758747','F4 KBS50013108','A9 UFI 23.461.00','F4 UFI23.259.00','F2 1000420760','F4 KAVHO-605','F4 KAVHO-823','A2 FI OP557','F4 PURLS280A','C4 LS280APU','F4 WIXWL7164','B1 MANW811/80','F4 WIXWL7081','F2 1001035936','A3 JAP FO-120S','A9 J1317003','A2 UFI 23.133.00','A3 JAP FO-599S','B1 BOSF026407200','F4 MADFKHYD002','F4 FASFT38019','F4 KAOF104701','A3 KAP HO-818','B9 JAP FO-120S','A9 SF OF0063','B7 HO-816/KAVO','A8 365 902','F4 DECA210042','A3 FLT OP617','A3 FLT OP557','F2 1001692211','F4 SCTSM134','C4 J1317005','F4 MAHOC1288','A9 UFI 23.259.00','B1 KNEOC1673','B7 OP 557/IP','B9 ALC SP959','F4 KAVFOF-10271','C9 OF-919','B9 JAP FO-498S','F2 1000084347','F2 1000056351','F4 TOP820 215','A3 MHL OC1254','B9 JAK J1317003','A3 JAP FO-705S','F4 MMA71758725','A2 OC115','B7 A210159/DKM','B1 KAMF101401','B1 JPN10F9115-JPN','A3 MHL OC230','C9 SP-934','B7 A210042/DKM','B1 PPF1F0156','B9 FLT OP557','F4 KAOF104001','B7 H13W01','B7 OP 617/IP','A3 MNN W814/80','A2 OC230','B1 KNEOC230','A2 W815/80','C4 W 814/80','C9 H13W01','F2 1000831550','F4 KAVHO-816','C9 50013386','C4 J1315015','A9 UFI 23.243.00','C4 COF100110S','B1 KAMF102001','B7 A210021-S/DKM','F2 1004032192','A8 318 255','F4 KAVHO-818','F4 MADFKHYD001','C9 W815/80','F4 MMA71758743','F4 ASH10-04-498','B7 10705/JAPKO','F2 1000111652','A8 300 100','A9 OC1254','F4 WIXWL7107','F4 MMA71758756','A9 J1315015','F4 KBS50013105','A2 J1314013','A3 JAP FO-410S','C4 J1314013','C4 O0537DREIS','C9 FO-410S','A2 F026407124','A2 FI OP575','A2 N1317009','A2 W610/6','A3 BOS F026407124','A3 FLT OP575','A5 174793','A5 230739','A5 272918','A8 318 339','A8 326 211','A8 349 237','A9 F026407124','A9 N1317009','A9 W610/6','B1 BOSF026407124','B1 FTROP575','B1 MANW610/6','B1 PURLS489A','B1 VAL586062','B9 FLT OP575','B9 MAN W610/6','C4 F026407124','C4 O0539DREIS','C4 W 610/6','C9 F026407124','C9 W610/6','F2 1000594945','F2 1001368883','F2 1001410126','F4 BOFF026407124','F4 FILOP575','F4 MANW610/6','F4 PURLS489A','F4 VAL586062')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #