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 ('A1 GDB1468','A1 LP2252','C9 FDB1866','B7 B110918/DKM','C4 0986494439','A8 215 831','A1 FDB1440','A3 ROA 296240','B1 ATE13.0460-7248','C9 19-0644','A9 0986494034','C9 GDB1540','A5 170180','A9 13.04607157.2','B1 ABS37218','A9 23215 183 15','A9 T 2453501','B1 VAL302096','B7 24535.180.1','C9 13.0470-7221.2','B1 LUCGDB1687DTE','C4 FDB1866W','B1 VAI46-0134','A8 234 069','C4 GDB1540','A2 13.04707157.2','A2 RH 2962.10','A1 GDB2053','C9 PF0381','A1 P68030','A1 13.0470-7221.2','A8 236 205','C4 607158','E1 60 91 6435','B1 LUCGDB1468DTE','B7 0962.40/REM','A8 207 985','B1 BREP68029','A8 233 763','A3 VAC V46-0135','C4 2453601TX','B1 ZIM24535.180.1','A8 234 080','A3 FER FDB1440','A2 13.04707221.2','A2 GDB1540','C4 FDB1866','C4 05P898','A3 TRW GDB1468','B1 CIF822-336-2','B7 23215.180.1','C9 13.0460-7222.2','B1 ATE13.0460-7222','A9 23245 183 15','C4 GDB1468DTE','B1 ABS35023','B7 B110919/DKM','A3 TEX 2453601','A1 LP1708','A9 GDB1540DTE','A3 VAC V46-0153','A2 LP1714','C9 QP4311C','A1 GDB1687DTE','A1 13.0460-7248.2','A9 FE FDB1440','C4 FDB1865','B7 0843.20/REM','A1 573017J JRD','C9 2453501','C4 GDB1687DTE','A1 FSL1440','A2 13.04607221.2','A9 0986494033','A2 BD S853P','A3 ROA 284320','B1 CIF822-336-0','C9 13.0460-7157.2','C9 24535 00 701 00','A1 GDB1823','A2 GDB1687DTE','B1 VAI46-0153','A5 195030','A1 LP1714','A2 0986494034','B1 LUCGDB1823','C4 GDB1687','C4 23215.180.1','A9 RH 2962.00','B1 LUCGDB1687','C9 PA-0709AF','C4 05P1279','C4 GDB1823','A1 GDB1540','C4 LP1714','B1 LUCGDB1468','C4 KRO1687','A8 234 141','A5 151848','C9 GDB1687','B1 LUCGDB1540DTE','B7 B110651/DKM','A5 170179','A3 ROA 284300','A1 13.0460-7158.2','C9 13.0460-7158.2','A2 RH 2962.00','A5 143180','C4 LP1708','A3 DLP LP2252','A2 GDB1823','C9 2324502','B1 ZIM24535.980.1','A9 RH 2843.20','A9 13.04607158.2','B7 0962.00/REM','C4 607221','A2 13.04607222.2','A1 0986494033','A2 FE FDB1440','A3 CIF 822-335-0','B1 KAMJQ1012880','A1 0986424619','B1 CIF822-335-1','A2 RH 2843.00','D2 8671016752','A1 598566','A2 13.04607248.2','C4 LP2252','C4 GDB1468','A2 GDB1468','A8 230 208','A2 BP68029','C9 VAL601012','A1 WBP405','A5 118304','A1 13.0460-7222.2','C9 2453601','C4 GDB1787','A1 FDB1865','C4 24535.180.1','A2 GDB2053','C4 16435F','A1 13.0470-7157.2','A9 GDB1540','B1 LUCGDB2053','A1 WBP406','A9 GDB1468DTE','A1 16435 FE','A2 13.04607158.2','A1 0986494034','A1 GDB1468DTE','B1 VAL302221','A1 0986494439','A3 ROA 296210','C4 0986494033','A3 BOS 0986494033','B1 BOS0986494034','C9 QP2960C','A8 233 571','B1 TOM1350','A9 FE FDB1865','A8 224 298','D2 8671016635','C4 1170462','C9 13.0460-7221.2','B7 B111076/DKM','A9 GDB1687','B1 ATE13.0460-7221','C9 13.0460-7248.2','C9 GDB1687DTE','C9 2321502','B1 ATE13.0460-7158','C9 0986494439','A3 FER FDB1866','A3 BOS 0986494439','C9 GDB1468','A2 0986494033','A3 CIF 822-336-0','A1 FDB1866','A1 GDB1540DTE','C9 PF0384','C9 GDB1787','B1 TOM1471','A3 ROA 296200','A9 BD S853P','C9 23215 00 701 00','C9 23245-18,3','C9 19-1102','A3 TEX 2321502','A1 WBP1169','C9 0986494033','A2 LP1708','B1 VAI46-0135','B1 KAMJQ101162','B1 VAL301026','A2 0986494439','A9 GDB1787','A9 GDB1687DTE','A9 BD S825P','E7 P8623.00/W','E3 23215.180.1','A5 78034','B1 CIF822-335-0','C9 19-2090','A9 FE FDB1866','A9 BP68030','A9 BP68029','A8 236 295','A1 GDB1687','A1 GDB1787','A2 RH 2843.20','B1 ATE13.0470-7221','A2 GDB1787','E7 AC897081D','A2 LP2252','A2 FE FDB1865','A2 BD S825P','B1 TOM1351','C4 GDB2053','A2 23245 183 15','B1 KAMJQ1012882','A9 13.04607222.2','C9 GDB2053','B1 ABS37217','C9 GDB1468DTE','A8 241 556','A9 RH 2843.00','D2 EO FDB1865','C9 QP4311','D2 8671016178','C4 2453501TX','E3 24535.180.1','C9 0252324518','A5 44897','A9 GDB1823','A2 GDB1540DTE','C4 607157','B7 0962.10/REM','A5 78033','C9 24535-18,3','A9 13.04707221.2','C9 VAL598566','A8 227 870','A5 78020','A2 T 2453601','A2 FE FDB1866','B1 KAMJQ101290','A5 282066','B1 VAL301566','A2 T 2453501','A1 P68029','C9 VAL301026','C9 GDB1540DTE','A2 GDB1468DTE','A9 T 2453601','C4 KRO1468','C9 23215-18,3','C9 24536-18,3','C9 GDB1823','E7 344.1','A2 BP68030','C9 0252321518','B1 FEB16435','C9 PF0571','B1 ATE13.0470-7157','A1 WBP554','A3 FER FDB1865','A9 13.04607221.2','A1 13.0460-7221.2','A8 207 986','A3 VAC V46-0134','A9 0986494439','A8 230 174','B1 BOS0986494033','A2 13.04607157.2','B1 LUCGDB1540','B1 BREP68030','C9 PF0572','C9 0252453518','A2 05P1279','A2 GDB1687','B1 ZIM24536.180.2','B1 ATE13.0460-7157','C9 0986494034','A2 05P898','B1 LUCGDB1787','A9 13.04607248.2','A3 DLP LP1708','A3 DLP LP1714','A9 GDB2053','A1 13.0460-7157.2','C9 VAL301566','A3 TEX 2453501','A5 206734','A2 23215 183 15','C4 2324502TX','C4 FDB1440','C4 0986494034','C9 0252453618','D2 8671016705','C9 QP2960','A5 78021','C9 23245 00 701 00','B1 ZIM23215.180.1','A8 230 412','A3 TEX 2324502','A3 CIF 822-335-1','A9 GDB1468','C9 VAL598993','B1 BOS0986494439')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #