q2ZpuWuFfWS+gnbIFUFig6m1qFS5xccZ+PIBRCxlJGiPUYxK2MfeyJLT/u/wWBXfD0tFu2/OYhrtUGRcSRG8YdDGhQDYcXmf63UHRp/NnByJlM2AwBYo03BtULYorxz/8V14ZTc4eM2CXVG942oAqH3F1m4xTTH/rhnbiF/JCRI0pqmzl1pKjqRa7vEW6BdH9WTyaPfTYEgFoID4lbbpHSzPPbcUhVkj/0oVP7jaPbSqc4xMaLpuJPRtCWEMgt/9qqv13ndcMShICgXprvlLU+B2WedXb8GaVOb77wr4uxQLCuGfBhQwaUiai2NAeJwjIjvT7caPlB5QaWHfmQ9cdZpmWPVkzHPlTqtRxRg8hAmlMroHUzy1jTWCRjort/rKYkt/CcCiCZ6O0K3yoEY2gxAMP8QVzGWJF/uMO5SDRoEKcHQaajUxW5Agpon2L3aQJGFjJGdI5GiL+3DKsj4zCteIdyEbxs7XvSxjslLevkst6OCMnYAAu2ZXILvpK9qSnEuhCa8llx9EFoErVYZWz26O4V7HlSe2gTYSuIiPB4Lj9ohe6g7BbRVuj/wy5mM5+6Lst4ykbQqjwflqs8eqWNSddiU93fVY6eCHTS9HjU9vFo1ziF6+0ZsWDuOusCUwXnY/iubWFpHfvAC51QoUMvgCBEdmepG4zHxHtLS4JWI++XNj1urb4y4fonULkAR+nwAeayA4kGiK503dZ7bgKWiYi9WPz4nyS1t7Tz94y5sboU/wNTmQSxQRxduuZeyHymdP5+rlbws01QlJvAhdUvL1Skd/SuUHohorEt9YBYl0/qh5a/yrLhKQHPbKQqnQDsbU5tNKKAFwo+K62X6jT4pxhFB4L3L47vcDAnFXEtiGDqIZP2+X4uhgR1kCAXHz5d0k+gEAcY+pt7ozhyHOmg318szqh9PCd/OPDJrg8rQ1SQiX0C9025dKl358yoLYfVHJLyckf0pGM+sT1fYWEuvaK/uJQ02Gbr7Yx/S+dobyl2AhwJt8Kq0VPDjffUjhweSWPt34KzEXMa7fJ+PnJqyJZseSWhMPs636Vfg8EV+x5Lvlxk2ZulFOs6xcAtV1iTVGp6kHNRU1TFEUm8SE0HNDkaC9ArF9f7QexwWD3Dm5ErGFpGieK9fCOU3cZ3Qc1W2N1xSdULFxZMOfH71uz8hZ/RlTIG07qCZTOC6yWHEFDl8HHskBHqX/81ODB5X8GnsGjIZ7GGdhX4+hkqmUMnIn86gMRkxe937f2gWMs3YhMkRZXuB4qCe8AcCx2chceF7kKmUFPdG+VmPl85cYBhOm3Zz6UIwUKgDtsD24RyV8arfKsygcnAOFIvLJ7cPWmlNnDx6Gt3c1UmObI02CbYXV+0Du7Ab5zjXSfa4=
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