Fe/xXcarh4zvggEh4unhXTwaQOC7Soz4g1iem9EfBhdyi5PLmzHEIhULswPif/p8ngCtgW+6jEbf5W8b8VcfltsoHdFyQv7qNO+2ZgpVmQNr8qVgXl6Q2cl2SSlcWGgOhbJhcc2xiVXJMlpyu/bZZIUYl8p3TVav0gqDjkpFyNXG+H/MVNsTRasecA0cblVMqGvEbIAroafe500ZDCL8+RJX5dr8G2WLlFdF7Y4l7X323plVv3K14laGbUk78f0pzAnrFRPImwe/RQ764N6cBStzuMJhuZVQNSLSrp+Pxl1jLaZUy0hwfTufxlRjtEvs8gOAjhYv7k14+vr1MC9PgTjmgihfCrgpqYw0DiD53ZbA9KpT+qEWd3U13tkaWhWAJTUkoXk8EOJeShonDfafdGxQ0+etxdIa/M7GAOdQAy+OnUHnTNm2N8B1T3KtPAFeAkSEpadykVHEJ/L2c5oHDeFaLrOup6tbHqQZIxqash8VZbFy3ZkI3CiMLu6ozWmCLGxDwgEres+hWXZteIdp8k0UCe0yOxt6UFvqmHlVGBiRe7GCwwdq27wSofEksohs/nUx0PbgyiFgP2QunK579HZJOYjeDteFtn7NFepZgIckJjiWBDSof7prnTrSdg1VR9EXMSo1fIFhc/KwFQjTdAq8zt3eUnpJFdbOADUR2X0qjbHAhlEuL+5mw3lZa43tsbG49mccL+YxM03y/OoEPcHm8jycQbtc8YOHQSBrY0I+zDeyxN52IdWlUZIXQRRjqbbFjbYy2XOtEqwFz4Ie16tnwGNu+wl9CkEMliC8Ml/9v+/Lrh3uojvSfjtT3uuw/n910qyQryflr2QiRQQFYFhtIy1ccme0Ul0Zqu4jig8NNzgEZZ3IjLYl1wNz2arb49LFxQnx6fgUi1x/bN8IORFxsYP9UEqIPvxYprdU2O09TjiAxxmULb5OHo9n++/B+3zvoNXKZYReIKFHXbxXCXTZJkoLDB2bIOPjfumWoCRnA3WU6RsmfHI69eEKqSp9KR0ide05yYT0P50VOxIGEZaT2hn4qMEfqgV43SXaM3bvZ+jSU9MiXG89F/uvgbj+EIMNFQAUxrQ8GBY6mpd+DfNBULiilDnVGvkEfR8npzCFS23WRvFq/oR8ZC1G37bHeQ0aN++tXR4fMjmeBqsJQP+fP1iHHAWgZ+JAvBCZ1n7VogKjydZ/EgNH/kWfaJGkJChLe91hleNszjqwa06cEtoLPgQ5X7UT01P5AiQUV1w4aN3agkwF8TR6VLjFHtAM7tYQMPgSr00G1e3FK6Jydkm3iHzDE6FTu/Z+g2K9nLlsrDslHh5OVTUCk0j/jOcL06OhKbL7IIMQw18c12DXPUQxyGJS7R1BCF/WMro=
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