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