jfd/0Q4Eu5n3IDLqoEBhn7Uq5fa1fdszC2uqCTPRxGct1BbGAGCbURZN2Ql1xisBou1ONkdbrFLTvBcnSL6YjZEXHeNEiP9DplpVJlZUn1+fSxUX6U0rhEAXia+xPHuc4Nki4FqLzWJluXhZ9xeO2FxwWt5dFqtjv9NxcxZvYBQ0ZGOlAzi7AvdsYljR+PE7KaR3VCWGmtq9H7744+17XAOlr3pOUtTiOQtIzW+HXX57rlYYFgxnPOD+YafyhljDZW8oMvqfIsdJBIsiw7hJQEaJvrmkAC3eEgoYPmOYCsrP3Bt/iCaubUI6OZtLOe2IzS2hYCmUv2ljOwVN0KUkWEvuW89/MzZJlhtVqLj5VsBMFikC3zc4q4nBIY5NFJTFMPiWSwALDl9QcpO1xPhNaylPD0IcPBc8pfq5Ty53jVdIFTAQ5fDbQrY3ITAipPBCj4aHF1vHK9DLJ2QSYzXvo7i6d8oUaL44ml2UxT2DlzlblcfNOyypRYMPQ8A+fB+F74VdOBC4KFIUlZsEla/WAq4AqL/79KHJaRJYysgTbAxYZswlvplfa2n9U0zPBM8INDtVLwpem7QIN9S/N056zPHydax+21Yu5s4x2QtjsD2d+q+DfOR4E8alHMGkVJFtdJ4rAaxgXEYFv3nba6OuTAfla58P14DTCpTJ4NLzwmVpfmQJPCy86F0MPAdd2Rl7Vy2KQP+RXZBC20gI8cCb0NjgmQqpOJGjYJTXSK1dk26Mcjtu8wdglQSdi1udlkuhA79WkxzSLQdb0SvKGJxwrcxaM6sS4YCdw4kMtZh7sftAveICZb+Ai7w0V9rOnIJgwO0dPmv3tjycs/Yzj0vmg0WiYXC2oLOlanGdwiC0JwNJRckqL4lDoIDkvyuKPt9vGFgn7Junqk5iWcNycIpYYW5K5rFTc2/TXg2ksTspQqlyx+gohwWComAqSNUAN7KQQ0qHa/iM4SbM8bucEVHOorPqpZXw0f3/3Aoc4cU1nlM6a8vYZJYbszJJ9nJicNfM79ghbULJ+mhSK7XAnrozxKEwf8M0L8WaimSS/E/aoRZmFOIVLCINI8zcP1Qk25issyYgzugB0qUw/Lu3b2ulqrIqARiAbAlKA3bQ5ZxpjYcTDygz79l7NluFDBu3NLehSg45+2+Be8RPBl9kzLsvfIKAFU0kbEqSRz68+tXWk9SXrCkbEpttotENdGsHPZTxUlE2v2AYQ8BQRcwNUWyrlOfr2igzM+bmJQ0wI/xXVy0eUOqcGL2rqPH3n9OkCAIfFbWbff90c0eoCTdMCAq6ZcRGoYoSNR0foNH4eZq96mKjxoNPq+3e3kdc5wqCVMeYcU8tKOfXhyuiJ8VvN4fIC06viQUvf9lN9acK6W4=
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