uTOLz1+moZu8MTM2pBtJdcqDVOoGX+favxSO7Fc/+cXaxcsSQ4eRG3xVFHIvDA5MZUMbvxSXgonHWOrRNZoclgSq2bo6ZrjPe5MQYA7CYqefJmhllm5R/x56tQ/0TZdTr2giHDSE63gutd15m+vKnGvyHF6h6Yz7sg9cN8ZULBTEv0Vd6+iKKYod8Ty5mDZGYRELRNEkyU5rI//wK5tozQl8cAvrqZqOYpCFBWVVlxes80ifFi/sAh/pOtqhBIE1lpD4vVF5rMLqc5ZTKmIeOYZ2I7ARF5m0mOE2i3VREUOIShxeIMbEuqHU1UfW9ns+Tr6qmFdyqiahGC7n/F0i+hbPj4dNr8JHGrp2arVwHCWz457CrgPq7igGEeCXKa0Q35A32D0M/PpHiUkxGg8Jingom2X07eSRV6htR9i5iCemsVrr7kX1572O3b6p/O1zcH71FWKw3Dv8e9j8uAaZSG30IjnVV3clY/+lV8SA8ihuUaeUNJF5whTSia4gWbh8Svuu4H9VOHr0Bg7MZOoKXXx5dli1E5eU/vYr4OSzI2qxn0KFfbSzlTTxjGXU2k4aoYZdsv3igY7C4pEtP+w/B+RG2t42DoAOkKl6U+I55xZdQva6hofulkpFcz889CbhDjJYs+bnIILfgkOwHWwlVM4QZAJ0ZtJKZgYSNjv/1lX00AScbjzgpXJ1JVqFpK/OcI4evDyphlpjifmC39Y4Im2IUiQ7Ifoh7kwTF10mmG1gc3bfc/+yEaoe4una4+BCwgF8ljJo3zUzIuztPxoJcH66htBv0j6MOJNhGAFj1Gy9WBhGzqCu0RJpXQlHqab6y3LD1RP0tiduPf+1kHdYnTFHkYIVq7NGgO3J3BpXH6Ku5GKUonI3O753G6UdBCT/pv+QWCU5Gu7qn+h6lx/b4MgBGP9sIL+80+9ERYTHnM/Shq+wlyg7ZMVq3JYXz9Hozh0B8UHypOAG0Uatj5uaZDtoth/0SHhpsJ4eu+vRNRet27kY/i+HWSOZ33SvclpDE2tq+cRvNlKIUNzoRQUAAWiyolS1w3RIEBbYaMZuhBfJk6ldFRuXOSQaymj70uSrOXv9uIQb3pN4LpqsseQJ3aLMaGesQ2PZyhjXRcNKKfUtRfvRu7i8z5+G1krbgqatSnTM8UVlqD/T0DB6a4nmrJ5HaZg6ZtRqzO28c02eI8yyZdRBkUHkPm7rVcmJWPCQSXNcs7XhH33hWWRjSaWUYB5+tbUpn5PSdWU7Nna8d3RSO0IeERJ4j2ff8e358sHoBIAPrmyzqqJwoyyC+QS947l6XK+mHadynj5ouIBB8R5hz1WrnSyE42t+TaULvPTnh79lmnbR1lOxLmY3v8A/FUJxTz45QHUgQGFcIE4=
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