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 ('C4 2453601TX','C4 FDB1441','B1 CIF822-336-1','A3 FER FDB1441','A5 195030','A8 209 445','B1 VAI46-0135','A9 23248 183 15','A3 VAC V46-0135','A2 BP68032','A3 CIF 822-335-0','A1 P68040','A2 23245 183 15','A3 BOS 0986494033','D2 EO FDB1865','A1 16427 FE','A9 RH 2843.00','A9 0986494033','A2 T 2453601','A9 FE FDB1865','A9 BP68040','D2 8671016752','B1 BREP68032','A1 GDB1468','A9 BP68029','A8 217 809','A3 TRW GDB1468','C9 0252324818','B1 ABS37218','C4 2324502TX','A5 151873','A2 05P864','C9 2453601','A3 BOS 0986424616','C9 2324502','A1 FDB1865','A9 FE FDB1441','B1 FEB16427','A2 RH 2843.00','B1 LUCGDB1468','C9 GDB1468','B1 CIF822-335-0','A8 233 571','A9 BP68030','A8 207 986','A2 BP68030','C9 VAL598471','B1 CIF822-336-0','C4 0986494033','A1 P68030','B1 VAI46-0134','A1 FDB1441','A2 21248 155 05','B1 BREP68029','C9 0986424616','A2 BP68040','A2 0986495264','A9 05P864','C9 2324802','B1 ZIM23248.980.2','A2 23248 183 15','A2 BD S825P','C9 FDB1441','A2 GDB1468','A1 598471','A8 207 984','A9 23245 183 15','A1 FSL1541','C9 0986494033','A3 FER FDB1541','A8 219 757','A9 GDB1468','A8 230 174','C4 KRO1468','C4 2324802TX','A3 TEX 2324802','A9 BD S825P','A1 P68029','A2 FE FDB1441','A1 0986494033','A1 P68032','A3 TEX 2453601','D2 8671016635','A9 BP68032','A1 FDB1541','A2 0986494033','C4 FDB1865','A1 573017J JRD','A9 T 2453601','A3 CIF 822-336-0','E7 345.1','B1 BREP68040','C9 23248-18,3','C4 GDB1468','A2 0986424616','A9 0986424616','A2 BP68029','A3 ROA 284300','A1 0986424618','A2 FE FDB1541','C4 0986424616','A8 215 831','A2 FE FDB1865','B1 BOS0986494033','A1 0986424616','A3 VAC V46-0134','B1 BREP68030','B1 BOS0986424616','C4 16427F','C4 05P864','A3 FER FDB1865','C9 23245-18,3','C4 FDB1541','A8 236 295','B1 ZIM24536.180.2','C9 24536-18,3','A3 TEX 2324502','A1 13.0460-7159.2','A1 13.0470-7159.2','A1 573025JC JRD','A1 GDB1540','A1 WBP554','A1 WBP743','A2 GDB1468DTE','A2 GDB1540','A2 Q109-1187','A2 RH 2962.00','A3 ROA 296200','A5 77624','A5 78033','A8 230 208','A8 234 069','A8 234 080','A9 13.04607158.2','A9 13.04607159.2','A9 GDB1468DTE','A9 GDB1540','A9 GDB1540DTE','A9 Q109-1187','A9 RH 2962.00','B1 ATE13.0460-7158','B1 ATE13.0460-7159','B1 ATE13.0470-7158','B1 ATE13.0470-7159','B1 BLPADR164209','B1 FEB16435','B1 KAMJQ1012882','B1 LUCGDB1468DTE','B1 LUCGDB1540','B1 QB109-1187','B1 VAL302221','B1 ZIM23245.180.1','B1 ZIM23248.180.1','B7 0843.00/REM','B7 0962.00/REM','B7 23245.180.1','B7 23248.180.1','B7 B110651/DKM','B7 B110919/DKM','C4 23245.180.1','C4 23248.180.1','C4 607158','C4 607159','C4 GDB1468DTE','C4 GDB1540','C9 0252321518','C9 0252324518','C9 0252324518/PD','C9 0252453618','C9 13.0460-7158.2','C9 13.0460-7159.2','C9 13.0470-7158.2','C9 13.0470-7159.2','C9 19-0644','C9 19-2092','C9 23248 00 701 00','C9 GDB1468DTE','C9 GDB1540','C9 QB109-1187','C9 QP0383','C9 QP0383C','C9 QP2260','C9 QP2260C','D2 8671016178','E7 AC897081D')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #