EByCbP0Epm3HEpzCbK+ZvRhAYuC30LgzwCuk7Gsio8G8laccmp+JW9DjgTA4AkVzwEODrSWT7Nb0C5y5DaXzhnglzr6Tk/RU+XGCRYanGJxzfmkyrtPqwL1evxXVJyVBYBMZYdTRmMHZ4yOUL8wyfU8Hjakkw2OTiKdBt8Zk31vURxmPjuN6NqLxVBHRHGaHGD+KSkVHjuowXY9p+iV5VRdIr2O+NR/5UG5YZZXTP1PEzCaOZtlan/Rey+H84JkZcXAmCV9qY+a6auGG+NGLefkZUoTBBZfR7+QSDcrs/ThLsJfA5VkiL6e0AKUMzV5q6jdPX25Tcr1YmSoehjbmnd6/6WuQXsjaxJVlFkXWbME6I1LTkiZoQz3Z+LpbpzLVsZ3z9/3ebFsWzPEzDwdBS+bMpw85/gtAC4f2wDLTJaeo5k1cX3NMttmzdAqKZCRgt2OrPRK4Jx2GgbYugWmADLFlD28SqAjUoECajVsxmPTzg0jxqQA/m2bedDqoHA6Xse6KcwuFviFQdlXmBnlMyHzX413UDqa49+gZJNMLra+HcFeqpbO3IQh6vCv2iq82jYt9snXNDuClvv+C57KgazbA0X2dykXorxeyIujLJ+bTYJ31QsvsW5jXTM7GmUOFR5HrjpG9H8vJRBHJDWIzmAFvfDdoZscEs/fIUHpdPT1Lr/qLbtY0Xyv8wCtvJsgbfi6iEvPIHx1H96qZM9NUctRzlLchqlM2/NEPYpRnuenh+Ki5bJLjmhTqeP3dWQXBlhCPmI+tMjnYjt/UcSipBvHLFmHgJFQOlHEv/uqVmBGI7pvdgYIktlZQGOOwC/PfW9QmbWiu/AbDMF4kKpz4HR1ZLkE+oPBSqkFVHsh3vPnyeQl5mjCfBTLb8ydp1MiuyxNaS9VCrfq8J1bXk2tBy7b3B0TSB96Xo+FJLmfjYDtYFq+RMLzXQSi7uocMS/qwKkKN5P6Ugk2hhT6B7Lw8B/kUpp7K+PcuHX/3uxXFt+ryc8VQQs0pErOX/eyvI4a/7OxNh/Jlzgs9otpTnpkNLjHqoLJFU423yiVzbkLqA0rG2yvnyXxbCbcXjAQQihOTP8gjIjZ40SkV+bW+JQ7SYHnEST3mq6TbtZvDK6tryyWRAfRvDC8q43YDkQx/34ZIga2n13II42Kzb72GWTnZVzqZhldfc4aSm3pucTFUzhvbAa/STi0R5c5+BF7Zmrb5e5+1dpp5sLCI+nfGnikjKI4kgZV08T7zUelLYLAOl9VTT8ZYv2BFI184b5P/3fWquz/QXVZijn7R8rH+NqiGbpRSveWHuBt8NQbbdkt7U3h1TK1eE6+4NWUBu0TnI2mhhKfpWVt+k9KydJtAOvjTwcTb6cVQ48nzxR0FbQw=
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