SELECT
age.institucional_id as age_id,
age.institucional_nome AS titulo, url.url_amigavel AS link,
age.institucional_imagem_pq as imagem,
ueah.dia_inicio AS diaInicio,
ueah.hora_inicio AS horaInicio
FROM
institucional age
INNER JOIN unidades_em_agendas uea ON age.institucional_id=uea.agenda_id
INNER JOIN unidades_em_agendas_horarios ueah ON ueah.uea_id=uea.id
INNER JOIN url_amigavel url ON url.campo=age.institucional_id
WHERE
age.institucional_status='Publicado' AND
age.mascara_id=37 AND
uea.status='APROVADO' AND
ueah.dia_inicio>='2021/06/14 00:00:00' AND
ueah.dia_fim<='2021/06/29 23:59:59'
ORDER BY
ueah.dia_inicio ASC limit 50;
