8Wms+xm0W5dmTetmcDsjKBV3rCB73KkYrKjo9ySsa/W+i2uUMr9IOd+yhm/qI1bQa6Zbu9BrIi6zOI/cb0j3TLzUnBiaKxfeLoIb7wt37Ae4Qn+Mm+rVaDa60dHSmAnhrQwlHFGKri6vuIJwMWv8hHe6kMtDUwvNOzUJixBYAbZlEffgaGRcKFM2v2Ym64vfEtdsObWZJ2nwmu59utkMPg3zG0cVmUnetX9kXkty92dkn0Y2VSwQjIE+VXeQs5L8VxhF5uJJz7LXl4oLraeO1JOVl7IoXX/VDzxLut6+uXYXrwl4l2t/OEvlyUgHbQjpqe242NOLSVbSC2hYGize2KlgWF7GMUKfL1/qixH10WP+H0h+y94ZvbPzmh51k+BXqgzpp9guaTVlLpw16gAYzdL4a7/7ZiJHdNxmcJnH1KpjKs3/pNC7lCKnxqCO2bfsFMC90q6ihLNoBvcyMyNb1LK7mSjOuomThYwbPpehD4bQpOnYtE0HDGkXFDW0HEbCqBMk4PadXrV2mlBfyBFGR+sYQ7GoelkMJ9/60OlBOD7Y1OQ96j5zje1UraAJhkD8osnAvLEmSed4jPl8Csgtw8c9n5Rg31pU/5eMXIeqW8Jz7j4UKTpia5Aq/9LBWTTqC3WMTB2ohmCKPchwvf4FTuglva3Kkx/hCyqSxw+YZ+LdnxVd88HlK2zl6KLhYAFFGqE+FOtrlIWEF8/8L942/SEtFKMlLLDqIN3HhuRbRWV2Eb1c22gpK7CZyDwACEjb+otrn2E2G3IflDUBJxzSCvltMrZfHpQeEwoSn/Dmow0xc8FHSLXj8kfP+Dc0gbDJu6dYXlis7jtnUh5o/wC3PnuNBH9QrSxNN71nxNtD6LdJ3tuZ3/La3syQrdK3Tpd+vlzlt8PKWQ3G+h30vQm7tDf/m/DcZTjG0M0cl9r/LG0RPXfTQnBiFyYvJw21+37ydpJHop0Fy71TRa7DLLtueJmUO6zC3F/F+MgatZa1FJXZRj05gTQbgWB+QstZoJtd18ttUGE8+1umICzuC5oMcW6wv1BTrYcGiSH7salOArHe9MghlyEYtlIobys9VqhTIHY0pXm+rb18GhtbyaCz8uce37s/+5CLSqFYtL13u63i00pGLXaFXHYkV8ouhu9plx97X+PquFXze1LJMQveqZ5dVjgBLDlEU8PPU/Pkcq2iNRP+nS0Fv+JA/ulse5HkQb3V88rkYctu8ncGxNFdrR9b8utLEoq7Ktem5BmNjRbdVzMY3+5TA1DARRkFTuNERNhh3x2NFuOgG6Po4RJLe65YIoau8j0KqEOQrcHIAp71BYd60mgBSiza/V1wFRsAvRGkDN9LaUDUIbkKb+dY1GYHa99Xjbi2dYfctoQ=
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