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 0450905976','B1 VAL587028','B1 FTRPP905','A2 0S 1515 B','A9 UFI 31.850.00','A9 0450905976','B1 BOS0450905320','C9 WK55/3','A9 UFI 31.515.00','A2 0450905969','A1 WFF443','A8 303 183','A1 L436','B7 A110556/DKM','A9 FI PP829/1','C9 0450905976','B1 MANWK55/3','C4 S 1843 B','A8 361 561','C4 H110WK','B7 H110WK','A9 J1330908','B1 BLPADG02325','B1 FTRPP905/3','A8 361 751','A3 BOS 0450905320','C9 0450905316','A8 337 283','B7 PP905/2/AG','C9 FC-W01S','C9 ADJ132319','A8 920 678','C4 S 1722 B','B1 HENH110WK','A3 BOS 0450905273','A2 587008','C9 0450905969','A8 314 120','A1 WFF557','B1 FEB33467','B1 HENH276WK','B1 BLPADG02331','A2 FI PP905/2','A2 FI PP829/1','A3 MNN WK55/2','C9 WK55/2','B1 VAL587046','A3 VAC V51-0007','A2 J1330901','B7 A110001/DKM','A3 VAC V51-0041','B1 PUREP155','B1 MANWK55/2','C9 SP-2158','E2 201 622 756','C4 WK 55/3','A5 301957','C9 WK512','A1 WK55/3','A8 318 288','A2 UFI 31.843.00','B1 FEB17635','A1 WK55/2','A1 J1330902HB','A1 WK511/1','A9 0450905316','A1 L468','A3 BOS 0450905316','A3 BOS 0450905976','A1 J1330901HB','D1 BP ADJ132319','A1 L420','A9 WK512','B1 FTRPP829/1','B7 PP829/1/AG','A2 FI PP905/3','C4 J1330901','A9 J1330901','B1 VAI51-0007','C9 SP-2170','A9 FI PP905','B1 VAL587008','A8 358 179','B1 VAI51-0041','A1 L225','C9 SP-2134','A8 357 448','A3 FLT PP829/1','A1 17635 FE','C9 EP221','C4 S 1515 B','A2 0450905320','A3 JAP FC-W01S','C9 WK511/1','A1 0450905320','C9 0450905320','A3 MNN WK512','C9 50013912','A1 0450905976','A9 WK511/1','A1 WK512','A3 FLT PP905/3','A1 EP155PU','B1 BLPADJ132319','B1 BOS0450905273','A3 BOS 0450905969','B7 A110003/DKM','C4 17635F','B1 MANWK512/2','C9 1002010013','C4 WK 512','C9 WK512/2','A3 MNN WK55/3','A5 111176','C4 J1330908','A8 930 367','B7 H276WK','A9 FI PP905/2','A2 J1330908','A9 0450905969','C4 S 1850 B','A3 BOS 0450905975','C4 WK 511/1','A1 WK512/2','A3 VAC V10-0207','B1 VAI40-0019','C4 EP163PU','A3 FLT PP905/2','B1 PUREP163','C4 0450905316','C9 MBNA985','B1 BOS0450905316','A9 FI PP905/3','A1 33467 FE','A9 WK55/3','A1 EP163PU','B1 PUREP221','A2 0450905316','B1 MANWK512','C9 SP-2060','C4 EP155PU','A8 370 711','A1 0450905316','B1 MANWK511/1','A3 MNN WK512/2','B7 PP 905/3/IP','A8 367 255','C4 WK 512/2','A2 WK55/3','C9 SP-2171','B1 PUREP164','C4 0450905969','C4 WK 512 SD','C4 WK 55/2','D1 BP ADG02331','B7 PP 905/IP','C9 H110WK','C9 50013643','C9 ADG02331','C4 F0300DREIS','A2 WK55/2','C4 F0299DREIS','B7 PP905/AG','A5 38820','C9 FE17635','B1 HENH227WK','B1 VAI24-0483','C9 EP164','A9 UFI 31.843.00','B7 PP 829/1/IP','B1 BOS0450905969','C9 0450905273','A1 0450905975','B7 PP905/3/AG','A1 WFF134','C9 29-143230001','C9 1002010000','A1 EP164PU','A2 WK511/1','A8 318 573','E6 FF1165','A8 370 357','A9 WK55/2','C9 EP155','B7 WK512/AG','A3 VAC V40-0019','C9 ADG02325','A8 336 948','A2 WK512','A2 UFI 31.850.00','A1 0450905273','B1 CHACFF100225','A9 UFI 31.722.00','A2 UFI 31.722.00','A3 FLT PP905','A1 EP221PU','C4 0450905273','C9 EP163','C4 CFF100225','A5 40886','B1 CHACFF100420','A3 MNN WK511/1','C9 H227WK','A3 VAC V24-0483','B7 PP 905/2/IP','A2 UFI 31.515.00','A1 30-W0-001ASK','B1 FTRPP905/2','A5 82102','C4 F0279DREIS','A1 0450905969','A1 CFF100468','B1 CHACFF100468','C4 CFF100420','B1 VAI10-0207','A8 367 164','A2 FI PP905','C4 0450905976','A8 928 031','A8 911 012','A2 0450905273','A8 336 618','D1 BP ADG02325','C9 H276WK','B1 BOS0450905976','B7 H227WK','A2 SF PF7012','A5 341961','A8 388 093','A9 SF PF7012','B1 BLPADU172305','B1 BLPADV182321','B1 FEB170395','B1 FEB48555','B1 HP201 622','B1 KAMF300201','B1 KAMF301501','C9 PF-2060','D1 BP ADV182321')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #