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 ('C9 ADS72101','A3 BOS 0986452016','A1 OC 205','A8 365 855','A1 OC205','B1 FTROP617','A8 920 092','C9 LS489A','B1 CHACOF100119S','A1 F026407124','B1 FTROP536','A3 MNN W815/80','E6 FL1157','B1 BOSF026407104','B1 BOS0986452016','A3 MHL OC1673','C9 ADZ92113','A2 OC500','B1 BLPADC42112','A3 BOS 0986452006','A8 318 852','A2 UFI 23.165.00','A3 JAP FO-502S','A2 FI OP536','B1 HENH13W01','C9 32-143220007','A8 361 750','C9 H20W07','A9 UFI 23.165.00','A9 FI OP617','C4 F026407104','A2 UFI 23.485.00','A1 OC1254','A1 LS489APU','A5 44645','A9 F026407124','A8 318 255','C9 FO-599S','A8 314 274','A9 FI OP558','C4 F026407082','B1 MISZ165','C9 W815/80','A9 OC1673','C9 SP-1229','A5 30160','A9 FI OP536','C9 F026407082','B1 VAI32-0018','B1 BLPADZ92113','A1 J1310508HB','C9 DO828','B1 BOSF026407124','A9 UFI 23.485.00','C9 FO-510S','A3 BOS 0986452916','C4 H13W01','C9 ADC42112','A9 OC205','A9 J1315015','A1 W815/80','A5 385474','A1 J1315015HB','B1 CHACOF100110S','C4 LS489APU','A2 OC1254','D1 BP ADC42103','A1 0986452916','B1 BLPADG02110','A1 10-07-706ASK','A8 921 238','C9 FO-914S','A9 0451103316','C9 SP-911','B7 TO-149/KAVO','A2 OC1673','A9 UFI 23.461.00','A1 WOF120','A2 0986452006','C9 F026407124','A1 10-05-510ASK','C9 F026407104','C9 71758725','A3 VAC V32-0018','A2 0986452016','A5 266403','C4 J1315015','C9 35-143220002','A8 358 664','B1 BOSF026407082','A1 OC500','C9 0451103316','B1 BOS0451103316','A1 F119','A1 0986AF1038','C9 0986452016','B7 OP 617/IP','A3 MNN W87','A1 F026407082','A9 J1315025','A9 J1317003','A8 320 521','A3 FLT OP617','A9 OC982','B7 H20W07','C4 J1317003','A2 OC205','C9 FO-706S','A1 OC 230','A3 JAP FO-914S','B1 FTROP558','A3 JAP FO-706S','A5 372458','E6 FL1037','A3 MHL OC500','B1 BLPADS72101','A2 0451103316','A1 0986AF1034','A8 918 265','A2 N1310510','C9 H13W01','C4 W 87','A9 0986452016','C9 LS490A','C9 W87','A1 OC230','C4 S 6902 R','A3 FLT OP536','A1 OC113','A2 F026407124','A8 313 537','A2 OC982','A3 JAP FO-599S','C4 COF100110S','A1 0451103316','C9 DO328','E6 FL1199','A1 J1319019HB','A8 345 060','A8 370 382','B1 VAL586060','B7 OP 558/IP','A8 358 665','A1 OC982','B1 MANW815/80','B7 OP617/AG','A3 MHL OC230','A2 F026407082','C4 OC 982','A3 BOS 0451103316','A1 F026407104','C4 0451103316','A1 0986452007','A5 27476','A2 J1317003','A3 MHL OC982','A1 0986452006','C9 0986452006','A5 30173','A2 FI OP617','A8 361 470','D1 BP ADG02110','A5 272918','A3 FLT OP558','D1 BP ADZ92113','A9 F026407082','C4 F026407124','C9 ADC42103','E6 FL1202','B1 VAL586016','D1 BP ADC42112','C9 FO-502S','C9 SP-961','A1 10-05-599ASK','B7 SM125','C4 OC 205','A2 FI OP558','A2 OC230','A1 OC152','A1 10-05-502ASK','A9 W87','A2 W815/80','A1 F111','C9 ADG02110','A9 OC500','A3 JAP FO-510S','A5 27488','B1 PURLS489A','A1 W87','A3 MHL OC205','A8 926 772','B7 OP 536/IP','A5 174793','A1 LS490APU','A2 J1315025','C4 W 815/80','A8 326 211','A1 J1313030HB','A5 287946','A9 N1310510','A2 W87','B7 SM121','A1 OC1673','A5 30171','C9 32-143220005','A9 OC1254','B1 VAL586017','B1 MANW87','D1 BP ADS72101','A1 0986452016','A3 BOS F026407124','A1 J1317003HB','A2 J1315015','C4 S 3485 R','C4 N1310510','B1 BLPADC42103','C4 J1315025','A2 UFI 23.461.00','A9 OC230','A8 318 364','B7 H13W01','A1 WOF306','A3 BOS F026407104','A3 MHL OC1254','A1 F110','A1 J1313015HB','A2 J1314010','A2 J1317005','A2 SF OF0063','A8 360 886','A8 920 430','A9 J1314010','A9 J1317005','A9 SF OF0063','B1 BLPADN12112','B1 FEB32099','B1 KAMF104701','B1 KNEOC1673','B1 KNEOC205','B1 KNEOC230','B1 VAL586001','B7 HO-605/KAVO','B7 HO-823/KAVO','B7 MO-429/KAVO','C4 J1314010','C4 J1317005','C9 ADN12112','C9 FE32099','C9 OF-934','C9 SP-934','D1 BP ADN12112')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #