SELECT * FROM [WebBranches].[dbo].[web_premi_pertama_dokumen] WHERE no_spaj IN (SELECT no_spaj FROM [WebBranches].[dbo].[web_premi_pertama] WHERE submitted=1) AND [server]<>'\\equity-elife\' ORDER BY upload_date DESC
SELECT * FROM [WebBranches].[dbo].[web_redemption_dokumen] WHERE no_polis IN (SELECT no_polis FROM [WebBranches].[dbo].[web_redemption] WHERE submitted=1) AND [server]<>'\\equity-elife\' ORDER BY upload_date DESC
SELECT * FROM [WebBranches].[dbo].[web_spaj_dokumen] WHERE no_spaj IN (SELECT no_spaj FROM [WebBranches].[dbo].[web_spaj] WHERE submitted=1) AND [server]<>'\\equity-elife\' ORDER BY upload_date DESC
SELECT * FROM [WebBranches].[dbo].[web_klaim_dokumen] WHERE no_polis IN (SELECT no_polis FROM [WebBranches].[dbo].[web_klaim] WHERE submitted=1) AND [server]<>'\\equity-elife\' ORDER BY upload_date DESC

--SELECT * FROM [WebBranches].[dbo].[web_redemption] ORDER BY submitted_date DESC
--SELECT * FROM [WebBranches].[dbo].[web_redemption_dokumen] ORDER BY upload_date DESC