RQA/d9Ios0g/zoS/oPVaXiyBntm43mvIULgP0X2hN7XNLzUM5HpVtoNWvGV2XAqaSggM2NIP28oM1ydH7Pd9FpuOCjAx5ALdrfbBPFfMXt64SiPO8dP65QpiJhxwd8OpbvTU/U4a6VoUFRA5gYrNrNYG290S0G1wbi3nzKNDeGPR3YMLS90JpUmvkM0DmjBTGKu7zDOx4NWrOgbEiotJdcg5SyxYK1XPH9ZPtvTEzDuVamH/md7nd1DTSc0AhRn4ZjxIEKK1VLJoM/0FayihgtJZkdDuztqmWfoFHyAIBIeJMHa/d02Vk/t8r5blJxejhq24/efeD3znkPKnem2pZ3bNbs62SctU+CMldV8ypu5C0wczygfmAsb9P9bYQpwiBuRxYpiPY205aoIoFbVFy+6bvw+/ugNVUmMpSfCqYYe5vfDERHImSe3R1xTrwKV2+KQ0Xzl5y2gcZPN4rBksvJ/ey46k9sb4L79+RCunVQeDf4T8Q0Sqp98atBgBuMjdcyRy1lZR58N7/FHjiXasTy9cgo7iFKY+mIVI/y6hluzukhPOVzATgcMZiMvDiLiFLiYG7ScDHY2d476VscKzE9f9WXZcRjFlbe0JqDxt1lPea1A/99BK9LhLu1gOa7Gf4MTkuCNvZX92skeQLShsMkHRJTQ4dX/sS59LxitZIJphxCN58/Rn1ldb7zPRG9uYjfzzXJ1BjUbNsdgXWQ//QZ+VwWlTdzVgbUTTJRxct6jg7fuF3krd3K955j6qk9L5X1+czaB0R2wkOlT3N2EZ5r0n94a6haC9dt36Fw0eDm2dgNytB9rqJx0KLtttZ5VgGZHNMwYugZdmml6dhA5tRLRW/LKwUAcDlRG0lIDUGXZYVHa+ZRaPSnxCHMFleXFHViX8ckioz4ZBHZY0SCQX6qOQ1XoWSSedjn3kpzNQP/x0Czhssei0nKlWjFjHbVOeDjed9mxwzbbpim9YnR7BULpMGmjW1fOpkzIGX4U8NCTcJGgntus+o7wPdXgHIReGO+G+ENmsKWZKSGLBfsnQcRLrGqIQtMMBkfGYXaXiWp7kb9HNqIy2WSff4pr+wVzdN8wdaT75n0QNAL39LgVLKXDjE3/CUkY11y4wkzuSAmNn8b9Nis/EBdHQ8h0phrgHJtBmHdqEz5UJsxduNWZsIKnTuUNmq1dA7GdyGlvAqo9pHVvfPoB3ERYp+Fewj1gh3WbPVoL/lemP4WtAFF8ltuqq2l091MFQ5rLnkO3ruL6R6qgfNXl/OzbFGHlIfvQpCI19qJ3dlMUgaQkeSoVsJf9LEjNjIrSPhTYvznHOLGg+oySyemcbHnh5SXMz33bjCNFGY4QwjizkieMO6jKkDRUaGOC1kC4xEioJwrI=
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