fMnIQ1WklMeYSMuGQgAc3X3A2nRsYbCMY4shaVEc5CkXm8KQa1HxkMzW9AKPvINYMmtEPscFqMytAlzFYXDR7p/XaZgnWbVJ+wVBmIqb3z3HsKjzCAlknx4I/5zAomSWrZ/ErjDNijd0L0Qi+okgiXNEDEBWr0lPsUOIN/umErbju7BlniczONcn7i5bSC8u0VNjv7ex8Uj0bXw9eE2ykIzse2vBpDtzki4Gku/uCCfIs5WOeIxpQnwr2TfWU9fqJ6Li5wnJKeP+hunlleytNsSS0CgImw8WZfehY+Y8kiKYF/ttl4bSLrZqoaDkPvFi1PbnpoPeIuq9ZDYaPAEfCEqbyqvIWTyWJq2zEnoP34W93VqVmsxzRk/HU5+xQmHVDpVfUDTKa6BarpI1Dc0DczCWU46Qz1RpzUKYgxx/W/YjlB0J7mLJtIsL7Hy+KMvbEwy0tgTEdcgDBYjbuS9+uiIwJ3HRAIZQ/5ITFL1HHxlGytzGkcNkPjt/9HNpPAHkT7SchtjZXtYo3Hew1kjlmJPoXfaukqg/8zF13RzeYJxYj7SftNZYpB2VlvdWfiM7xy2gZMR6J7Bd25EiD+BdMteMNIr7QMBnzQ71xD0Hh+t4AZQqqIPWdlngUuw5zQmZvSX8kW2CkRz/IeauAo9r6sI+flHIN81BcadR/fGDxV+BzUsSLcCdwXrLu4zasxa9s3xJ11nduL+DkuAT7NR1240/F53xlASnJqDMDTxAYoY+0lztOiQgcOiF9zhSOMkUH+wehKx7pJq4+3V5Q70wp90N0Cn+flhw/z4q8Lqm6w0WsRtubO+wgMb+Mnk8Me8S97sPqTP+mW/l7kJiImzZhQTpcAbvwDtKul98ITFT4Te5p2zihzISJun0C4i2rDOOKgXElBWGdzpF2Mam84Xd7Fj5sQzS4Vs/HX/HzMJJl1q1CPiMokL/sEff06tGzWZe6lsLFKwokSznzfPhQrtbtj3h8TVUFat6H9JW6AosnJ2RgIpvrdNGX5tNIQKQSEgKbUGIXHbp9lwcET8OU3sJjLEzOyTUrLpNsXOEnSR+NveBj11y/AUV/LoqrV0Pgoi/SU+KwNg/kBqT6HI85YAJf0NCvlIJIH6QkJZJEstiX/oTenQEyVODzanc2EfHfx3GF4aMotBs+PBcoR2x+ePjrGZjpn9XPBDjd+I7WGT3V6bkPrKw8RfWTx0ldK4LtNYkF3ssfEUEvycaBBRdv1UpGprWWVeNKD5wAmV6Wzm4xbUTnR5g7JdkkbsDkqks4DIT9w6HFF992AE6PeklnVwnfiqggGljOdm/GH/R2TEI8NCShFL+d2ERbbtga2eajQqDCaZKeuYYZiahi0dqldtcTPU2fr223a+NFbaXCQI=
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