RX+xXVGQ1TpVhSENDIzIGCEhnhtxV89sgOO4CAfqy6yA+68AHCOVhsVzFtpubQL4owExq/bHf0n7lhodevScxahCbahC8RZkoSOCIrd6Ft177crKaaAAY1/zfB54/TZrDtuoerPil9FXLxrYnLdy/CAAVkhSR8jRpLgvNSC5kQLa+4vLgCz9GReNiKiHok43KQmXcUioSjRNCG+aHtSu7tHvXe+K4Je1zSVR1edHm00pYLKxkVa5TK83G73+icLLrM21wF5wqBCtF8mA5brCm7G0XPkVZrChh6FwcQJmOEZWFuO5nmzPcLtbVwcdHXytLe3iShoePAUbLyPMnzfBOQcxJ7YX0ctvuOvnVe0GV7pXOs/LxeCOWrxrcs2OcEYVkHGLufnNCpFgdxMUkDAOq4hMhyVoP4EfxfmkmJ8NGRltbD6rWXHZTe7SK53OJ3+A2LkgoDc+F7U/ROVYAOsUQX1nsWAoHxEKo/wlhevql2GOJwJ3RaVQhj6XkGH8yUXgTVjmLU9PvM0J6z44uOHWz6hz+pX8WKVtR0mQEedlY7G0JXH1Kn2dZ3g9ZBSE1A5yJNscOPhaS084/W/tRQlX5kKtlxJu3RJvpellsofCyj2sA6V7Larbmi2/MJJXcGT9k/R3OkTVBe1avjMEK4oC+ZXkuERzwHrmn6uXRQZamqNEWzKB3+uZYLcD7w2XG/MVjQwtCZE7ABWhvtBICbUMQFp9yveU8891ZGnyYi3QCFca/Ae5YI5gQU0TwVqj2CjyIu5YHUdItNa6V82AAnG5bLZhZZXilW47xcuoWdEy/eqn9J53MceqJSLNH9uliL81BJCEPpg2grUzfQsZ4a7Q/XSh6DFR1qjNQuchTr+uomVnXnM670OwReMBmdimSHwcnM731kmC2OFgnIA8fTcqNHBOiJXdR17IzZnejEmm2CY0xzqiv8IJWApmAx6DQNbF9V3J7I/IbhnhRiph6OyCazxxLdxqd8AAP0Am2PC2RyztXE+fK5WigI2jHE7Zshxprrmg8klh1vUL94sEar8Ab6m7o7EfJ18305vnh2WGzCBG27PPncy+Ot+Pr1GjIXmCjr1vFC6cMvYo/UH5pT5++xVXM9mZd3RNQALi9FZkrROP1fJQekSuf8qN03ruleDyNxfe9P1vOKjxsehemV4zAVXQJN56zyjBpDGeEULro9sRMnZNgs9xCIXU4tttToFY60K8PBNTKLD1pdB6ATRMZkzZqN+VyAIrYJNZBZm+kMYcxHzEeKAsLtnr7xND2sKvK3fSQuK9FIFC07yD/ilgJbZPeGv95sNMURuBKnI9nb0P3bdLEAWiNye2VBgZhhLEpfEYGUWU4Z8EXMoqU2bvJqznyh7Pny1Urms6a6c=
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