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 SF OF0066','B7 OP 536/IP','A5 385474','A3 FLT OP617','C4 OC 239','B1 KAMF104001','A1 J1319019HB','A8 365 888','C4 S 6902 R','A9 SF OF0066','B1 KNEOC115','A8 318 255','A2 J1314012','A3 KAP HO-818','A3 JAP FO-498S','B7 FO-013A/KAVO','A1 OC500','B1 KAMF118901','A1 0986AF1034','A2 UFI 23.259.00','B7 SM104','A9 OC1177','A5 202470','C9 DO324','C9 OF-934','C4 J1314010','C9 DO854/A','A3 KAP HO-823','A5 30117','A9 J1315015','A2 SF OF0063','A9 W814/80','A9 J1314010','B1 PURLS280A','C9 OF-1006','A3 FLT OP536','A2 W87','C9 F026407200','A3 KAP MO-422','A1 OC239','A2 SF OF0054','B7 MO-422/KAVO','A8 300 081','A2 W815/80','C9 W815/80','A3 MHL OC1288','B7 SM166','A1 WOF191','B1 CHACOF100110S','C4 W 87','B1 VAL586017','A2 OC1673','B1 FTROP536','C4 OC 115','A1 50013146','C4 J1317003','C9 SP-959','C9 DO912','A3 MNN W87','B7 MO-429/KAVO','A1 OC1673','A8 365 829','C9 H20W07','C4 J1317005','B1 MANW815/80','A8 320 521','A3 MNN W811/80','A3 KAP MO-429','A5 30187','A3 MNN W814/80','A8 920 092','A2 UFI 23.133.00','A2 W814/80','A2 OC230','A8 926 772','A9 FI OP536','C9 W87','A5 30160','B1 KNEOC230','C4 W 814/80','B7 MO-510/KAVO','A1 50013386/10','B1 KNEOC1177','B7 HO-823/KAVO','A3 VAC V32-0018','B1 KAMF113501','A8 370 382','C4 H13W01','A2 J1314010','C9 W811/80','B1 HENH13W01','A9 UFI 23.159.00','A3 MHL OC239','B7 HO-605/KAVO','B7 SM121','B7 10498/JAPKO','A1 F208','A3 KAP HO-605','A2 J1317003','C9 71758747','C9 OF-0410','A9 SF OF0063','A9 OC205','B7 W811/80/AG','B1 MANW811/80','B7 SM125','A9 N1310510','A3 MHL OC1673','B1 VAI32-0018','A9 SF OF0054','B7 MO-432/KAVO','B1 BOSF026407200','A1 0986452008','A1 OC205','A9 OC115','B1 MANW814/80','A2 UFI 23.159.00','A9 FI OP557','C9 OF-1094','A3 MHL OC1254','B1 CHACOF100208S','C9 W814/80','C9 71758743','A9 J1317004','A2 OC115','A9 UFI 23.133.00','A3 MNN W815/80','A2 J1315015','A1 W815/80','C9 H13W01','A1 OC1254','C4 J1317004','B7 H13W01','B7 SM124','A5 250135','A3 MHL OC205','A1 J1317003HB','C9 FO-498S','B1 KAMF104701','A9 OC239','C9 DO828','C4 J1315015','A1 W87','B7 H20W07','A5 27488','B7 HO-816/KAVO','A1 WOF120','C4 N1310510','A3 JAP FO-599S','A1 OC1177','A9 J1317005','B7 A210021/DKM','B7 A210039/DKM','A1 10-04-498ASK','C9 DO925/A','A9 UFI 23.259.00','A3 JAP FO-705S','B7 OP 557/IP','A3 FLT OP557','C4 S 6900 R','A9 J1317003','A2 FI OP536','A2 FI OP617','A9 OC230','B7 A210023/DKM','C4 S 6901 R','A3 MHL OC500','B7 OP617/AG','A9 W87','C9 LS280A','B7 HO-818/KAVO','A3 MHL OC1177','A1 OC115','A1 F110','C4 OC 205','A1 50013386','C9 SP-961','A1 OC 230','C9 OF-961','A2 W811/80','C9 DO328','A1 OC 205','A9 OC1673','B7 HO-824/KAVO','A9 W811/80','C4 COF100208S','C4 W 815/80','A1 LS280APU','B1 CHACOF100128S','A2 OC1254','A2 OC1288','A3 KAP HO-824','A2 J1317004','A5 208501','C4 LS280APU','C9 35-143220002','A1 10-07-705ASK','A8 318 330','C4 O0650DREIS','B7 SM134','C4 J1314012','C9 SP-934','A1 OC230','A2 FI OP557','C9 50013386','B1 FTROP617','C4 COF100110S','B7 10705/JAPKO','A9 OC500','B7 OP557/AG','C9 31-143220005','A2 OC1177','A5 80527','A9 J1314012','A2 J1314010F','C9 SP-1006','C9 71758756','A3 VAC V26-0012','A9 OC1288','B1 KAMF102001','A8 345 060','A3 KAP MO-432','A2 OC205','A2 J1317005','C9 FO-705S','B1 KAMF103301','B1 FTROP557','A9 FI OP617','B1 VAL586016','A2 UFI 23.461.00','C9 OF-919','C4 W 811/80','B1 KNEOC500','A8 300 100','A2 OC500','A5 372458','A1 W811/80','A2 OC239','C9 50013146','C9 FO-599S','C9 71758725','A1 10-05-599ASK','A8 365 902','A1 W814/80','A8 315 284','A5 27476','A5 13603','A2 UFI 23.243.00','C4 COF100128S','A9 UFI 23.461.00','A3 MHL OC230','A9 UFI 23.243.00','B7 OP 617/IP','B1 KNEOC1673','B7 A210159/DKM','B1 KAMF101401','B7 10599/JAPKO','A9 OC1254','B1 MANW87','A2 N1310510','A3 MHL OC115','C9 SP-937','A1 F026407124','A1 LS489APU','A1 W610/6','A1 WOF197','A2 F026407124','A2 FI OP575','A2 N1317009','A2 W610/6','A3 BOS F026407124','A3 FLT OP575','A5 174793','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','C4 F026407124','C4 O0539DREIS','C4 W 610/6','C9 F026407124','C9 W610/6')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #