K9Ttob7j+l3FXattQ4oz0PIsvUs+VtwG1OpEDOZ17mVoqFsSS98v4h0ECoq2aOVjtz8yIzwezv1/55pFVUBW4pEltCd/zaWZps1+tuATu9x36OX5M7sKJBoDJIzaqMYx1HlPMjiGZOM+tLJij2MP7PUXpZoSD38oLijpL4Sx77o4Lm7JXc+RgjOaIxt0vkbpiEknfpyQuEeM2OSgf7Sc02QwkC1IH0DeGiGR3TVOjQCgAchmnS2GUmCzcJmu+mlyzW0aeWYCNg3XQNqoThwhmNHvsKP8445Q0b8GZe77vsz4odnsUugpQGuBMDlKQEISxMt95MFfS00jHi4a2ZJgl3ZCScvM9Vi2N3ONe9YcgStZs4RUl2zLZsfmMU7DWrKAJe/7CY86dsUUC3H4zdXmWiU4Tejw92fTVQO1ozyW+TklRN9p5zMnlgUSjstpZ/4I1OiLMEtr2KLvvslf1IjaRCe9Y1sVMUdYq1HciJIYVWITieUg9TXs2TSptWxMhsfOh35lNybJRqfMwZyJjjPA+o0Z1Sf15KGXYoWrpiMXNGpNWSFixTuwUFZHN9rcP1a9yDJSPm5fvfh2iPlLH5plDKIszP1qLmXSkjocYCtBc/5WqfDEqSHlwYfyFRN5BY4eAmEanPt5AuX1pubCIh4Q+v2yLvNptP8pgZzCvuzWTLQTIwsBFebS62Z+YvnR1wytwRVDWpA/EjjKCaSLGWNnfiyG+xsf6iD6sk8AKkTtQSBhdACGTuBWqdkTQzbSuros/9mRYy58ZSRRlJXCrfgKfRhIYu/GlkYl3bFJrjYIWJZZOGg/DUYaX9SeDiMUAIuVllxrpU65pPuz2Z7Lq/rCfeALimKjULV2yaq1LAxit5SIJXILuEg14S0mfDLk+b6vCXY2eAdAica/LCiyhQxAEZPj8OmKI9kf7Ysi73s4LINpEo+sMm0cztSOkCtsDJF3ABXa8EpQcY6CDap/rI0IW9uHU+xVlDvYXtHU+aAHCQjFSELZUIs/0ks2a8bBx1fGYa96QmMI/4qeVMrO+uMBuL7TwZij6JeKgGxDyXOcvQsf2rc80BXn/uOOTLPUSUNuOQFOZTAtuBozbmNHxbaC/iHf4+NYS1Hk6uWd2vx4HuwaFZPCywF6kj4g678RUFk/FqRx1sxonZJWDJmDqIJz1OWZCqB3u/kgXDH+pownVboTF3RQLNQgO+62WJrHfG1sqJWDlT+4xKpIKMR6OQt/bNfpn6QTWVdYKFPQ29Y+N/+/8EMDVVVdAhyxJF+h73/whfbsFN7CdtkZK1Gx3hTv/W34ADQ0DeXCwg6Dja9xNynY+mhRglAoEayhEIeEVAjC/qVtl/zbAkQLlNYntyv1l4GTCwPJbgXTQ0kBUMA=
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