PbXC21A2RX0Mue70CsCX0QGRiSt2ccR5kiHofHjPCYHfwTqAfBkLPFlB2rZnSFV+WY7+vMqZB3Kqg8vsEnec+E1AukS5XfCn5vmC4LVtp3U2GhIOiYPvvNVu8p66kxLxp9nlxIpFNrOw1RLKHhyyosAW9X8f5Dn7mgQqfx8Rrz03r90cD54QcjRa2eHZf5/2tmfSWSSQfJcrTgA+n9WF4Ny8hebGYoW6Yzj2QRXNGMy0qLkue9JI7jHtvsQRxRORu9Sc4HAmQ1FSDUyNL0AWSE6bTIdLo7rDHDlMUZIFV71fbnjcY7ucwcdEePKHy6UEJtOK2DNlXQJb46+fWWr8T1INVVVkXjGz33k65h6SODI/qIidfBmwBBNHHsKmejX5oLp0eiju5TnJZ7nA4wVAeKWql6gGzleCbAckOHPJmIxC4bVQE3xasfL6xRH17hJ/dPn5oCLCNakXwjDYO9BOKqwJThsWlIdwC6H2i/RUCX3rT/wNobyqBOUmsYkpFYsHPHkjRRFcSmSOf0u7iOztLwHwIBmiCXdDo7cWZrBm0KtosuI9HfOjA/wWiQwo3DIQvhum0OH52dCixoM1rVg0ivm+Q0LeQrbNGMsTAohxqip3B2THMjPQJmILG5Blp0P8yPvancugmigftSqbAewVERWe71Mr+jY830w9WIsZ52wvsMjFR+4q8gnBmwWqTEfk7maXqMkJzdrdpZLqtRs8Fs4Jhn5ngHBU/fsJVAVjhKbqgz7rRdEmnckkMIToZqadtcnScwTg+gto+nefGEjeFx1x4Rna3bO48+ZB/KQhWbquqBeApJwl6N6XdwOSG9epSb8lY+qW4RYrXm/6eOQBDMr6Yul8aNw93VxzCG15lGwf5BdviIRyGJqZQeVH/7kJZ5fXyewsWU3HqC8QYN28+DyNDKykt3INntMuAzkAd8FQ4GOPWM+uUCNvCgMlUiLbcZ3derQd/mMO9KGo2WYvC3jykxOkxXQ3oFjFXg6fgJQ/D9GAOfTDy8CJcY7OZem5qYY/uOqsZ++Qaquxnh414YN3MwuOK/rz1s7BlleyOvPc9c4L4Ty+cx0z6CWz6og1jjQMFlR7lBC5mAYtsURedO1+tYUQZdvKExExa4hKeDavA/3FYLmAFhpUYT1qBv6hRoX2KxXMMYUU2HQ+777CXmJd5BI7D2rmrL3inrjqwris1V8f3fcNF7T3woUhfULCXhRdsCDrVIL5XCC+LRWV6aA2QJZPWu+WDf3Pkq96VkdfSE+TAgIckQ98SNlQdefUysNNkbZpb4OzmBNoub4HZZ13w9XGXbdpy3h1r4P/xluQSwCUH/6OM/jde4DGb96E2PjiTAj+eXp/dtURTf7an0pQgcQ+ZNqbaJVdU00=
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