FRedbFzchzsxjwVCsJrB+NT8f8YwpLPwMGOVqUA95lYEcc/ZVwnMNdO2RM+0CS9CUBsiK/ML2U5Z524JMf90FD7t0CclJYCeQV2V8QzFgCoyOVqe2H0v2mjjT8WkVdLe0Xw1vfLzjvOlI7xFnvdEsHUYC8HzDHNne0NEQ/rcATwVvpK6zM0h3jPwvf35FfkaCgu8pMdn/vvi8HCXSaWKTt0eilcZ1pu1e0ZdfqkkEsUcEGZvxAkNj3QuvGA7SSPmKyrHxYWAIQNIPUo4nJNR0x0Zgaz9np93h0wRD5kepC3gy7c6QBzuKImFFcFCAMHPOWfznWVD+s7lRiHrFKDAkwvKQECG3oNlkD6hERtwYO1PWXMqt5mmB+PtqydCHI3nC5pPjzdR6NOQoQDz2f5VO/wQlDUR+L1Wg9UIwR6CslEbuFdyZ/xxF3+YJzixlKUEZdBck1cg948uOSl5PwD9VCSbld22dI7ND7waXHD2x4//kep5cp+MIfmVndqHMN6XaW/FX6re8QNaKWAs1HLOZkSChc+UGuaG+qZisRtlq12szlcO+u7MzPZ2SOao6tqqYkEqx3s/Ii3dmHkl0h7K3Oo9CnASRMHiZSV42LIrT3ZoKwugHPk6HY77Ds4+ZxDHosf5kfAwAW8NbffRkSbzWBS3KH4S5CS3OXBH6+6M2Xg9K9OmriFUyy8HsFzQD7wKzkc02eLbDNG+iJ7crM6iT92uf1C7XqHuwuoNiuYjugRzfB19dYFtS6nf3bQ2dhgpoV+vALXmTA6nLursmCgYXUVUce4tTlvErcFXQHk2RrzZCmG31CtlkVZuQhzV/VGPa86kFCTC7XF4ehFTr2S98772FuRZ8X7om4wO5p9IbUVSHxXxKH8YPAoxJK4iEZ2DZsuFe32PjjR4WmSpkyN6zZEobtJDUM/sP1TG36R2t2DUDskDOdKomnaEWzKKDU65fd+vxB2vGKKY3OoA8If3I/XuXWIsmav4zbjOvS6ZMI4x0EGqMNn8lO2vB4SXsq+l+L36NqThSHO6FYa8vAkzXeGdy9VhM+sWqjj374ZLpK3wUgzfoYbjJoYYOp7vsV9EqEhifnjUWyFyOPeTs3LXGKTl36CK6a43+wIYvWQaF26WOYZo1c52Ua3/FlEfl66YCOMm2qMhuOuelvFnsiCeQNJFfYR0aLUAy6vgOBlUhfR35wN82GrHnGoV9vZHw8nryQP49Ra3aRlArum5xQP5hfnUD1gFpTXUBrSlpxuMKkSaITcCmCCu9JpiNbWsbMjVA4I+vNIXm8s4ITk2wPs59B6rKtYzlw27jeN9t+Gkt2t+FTSCMlaefpBg1wOd8zjeG/wlxqUFz1Zi4acUbSj9LkE5vT2qDJUfSStvqlY=
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