tLsNpVghcDFGUWOtSDvrdSOhCPi3L5eX19Gsp28DL8VaCyvlwxkm+kKfgTO1px8AWFzKFkwT4cBjnUmHp2F4UvPl+8Hb4YThgQc6aSDlepaJyWCURiHyCiCZ8TuPNqQo9gvC3YADb5ZNynCf1D5cLqctZgI9eMF+IPQOvf0NWeA8PeUI+KfAU0OaPbBpZ5GZKIw0hYj2eFvuHcuehzsEC7FZ4R72URqYB1uS6t+zG10bJe/yr5fRJWKfNgoUCnNHyVUp6MCq9ySv9cPlT7d75L/jDeYuY2kizM2A6hq3jy9sc+4s/uPUfBzSvTscSk1w5tPLbqEW7CkZWsGm3rzs6c+nHlqmnv6ITd0+t9xETqkrDe1Ieux32Yf894myJtNylQvPwg8/8rASQOr99Wfx09sGbQxVxoVX5TqUOkUWpoQ3wTv6rbhpsauSuWxxUhqrvCPKJiV4ypHX9rRYs7bkdS8Plsq+nwLzMyneQVg1icttApSzVYAguL80FK3NNiJg1gb79dV7VN0QfXnG8kurBHEFP2t3UmIWdJr7VtCeIh2JxSUIINWQJo1tNg1+ONokgkolDol0I+Ao9wfQ+5UiGryQ3/5H/ugdsE7okUwSzSzz1cZwXw8aN1PA/WeCaDiLC//EImlu3kXp2Wp0/toibCCN6lNPPCxS3H8UwD3ySQ0ngF/T8+7cAbJC610B0pdIwRjAUjaYaoDGH7ydZ5j4TqD4xDm/3lIMzdZefxmyvANu6CkiUZ5tU224DFztzuIVP9sHU3si3fHhZ/KA4FbJ7ejH8PDyR62p+o8RPPhx5OElE1QjpC0VIEg2z1KKoNr3RhugAWf0TqTZAR8BU+PVxMFUo6FQlpalTpqtBYOWS2UA4BCpjwaJhMrU6oOuWFGFeExh4WTYAvhOFbtBVO7GpucgCNTYGGcaXQJdGvA9jwVFLvvo7ROKH0pZPwDW1KGL80Bj+3zDEUCnYE6KAjVRhIfjbXrX9wYxfHrN2wuyqhW0oS/X9OWDvdI/xiYP7LT9pQ/H8I7ynG6PmFpLaGq2WDHhhL92PtlcRh6GV8qwOKWSfUIgHe1vViCeRlpm3qrxPRI3xdIto2zs1DZVLlwJOjDB0+GvPcqZNBon6Xq97cZ5Cg4jDcbBDV0IFeiYPc0utYUGk9TunGf/sN4NUHnBT5Wsh3I+Y6/jplbZg9B1PoL5IFULmanEDeEs2ZSUGIuyBDUGNklkZDEvd55rp3XqFo4G6I8eeH8NsOjH+fPFEJL+KnU+fuTgHSYrqq1Np7/bdJO6Yri62pMSly9Sq/kebYFwnZKu+B+NawE2GwAEzQeg++1bQnqw/2fPSd2k3oiFkG1jcSCbO+KRQPzYfqYz60vF3XkDZUm4XEKvzL0=
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