w4MZpPxlklu4PEKW1aSzwoyHBb+YQp6/spcNEYfBFvEcOwmCxxvgD3iTKH3HUGabP7ae9qx4FRo2KWnAXqJBQ3sm9VDCnnEPb35xlbqHpbLsQ2tQuPu5Nwc0168ytBX/yQF4Cvl2B3JVtPmmVmzCjYPrtp8jR5BHlMktSOrf8BJIKylS9yfrdCTGunuvMeW052Mm840GpFWN9FbSB2W3jcvrZNVG+502j1mFHJo+t7sn2mKisF9779SnH4EF1uEJhoDrwo4osvw1dPyzA0hhcR+jWDHv34DwtXhuSzdIFIjyK/L13HTWlodpRxexclQw08Y7eOWdYbfC05IFJERU0Nkl4oXZ1StZrZG7V4DyIiybjXzmi7LfobbRMi1dv9fRetmLKMHP1kUFzoucuDShEiL+IOrs+FWnSFr9mGpMLbEBMITQ1vDX+WYvhfISiPZkt/cQOfXHWkYoONKG79/HBJDaRUW2Th5POsH1RgDUGHJxiBUpQwzO3j3g7dteescWIuGD1ftcfIPYt5T1sAeTT+LluDY9sb3fgX/TMVtuTp1zwc6Kdh6sBYSlPq9gSTl+mpGk+EeIkTlFeOMEfXEgOylovWyvRkH700u5r2fR5/EiUU18zEaGwj9+luljr5yx9w2iPtf9wMlBXMAqrnk1OrhvDuIU9CGwy0bGcTFfiwAfG6/9pG3v13hy39BNpVB3W+0+W194pC/CkMyrwMWFhfZ/Ff8LhvmfMB4N+jYEcySIPzbY2mxazbIjAkgyV00x2BqWkdtv6T8Hn8Wo+8AhmHL6pYS9uzVzOPv7a890+ZGLVdYXFlaMqplDxBw45QsS65/8f4ZlbOZkb+iDro6upOCNa1O13okxHS7xEkIEOH3M5EOhHBl+d28IVZnkj2X3LCtzkodd15UCpSwWgzyn90H+5av5XFtghgBpXFTYQIhZKAVsIIwlQ1Y5tjcQokRcN/bKdoDOFf7J0vCYG5HZeTUSr95JwS2A4rX6+Tq9azhqIUaAngzF+Bqea40tWUwQmRNbo9LwRCL9aBIV+un1jf3eURV3rrdz1mH6ZtYjtqjC51rWVsPnA5WIB7eu9EDfrIwsOM31Tqtp8NrrJQyVCk382PfFH06+Jqaa1I8dsXbm36ozVQ/hSCkNccMI1EjZLowdvzH1CIPeAtScoU1sebTUznnB7/7eM/wGo3f7eqWWR3azyeD5WEDt+ePnIjI9A7+rjVWG9q8JRm5GdOJwVf8B6Rmanm5eF/Peu4wJ1senPceqqYpnIfgy+yPWbVDBw15vzEs4RgimaLD71ZuBLa7qTwcPm8fcwqdCdqqbdpVt+zUGM8RlZ/drZey5k+jbqy78Pp8/vDfjCK/PP8MacUOQb07PEtzDL/WWAzs=
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