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 ('A5 217114','A9 ABS37142','A8 064 591','C9 PF0529','B7 B190096L/DKM','A2 ELT 86-0180','C9 23224 00 702 10','A2 05P1303','A2 FE FVR1132','C4 D-4846C','A1 LP1541','C9 PF0542','B1 DRI4292300','B1 ABS522062','B7 0767.00/REM','A3 TRU 07.35.142','C9 VAL301482','C6 018680','A3 BOS 0986494051','B1 VKA66151741101','B1 ABS37118','B1 BOS0986494051','A2 D4-846C','A3 TEX 2322416','C9 13.0460-2872.2','A5 365542','C9 0252322417','C4 DC72821','A1 16412 FE','B1 TOM1390','B7 B110901/DKM','B1 KAMJBC0278','A5 73634','B1 KAMJBC0684','C9 PF0258','A3 VAC V10-8148-1','C9 27-0450','A1 2322416 TEX','B1 AFND4846C','A9 23224 173 15','C9 FE16412','A3 DEL DC72823','C9 2322416','B1 DRI4192300','B7 B110847/DKM','A1 GDB1324','A2 ELT 87-0180','A8 230 131','C9 ELS87-0180','A1 GDB1369','C9 QP5531C','B1 ABS522061','A2 13.04602872.2','A3 CIF 822-346-1','C9 GDB1369','C4 2322416TX','A3 VAC V10-8148','C4 DC72820','C6 018676','A1 P85046','C9 ELS86-0180','A3 DLP LP1019','A3 VAC V10-8149','A8 217 860','A9 FE FDB1482','A1 13.0460-2874.2','B1 ABS37142','C9 82-0020','B1 VAL302424','A8 253 654','C4 16412F','A5 78026','B1 VAI10-8148-1','E7 355.1','A1 FVR1132','A2 LP1541','A2 13.04602874.2','A8 206 599','A2 23224 173 15','A8 236 866','A1 87-0180 EL','A9 0986494051','A9 DC72820','A3 DLP LP1541','C4 602872','A9 BP85046','C4 0986494051','B7 23224.165.3','C4 D-4846K','A9 GDB1369','E7 355.0','A2 RH 2767.00','B1 TRU07.35.142','A9 ELT 87-0180','A9 D4-846K','C9 0252322416-1/PD','A3 DEL DC72822','B1 BREP85046','B1 ATE13.0460-2872','B1 FEB16412','C9 0252322417/PD','A2 ABS37142','A3 DEL DC72821','B7 B110902/DKM','B1 DRI4210800','A3 FER FDB1482','C9 82-0052','A1 WBP427','C9 13.0460-2874.2','A8 064 596','C4 DC72823','A3 TRW GDB1369','C9 23224-17,3 1 5','C9 0252322416/W','B1 FRE738911','A1 0986424748','A2 LP1019','A1 13.0460-2872.2','A8 223 798','B1 VAI10-8148','B1 BOS0986494619','A1 LP1019','B1 CIF822-346-0','C4 05P974','B1 ATE13.0460-2874','C9 500038704','B1 ZIM23224.165.2','C9 D02519K','A3 DEL DC72820','A5 301757','A2 0986494051','A1 WBP312','C9 PP-0301AF','A3 TEX 2322415','A5 119356','C4 FVR1132','B1 ZIM23224.165.3','C4 23224.165.2','C4 1170184','B1 AFND02519','A2 05P974','B1 KAMJBC0683','A1 WBP295','A2 FE FDB1482','C6 018682','A2 BP85046','C9 19-0444','A2 D0-2519','B1 VAL301482','A9 DC72821','A1 FDB1482','A2 DC72822','C9 D4846C','C4 D-02519K','A5 181767','B7 1163706110/JP','A3 ROA 276701','C9 FVR1132','A5 221596','C4 D-02519','C4 FDB1482','B1 CIF822-346-1','B1 AFND4846K','A9 FE FVR1132','A3 ROA 276700','B1 KAMJBC0277','C4 602874','A8 253 596','B1 TOM13901','B7 23224.165.1','A2 GDB1369','A1 86-0180 EL','C9 PF0586','C9 82-0051','C4 05P1303','A3 FER FVR1132','B1 VKA66151741001','C9 D4846K','B1 ZIM23224.165.1','A9 13.04602874.2','C4 LP1541','B7 0767.01/REM','A9 D0-2519','C9 D02519','A9 13.04602872.2','A5 136659','B1 AFND02519K','A8 222 450','A5 301756','A2 RH 2767.01','C9 0986494051','C4 KRO1369','B1 LUCGDB1369','C6 018681','A9 ELT 86-0180','B1 DRI4110800','A9 RH 2767.00','A9 D4-846C','A2 DC72821','C4 GDB1369','E1 30 91 6412','C6 110213','B7 05P974/SUZ','C6 018683','A1 0986494051','B7 23224.165.2','C9 0986494619','C9 82-0019','A2 DC72823','C9 QP5531','A2 DC72820','B1 KAMJQ1012964')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #