Expression Photography Awards (2nd Edition)
select TIMESTAMPDIFF(SECOND, now(), dt_inicio_inscricao) as countdown, nome_concurso, dsc_concurso, dt_inicio_inscricao >= curdate() as inicio_incricao, DATE_FORMAT(dt_inicio_inscricao, '%e') as dia_inicio, DATE_FORMAT(dt_inicio_inscricao, '%m') as mes_inicio, DATE_FORMAT(dt_inicio_inscricao, '%Y') as ano_inicio, DATE_FORMAT(dt_limite_inscricao, '%e') as dia_fim, DATE_FORMAT(dt_limite_inscricao, '%m') as mes_fim, DATE_FORMAT(dt_limite_inscricao, '%Y') as ano_fim from concursos where dt_limite_inscricao >= curdate() or dt_limite_inscricao>=curdate() order by dt_inicio_inscricao desc
