Abrelpe - Associação Brasileira de Empresas de Limpeza Pública e Resíduos Especiais
Select NoticiasID, not_Thumb, not_Titulo, not_Data, not_Olho from #TNOT#
Where not_Destaque = 1 and
(not_DataExclusao >= #CreateODBCDate(Now())# OR not_DataExclusao is NULL) and
not_Status = 1
Order by not_Data DESC
Select * from qryNot
Where NoticiasID IN (#NotAceitas#)
#not_Titulo# #Replace(not_Olho,'
','','all')#
Select EventosID as id, eve_DataInicio as inicio, eve_DataFim as fim , eve_Titulo as titulo, eve_Tipo as tipo, eve_Thumb as foto from #TEVE#
Where (eve_DataFim >= #CreateODBCDate(Now())# OR eve_DataFim is NULL) and
eve_Status = 1
Union
Select EEventos2ID as id, eve2_DataInicial as inicio, eve2_DataFinal as fim, eve2_Nome as titulo, eve2_Tipo as tipo, eve2_Imagem1 as foto from #TEVE2#
Where eve2_Status = 1 and
eve2_DataDivulgar <= #NOW()#
Order by 3 Desc
#lsDateFormat(inicio,'dd/mm/yy')# a #lsDateFormat(fim,'dd/mm/yy')# #titulo#