5nqdb/SrNcHD6QAhRqqwqLer03rUaQNaoet//2m4pRiGeJAOWl7OG8nOZST6D7sSusQydt1CSKShw9rMs9BhQSS4wrxuqiA+2WF5EuruLdN82biHWWSfoAFDDjo9w+G3EAeDFYjRViejiHGU6iuC5aOcgNLPZDW8E3CI3F99zJgEw5mhuptrVBqgqozAqcCWD3FgiiWNFuYEpIh3/ChyTxYsWV2NXcZX+k3VmT4Atmje2d3lGZeIboaTOvH9QwlAfMRqCj3J1pZkqJFAP2FonWv3GJoT7Y5IR+62B+2zwV01cEE6MIdqm0d551jpVXFBufZLFsDOwBZVBngGpvW9zehAF8SOuciRGABNxvl6Xsv9vz2m9kESViT4Q/31MybAnI6G/6kgUDEkMEmILQyAFBc/2NbmCWqstdJl3XgmTU6NA9EQgWZIHy3JffygFWbGUR8hlPp/t7eEpWSh92RK1oRQC3t43eqc2UwnB3naR9N4NoQW30/xRHpt/8qAcAiNa0XoiYkkp/iKKR6iQBmVPVUvnPMu18J/18dY2Ii0DR4sZYnEAbIaWu0/v7WeoER48zShjT/d2Ftv9OvaJQ81hqOeEmm9JzF/PmctwVwuoxCwpE5tQbPUVdScLb0nTNJjCKS6i106ABD7wQsO5vRHR8FgG/rAqnFmOWpr3xTTNrPP9qwVdsvsLB9eQrpBrNT6W/t4Nn5ldtL98trenXzlTC6ffufgbjpzNSEn2Cahdkr3TBrsohNwq0t6GApLxFXfrRXCypB0rctK9oKyTHJkIWp0HFTKQ1hTV6les8fY86UPUmJWFjLbyOcfT1o190yUt6VUsEVjjw7lfcg6KrxiZB5lUKXm1kskFSU1mWhjobrvPe9yWQTN+SjRzlXY2QWd0IJUhtlhptDxsYEWLoReH3WI0zaIrs0+0BxtulyNQSTJFnQ79NqHuYjC/QsaECWbcJeEvETiuRsoOar4sj6lk2VlC8F11Euujj1HpEderAJWkgL60KphRarnRiaTiQznZkybxz0mu937BdB0oDz/eSU552rEDTrEaH/hwPWYcYwF8XmOAVsYrDmp6nNwlR8aEV9LgVPi3iYPAQv8Jt7tmjyUXiRb2IJgSwb1YTrkTnpiEIrRHHb7th3tHFJkpGsSdULkI0D/ruE6kvhxpyV8yARvVF5a+84zZaTDZIjOpXmqlbOHOD/abImg+RopZjXSjnCOixhMlONKi9UC088yNL6bJVwRh0iSmtIasN6NjTm41pB8Ex+Ws3agTS0WyRdA7F7+7flSSbhixmJZTYJJVQoFPmB8qZ5ZrBHAk+O90a9jcc+6Etmn2dP5gLOhm7VNYjGzHEyOlqiU2YXuQVMD3Icrja9L5Xkbgyufdxct2yPLGAzGwfz56YHbMu1zWgZAHFIqrhZDVKnWcXb840VSO7tqbvBNXAjdC9PiRulRHjM8h7XumC9o3ceSnqBKGmAGdEpCC2JCTuhz9VCdhjGtacFIKRTUzQ+lIu5YK/CXI3M2+ILNlqnGik8X09gI+mg5QHi/7s3l0Vt+2ccxbLK+GzMpT44vYXtV96XjODNEUOp///R0XvZaAv5a85iU07pQx78ekw8irtDYV0fP5hJim1lIqqKr/SjqHY7dVN0iqXyEBoaAcXOO+D6GNSOPo0UT99AbxhBSX0U5/34rs5Gz/MrxsG3jYNpL7JN8bCmH03cR6sbvn03dnw3FWQM=
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