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 LS489A','A2 OC230','A1 F119','A8 920 092','C9 0986452016','C9 ADC42103','E6 FL1157','A1 OC152','A1 OC113','B7 H13W01','C9 FO-706S','A2 0451103316','D1 BP ADC42112','A5 27488','A3 MNN W815/80','A9 W811/80','C4 0451103316','C9 FO-510S','A8 300 100','A9 UFI 23.485.00','A5 272918','A9 J1315025','C4 F026407124','A1 10-07-706ASK','A1 J1313030HB','A9 J1317003','A5 30171','A1 0986452916','A3 JAP FO-502S','A5 202470','A8 926 772','C9 ADS72101','A2 0986452016','A2 F026407124','E6 FL1199','C9 W811/80','C9 ADZ92113','A1 J1319019HB','B1 VAL586017','A1 WOF306','C9 H13W01','A8 358 665','C9 0986452006','A8 318 852','A2 J1317003','B1 VAL586060','C9 35-143220002','A9 0451103316','A1 OC205','B1 BLPADC42103','A1 F111','A9 J1315015','B1 MANW811/80','A9 UFI 23.165.00','C4 S 3485 R','A2 W811/80','C4 H13W01','E6 FL1202','A2 0986452006','C4 COF100110S','A8 921 238','A1 10-05-599ASK','C9 FO-502S','A1 W815/80','B1 BOSF026407124','A3 BOS 0986452916','A2 OC1254','B7 H20W07','A3 BOS 0986452016','C9 32-143220005','B1 CHACOF100110S','A3 MHL OC500','A1 OC230','A2 OC1673','D1 BP ADS72101','A2 W815/80','B1 BLPADS72101','D1 BP ADC42103','D1 BP ADZ92113','A8 314 274','A5 372458','C4 LS489APU','A9 OC1254','A3 BOS 0986452006','C9 SP-911','C4 J1315015','C9 F026407124','B1 BLPADC42112','A3 BOS 0451103316','A1 0986452006','A5 174793','A1 0986AF1034','A2 J1315025','A5 44645','A3 MHL OC1254','A2 N1310510','C9 DO828','B1 BLPADG02110','A3 JAP FO-706S','C9 SP-1229','C4 N1310510','C4 J1317003','A1 OC500','A1 LS489APU','B1 CHACOF100119S','A1 0986452007','A3 MHL OC205','A2 UFI 23.461.00','A2 OC205','A2 UFI 23.165.00','B7 SM125','A3 JAP FO-914S','A3 VAC V32-0018','B1 PURLS489A','A9 OC500','A1 OC1673','A1 WOF120','A8 313 537','A3 MHL OC230','A1 0986AF1038','A1 10-05-502ASK','A3 MHL OC1673','C4 W 811/80','A1 W811/80','A3 JAP FO-510S','C4 J1315025','A5 27476','A1 0451103316','A3 BOS F026407124','A1 OC 205','B1 MANW815/80','A2 UFI 23.485.00','A8 326 211','A5 30160','C4 O0650DREIS','A3 MNN W811/80','A1 OC1254','C9 W815/80','A5 385474','B7 W811/80/AG','C4 S 6902 R','C9 SP-961','A1 OC 230','A9 F026407124','B1 BLPADZ92113','A8 365 855','C9 FO-914S','A9 N1310510','B1 VAL586016','B1 VAI32-0018','A8 361 470','A1 J1317003HB','C9 DO328','C9 H20W07','C4 OC 205','C9 ADC42112','A1 F110','B1 BOS0986452016','A9 OC230','B7 SM121','C9 32-143220007','A1 F026407124','A1 J1315015HB','C4 W 815/80','A2 J1315015','C9 71758725','B1 HENH13W01','A9 OC205','A9 UFI 23.461.00','C9 0451103316','A9 0986452016','A3 JAP FO-599S','C9 FO-599S','A8 358 664','A8 370 382','A1 10-05-510ASK','B1 MISZ165','B1 BOS0451103316','A1 0986452016','C9 ADG02110','E6 FL1037','A5 30173','D1 BP ADG02110','A9 OC1673','A2 OC500','A1 J1310508HB','A8 361 750','B7 TO-149/KAVO','A1 J1313015HB','A1 LS892PU','A2 J1314010','A2 SF OF0063','A5 174794','A8 360 886','A8 365 902','A8 920 430','A9 J1314010','A9 SF OF0063','A9 UFI 23.259.00','B1 BLPADN12112','B1 FEB32099','B1 KAMF104701','B1 KNEOC205','B1 PURLS892','B7 A210039/DKM','B7 HO-605/KAVO','B7 MO-429/KAVO','C4 J1314010','C9 ADN12112','C9 FE32099','C9 OF-934','C9 OF-946','D1 BP ADN12112')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #