XtZvLXOsMVPuDGWt/kCUR/AgXfawJI1gwYP6QHYIs30JLdEcZ/DDbE3TybtzOOZEq2pfv8mE1IyzP52QCHdLgzukfBrQILrY7O83GC7F4bqa4h77iYpaLYG1gSTt2F2aL5chBtwhcPsnPF8moYbWicXn9bukJU4rTC4vtMpokPzANYnQ3VFoUR2+Idw1XGy0C4xgfU2rIBR+DUVFH2Mn4wQWiTc3BNaFkwYxyiPZJE9cJnLOerL8TmZgvRuft00i6S1pHeOLtGwcdsqT+neZzau2sGCSxnXZOB98Qm12RCaUGaIlgUvPmKS5KxettBQ3jHqAM6ufL7ZAbpR7a9ayKpaG0ZhsaQR/beYf1nXBsXM0a4rkIF1ZyqZnamu6HzHxE1YEioaG4fIXSc1eM33Cvv7dWHCdnzqd0Mnpinb9a3MPcB1+PG+1ZsFMR5h1SEPrquhJIYJvBDw352EAsx6dLmPhlagONtRDF0dJymoGzo7Xkd3NXydF9ivMTKOXp2KJdqs1apGVa7wJezBx8hkFTIqjcCr2Tt/j18z6rWiA1GYNR0bEv4vCxRzyjZ5+Ja1Nr5FYZUGgkevFbiFVn5LsYuCrUYm9HM0MYo/4J1cFwcTFda1UCSAx7qALmfPnfqP3DawX23ADor5lzV2jd4WpaBKfxIK1nv6WM03r+Ot072U3hkTHdmm+hvtRwVeh1lD/oiMY2ph/1VqZ1zikfAHXGtoxdnMQNYu4GjtaGASqsUkNEcOqzyqsyFzQDyCGIuxjTBxP5DJt4TP+duQqpkjpesaGuQFf4MBEIBKdpMA6JKpU0ycgrKHvp7qEET0JDbyAx9gYs2aXnTRS6T43pNuCnyHiT940Zvf3/WPXgbF6Bqjp6MuMrtn8DRm4GlfzKDaWKd6r9E2xZI/hWMRzrIwURTlithNTtujh+DKd0DSVufXKPeH+kwzjoYzcYgezAVReawoXaaz0OzhXaCb/kB0Vohfpc4Ey2u8eyW7apccnJMYrC1dwerdaax541sXGHWPnnubtDRfHnXoEXvph3WtoaUABs1CUUhVteUA8k0GGJvJGG+arL3Trny1NTWpV/v/NsHcdegB+K0tgVfrwUnEd5GV/3zO3R8Pcp8Yn2cspTb9kAoaFF167hN4q1MKNesNx5VaTw8gr+/JXKrNPmItjoPv+XnEmSLS3AOpvqff6OFVtKVcQADm1AfwYAuqHQJNrOyh1pXXF4F44shu0iHtdrGT6fqTGOnGAmRc6OAjYwJIJSGzR3D3DxFayyNLDW7D6oOftRmimRrbSuAMco+/v2GIzHxYtiNqh9irHJWUw9wV0BkzrG0Yl+H4EmQcnRk57/VLmvKwwVVYScxr97WCWh9aAgy1z5Fw1psKnynA=
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