Z3zzYnVxUCZawOU48TpVSeeIkrakZ2z+kKfIuL9fV8Sjo75W57R/HD8JhNAtPk1GMP8iZBsL0o/oWMuoaT6k+Tdd5muCBgRlyggmisCuEDnpQSB8CnzCYXwed7GdN7ZtWIJRFcGtqlrIDCpzQltnAtY6lJHNpHuJeKqlpdr4YsaTN2lefQ+undESFX8RQrxLZBH0QbJ2mdmbRKvkxd5nGrB3YwYNBos5OthjRYnbWPiX572o/b/9KqsqCnokfid0k1gm167URcy34sDzBNe+U2lV1nXuMMgbqcqrZQqCcpLElKVyElOiAMBo1JOl43OGuD+PMTGG2Ed/koSZhnndJT85oyN5I0JTkmu1fRx+U2HSrKUsvOZxX4IocBU61MdPAAkquBPgm68J+CQgjUjB9W9PUS5nRrZUEpRKcukD8DpjhvzZ/WFB+5yfWwDqfS+AS/uLWrTa7pOeoi79cwFaWPsQfnyaLdxQMpS1HlHgA9rIA7Hyy9m26AJO0/bDfwu3Z/3J/vVukvWU7SDqAf88yliXL+IU4/EpK8f+iv6SDhXKtn/5z/1GYj/TyolEZVSLDkw2PZNm9tTuu4HvUoOlg0Mky6fOFOCgiwdrdQVCQajK+FBXAVfBIKLik8KBNj6qKV9wVCVSiGystrz8h/PJA+dY2fRKQGLJvmDmLUph0RNa6vGzZ0y+p9rRKWzBns3ZNeiGDfPWDjc8rIaG9rVaziq2WoCLYnzPnp+W48iB+Hgwd2l9f5Hq5vipdnHdJyFQlmbemctLelFIJ714+DX0TATandSWMLalEYBD34sZ2Me1vO2tSXsJoQ4ydDseJupPp/AAhBKa7W3hTns3YO2eOUi0EmrF4G9eV7q3XOVttDM8b/iPhliiME8Y896dSO89IDo1dR0Y1HgVy2WVyQmzOvsX6CEKLfthStaLB31FHjWz9wbxcmMtiURgpNfXXnUpJh5+Fo0bigolzrota2uAtKsFcj0RldGcUCNtUJColQTT5ovX7VOgkixq/2YzFVyUXRInu/3NBDex/2tUwraBO1B34hDknXKY31dM180ycXaPsVcGeGpm49EUpt3dUzsKO8Kx0olGwLQQ6yZJyQ4wnOGtWnW7sp+Hq5bbx9owkXCLwXEwxk2rDZbeGZTlbD73wG/RiYQQ5vxWQyFInQUohqorbnhmFrOTuxfc6QCTYn9CJkiuw+OGmmUf/+aBEwWLqIGaexGMtqxnqRlyM+lUMO/fHP76HTEuJul/0JEbwMCaYx7ndyPdl1NlNjey8M78WcM6Td6sd0ZFkWKyXkzjYS5WM+uIZYtqg9twDd4S7V1hdaLvVFs/G1LRRlUgOFTcJ4QKZ9xBgUfTfdWafo0oCbglX2rW7FDLQWdTTWk=
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