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 ('B1 ZIM24743.190.3','A8 226 741','C9 13.0470-2765.2','A3 VAC V10-2458','A9 FE FDB4044','C4 2474301TX','A1 GDB1768','B1 BOS0986494201','A5 194868','B1 LUCGDB1768DTE','A3 TEX 2474381','B1 VAI25-0521','A2 GDB1908','C4 LD2765','A3 TEX 2440901','A2 RH 21304.31','A5 100371','A3 VAC V25-0521-1','C9 GDB1768','B1 VAL302412','A1 GDB1916DTE','A3 CIF 822-775-4K','C9 PA-0916AF','B1 BREP85098X','C9 0252225219/PD','A1 P85098','B1 LUCGDB1908','A2 0986494456','C9 24409-18,0','A3 VAC V10-8304','A2 BP85098','A2 13.04602746.2','B7 24743.190.3','A9 13.04702765.2','A9 GDB1768','A9 RH 21304.10','B1 BLPADV184212','C9 GDB1833','A3 VAC V10-0767','B7 24743.190.2','A5 194864','E1 30 11 6021','E7 P12043.10/W','A3 TEX 2474301','C9 24743-19,4','A2 24743.190.1','C4 GDB1768DTE','B1 ZIM24743.190.2','A1 WBP1151','C9 QP3526C','A2 0986494201','A1 P 85 145','C4 602765','B1 KAMJQ101229','A1 LP2715','B1 ZIM24743.190.1','A3 DLP LP2715','A1 FDB4044','B1 CIF822-775-6','C4 LD2746','A1 LP2077','A1 P24161','B7 24743.190.1','A2 LP2077','C4 GDB1908','C6 020161','A9 BP85098','A3 TEX 2474302','A8 233 790','C9 0986494201','A9 GDB1768DTE','A1 0986495110','A2 FE FDB4044','C9 13.0470-2746.2','A8 234 114','B1 KAMJQ101298','C4 FDB4044','B1 VAL302496','A3 TEX 2440903','C4 0986495110','A1 0986494201','C9 PF0140','A2 T 2474302','B1 ABS37587','A1 0986494259','B7 1163606910/JP','A1 2474301 TEX','D1 BP ADV184212','A1 0986494456','A1 GDB1833','A1 13.0470-2765.2','C9 GDB1768DTE','B1 CIF822-775-0K','A9 0986494259','A1 573247JC JRD','B1 VAI25-0521-1','A5 269260','A1 GDB1908','B1 CIF822-775-0','A1 GDB1768DTE','B7 1304.31/REM','A1 GDB1916','A9 T 2474301','C9 GDB1908','C4 602746','A3 ROA 2130431','A2 RH 21304.10','C4 2474302TX','A2 13.04602765.2','C4 24743.190.3','C9 13.0460-2765.2','B1 BOS0986494259','A3 BOS 0986494201','C4 GDB1768','C9 QP2445C','B1 ATE13.0470-2765','C4 LP3152','A3 BOS 0986494259','C9 13.0460-2746.2','A3 BOS 0986495110','B1 ZIM24743.990.3','A2 0986494259','C9 GDB1768BTE','B1 TRU07.35.190','C9 0986494259','A3 FER FDB4044','A3 DLP LP2077','B1 ATE13.0470-2746','A8 228 950','A1 GDB1805','B1 ABS37728','A9 24743.190.1','C4 KRO1908','C4 24743.190.1','A9 13.04602746.2','C9 ADV184212','B1 CIF822-775-4K','B1 TOM1713','A1 13.0470-2746.2','A8 230 447','C9 24743-19,4 EPAD','A2 13.04702765.2','A8 241 189','A3 TRU 07.35.190','B1 VAI10-8304','C9 0252474319/PD','B1 VAL302303','C9 0252474319/W','A2 0986495110','C9 QP2445','A9 GDB1908','C4 24743.190.2','C9 19-0911','C9 24743-18,7','A1 13.0460-2765.2','C4 GDB1833','B1 ATE13.0460-2746','A3 CIF 822-775-0K','C4 0986494259','A3 VAC V25-0521','B1 BREP24161','B1 BREP85098','A5 269261','A3 ROA 2130410','C9 19-2982','A3 BOS 0986494456','B1 LUCGDB1768BTE','C9 QP3526','B1 ZIM24743.990.1','C9 2440903','C4 KRO1768','A2 T 2474301','A3 FER FDB4268','A8 224 092','A1 13.0460-2746.2','B1 ATE13.0460-2765','C9 2474301','B7 1304.10/REM','B1 VAI10-2458','B1 VAI10-0767','A2 GDB1768DTE','C9 FDB4044','A9 RH 21304.31','C9 24743 00 551 00','A5 72737','C4 1170127','C9 0986494456','B1 BREP85145','A5 157604','A5 282074','C9 PF0828','A2 05P1420','A1 LP3152','C9 24409-19,4 1 5','A9 0986494456','B1 LUCGDB1768','A3 JAP PA-0309AF','A1 P85098X','A2 GDB1768','A2 T 2440901','B1 LUCGDB1833','C4 2440903TX','A5 113851','A9 13.04602765.2','B1 BOS0986494456','C4 LP2077')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #