soexGywU8mCSbxEha0WGc3LQSdjZ+wGBoamoRoRvqdkuEz/V4tjbDL7VDu96kf09TLlTiu77bB7j2WbzRA0ljmqbIQ66WAx+wFR7SJ9HgYtJRS5/E26qfgrn2AyD/qRw2oghg3EbbXj8A02ay4aYA72ILzL64DZ5Sh7C3ZWcB/Ee7ER3kNXAfZ64Wl7gbRYpqnWCqm2sqKvA4GgSquhfQOzN/ewKU4Yf/RrVQoyseCwS64Zk7csyKbRPs43YVYvLLpQKp1vZZv93Csdg2nBiLbkB20TR6qDHw6hTrUdaoVuIOpUYylFql3DPTK5mKfSZYnoX24ZVgECpBK3C8vryOOlCE8Wfi+hNUh1mWIgS2xCPWUvgRGrHkRkonQWGnNJdoKixWPVWJkyi8IJYR74TgggXUsvKcmxXbX7ctQeoQmLm7bascYD94txgaZ7PaqYZNEJ0I20WdZIjDzehIzdAwyfdGatPTu03rLcgYwr950+HeslfHRnMIzv+B0s03R1OPMchpJxJBLFExM+zUsGcOm2H5awKUbHlMzInk7HdfZgOuwYiRZLy2NbuGOp/HNikyP7nGiobId73iB8XJWyga1kIqv768FPvE31pR8pQGok2YLLGOQFCc7J5dU7L/+Up0XYDXB4a/qVYHW6jRUsTDCGzbRbbqSoaFlX6pIqoYGPfuwIqRrw4LtPiw9yajimL314m4//Ubd434hWo2AfXMkzSNcrrXz9c6YPTetJdZ810rYWZZ5NvglFsP0gsfY7QKZNJjnITN/L0N8kEjjrdBV2+HpduIgBPBevoMXRpVlRRKkXRNHUGwA8wbnDblH+z4iQ2KQdqC+tsxtk8UjK6eJNqYo5SECddJpF+eG++uD5SPqiMrx8mOO4RvYZdIxnNDbbt7MExP5gQvC42dcBkFRIh9UHmcqTunKwFsoEo8HxhXLoxF6UyffhRbMAQ7pnbkFxiQd4copHu2uWmBVvHrCYA+nECuROk/Wr5ks01+0xjV0tj4eFScOWeOmjkToY4/EX8DEEiFezCTJdNljXOf/yUsTxu/Ykbc13vEO6iaKNpM/3IpYFvw/CnUQMcn7wzBGNjo6mowuPGGMfH87b/YvZ+2dXyhaQJxJS85jIi37bYa4l5H1k/Fu4XrS4qt+F3No30iLR0gQuPnpWl7yLDONmeJ+WnJkIPoLQguCYp2GVyAVMuQ+hUozyFXDd3XE8PlORLmaivsHNuE3V5dhnr8vDvgEfdmeJfkbimDaq+rQhRfAcU8VWAUKSK/Dp2m/aBZrx2chvqFz33qrmYO+aS6TJ2cP6bMQ5U1FkwiSIceJhEOWJPssuaQEobvTIijbrJoAwDWUbR79F+Bu0FBUG98hR/J3QazA7JmlnZfjo=
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