aWB5+xSQXA3eqL98IY4wRDVgS3ARn77V/vGCUNfjald7R3kehux0v7q4Ta8024FnLl2LCTL381MKyuh7NBuEBfrxZSb9MfAyNwnkBSRV1k9mV0e6IPohmHc4k0USHZSYEJEYmPMEyaw/pNdTX2BlzTmHggzYG6rQSokTVQ10Flw40wvw3v89PI/u++NBorAy+9XYUjlfGNGYF7RJgtTy410u6SjkOD8g/NyzLJg1qAMGCXZcTvt+FOMbHwvnLVZLZbaItGThPCN9vEDpz9of5eJQqJ6O0+CjBZCi97m454mttZIWXbOFHunfXE6lm0y6LJErPHZCl9uTzIaPytyg9zIJcF6IaVEcPYazKvzGtf5TYQl6gdUBEPHtBnTeFxdxH/NJJxj6SCuwxYFdXuXWYzREWTCOOxUDYUAV2Q2vvDfgnfb8noejTEgfRlXbLBiCpqZpqDpe6hrlbOeTx5hDH4xfF3KN5S53njf5fCmYkSapGVtSWEnDPKUgKuBBCQvrHIP+/7zGUfzpnWzJAFD4Tj2UucThGSbDHWMPoqBzAxPO5KnKugsb22PG+FMmAmI4NLknq1HENrjq8HWr0k4gjN8z3oyTvaScCKZlbFII1MB7UtMxzvMDqufOOw082D0tyB/ypo1/e2aXQKwCXDVypMFwLrskVDA4ILu++27vCS0iffCdb8BatdbtroG7xCCE3HjXS+FMngC+jA96pB8PBZWSEzYeRurqr+vtuKVHbDHcQ4so+TbzLOUcvbjEu3IyRxwAHL1ZqxqBA8xWkHsGAxptwgcTVAz1B1TFlngV9PzrL9Fkn0Ns8IOpfVcTEud2Lp/a1aczRd4tPYXO8NLRR/+d9yvO4iMKk3mcbwaPsAoNvjOx3xm4tFr5Ow/2R3/4Rj0l5FDNd5GJK+xXWwtLNL5flPu/DKqkFtkSb3URXZ5EfccKXsg6lyMb7/rcP1vqur3J7UDVk8GBjzdalyCKBtnbTFQvetJCVLAcyhsbKcRj/c4ZEG1BJ1Hi4xXj001ehfQ0hBjopFOldY/E/ju+YUyCaTgIzuSDzcqR46SY3wjPN6JwjY0UiTMBsI4/0Ymx1wOy/76FWDzftXe/ddbTKHUU0p0moEHbOR0th9dz/jIli+QPu4KfE6uKmg68je6X7ef/9ui4wKHnXkCoelGGvlThaIUnZxmwr9tTrAXiLi7Fxh+qddxTc+s6O1pJfIPwKwhOBMlHUc67gLyTfY6hm8U4IKNnjMatuvgP+Ybmh0Y8PIGHoaN/Ap/0R2dE91Ywn0J8LzuDZgkfylOrNqUgp4W52QuaLlOFqk3Pksa19pL5Hs25vxxNWWby8u30/l21oxHVjHZ/gc3nAdmk7Yyh6fUi+pfKySkipvePNks=
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