NXx+RYJqa/gHgl2td82oxiZL7Q2pqCGOth/q1+tNT/jFas1EaCFJZB1y0v0rOYwapAYpbLSvRJ6EIDjn2PxhGSumXUmXOg16psNZQDa5cySgQqhLxrwfw+/fMOtD70z1NXOZ6noqxmvAEkdAmzKJy6prS6vpZ5LQIyX8S8JSVu3u0YRRH0gFUtwcMhDS35Y8jNiMyb4m9vJBsKKG09opbTx+DrSzDQPE6+YupwWgC13CUHvQn+5qJdDVcqj03bPIJBaetuq3ja/HQJZoA1y3SUeWZDaEkwpQeIhemCJKiGT1W6OVswtgAnXOuewRM2dex5ndZPG49jp9yi2VtYh7gaIk1zmyGAfrcPM890AdQRshVdmBk/JQfCIkHWWnMpdVTXo3uAdHI/70BfblzRvpKB5Zhd8/KGZz566aTgnp+2BUZ4pmQ/z8e6zpDmiNRcmLUbLio9xsyWnXuRW4yBj0EGnSP3CfI96FlPfXVDIk9WTzNxxviHd+2IbJWA6+GabDQrQBXoVmHQnVkBSRlNJYao6Ipc2X5/hoPQ0gqH1CwIeVBoGlpOPKVlRN3laJSNg0S/aBCsL/eYBj0nPYjNrY2+V0FAMupTJy7sIAOsHA08zDSn3S6OZ018R3RkiSlray8ReWEK6ie8pWxyCq93jQ9IeT6iJYEsP60mWYI4u0BPjatzG0mfT6n02V0O0aj55JptDB/1pbwqC5k7ly36Ah/n+rPHauye62T8judS4FbGvhJoX3sAZ3Rodsr9oAcftmLA9uo6bXgwNChIvNwcbGOgbmNBl8uloOZZ9vjcg77iH136r+L2FR1O6nKRASXD8ztYCwIa4pXWQowVP0xuV8UdF6+VyDX2KIX9N/FeiHd7+2l1fc8WzONuN2VmmTWYvxVU6i4Pq/+eT+1THLjt90Q+E0tHC1AgO2ITTRV8ANg+NKU4WIko0jS6dJSWJoh3e6VfYgB9uTPZL9OxnImEVYCEej4AwakarNjtgz++8d0gGJOYmufxFKOjbBZUgpQj2HhRceQZ9U0X9yRkQsqmSxCw7fFDgb5h3DVm9EnjJh9CjSGTo4SvRpPYpv02uqnJiq2dCiXMowOIyjwpPwv5DMn3wRM5OSXjOYm166cGXMThaUxnyn0sUXoZCkC3BZjTwTXtNLcp6/5AcJcQABQJtF4Dtl2zF14rvl7CMNVG3wCd2QoVClzKUiOD4N8TFkXj5m1+Q5ISJUJYtq7ptM+J3Oth/uLWKwj56Ofrw7uHdGkkubdFEptbTiwn3U00y9vgxDasMOj6l2KhtTX4cKUSF6B81qDsFWKfkTx4dwYWu+uHWV0In/8CmaaXFBR3/amqmSzHN7P98U7DTg4IMN88323DoioPjE2tr2PX8DDgc=
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