eFCsO6XCSxFVs5hGxxelHYC6sxbMO1xqqS8RPT3X7u3Mm14e9Lj7G7tWVXLCdwCSsMyhdmjV83P+w5RXb70cVkAhyZCEoOpbxMz5mBs2ljDnn47W5G0ZOexdJGhMu5b2oOox/fMWafLzOjZbAEhF12zWibwLZm8kYl0SS1eQiwl+NytMOEGQPxx2jDX1VnEgvBfDs++Jt5Im7U1pdLTw10M0UpsFJXGXb2HmK1UvWQYWttwm0DzsJgwr2j1iD0Yc2qflaoOfFTixOe9qPV5kwhdKAtZCblAaIfCthnb2g2r2BmVn578ZRWg8hH2I5kYckfNBeWWzIwbqGFaoSNdckaKfImm9psjSJTF0yvXccjQ3FuNei8co6KZTZ1GxQXSYPqOBzutLGzAqz3CTsjEzPKLkBJEKowT3i839eDMH/T2tjoQlhC/5+l9k0l8yP73owLlommUfB6Xq/XIHdpQzlI9U3UJCM3WwIj/PF21RKxI30kIJaOXqXzMR+3BKdIU7rDhiBz4CPXTXSngzLhcT4n7KXIJQUsAtSPkkrPUw4TUQB6pfpGnfbtQj3CendMLLs0QLPlPL0WDRUVeB9McdzRjt2gsReSIdC6dCwtFZnostr4bqupaCipaSbn82Ts7+x/jcY1NznFFwhWNkfKBS9PiWsxg97/C+zRlHq9vNj6Gwk9VjRFFg4J9Hu6LrWI6GhDHiK5plVY6Z/DNYN6xfMGi6rAEjk+xUwVFAe3mA78q8qw9Njodq0zJje9In837wrgg5QYXRiSUXmAzbQsO+ELegSqCKgIoa0SDD1Uj+YtpSau6v0LYkZ92IJrszD1kbcm3XqKUXpQ9ku24GAzKTv4voFNugc5BxckVWTA85ZcrnN0qsbmgmvevI6Db962tDhzQ1MiXfkCm51nmHvDtICadA8Hc2zfQAk5JbCYRd2cF2W3fMFdXZOecggMPr5qpYc1RVLJA4PJanpxHw3DA7s6sSbfNhQfT2rwg/gbpluzur7WLnM/b04qVGL8/9PvOxpdouxcnakU6Z9eGuu8BpGR8oDLfgzWdD1lbVUk/IYIYjVrd9ammrM1QdUNz1deFwhIQK2+Y52OxOjQYmKsbwcYpp+y4QSl7YNtfnV0J27EQbMhbcycKH0W7DlcsNDM9zVsl4lfl2qcQ3vNYus9zJwjwRtXfBidzpa9yaRqz3VrrX0/ICDaNqp0F4/Tb2pRZ0W+fjrvacNynDefnkKXU8vwKd1FsqCNp19boBLuldUTYSMTwet7HwMwas2IqedZdE1DXFMUU12u7gwpFV20IrIMAiFl5Xa+XaXgPxjQ6Y6RxZRVJ1C1nvv7TZyCnE6A7QaZlYmb5J1ZiZdAsZHlfLYxpXkYgW9BGl14KUthXA/iPXthMtZ0MsxHk1tOz950nd8fKtlyMPXN9nuUADIq6I8wNPoBFhrj8zW81y1D6FxGp+mLE7qOhKUkzEzTHE+80XMrawRHGUj0UxflZAio5MQeq6tBnApfyg5Z8oBXiqibhNOOudfKEgB9NnYUxJXKLM6X/nB5IuXrT6PDkP9aDuDWgiAl45RhX3rZtM72p3C9SdtbRLAOWwpOKTu7VncGLqw+l36V9naDVQrIFu5WZjdnHaDBDaL4LQ6dB09zOsJdgJ15vwUFonqH8hqHCn7ggvEPF/KIIhHh7dfmd7UNCDpCArLfbxwcWjlkmFJu8QDqSbVwQ3VU5NaHlhaMU=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100