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