O7ahgCC+hEEOonIxWISF7hB0ct9vxrZAZdPB8PmsY4SvDizebtQw/ljStxq33O/esvzdGQNKrgsNrRHvDh+nONi4HKPy5UgHiVnE6w4JOju0eX4TwhSLLCafqPX3VElOXX/O+BsZ65GGPVhPJnd8lbn0dwvgrnkNXppiRPpMukIlIpfsMlWI8t2qLkp5pfNPlHuEmC04NvE6OFD5Y2Uyr6n5QHZ0BRmW2d6MZ+KB1vGZZq1BXsndVQC0W4BQQNiDximMDTO9SzONbROe28JtNLn2ncFE83kWTtAhuYXqLUMdhmXkwPjFgcmj6mMoVhMbh1+g7ImB+x7lKMULP+wFYcC9c3PUcapty7DpD/BKc9zRkKO5PsF3Jl8TeVbragsnFRn2HCESUG9zXxa2Mg6K+QpRloGUx7D0ineUzIKfH6c+m8XV+1RkiRcI0HHDPJkGFg025EygarVtP3c5Y7c8DEfhdkJs46fJ0PvnPDPEa7qH4F+FZbvKa3Bd/TfCK+NOQ+egNl0n3FPoE96KL+ljozD8+BXXGsoU3Dcec133gqQsvXD5wysIXcZi8ENXdzDfzB/IXJL5qVfvdKl9p1xgPw42XiKgQx1b86/7FA7XciDz2rrXvdImiXAs8iSHgum51PiXSL5JQ83lIb60gswYpOBDr8azMkBQyNkV/F1DNQu+iTe0XMPHU/Os3bmN/PjkLFlJjOx5hMlMqebl1PmU1j0fzMsqDqJdjmSeLsfwhKSuflTHkB1pcuPZbd3hjs/Lsluh+7KSSEwlKqohUJyJLjIki5ewXp3uXkQ+3qut3kyUnD2Z8tX5a4wJTLWuG7XgkgOYmRZZRpZ4l+ZyQIvPknmHXjmw1qNjfSIfhD/pAbDL2dF15PM669FsNuqIQqDsKOjnmHwPQjRV1RZZFdmy93yD2FNtBTD1Zh4DLHq9xHSe1llyFFGnjM2QyD1WA3nfIOZhKkD7BZjR+okQCDgYtzvrzuq7dfMFtN13pJHjdbqd4+JzPImmO6jzDkJUJo0lcjti94KQEwSruixrx2stxV9tI5Li+7GtEqoQ0PkDW7f+kg4E6QAJeVsTwOnx6d6VTXVTgzm9zAIWx+mXph9aiS4xa8SzuIT6huZXVr7RK1vlmpsnYoOx+QJjUGPQyfya19HMYnYwxC+Tf2kRtZ7Qc6nOQHORJGREnYYqSxfyiQGYhJTQN4z8IMq4iIvxZ40/Wka4duJjzxYFFY6AkIgk9/IsJdgJbtN8EdxNM3svPiWL4JRFOu4JNp/ohZZIaZwDg4OYEsQMyX6wyfKHqgqhfSR3Ncci5a54Wlwe+MiA958NDCWOhylrjvpoQP3Hoaguxll+rptnDwzu9bUAWrPC0QqhLxLc8B+qRlmUaG0=
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