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