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