MjuSf7XWawCR+AmCu+bosvZ2ebKBdeZxud7pRyvUycZASf/7e/U1vYgrk3F5ZOY1MIpyCgH8IqtaeBZL/U1JNd+R60tlmmMOJZRIrISZBEpivUIxtneJu4gcqM+d8bLydI/vUCR7luAqSKZ/6ks5Jb6u4FuFeKQcu9Fl8YyBDh9frhQ65dBKd7PxrBEiTkGjC0qL6hnEH64rF0+kZ1tk5QyGTw9aoBHNibXPjOc8v/7DBemHcTrmaIZUf4YVHKzEszrOQoIAo5Obn2CqCmhmiEKKXB1ChICRUT5E4TFFT8Cx5CmjAiFhD11aJl4ZNSFw86UHSYaWoG3arN9QUyVLLHRjbokc2yerweQU7E7yqGQVRJNqECa63nXtc9+TJsTdxERlQYw0ndPTVkLYhBaxhpVGYyN2hohqCDW/OBebYkeRkEad6/8yILioFtMA398LfPAOw+yIAA+o/aVXUwMWZChIf4TgrUi5j3eUKSPLhdkzkuJNbJ6jRE6DsboSAs+cHamx/uHtfXKiXrtgOdiza89DBDh9uvOA6dVIgJ3JUMlcsN7PBMgSgF4zgNxhAk7+lLs+WTXkecBwzV/cr90loQZE/uKrNGiXUNA6oUHmtsbNemfB9Y7WYSN/+X5IdAIET17058B7lf9lqtbRowJiiqennT8WbMuCX3rtWwCE7kIHkTKFJcHhIAOqkZMDCH4xCJxH8i/WHydvCC75BGLwMcG7HMDBpFnuZatapSuZ0BEKtBSHe9VYqf7Y0gCAwh2yA3MAH4Jah/6+bTGWSCbV4s/5lKZxa8l1GfU0DKmBQIwFp1gYlYnEgQai3I9pGcDfj6ngtwKoyRxowxJ+XXy3kH0v75jbcrJFyuRV15/RPlb0/wD16GWjLWJ8LEyk5BqGAqI7VGhjhzzr2kmFFvBAHsrHYS85cB+XpHCkdIyiypwyOIo17waNx53TPNNxqSCY1vY1y/kVCF9MKeIPUimvMYo++07iWKqBCKCmnuPPmXefOgxXD2jvJoOCoZrfIrwWPZk4n+U5NyppMMGQ/wsDgyymvKxg9PNBV/alndSKs3Aw9w4hvRZybm4BjU+8hh7O3gtSfQEUbb7ERFg9x3h749XIXqjwYVOBWC487LyMXXCmZzOf4S73Vi4w5VPeKzThQgSBCSXg22IG0st5zqw3KGT2e94jvc2S+5cW70LwGRh1EAWifv4cLZGiiZTMDdhShiFKzxbk/Rb4R75N7P36FAGqmU7hVPM6tXchcvekauy3H2MmTmsHfC6WTWEA+CSWxSbSgWVBhb02k3wuh052iNOlO0Vrh/hqwgFNtANUKX/pN7NZ7GO9fXhoB6AFi28k8SOFANChyEih/WFvxQoO9FOBnBiH07hTAXC3U9g=
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