jvrTfFPvWP0jUhcy8h5ykuq5g33XJE8kbC21dS3wqEKH2qk3cMZ1RQzRZimJLtjJ8nUgi+W8R01Lc/3Y6Gl7XVtvh5vph9V8dJoyro2J1FiQPJQmvuZDNvWR7ccrlbUMqDH27U/7dDzbfVDa/lF59OTHocHybyMJGbo0j+4zH7jb4Sdk6K1bGEqz8gnxRb0TxgqOB9Zm442pBAOmUHAF0bSdgi8bbZbuLg92QLvTT6dt2415OT+/wpmuZq9RVBXW2+zdr/ULhzbS9zCge0WwQOgkGTBTkCexnS0t9fHUwZWUBDunmKQqTvqV4zCC1gHxfR8h23Ww97yMRpvy/xEHREb3E1JYixyNnVU9VjK2zHOYRjL4eR1YQTpdsVYNknIbsGzbYPXtXtVAeY3kBn5ycWdclaYDFb0PqnkKFr5nGOMInQyyaA3dV0HAptni/jNvqGBWL1FTeIRrXBjjnG/HzUgMzZAeRZVh0VeztfOv3+PAhZ3zcES2Q2a9biJkAdfgaGsaH7HDBZwRiukyxLpXQTrErLLALNu+o/qsbjLP9D4Kr26xEWTE+9VTJc5V0Q5SB3UT2XtYpvTO4YVb/flDCrEVwfrPyX14661IKe+8JbHaYmkH2fXG2zQMmkUhmM5uOCSbmawh6iEvczgRKMaFjFPSCu8qARYUIH/pOH5xHWTTcKuoDjS/mAXs7Awu+yRBmNNpKuqE1FSDa8eoURAJwSUhA3vhLNNxJHAmBLjO4cxEWKtwrNRd4SEYSx3pqggSiRdu7bWqJrGnZt8MRJV3rVDmu6msgjikmG5iwhcjzxIbBW3EWytmArHjNPoCrFYaqjqAHbbv6dvveFU/feTe5NKQx6a5m72HJjW7hLiX2gpJuNF0aF3R7NwI8rQF32IjPStfVsPWXe4+Zn8EYrBb7GZrhZCyNu9+oqQtXofWKhj8lGC5PTnG1YQMIe73nzye0xI3nRdRXGnE7bKKEStRn/dSik8PX68u45L/kvInGuns4Zy3YT5KoRHEh63jWZMijo6NHs9zHB+rNVvBxItNA0ZfL+cKy9CKZt5xd+Dj+QSR+cXTkmU/lnXFCKYJNPsJsE6Jq1fg5CX1pvoFcwCEzQmApTMQ3Ivhtb439Pe613/Gbr6e8GLO2ajOnj7O035m0SCL0hKF7e7DixXN6q8O8Aqb77s8BhgWRtTxI7I8eWdokA6Lcl+PRTX29DXkikoh87IrRcwD75cduuIAhiDvh8P3Dea2giQ+X+rKhB961QUs+/UNF7BbALi0Ss16EfDwsV0YB72Vdqf/ip+HVFAe+AOlnzf0K/27JDsEBTwIU9MqDhWL7+ENaLLzCGXY4wdkVuxMIqtEUoU4PgcuO3O/UhtutkTHKJ+wcAH4KJw=
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