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