Ixomajyf+pra/OyTkSEMDYqVBCHtnl/42Zitu79Z8NqTiOofgcOviGXJXRVAtXF8PsPub5lLU+E0zFn9lE/K7z11xoerVD5LSe4g9O4cVBSksUH8ND/DT9uX9XA4awIcpg02foII6WDW7VcuF6NcaYjpQNhYcqsTQy906N2BaeTygKSyxX+1IrlsZlkXNCaH1Leu+J0L2abs6U8Pk0mFVcAAoChPRxVF/EqnIkRWEQ6i4eH6C8fPlcs8/Rj6/dYORsh30nO6aynBYlHw50LJlZjiw+M8ph6iIyX7FUsZqPV8mtvjvq/v4BekSyw5Xhqn9drFgcmAOnkPldbruVP35wCSLjRjnFTdyXQJ1pF4O+JbpjetiVZWbOb10IFu/CdjNXeG8Mjm+QxDnoYoE55KtMjmjKxNcMZCQVcLb0kv/yHGoxOcabRLmrZWNvJFfJhlUY1FOuS3zlnEluOZucgtc0IA8zpeDQNZhUqlhbee3q8tCO8WAqF4I9xKNCMSRxuD2qzOEIKqvFGMziKdFECZhrLJyfm/izvh3n968HdjRMjh10xN9ai/M0+vrFSlIct5mE6eTulTErEv2ulKCp+pfOAD4EIAmjB0GAqD5ZtUK6MZ/H7Ic3DjXrpOrV6DnJmziDiG7vqW54IWBHvKpFiWkKMGZRZek+fpptBP0B0D2pg+7+51kIulRrMZRIok0uvWjqMAp4K9xeSRQ5PizAdfJSrqVolkijTObu4l0peK5q6BIv1Htpu4WwLvOkws30qTlRKwSQgF4DlKzGiPDv9c0apCOFc2IwqhCW0vM8VUs2nTQmSg0acXaZylk1G1BuDVj+ujESc2JSkC9bJFq+iVUvV1xbnpnL5BaLg3dYtp4U9TeHlQt1Gs8O+f1qDE4mFFEzR2d7LeYhWn8u8QuX8HsStvJ+ZZa5ntcV2fA9xzbqui2rB5nOOVmBi8o5/HD+72c4wcGqT0zMYK71aWoEvGuqO/yM1g1uiiwmAKp7HAx9UNXRAxy5u9SmjcCVZw9JypQPOQ5lDZfxjO2sWW+SLlNGFoWXucZEqZ2IbnE5NR9VAC8O470741UEgZ7vNl+/frFPHVRwkGhNGyuGIUgrJBc69BerZj//0lbwI1dLL7wC9w7vuQH+QHqdoiQzThZ9XECrotpmNJ53YRvp2dPPOGtyog8UcPnbmd6ieaz8/sdnPC0Tk7O5Wr7p/f4A5YtLm9Snx/xuq/CXZCfwDxpEoa41CJBFIIVXF4QcsBIZ4P/QW9qWLaTgcFTsFI3kLfKKN2LxaWg87LJElo39KQoCce2NHcVmmJSj3mEWdT3B+TnMd1FeJPycqiadjKy5ROUXoUTeU/G8wueC3ZAkJRaNRc6UuRRgcZK1WUtyqgUhg=
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