2si5AhtWyiRXjtWpAJDLbJYa4lTu+tZUanDxxIIwBxBZSgz68q9W4Pq38rCg//7n/Rkywe656jKljxKxZlPPyeylr5DJ2psobpiKAXb0uBzS9Uq5EFxMWOA4TTZZE1NcKnVo/V5Fg38zvljADkw2EEJVWWA8MUqZ4htu12bkCuLLCwaFTCpWYybBhQGHt8U1byIYP3H4PyBUbc1VFzP3lZDP2wxng3OERfRZgg6arGcWBWSmmbKN59nLKBL6GZdN2UaYvGCqXZzVVM14CCRDqp/apTdOixnqPqZHzecgG1SzKeCCGHB6Zv4lT6+BtmmvzcoeTvdVZut+PRJKjA6G/DYQlwiIIM9x8yIXEgPNlv27AgqkcrU4dZRdz+QQ712pCtdm3/tByqSE5xlvghXJ+vW5xPbwEjkkLzl3Gs7MlS1emKQl+vWhOzvsBugaPThBjml4YuoumqYDXM2Eba1O524C4zQI0cLEnnI5A58iRHvfaP8/+MMXzcr3Ef0JOgxzJbBTDv+IJQtm/Ql8sGaqazGo0r7qUnx4zqi6BM0POIgNQxABtHPVC2r1PNHMt7W5z4nBZpJuyzwdvQ4ycNACz0ZQVim9YWC0hAlPYwx9y8RXVvce0rZupPZZVil08PP3qDNHDFyEi+vqvVmz3Oo5A07JMm7Zwiw7TmAnFpA/F1RtVWEB6HHvRnmuT90/L7Q16a/NyGLhR9v0v/OQILGJWldcZWJWA5yJuNjH8tmZp1Gxe7/uWsPbKhguwaFf7D9EztDGJXiTAyetlyGi/KC3X7gS62KLLg/NoWu/cFrNpkCWgNTsxOeZmGa3hgbCbPnSsSE8/ExwQ/BJzmtGgMvNktFdHVOhZlMRQ7Hp30+egMCsZyRzW77WfrZ5AAopSWggi3XIjBra3xld9/A98rJsv1w9ssj0l6r3Fg/VflQ/jMhunRmUTGkZqgqn3bYvMmEXaXC9xlh8T0AdMP0cMEzV0qImdfT3MyqUOAU15zuG1oYLzHWAjWkDFeChdbCPy8BMqQxdBkSFiywIIl0wC1GB6cv9ELMG1ZVDJSCiVebMtyV7VdYkRV+s16WXmG3+teYcsQmNBaZGyKMhzJJBycF1D7ut1j0WmcRSNxNt8cj+zOvldJnrnmaeY/mcpT3OYP3esP1TJrrRNmw/+YAF60z5giOCT4IzaxlzHcqURcbXgi/KrS+LjZyhtRaHTC8WT8dxx2i/ALyxLe7P77Gr90ZdPPS0wNykvDTkPVKOLd+J6WrUg3MSzdxRDDXTUyz/2qOW07QCfqasEsPfPkbIkp666MfXoewH7y3iTPrEGRdU10yEnOmMuWvqtFMjZn81f/uDxgrr+unDjXAzFpKjKiufhOnjzhbw2Q7MnAhYEFY=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100