GMmgtABsWFnfHUSj3HcoN9dXrQi5nGfqwrnMyImMmthl7jxC1x6XYG3PuhXCQrDgHNYmJNHSWy1iczLI5ojr1d+N1ZdLZpXz7+X1CAR6QT6zAIGcRz0m9AJ16NSdhVOVa3O4MmeobMUcHLTNQrJzaRoxfgioOQmQPrTM7vCFNmLLQHn1vulfA3ihNdYQdD33cHu6iZP4Tf2sx1ztaqO5Ut0Sv+bURJAJ+21SBHoyTZrfUFsUH4yD652Vi8lQSRJ28bFlcJx4b0DbZK09laUmxK+ntSdFZOX5Rxw5qvEooehqc97kn0o14cj3wBm+FSIf1eQokLoU1E+N94jZoJljw6TlxgWy2RnpbuPZs6tpYxT/9leCsc1PX4AvOjhgO5QoLCMOIg5u8h5jU+D1MISZLuCuoY3MeUafwMz5Uz/keEeafWL6EmvyNpLoyhmnfMPT2KpDdUVgRPfnMzISDc/4bsN7wG7Hfb+prFIJ/zBoEiGxXq3fAXgeB7EFX4wKpeZcJ4ga2t9hfTuk6FKQwIzja8BZt9zNgwasmnyiZrnQi1/2NOUxLUY8PpU4B758/8riOSg3H3HfvblaPuXILAaFw1CK4UDLSCHBxyMWv3gpHcL5ZSTGULdXF8up7erYlkRaq8CXAGG7VxrO0Tw7ErTFVqbLi5f5ZPB8qBWzEpHx4n+wJx52LhKwxarfZD293tO9qLfmPUviIWtGpo+XHfJxcGZqBDWzBFk5X1m+xoGLhtP5DwlqZ1aeXS3A1GkKZHRbcMYjulatvOcxosBdNAlmb6CbrghxT4S0M93OVf4/3TmyZLK+jSQrBwC+dX9tY6OODAadKalrF8GFw+bHTH+srPIsKcjafmEVpRd7sNz4ap0C8VJnIAmKJ1Jfg9Dq0RQHjTPmXMcLc+J1QOfQFoDFd4BXLMJ9IMKHWuV5R4nU1DZsrQG9vAJwV/sljMBhL0BDo4tTxv3UKFl1g295Hln7TxFfB4ip94OPoHb16qwGvDB8Y1OkvLFJ7SVYNghXa4wDitjE7vNUmuM0c9g7vSVxcj2y+hFxiqBxJm8MloZ1f2F1Eu46f99e8omp7cOP0LkKt0wQOaqdWJmAVd5dCXo6hpj4jIVPJN9Wq7W2l2SuQpdpZD3yUQX1jmRDo37vCkLvXRcgycVMiyuzv2dIMDM22XBPCdY/QqC6jICmrA67chnHfVjy7lzp8M63j5urZpopydm/O8PEuEq24c2RSfIkc/qhcrDMFiAaqvGJ0ogthUeTptDLfOobbI+5qkyStVVTKAqipeABTOTJZfJoURhCevf4PKeKl91VaW0VNYv6CxZXTlrIpJB8LA8o5bPEzGWwpVqBeCxvfTBxByo7+LihovZbxP6aqrvzmBShxNY=
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