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 0986452916','A3 MHL OC1254','D1 BP ADZ92113','A2 OC1254','A5 202470','B1 VAL586017','A8 918 265','A5 272918','A8 365 855','A1 J1313030HB','D1 BP ADC42103','C4 J1315015','A2 N1310510','A9 OC1254','B1 BOSF026407124','C4 S 6902 R','A9 J1315025','E6 FL1157','C9 H20W07','C9 H13W01','A3 MNN W815/80','C4 O0650DREIS','A8 926 772','A9 UFI 23.165.00','B7 OP 617/IP','A3 FLT OP536','C9 ADC42103','A9 0986452016','B1 FTROP617','A2 FI OP558','C4 N1310510','C9 32-143220005','C9 FO-706S','B7 H13W01','A2 FI OP617','B1 BOSF026407104','B1 MANW87','C4 F026407082','B1 PURLS489A','A5 30160','A8 920 092','A8 313 537','B1 BLPADG02110','C9 FO-510S','E6 FL1202','A1 LS489APU','A3 MNN W811/80','B1 MISZ165','A2 J1315015','C4 W 87','A3 JAP FO-502S','B1 BLPADC42103','E6 FL1199','A1 0986452007','D1 BP ADS72101','C9 ADG02110','A2 J1317003','A1 J1317003HB','A5 385474','B1 MANW811/80','A3 JAP FO-599S','C4 H13W01','C4 OC 982','B1 FTROP536','A1 OC1673','A1 10-05-510ASK','A9 0451103316','A1 0986AF1038','C9 ADZ92113','E6 FL1037','B7 H20W07','A1 OC1254','A9 OC500','A1 OC 205','B7 W811/80/AG','A9 W87','C9 ADS72101','B7 OP 536/IP','A2 0986452016','B1 VAI32-0018','A1 0986452016','A1 OC152','A1 W811/80','A1 WOF306','C9 SP-961','A3 BOS 0451103316','A1 10-05-502ASK','A1 10-07-706ASK','A8 314 274','B1 HENH13W01','B1 BLPADZ92113','A9 FI OP536','A9 OC982','A3 FLT OP558','A8 345 060','A9 J1315015','A3 FLT OP617','A3 MHL OC500','A5 287946','A1 F026407082','A1 J1315015HB','C4 LS489APU','B1 BLPADC42112','A2 OC982','A3 BOS F026407124','C9 FO-599S','C9 W815/80','A2 0986452006','A2 OC205','C4 COF100110S','C9 F026407082','A2 W87','A1 J1319019HB','A3 BOS 0986452006','A5 27476','A1 OC113','C9 LS489A','A3 MHL OC205','A8 358 665','A2 OC230','A8 326 211','C4 0451103316','A3 JAP FO-914S','A1 OC205','B1 BOS0451103316','A9 OC230','B7 OP617/AG','A9 W811/80','A9 J1317003','A1 J1310508HB','A1 W815/80','A8 361 470','A1 F026407124','C9 SP-911','A1 LS490APU','B7 SM125','C9 DO328','A3 MHL OC1673','B1 CHACOF100110S','A9 F026407082','A9 UFI 23.461.00','C9 0451103316','A8 318 364','B1 FTROP558','A1 0986452006','C9 FO-502S','A2 OC1673','A3 BOS 0986452916','C4 W 811/80','A1 F119','B1 BOS0986452016','A1 OC500','A2 J1315025','A9 OC205','B1 CHACOF100119S','D1 BP ADC42112','A2 W815/80','A1 OC230','A1 W87','A5 174793','A3 BOS 0986452016','A3 JAP FO-706S','A8 318 852','D1 BP ADG02110','B7 TO-149/KAVO','A3 MNN W87','C9 LS490A','A9 F026407124','A8 320 521','A8 318 255','A1 WOF120','A8 300 100','C9 0986452016','B1 MANW815/80','C9 DO828','C9 FO-914S','A2 W811/80','A8 361 750','A5 30173','A5 372458','A5 30171','C4 OC 205','A9 OC1673','C9 32-143220007','A1 0451103316','A2 UFI 23.461.00','C4 F026407124','A2 0451103316','A1 OC 230','A5 27488','A2 F026407124','A8 370 382','C4 J1315025','C9 F026407104','A2 FI OP536','A9 FI OP617','B1 BOSF026407082','A9 FI OP558','A9 N1310510','A2 UFI 23.485.00','A3 BOS F026407104','B7 SM121','A5 266403','A1 OC982','C9 W87','A3 VAC V32-0018','A8 921 238','A1 F111','C4 S 3485 R','A1 10-05-599ASK','A8 358 664','C9 SP-1229','C4 F026407104','A3 JAP FO-510S','A2 OC500','A1 F026407104','C9 0986452006','B7 OP 558/IP','A2 F026407082','A3 MHL OC982','C4 J1317003','A5 44645','A3 MHL OC230','C4 W 815/80','A9 UFI 23.485.00','C9 W811/80','C9 F026407124','B1 BLPADS72101','A2 UFI 23.165.00','C9 ADC42112','A1 32100 FE','A1 J1311018HB','A8 358 666','A8 360 033','A8 360 056','A8 360 406','A8 360 886','A8 919 224','B1 BLPADG02109','B1 BLPADG02144','B1 BLPADH22114','B1 BLPADK82102','B1 BLPADM52101','B1 BLPADM52106','B1 BLPADM52107','B1 BLPADN12112','B1 BLPADZ92104','B1 FEB32099','B1 FEB39829','B1 FEB47459','C3 16510-61A01','C9 ADG02109','C9 ADG02144','C9 ADH22114','C9 ADK82102','C9 ADL142102','C9 ADM52101','C9 ADM52106','C9 ADM52107','C9 ADN12112','C9 FE32099','C9 FE32100','D1 BP ADG02109','D1 BP ADG02144','D1 BP ADH22114','D1 BP ADK82102','D1 BP ADL142102','D1 BP ADM52101','D1 BP ADM52106','D1 BP ADM52107','D1 BP ADN12112','E6 FL1015','E6 FL1045','E6 FL1052','E6 FL1151')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #