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 ('A3 RUV 935728','A2 ABS270318','A3 FEB 07856','C4 TD239W','B1 COR21652971','C9 FE14444','A8 440 125','B7 825 0173 10','A3 NKS 5014718','A2 30 78 0034','A1 821 0349 10','C4 850029546T','A1 RU985425','B1 TRWJBU161','A8 410 610','C4 850029535T','C9 985423','B1 HUT599015','C9 935728','A2 JBU161','C9 5102550','A9 JTC342','C9 829009210','A1 37487 SID','A8 419 730','A5 35307','A9 AK.176411','A1 10814 FE','A1 RU935728','C4 850029808T','B1 TRU07.31.046','C9 TD239W','A2 TD287W','A9 TC787','A9 ABS270318','A3 MOG VO-BJ-8288','A3 FEB 12660','B1 ABS210042','E3 SB12','B7 1140101309/JP','B7 1140200800/JP','C4 VO-SB-1369','A8 402 671','A9 TC2010','A3 NKS 5044739','C9 FE19822','B1 TRU07.30.036','E3 A-504','A2 TC1970KIT','C4 VO-WP-1553P','A1 JTC342','A3 RED 6-600','A1 WRM219','A1 G1708','E3 A-504K','B1 TRU07.30.016','B1 FEB19822','A9 S863601','A2 32 73 0016','A3 HUT 597095','A3 MOG FD-WP-7997','C9 5104720','D2 EO TD287W','B1 MOZL29545','A9 32 69 0009','C9 FE10814','A3 RUV 915747','B1 VAI10-7299','A8 457 779','C4 TC787','B1 MOZL29808','B1 FEB11091','A1 37471 SID','A1 TC787','A1 12660 FE','A9 30 69 0002','B1 RTS76.00960','A1 G6-1409','C4 TC2010','A5 35220','B1 ABS270318','A1 RU985423','C4 VO-SB-1329','C4 19822F','A8 439 030','A2 TC825','A3 RED 6-SB3','A1 RU915747','A9 TC825','A1 G6-1408','A9 30 78 0034','C9 FE11091','A1 G3-541','B7 829 0093 10','A9 TD239W','A2 JBJ113','A3 MOG VO-SB-1329','B1 MOZL29535','A1 851622 SID','A3 RED 6-BL914','C9 FE37017','A3 RED 6-SB4','A9 S37471','C9 985425','C4 58011902','B1 KAM8800035','B7 915747','B7 T402963/STC','A3 MON L29847','C4 FD-WP-7997','A2 AK.23419','A1 TC2010','C4 52005408','B7 985425','A2 JBU129','A8 438 900','A1 G9-649','A3 FEB 14444','B7 935728','A3 MOG FD-WP-7998','C4 37017F','C4 VO-BJ-8288','A8 458 026','A9 AK.23419','B7 52004908/MTZ','C4 07856F','B1 TRWJBU129','A9 12.24.701','A1 825 0173 10','A3 DLP TC825','A2 S37487','C4 07.31.057','C9 850029847','C4 JBU129','B1 HUT597095','A3 MOG VO-WP-1553','A3 MOG FD-SB-8092','B1 MOZL29A09','B1 MOZL29847','A9 TD287W','A3 BGD BSP20234','C4 VO-WP-1553','A1 863601 SID','A9 TC1970KIT','A3 MOG VO-WP-1552','A3 NKS 5104720','B7 1140200100/JP','C4 10814F','C9 5014717','A3 NKS 5044739PRO','B1 RTS017.00959','A5 158855','E3 A-525S','C9 9001523','B1 FAG829009210','A3 DLP TC786','A9 32 78 0019','A5 158979','C4 850029847T','C4 VO-WP-1552','A1 37017 FE','A8 410 242','C9 1160108288','C9 9005267','A1 JBJ113','A3 RUV 985425','A1 VO-SB-1369','C4 19820F','B7 985423','A2 32 69 0009','A3 FEB 19820','A5 142078','B7 829 0092 10','A2 12.24.701','B7 58011902/MTZ','A3 RUV 985423','B7 D300002/DKM','C4 07.30.036','A1 TD239W','B7 821 0349 10','C4 14444F','A8 431 852','B1 VAI10-1383','C9 HP103 474','A1 WSS356','A1 EL1405','A3 DLP TD287W','A5 268123','A3 DLP TD239W','A9 JBU129','B7 D110050/DKM','C9 107702466','A1 WSS118','A1 TD287W','A3 TRU 07.30.036','A3 FEB 19822','A2 S37470','B1 ABS220017','A9 JBU161','A3 VAC V10-1172','A1 7856 FE','A2 S804601','C9 103474755','A8 470 542','A3 MON L29535','A1 829 0092 10','C4 JBJ113','A3 VAC V10-7018','C9 825017310','A1 19820 FE','B1 VAI10-1172','B1 ABS270315','A1 829 0093 10','C4 FD-WP-7998','A2 30 91 9822','A1 EL1318','A8 483 379','A3 BGD BSP20519','A3 TRU 07.30.016','C4 11091F','B1 FEB19820','B1 TRWJBJ113','A2 S863602','B1 FEB07856','A8 425 809','C4 8500295009T','B1 KAM8800026','A1 37470 SID','B1 COR21651269','A3 MEZ 52005408','A9 S863602','A1 863602 SID','A1 19822 FE','C4 V10-1383','A9 30 91 9822','B7 1140101300/JP','C4 107106HP','A8 443 335','A3 RED 6-914','C9 5014718','A3 BGD BSP20259','E6 DB1094','A3 NKS 5102550','A3 MEZ 58011902','C9 FE12660','A2 50 93 7017','B1 SAS9001523','B1 RTS017.00960','A8 407 803','C4 TD287W','C9 21652971','A1 G9-648','B1 VAI10-7018','C9 829009310','A5 158978','C4 JTC342','B1 TRWJTC342','A2 30 69 0002','C9 5044739','A1 804601 SID','A8 402 672','A8 454 487','B7 935718','A1 JBU129','C4 57004012','B7 510084/GSP','C9 FE07856','C4 TC825','A8 411 654','B1 HP103 474','A8 410 239','A8 406 730','A1 WSS356K','A9 JBJ113','C9 821034910','A1 JBU161','B1 TRU07.31.057','A5 264482','A2 S863601','A8 454 484','C9 5044739PRO','E2 108 150 755','B1 HP108 150','C9 21651269','B1 ABS210607','B1 GSP510084','A1 VO-SB-1329','A1 G6-647','A2 JTC342','C9 103474CN5','A3 MOG VO-SB-1369','B1 FEB12660','C4 TC786','A3 COR 21651269','A1 TC825','A3 TRU 07.31.046','A1 WRM225','A3 FEB 10814','B1 FAG825017310','B7 1140200109/JP','B7 52005408/MTZ','A3 VAC V10-7299','C9 103474546','C9 FE19820','A2 TC786','A1 VO-BJ-8288','C4 850029545T','A3 FEB 11091','C4 108150HP','B1 VAI10-7120-1','A8 407 612','C4 12660F','A3 HUT 599015','A1 TC1970KIT','B7 D120081/DKM','B1 FEB10814','A3 VAC V10-1383','A3 COR 21652971','A2 32 78 0019','A3 DLP TC1970KIT','A2 S37471','B1 GSP510065','A2 TD239W','A1 14444 FE','A3 NKS 5014717','E6 DA1187','C4 07.30.016','B1 FAG821034910','A3 DLP TC787','A1 G1665','A1 11091 FE','A9 32 73 0016','B7 L29808/MON','A3 TRU 07.31.057','A9 TC786','A3 BGD BSP20235','C4 07.31.046','B1 FEB14444','B1 SAS9001542','B1 FEB37017','A9 S37470','A2 TC2010','C9 9001542','C4 JBU161','A2 TC787','A2 AK.176411','C4 TC1970KIT','C4 52004908','C9 7146100016','A3 VAC V10-7120-1','B1 FAG829009310','C4 103474HP','A1 TC786','C9 915747','B7 D300023/DKM','B1 RTS96.00960.1','A3 DLP TC2010','E2 103 474 546','C9 5104708','A9 S37487','A3 NKS 5104708','C6 000308','C6 000309','C6 017672','C9 108150CN5','C9 MGZ-101115','C9 MGZ-101124','C9 MGZ-501036')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #