X4PRA42+7dEYeXwv7AMEV2ohZF3nh9CZyCBBUT3utVIpDjZeZ9kCISYPzG8+MuOBGkFTRe9yFIryBu5iC7sw102M9wkNm4H8rXlIKlY28YX8i4Ybv8X9308Ddypavv4s6RlT6pS5NyPh4HbHEvszTzGUobsMuorH0hUPw3TKWJGtpXNvTTFYdVeFRkyV3jp/CAJtUacGtah84M92iUjeFdDBxQ0AP6cA53iWDoosLQGnh1e1/vURGAVU95GoCfW8452w9glzzzsOBllXKYglp5j1KZ5FL7ny57hKQOZpL6DjnrdA8W3ai5ehg7Fd7qXj++K84Y2IKbsUfn3Rgr7S58bFUqk18AoBSXjSdivRGOxDRI2lA7zt5w2XOjS0eW3Imp5QRAnyfuSdH/i9aFjSrSXqmz7qPcfG+rhUSOdgBV5Kg+wWdfxJ9zs3l4Dax1Pwpfhn3V7a4m2BQPrN8fS/yd5YEwUL+01QaAUVFhmK9kFF6nNLLtRfrMJa1dEPUwNFwb4xZcpTmCZrpKTEZvHbZA9liH3h6wXqL8ignuZW/mQIK2C1GeWGmeuAqbFX1IiJ9Mx0vQUPhaMzVmIIeTy5zq5c+bvTmaLZTEVjWu8WoJgM+RaCDBzHqvtmqO8M7Gb6UeEHS4pqKrlsILDLHjnT+et/GzlUS39M710TIbECeCq/MZCgWWJH09YGWlI+yxeayeA8eDOCozcZvdpmSCrOKHRBStqtFS29MzOkj/HYA4pEgqFYC2LR3LCrTWpgqkAeol7/NT6plKqzwogyU+HrHgST9bibG+z8AgGfHe9Q6B4RjzsMG4jEFnp25xAw2BkbrYFjlPXEu78xVjgiC0yg5MRglgvIM2NW/IIpqkT5pTbuK5oQhZIl+HYfbDxulnUxJqLTt+251Z3obt+WAaOUcRvacGshHmVyhLv8YG9ST6b9i0/FXPcM23wUcsWxOKsFIu+VNwRg10Uznlu86mIU9SPEkL/2G//eZqTNEsoZ2rD7Jb0QO+k49Ws+vdI+tP9Od2vNLWMJI5SLivUAsDtClDSTtkfAoPbQ4x17IvqbwO4Vp8A69+inLz31h5BF1mjvN41bCHr0stC4z1CcpeuO/PF72CAdQ1wtvDKZPzjA0IQ65/VtGFrp/YZ4R7OmsRCCm+kPH9AasDJAdUFm2lQEW8u1PSUEzIYBwBfY+rZBpfOPp1IbCNxA74jLQ1SBPbgZG27HBLsIKG+GH4JJ/qtcZ1RwiaU7xaRlYqrPIJg+2wHWyUsv5S+rvZjEiY6r8rk3kFgL89p0ENHRDk51HdvqwTeE7rOhBOZocB8YO0AQxbGjVqNWwrjrLfV2GW6/MDYrzAGeOYKGGuNVVq9VVH7F25Axkt/f9QxU+My5QKs=
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