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 23248 183 15','A8 217 809','A1 16427 FE','A1 P68040','C4 0986494033','A9 BP68030','A9 BP68040','B1 CIF822-336-1','B1 ZIM24536.180.2','B1 ABS37218','A8 215 831','B1 BREP68040','A2 FE FDB1441','C9 0986424616','C4 2324802TX','A3 VAC V46-0134','A2 T 2453601','A3 TEX 2324502','C9 VAL598471','A9 T 2453601','A1 0986494033','A3 TEX 2453601','A9 BD S825P','A1 P68030','C4 FDB1441','B1 CIF822-336-0','B1 BOS0986424616','A2 BP68030','C9 0986494033','A3 ROA 284300','A9 23248 183 15','A8 236 295','A1 FDB1441','A2 BP68040','A1 P68029','C9 FDB1441','B1 BREP68032','A1 FSL1541','C4 2324502TX','A1 FDB1865','A9 05P864','A2 21248 155 05','A3 CIF 822-336-0','A2 BP68029','C9 23248-18,3','A2 0986494033','A1 P68032','B1 BREP68029','A1 FDB1541','A2 GDB1468','C4 05P864','B1 BOS0986494033','A2 05P864','B1 LUCGDB1468','A2 FE FDB1541','E7 345.1','A9 BP68029','A1 573017J JRD','A2 FE FDB1865','A9 GDB1468','C9 23245-18,3','C9 2324502','B1 VAI46-0135','C9 GDB1468','A5 195030','A9 0986424616','B1 BREP68030','A3 FER FDB1541','B1 CIF822-335-0','A9 23245 183 15','A8 209 445','B1 ZIM23248.980.2','A2 0986495264','A2 RH 2843.00','A2 23245 183 15','C4 GDB1468','A8 233 571','A8 219 757','A9 BP68032','A3 TEX 2324802','A3 CIF 822-335-0','A5 151873','C4 KRO1468','A3 TRW GDB1468','A2 BP68032','A3 FER FDB1441','A1 0986424616','D2 EO FDB1865','C4 0986424616','A8 230 174','A2 BD S825P','A8 207 984','C9 2324802','A3 BOS 0986494033','A9 0986494033','D2 8671016752','C4 16427F','A8 207 986','A1 0986424618','C4 FDB1865','A3 FER FDB1865','A2 0986424616','B1 FEB16427','A1 598471','A9 RH 2843.00','A3 VAC V46-0135','A1 GDB1468','C9 24536-18,3','D2 8671016635','C9 0252324818','A9 FE FDB1441','B1 VAI46-0134','C4 FDB1541','A9 FE FDB1865','C4 2453601TX','A3 BOS 0986424616','C9 2453601','A1 LP1708','D3 05P864','D3 RE 84300-AF','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','A2 LP1708','A3 DLP LP1708')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #