2I4hhVDQFJdpl4zpO30jzkek2weEBDAaB2fQsahO1407JMxsifpuZ3+jn4DNDNnFGug5gHffhAOu5Xoz25WTGFHI7wUlldb41LbORHKRRAFkJ7gsoI8BTQ7Yna7EzOCkKovZVL/aA8RJbrNiU7RjkcgBm0XqHoUeZ5FFPlxVWdhq0oXzBmZYZ2lOOlhHQ/Rh4ta/1qqZuAkrDXJxeBRXAjXMyQuJmfVzBT/7kC6gmn15FKhePqa3OUQPuzJR67gQ97rg6dSI5QDp37y8QXqhvbUuUNSobsueJlSJjV+ZNNtqn/ub544NgyUnnQ7kyt4VLDO9soJprhm85KjAy5aB7xYHQL3+pQcQ0la7NjHnbx/5XewfCTUoeyhUg4KWOqH/OAPXWblJvQW+I3kivsYuoKucXPjVUCyrvn3cIiOJFY6A5SWxj4s32Lx+dcggJl/vSjtFWyPpXkpDBtHvMMbx7o/lIOOH/eRmmT/p4LiAMg9e0B8+Ki63lElChfgODQ9MiZFuvSbHxVmXP8C5o47dRJnJhEqFMUF2hUZF0+vJ8E1OYXPiUINuuiAC7GVGLNOACf27vWgBH41sHMoEJTQZFYgZoM/hmio3879bkaB1Y++owZLbLZWJYS7uLut79zAEtVJFqEUpkggmX6hS3sUMk2C4qetCw+7lL7qUUm4Li6nCLE5HQcjXj4RXE++S+G0Pqo/JfKA+q5DApnwOE6F5TA7dB8FeuzKWjQFqQMe/1gNGhMhUkuXCiid1UjO79iKALzI7qZcPPnZIu0yWmVukSOXOxhqOhj+a+7j/NAeD6RFcJXyWdHlQybE/kdWO/aYv57E16s+SyhF50Y6pZBhKP2kdmL8CIgnA/YcIvMNWhb/12NVps0sK0LBDuP0psR90UmGYnZUgffxmA6oidAwb9Ro865IudJ4UrIxdMmIbKFU/PJH9485meNAhFRDQEsfs/7uvp/LcrAW+6KgglsqFJfBOQLCzfr2sDZm/N+6mxNP3YQUZ3e5HUxnG9LhNn1s0W2GG+a8sSkJEVd3Xozat8h32uUcRWb9WatKKnNjzarrylHVrGZJMaGzBGiBmqc363y/dEVL2Z/BKjJjo773YVln4infm2xgcUNCMFXkDE9KlwSt3V68YxgNfI1RKFtrXa2Gx+jM2qNx0GjoBqXH2JHId4dbFyHTFZPnqo4zoR6pkVNj+BGu1TVafmoMSxo81eLG5lD94A6uHZH9EeuByoViN54su9cuvM5buHgbmHUWE5wtFFtZ12UQ0JEe3doot/kJM+pLu2J+mF4L2ObUfAlLX/4BNbMYCY3Arv6i7Ho8/YOCPRStsN5AczlW+AaB4OZLMkmJMfUmD5Exhg6ulvuwLgc7zWhG5da99EMo=
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