[Error]
Wrong Query : SELECT em.id_emission,
CASE WHEN MIN(prion.date_programmation)>=NOW() - INTERVAL '7 days'
THEN (infem.nb_hit+1)*100000
ELSE infem.nb_hit
END AS nb_hit,
MIN(prion.date_programmation + prion.horaire_debut) AS date_long,
MIN(infem.photo) AS photo_emission,
MIN(infpr.photo) AS photo_programme,
TRIM(MIN(p.nom)) AS nom,
TRIM(MIN(em.theme)) as theme
FROM emissions.infos_emissions AS infem
INNER JOIN emissions.emissions AS em ON em.id_emission = infem.id_emission
INNER JOIN emissions.infos_programmes AS infpr ON infpr.id_programme = em.num_programme
INNER JOIN emissions.programmes AS p ON p.id_programme = em.num_programme
INNER JOIN emissions.programmation AS prion ON prion.num_emission = em.id_emission
WHERE (infem.fichier_vod IS NOT NULL AND infem.fichier_vod <> '')
AND p.num_type_programme NOT IN ('33', '41')
AND infem.active = B'1' AND infpr.active = B'1'
GROUP BY em.id_emission, infem.nb_hit
ORDER BY nb_hit DESC, date_long DESC
LIMIT 3
OFFSET 0
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.