yqARfXISPcS93LHvtKqLMktOHJBSc3pV2HP0bDuRdO0GRRsoqhxauf7bk+ARt9WW+oGFfktNTmbihZWQRkZOkstsxIYRoE2UXk8yMkLgk9GU/wOKr3fCw1h4UHGWabjBosoZB0oqHc+R4TG2SmqmIFoUG8/ZlnzjkDcJXWJIcKzviw+3vBZb/hXYOUShnWgpEtUvXbLbHoSyCAgnmbWMbdInh7a3QrhA/6jOvRqzbRN1KkHhXNacsOXPPBfZ8r8Za9t0OivAFNE2aRqj6bUFbGpr+i+SBXVJmT5en+I/+XHBMzwopPJhfeB4r8P0gIHmZsYwRkNFzCok0fPMIY36lCqgln8O1FH1GDMinDQwbYwW3QzRoxHODdAXUDBON9Ey09yA2YPsDNCMaWuKNJX0lEwy816PvArPBDj/Uj5FvnwtjZa6b2mgMGIG8DjqbLXlTwA8A/P0Cr+wgF056hv4PJf05Zxld8e2Ic9QiCXJ2AUwEF52i7LE9wD9VADvxMcm24velvXHeS+yuvP9K9Bd/t6ciUkJ0VMfunV0pxqcG9f5l6qAkdh//xsAL3CtlkBcZLAMnOrFTpSCVnPRFhIOO3CoFPVACaiY/KQPDc2OOJ46quUTzpGsBM+EdBUX7mKG13VNCvoViPpRnff/MBrdy5fUAq3IQvElgnMVvyispyLDhck+xuhwk92IG3ikvj+VTaREHwCV33kjUJmh+icPdw+E97benp8INMh7xFGCp0B3lvTyWUY/xYeTGpmQhCnEOVK6vAY9F+xPGiDntvvdfYLwwXLsznF8seN1xfv9uUe0b2faH5rFCZYdsehzZpl0U8MsznCbcXQeRoWA9CT0uHYQdNRnTEN4H7uUClfOdiNeh82HULNZ/0ABPyUI7qfYdDfHepB01QMRVwD1F/pLJVJb0JkUAJqBuwY5/PIFxKgOPNBAEKG7/CsAGuQdx69VnbuiBlkpxithq5DxW8L/aPi7rI0rbRcqrgdWZX4Jc0aanlSgguoVeo6L+EnTYXN27K62CMh+xAQuF0DmqenBsA/dyOuiMUpsw4exaRnsY2w8lXXbmVq+2hthE8WqSD6W1DZsC8eWFmgAKNv2cKC9C/95nGdF14yXfu0sNqqyuhk/Nyam+jffpRh+0pziF7QPSd6wcnyKecfoBknV4Mtf36q4UUXkBh72+rluonckqbHaqV2uQcK4c8u++NuG9qOsoQTEUgvCnsNesFEhnpt7p+R4/cWe3t2eIS0e33GI4SJTjEFh8atL9GxOCRv/iay4jUcN73uYJLvaTamM7aCOJ1Yhr1yPO8sm5QvYYmb1TJ9wH2VPRQa2syGSzaWMi3szK+h+x3gh2QexX6ovltXQ7SZvUl4Z5bfpI5sZ/Uw=
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