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 ('A1 0986452016','A8 919 462','C9 SP-961','C9 ADS72101','A1 OC115','C4 OC 115','A9 UFI 23.271.00','A5 202470','A9 OC205','A9 UFI 23.243.00','A9 0986452016','A3 MHL OC115','D1 BP ADG02144','A9 J1315015','A8 361 750','A3 BOS 0986452036','A3 FLT OP617','B7 OP 617/1/IP','A2 W811/80','A2 J1315015','C9 0986452061','B1 BOS0986452016','A5 27476','A8 908 794','A9 W8017','B7 OP 595/IP','B7 OP617/1/AG','C9 DO324','A3 MNN W811/80','A1 0986452006','A1 F110','C4 J1317003','A9 OC115','B7 H20W07','C9 W811/80','C4 J1314010','C4 0451103316','E6 FL1037','A8 926 772','C9 H20W07','A2 OC230','C4 H90W25','A9 N1310510','A2 J1317003','D1 BP ADS72101','B1 PURLS415','A2 W8017','A8 350 614','C4 O0650DREIS','C4 OC 205','A5 44645','B1 FTROP617/1','A2 N1310510','A5 13603','A8 370 382','C4 J1317004','A2 J1317005','A1 WOF120','B1 BLPADG02144','A2 J1313002','A5 40935','A1 0986452036','C9 W8017','A9 J1313002','A8 313 537','B7 HO-701/KAVO','A9 UFI 23.583.00','A1 W8017','A9 J1314010','A8 320 521','B7 H97W06','A3 BOS 0986452006','A2 FI OP617/1','A1 H97W06','A2 UFI 23.271.00','A1 OC 230','A8 313 523','B7 10599/JAPKO','B1 BLPADS72101','C9 ADG02144','A5 174793','A2 0451103316','A1 J1317003HB','A9 W811/80','A8 318 352','B7 OP617/AG','C4 S 6901 R','C9 H13W01','A8 314 274','A8 300 100','C4 0986452036','B1 PURLS489A','B7 TO-149/KAVO','B1 MANW8017','C9 SP-1229','B7 W811/80/AG','A1 OC113','A2 H90W25','E6 FL1214','A5 372458','C9 0986452016','A8 360 033','C9 H97W06','A9 0451103316','A2 J1315025','C9 0986452036','C9 LS489A','C4 H13W01','A9 FI OP595','B7 MO-520/KAVO','A2 J1317004','A3 KAP MO-515','B7 MO-429/KAVO','B7 SM121','A5 432468','C4 S 6902 R','B7 SM104','B1 FTROP617','A8 318 852','C4 W 8017','A2 UFI 23.461.00','A2 0986452006','C4 J1313002','A8 365 590','B1 PURLS350','B7 SM124','B1 MANW811/80','A1 F111','C9 ADZ92113','B7 SM125','B7 FO-013A/KAVO','C4 J1317005','A9 0986452036','A9 J1317005','A8 365 902','A1 0986452007','A2 UFI 23.259.00','A1 0986452059','A8 370 625','A2 UFI 23.583.00','A2 UFI 23.243.00','B7 H90W25','A3 BOS 0986452016','C9 LS350','A8 920 092','A2 OC115','A1 OC152','A3 FLT OP617/1','A9 FI OP617','A1 LS415PU','C4 0986452061','A2 FI OP595','C4 J1315025','A2 0986452016','A9 FI OP617/1','A9 J1315025','B7 OP595/AG','D1 BP ADZ92113','C4 LS350PU','A3 BOS 0986452061','A9 UFI 23.461.00','A1 0986452008','C9 DO328','B7 SM134','B1 BLPADZ92113','A5 27488','B7 SM166','A9 UFI 23.259.00','A1 0986452061','B1 FTROP595','A1 LS489APU','B7 SM120','B1 KNEOC205','B7 H13W01','A8 373 761','A3 BOS 0451103316','A3 KAP MO-429','A1 OC205','A9 OC230','A2 0986452036','B1 BOS0986452036','B1 BOS0451103316','A3 KAP MO-422','C4 H97W06','A3 MHL OC205','A1 OC230','B1 KNEOC115','A2 0986452061','C9 SP-911','C9 0986452006','A1 W811/80','B1 HENH90W25','C4 LS489APU','A2 J1314010','A1 OC 205','A3 KAP HO-605','B7 HO-605/KAVO','A1 0451103316','A1 10-05-599ASK','C4 W 811/80','A1 H90W25','A8 365 888','B7 OP 617/IP','A9 J1317004','C4 J1315015','A2 J1314010F','A5 162212','B1 HENH97W06','C9 H90W25','C9 LS415','B1 HENH13W01','B1 BOS0986452061','C4 N1310510','A1 LS350PU','B7 MO-515/KAVO','C9 DO828','B7 MO-422/KAVO','C9 0451103316','A9 J1317003','A2 FI OP617','A3 MHL OC230','A2 OC205','A3 FLT OP595','A1 F026407124','A2 F026407124','A2 J1313006','A2 SF OF0063','A3 BOS F026407124','A5 272918','A8 326 211','A9 F026407124','A9 J1313006','A9 SF OF0063','B1 BLPADH22114','B1 BOSF026407124','B1 KAMF115501','B1 KAMF118901','B1 VAL586017','B7 A210039/DKM','C4 F026407124','C4 J1313006','C9 35-143220002','C9 ADH22114','C9 F026407124','C9 OF-934','D1 BP ADH22114','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #