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 J1313020','B1 HENH90W04','B1 HENH90W24','A5 202450','A1 27147 FE','C9 W712/83','C4 O0583DREIS','B7 OP 618/IP','C4 S 2400 R','C9 DO261','B1 BOS0451103337','C4 H17W02','B1 FEB176735','C4 J1312021','A9 W712/83','B1 BOS0451103271','A8 312 820','E6 FL1042','B7 H90W24','A9 0451103337','A9 0451103271','A1 LS149PU','C4 J1313020','C9 0451103298','A8 365 941','A1 LS582PU','A2 UFI 23.131.00','C4 S 3413 R','A1 LS357PU','A1 0451103337','C9 H90W24','A1 LS245PU','B1 BLPADT32108','B7 TO-138/KAVO','B7 W7015/AG','B1 FEB27138','B1 BLPADM52111','A3 BOS 0451103050','B1 PURLS245','C9 H10W11','A3 MNN W7008','B1 PURLS186','A1 10-02-279ASK','B1 PURLS149','B1 KNEOC8','A3 MHL OC478','A9 UFI 23.413.00','B7 10279/JAPKO','A9 UFI 23.131.00','C4 0451103050','A1 OC74','E6 FL1210','B7 MO-539/KAVO','C9 H90W20','C9 SP-994','A1 LS359PU','B1 KNEOC74','A1 C121','B1 BLPADM52122','C4 MO-540','A1 0451103907','B7 H90W22','B7 H90W20','C9 LS357','B1 FTROP618','B1 BLPADT32114','D1 BP ADM52110','C9 FE27138','B1 HENH17W02','C9 SP-1073','A8 360 057','A9 J1312015','C4 W 7015','C4 H90W19','B1 PURLS359','A5 80520','B1 BLPADM52110','A3 MNN W712/83','A2 W712/83','C9 FE27147','A8 365 184','A1 0451103309','A1 LS188BPU','A1 0451103298','A8 328 205','C9 0986452044','C9 DO911','A5 432463','A8 360 975','A2 UFI 23.413.00','C9 ADM52122','A9 FI OP618','C4 0451103907','B1 PURLS285','C9 LS801','A8 348 232','A5 43662','A9 H17W02','A2 J1313021','C4 0986452044','B1 MANW7015','A1 WOF1868','A2 UFI 23.151.00','A1 W712/83','A1 LS285PU','C4 LS801PU','C9 DO910','B1 BLPADM52109','A5 337785','C9 DO339','C9 H90W19','A1 J1313021HB','B7 ST784','A3 HEN H90W20','A3 MHL OC314','E6 FL1209','A3 BOS 0451103907','C9 DO942','A1 OC 478','C9 0451103050','A1 OC314','C9 H17W02','C4 LS357PU','A1 LS277PU','B7 W712/83/AG','C9 LS285','A9 W7015','C9 W7008','C9 LS188B','A1 J1313022HB','E6 FL1018','A1 C167','A5 250170','A3 FLT OP618','A3 MHL OC8','A2 FI OP618','C4 S 1100 R','A1 W7008','C9 DO217','A9 UFI 23.473.00','A8 314 355','A1 WOF227','C9 0451103337','C4 LS149PU','A5 50035','A9 UFI 23.188.00','A8 365 896','A8 920 551','B1 BOS0451103907','A8 365 828','C9 LS922','A8 313 810','B7 MO-540/KAVO','C4 LS186PU','A5 169853','A9 J1312021','A1 0986452044','C9 LS149','A1 W7015','C9 LS245','B1 MANW7008','C9 LS582','B1 BLPADG02154','A1 OC478','C9 LS711','D1 BP ADG02154','C9 ADM52111','A9 OC478','B1 BLPADF122105','A1 J1313020HB','A2 UFI 23.416.00','A2 0451103298','A8 370 614','A2 0451103337','D1 BP ADT32114','A2 W7008','A9 0451103298','A3 MHL OC74','A8 378 012','C9 LS186','A5 40940','A8 328 206','A2 UFI 23.473.00','A9 FI OP562','A9 UFI 23.435.00','C9 LS359','B7 H17W02','A2 0986452044','A8 365 824','A1 WOF420','B1 BLPADJ132113','C4 W 7008 SD','C9 W7015','C4 LS922PU','A9 0986452044','A9 0451103050','B1 FTROP562','C9 0451103271','A1 27138 FE','A1 LS711PU','C9 ADF122105','C4 W 712/83','A8 318 372','A1 38813 FE','C4 S 3253 R','A9 J1313021','A1 0451103050','D1 BP ADJ132113','B1 FEB176714','B1 PURLS582','D1 BP ADF122105','C4 J1313021','D1 BP ADM52109','A8 303 046','A1 OC25','C4 0451103337','C4 H90W20','B1 BOS0451103298','A5 174792','B1 HENH90W19','C9 DO289','A9 OC25','B1 FEB176734','B1 KNEOC235','C9 SP-1296','C9 SP-1123','B1 KNEOC314','C9 ADJ132113','A9 UFI 23.253.00','B7 H10W11','A8 312 830','A5 62149','A2 OC25','A8 360 027','C9 ADM52110','B1 FEB27147','B1 KNEOC25','A8 389 804','A1 OC244','C4 0451103271','A8 370 610','B7 H90W19','A3 KAP TO-138','C4 O0550DREIS','B1 KNEOC988','A8 326 718','A1 LS922PU','A2 FI OP562','C9 0451103907','B1 PURLS357','B1 BOS0986452044','B1 BOS0451103050','C4 LS285PU','A1 0451103144','A2 H90W04','C9 H90W04','A2 J1312015','A2 UFI 23.188.00','C4 S 3435 R','B7 H90W04','B1 MANW712/83','A5 189440','C4 J1312015','B7 OP 562/IP','B1 FEB176736','C4 27147F','A3 BOS 0451103298','A2 OC8','A1 0451103271','A9 UFI 23.267.00','C4 H319W','D1 BP ADM52122','A3 MHL OC25','B7 OP618/AG','A8 365 910','B1 FEB38813','C9 ADT32114','A2 J1312021','A8 320 522','A8 365 946','A1 LS801PU','A2 UFI 23.267.00','B1 PURLS922','C9 ADG02154','A2 OC478','C4 OC 314','B7 SM143','B1 KNEOC244','A2 OC314','D1 BP ADM52111','A9 UFI 23.131.02','C4 S 3416 R','C9 ADM52109','A5 169850','A2 UFI 23.435.00','A2 H17W02','A3 FLT OP562','A2 0451103050','C9 ADT32108','A3 BOS 0451103337','A3 BOS 0451103271','C9 SP-1072','C9 SP-1067','B7 SM110','A1 OC235','A2 0451103907','A2 UFI 23.253.00','A1 J1312011HB','C4 O0549DREIS','A9 W7008','A2 W7015','C4 0451103298','B1 HENH319W','B1 KAMF102301','C9 H90W22','A3 BOS 0986452044','A2 UFI 23.131.02','A9 UFI 23.416.00','A1 H17W02','C4 W 7008','D1 BP ADT32108','A1 OC8','C4 H90W24','A8 365 937','A2 0451103271','C9 FE38813','C9 SP-1423','C4 LS188BPU','C4 S 8540 R','A1 LS186PU','B1 PURLS711','B1 HENH90W20','A9 UFI 23.151.00','B1 PURLS188B','A8 920 093','B1 PURLS801','A1 OC988','A2 FI OP629/1','A3 FLT OP629/1','A3 MHL OC244','A3 MHL OC988','D2 WL7459','A1 W712/73','A2 SF OF0183','A2 W712/73','A5 500318','A8 325 297','A8 370 404','A9 SF OF0183','A9 W712/73','B1 BLPADM52118','B1 BLPADV182118','B1 FEB108330','B1 FEB108977','B1 FEB27289','B1 HENH14W32','B1 KAMF106401','B1 KAMF114501','B1 MANW712/73','B1 VAL586073','B7 A210052/DKM','B7 H14W32','B7 MO-534/KAVO','C4 H14W32','C4 TO-129','C9 30-143220004','C9 7143220014','C9 ADM52118','C9 ADV182118','C9 FE109139','C9 OF-478','C9 OF-994','C9 W712/73','D1 BP ADM52118','D1 BP ADV182118','D9 16510-60B11','D9 16510-60B11 10db','D9 16510-60B11 50db','A3 JAP FO-279S','A5 43729','D2 FLT OP629/1','D2 OP629/1')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #