RZnSq9nQkV43nOY7jStE2S66kQkhbnCZLvxdurXDcaioRf54ehYzkaI17FKYA4gbaA0b/Dcjq3AHKsbBdntPVw2DzNoeYgk7FKuL+tujQRiZG98bnq/6p+vpowrCvPOWogETTGmv/0Pu6FBlCdJOJJ0MZQUC6lOkvagBzS4fPf9zODrYlZSYSCaFhzOp3Qui67SLFLWa/dj0PIwKjPPF9w1dpVqyPda40eKv09XxVhYkozbD4qaVrqSA1OGHxs0HjOEPqeRWmSLSdv49OPlYjQHzdl39QDDgA2KpLusVfsAYyYP47wJefXhPK7qcFRjJ8sPSnuwN4RuNlvBIuD26yZ8l3R582pYL2NXj62ueU784d6KL/gG6DYLsC7GjpXS0Rq/ngwoEXe2aZWn711TW9bcA6qgP9CwLPeAWEd0w92+F1JzEsAD2aGRuhhKrbonnkNPelavlIhOUkUmC85Xm66x1FtW1jX+WsBnwu+fD9x41LoVrkkLBsD34R9OJ9LJfUPlnPZ8C5JhM4pCA+OG1UlKwJaSRXky15DTzh9Pc4W1wtU7aQa577T8KWMqdslyjkm+w+WjSAOsEf/IgIllrzuB2k2xIthZsjnJURjEEoGNzzRvb7Y1fToQJUouThhBm8l/ADF7NXmeXVwxRVdsnFhVm8DGWOw3osy/Qe34PN6VNyx5cAAihl+gRlwY0nC9icRmvyB2oF5UN3X7TS5DEpffOv7F1y744SdHs3A1zYyzVcSnjal2koK9VlmmKQuFd1ObdBBU+kHyEJfbaf1aok/aSpPa7BV3uDImg6XaXU+uvJBFTcQb/0TqkhqJ3DVCBelZcFG5c+7WUeURRjtSumtq4NH1R6HIf64fyNXaoZARZma5t7FGM4A++3DwmqJ8B5wkzDHU7D68eKCg2+ugKSbwLjiEsavKt55g9crsh+3i7wsMEmS4SB0pJQlBx64imGnt6pI6nZ5Mgo+Wjs4ye2bGJd8hwUx0DrpexDLRLsym9eB8kNQGzdu311VACC+kQWDzkZ/WG/Sd33VuP5RVzq6zS6hQL69ANanDjFvWOHDDs7WWotVWMeuQ6AvUDAJ7/rZKdJrdKoqVvf6qNiTdvSQm2ezOUqMMgysrcpgYF46fJj2W+UyYCgb2KF7B2tBNi15Zs3b8Ft92k9zjK2MNrtgHB1dE1aJ+POtAf1VNviAkUAhN5KPqsP11go9GVtD27/5wc7tJaktT27tHMkLq89wIIy32HGLoVtuvPHvAyHL5IsmnX2Z39BzlnTeROdsUyOvsjUaTSMTptifGkMsS1nMCyttSBItaZSMFyEtlfShDfB/s0ORJ/4KhrUrcT4H3hax16rTKpFRgfpJLPPlbnZgCupVGb2Qo216j/xlA=
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