select * from dnn_tabmodules
inner join dnn_modules on dnn_modules.moduleid=dnn_tabmodules.moduleid
inner join dnn_moduledefinitions on dnn_modules.moduledefid=dnn_moduledefinitions.moduledefid
inner join dnn_desktopmodules on dnn_desktopmodules.desktopmoduleid=dnn_moduledefinitions.desktopmoduleid
inner join dnn_modulesettings on dnn_modulesettings.moduleid=dnn_modules.moduleid and dnn_modulesettings.settingname='NoticiaID'
inner join dnn_modulesettings as dnn_modulesettings2 on dnn_modulesettings2.moduleid=dnn_modules.moduleid and dnn_modulesettings2.settingname='TipoDestaqueID'
where tabid=67 and dnn_desktopmodules.FriendlyName='Destaques'



Select IDENTITY(int, 1,1) id, 
dnn_modulesettings.ModuleID, 
dnn_modulesettings.SettingName as SettingName1, 
dnn_modulesettings.SettingValue SettingValue1,
dnn_modulesettings2.SettingName as SettingName, 
dnn_modulesettings2.SettingValue as SettingValue
INTO #Temp 

from dnn_tabmodules
inner join dnn_modules on dnn_modules.moduleid=dnn_tabmodules.moduleid
inner join dnn_moduledefinitions on dnn_modules.moduledefid=dnn_moduledefinitions.moduledefid
inner join dnn_desktopmodules on dnn_desktopmodules.desktopmoduleid=dnn_moduledefinitions.desktopmoduleid
inner join dnn_modulesettings on dnn_modulesettings.moduleid=dnn_modules.moduleid and dnn_modulesettings.settingname='NoticiaID'
inner join dnn_modulesettings as dnn_modulesettings2 on dnn_modulesettings2.moduleid=dnn_modules.moduleid and dnn_modulesettings2.settingname='TipoDestaqueID'
where tabid=67 and dnn_desktopmodules.FriendlyName='Destaques'
Select * from #Temp
drop table #Temp




------------------    SAMP_Objects ------------------------


V1.0

SELECT     'G' AS Type, galeriaid AS Id, portalid AS PortalId, galerianame AS Titulo, CONVERT(varchar(8000), galeriadescricao) AS Resumo, 
                      galeriasecaoid AS SecaoId, insertedon AS dtInsert, moduleid AS ModuleId
FROM         dbo.dnn_galeria
UNION
SELECT     'N' AS Type, NOTICIAID AS id, PORTALID AS PortalId, TITULO AS Titulo, CONVERT(varchar(8000), RESUMO) AS Resumo, SECAOID AS SecaoId, 
                      DTINSERT AS dtInsert, 0 AS moduleid
FROM         dbo.SAMP_NOTICIA


---------- V2.0 --------------


Declare
@Cod int;
set @Cod=0;

SELECT    IDENTITY(int, 1,1) Cod, 'G' AS Type, convert(varchar(10),galeriaid) AS Id, 
                   portalid AS PortalId, galerianame AS Titulo, 
                   CONVERT(varchar(8000), galeriadescricao) AS Resumo, 
                   galeriasecaoid AS SecaoId, insertedon AS dtInsert, 
                   moduleid AS ModuleId
				INTO #TempGalerias_Samp_Objects               
				FROM dbo.dnn_galeria Order By dtInsert Desc
		
select Top 1 @Cod=Cod from #TempGalerias_Samp_Objects Order By Cod Desc;

SELECT     IDENTITY(int,1,1) Cod , 'N' AS Type, convert(varchar(10),NOTICIAID) AS id, 
			PORTALID AS PortalId, TITULO AS Titulo, 
			CONVERT(varchar(8000), RESUMO) AS Resumo, 
			SECAOID AS SecaoId, DTINSERT AS dtInsert, 0 AS moduleid
           INTO #TempNoticias_Samp_Objects
           FROM dbo.SAMP_NOTICIA Order By dtInsert Desc

Select * from #TempGalerias_Samp_Objects
UNION    
Select Cod+@Cod, Type, Id, PortalId, 
       Titulo, Resumo, SecaoId, dtInsert, 
       ModuleId 
from #TempNoticias_Samp_Objects 
	
Drop table #TempGalerias_Samp_Objects
Drop table #TempNoticias_Samp_Objects


------------- V3.0 -------------------

select Cod=count(*), 'G' AS Type, s1.galeriaid AS Id, 
       portalid AS PortalId, s1.galerianame AS Titulo, 
       CONVERT(varchar(8000), s1.galeriadescricao) AS Resumo, 
       s1.galeriasecaoid AS SecaoId, s1.insertedon AS dtInsert, 
       s1.moduleid AS ModuleId

     from (select galeriaid, portalid, galerianame, 
                    CONVERT(varchar(8000), galeriadescricao) as galeriadescricao, 
                    galeriasecaoid, insertedon, moduleid, deletedon
             from  dbo.dnn_galeria
                where deletedon is null 
				group by 
                    dbo.dnn_galeria.galeriaid, dbo.dnn_galeria.portalid, dbo.dnn_galeria.galerianame,
                    CONVERT(varchar(8000), galeriadescricao), dbo.dnn_galeria.galeriasecaoid, dbo.dnn_galeria.insertedon, 
                    dbo.dnn_galeria.moduleid, dbo.dnn_galeria.deletedon              
                    
           ) s1,
           (select galeriaid, galerianame
				from  dbo.dnn_galeria 
                where deletedon is null
				group by 
                    dbo.dnn_galeria.galeriaid, dbo.dnn_galeria.portalid, dbo.dnn_galeria.galerianame                    
			) s2  
       
   where s1.galeriaid >= s2.galeriaid
   group by s1.galeriaid, s1.galerianame, s1.portalid, s1.galeriadescricao,
            s1.galeriasecaoid, s1.insertedon, s1.moduleid
   order by Cod
   
   UNION
   
   select Cod=count(*) + (select count(*) from dbo.dnn_galeria where dbo.dnn_galeria.deletedon is null ),
       'N' AS Type, s1.NOTICIAID AS id, 
       s1.PORTALID AS PortalId, s1.TITULO AS Titulo, 
       CONVERT(varchar(8000), s1.RESUMO) AS Resumo, 
       s1.SECAOID AS SecaoId, s1.DTINSERT AS dtInsert, 0 AS moduleid

     from (select  NOTICIAID, PORTALID, TITULO, 
       CONVERT(varchar(8000), RESUMO) AS Resumo, 
       SECAOID, DTINSERT
             from  dbo.SAMP_NOTICIA
                where Isdeleted=0                
				group by 
                    dbo.SAMP_NOTICIA.NOTICIAID, dbo.SAMP_NOTICIA.PORTALID, dbo.SAMP_NOTICIA.TITULO,
                    CONVERT(varchar(8000), RESUMO), dbo.SAMP_NOTICIA.SECAOID, dbo.SAMP_NOTICIA.DTINSERT               
                                                              
           ) s1,
           (select NOTICIAID
				from  dbo.SAMP_NOTICIA
                where Isdeleted=0               
				group by 
                    dbo.SAMP_NOTICIA.NOTICIAID                
			) s2  
       
   where s1.NOTICIAID >= s2.NOTICIAID
   group by s1.NOTICIAID, s1.PORTALID, s1.portalid, s1.TITULO,
            s1.RESUMO, s1.SECAOID, s1.DTINSERT
   order by Cod

-----------------------------------------------------------------------