gPTPs9fElrncgqERqa/iVDfOgpyduXL/P3PKLZI4cM0qm6WgwI47t5ctYJUhIFmfoyTmudIEdamzNkFHy1QWNHWqFq+pYpjqWhyZhPZlt0KeJ6yuF6taGfPYm0AtqJ6LMrqHRUfaMCYFVDvSb9uX+PJyVUMMzO/DSwd0mz83UUq3zVKyf7o6Av0+KJfCbOsYC3FWcTrHMZE66wKfdQXSI6EI4AKp2yk0xcDcfKYiPecBqABjPq+w+1ETjpDcWLE47FGrDgEw+nkGQn1hquHeL+idQ+6Ok0kiSuTg62I3oWYqmyaP84sX/SyfeIvcaQsrXC00ALxtrgG9YzkkOeNnpmvVzOU+q5xz1xrVMYKR//ZWPQdi6ra9w4Y4XwAamy3PT4gVuS8c7075jlpqzLiAx1MCVdR623opcKYHEgP+2ju5lIW3QnFWdDV8TZkdQiQ9tbMwkXHtElOJ8AGd1yqVW1n1NL8j9o2hkopw4nuw9/SMSXqcndWJIhOgp+CRAO/7EtlTRr1b2josqcDF5QlymHaWUv5LzVls+q2VTR7xXycIJVKxHRrzGujuNBBy+0OqSweDEGDbeLVDJHte301PJmP0YiU0sLssCdx3Brx0gAydIC4FAkXygkPJfZF1zN+l7VflNqzHy8yx5KQyMDoNKsL8k5iFEOy5puXaDQ4I7U2SafNh/yZvAYoZn2pqZfxDlsxva83gex5jX8XQ1IXNnY2k9SAQ3UpSNrnjuIfWyOMW52hDJn7QsH9jwAakBAXUPe/85fb3Jsegvb0UlTVNMEkiclbqZYyCj2qA/V60gcAMliTjAXG9dtcmCW3Cv8SOJMyV25CV99z/1aVf3jfGyLDE/APiTKvRxpgCoQDEC9pV/6xqG9g9WqX3TsUFUjhiFaxiNsu6BWmFxP0IOGDLYLVK//hbY7FkPD2N7P3rEFxPlAZy8wIuMP1cpY2w0vqsQxD+yAaO6d+y0NupnSP6lvBEVGbUgMeD1N5KGJxJ67xr6z+wdK7YCsQtozNA9yJHJHNcQD6iEeVXF0ZIwuyi92X/aGsQHMhhsOh1IyP+9a+O6X7HqAx8DdLnb6XnxmwETxY9opvw/LlzXbuA+tb4MGB9ZuCYvBMl3xtqK7Sa1bE64f2w3VOW+ZR5/Y803Hoq9mREb0YODoxtHvHGfRPxtFJoYo1MJYNVNLmYVk3mYOXEEMY/+ShBUydeEMs08CGq9//LU7TgmoZ+kcFoT1TNzWiC5nYZCImyYoxho7GGotnc7UIJWSj3kW4eXizIkoSUtceH5Kvo8m1agFeSyLowYiEbq3yT2VfvJUT4yfvMrH+kIT778/MuaS19OvIosftCGcTg3HE02se9N/rllJFKQVi8YjlfjBNEH1sBwYY=
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