3D1WD5xCk0+85WvLqRkLkyz1NemP969Y1WFoHqtzT3cME1iUrMq03+h66EsbpNMlRfKSHbtRMYWehHP+AHc4ROtYkMm5mUX4/Trnp/5KcEEBbZ1GF1TKMFYv7Y0Y1vVAP0fOgyKB5hU6bC/taBErYWDwee7+oUxwX7J+/B9h6KM4aAyI+zxxuN0aDi1unFDR+0VZ5HbQKknrgEnC8y/trECo0ZgIrG3Eg2Za79Xm5eoTwR8fdrDrrJ8hY7G+sSHZVOLkh9ptK4fkdunzh2Sf3LTpLh7UFppW2VrbNktHvZaQi4vDLj+Q5mG4ZZcjH+cg6AHxRnLMuabuI7ufgdKt+qcncWbR/bGtN0g7Nhuj1VuGqDG1CoJmjgAC3FZpYgwbkE3CNiopDKWSrY8o4WGomkJffKrcFj9pLWA7L4oxwpYNX07gUaLOyKtPtZmPIwrou8cvSDrmLHMyan8DBbOsxPPQs2okDqs/aP3EnRCbfwsczxmsuCezvtyEDDMXSBvE0gTus7/uRrbVHGl2zU78NkqJCYlVm8GrBLK5CDPAbBJbL6byqPDUGU21m4i9We72qqdOgJthDz3YE1V0cx5u6OiWWgV9E0+RUKrmZdu1G8rCFjdDCwF8eQizgO1xI9pVVohw/4550voUqF1/iOFA+qv3nvDVNIcwx+cYdbwdxZ9xILFjqM6hYGw1nlP08MlHvQBNFDGhxrm7qGejpO+R1EiAr8R3J64EsK5BvIlv4f+CyqzMgS5ZtHJ+XEsVLV2sDpVeUrpYT3kHUgF9sIn/nex3rn3HlnS5Keq0mpD+NeUBhlcsXSER5qGVcb0yzxwShFv67Vm57tIkHW50LNj2iw0SR7I3NZx3NliyRsh1dt2d1Azkcm9Inyr3RRsByc4/5m0qqaDs65Z6m+oiOOgXl7k3Y3GdCLFXRd+Mt2hzXu1gAyAmXXoDig5sAfUURixuptBcZd4g9SrecS93YBTADjMr2ep3OQolgpehikwBUD1GJDj0CHfUY9BQp/0YhJxjWhjFTP7k2ddiA0q7nbjHwwCp94rS7tsI90DXGuNTPidhd06OnNLNYcQHlMik8/UVCCmhYNktv3AKodTzYHEbmqipXg28pKUqy6mp7lNGEaO9tWrRHp4X1GCdE4nUXEaKVcBoN+Vxnpg8W6Y0JZkTzZmWL024Q4g6AsbSvce9QflDJiytNrnlizt0dkj4/44/Z0ZzO87c2J9O76dQzT8C+n53l6kV2p41VDKfgO6dncmMfCYOVbRfUOXskeT8fNgHBG4zGJNFlpE4kb7zWWGP8RhURi7gAhzKpu35yOwczylCVKM/D7TWCSabFEmVlDYmRa4HVGYKJz9gicLt//wfjfhDG/M3cEKQTaEIWs4=
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