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