D0wKmJoPZrMhkH5mtZJzIX4Uf1i4hoDfXE8pIZ1cUWEeYjX14sjhBultFxUn48DpUKYicrGXbXZswvfzmIjGZMQmeOmEgWMluQMEdh1K/ze+lgxX5tBAJ9k79ErVyxGqSGjGBachQjvUlHcZ8VKKqiDf4N3RXCTTGdixMTAO2pWIKMMvz6ff2TPL1I5H2Nmdx4tlcATaz9JB+bhOuBe70ne6Au6lLwAS2+zaTaRkh3ya47jGb3oZ0uS0631EykarfgLZgk/QiTIOrEOD4I0vUzjVDg6gbgalOBXU8Vm9Upk0i+ND1QKIWcwThFYNNBfIelfNWW1UCo7WMlblT/DEGgyv/+/wcQD6zrq+Jtqig10q7RakPseoLp76Fk5J0R+cs+8VbQB43Ql3nFlVqESm2oEVWXHbQK/miYePMrYO0fkcoCfPbrq2MirQZRuvtV1Pwr+ElXANKXYxuPQP8KMptnO8kgsS4hdCf2Qtt75HFFvs+bKqXEIuMF4wEavQVxGX4GbLRo4RgvGrfuJvvlehoHmeDIYF5xfsKc0hxHwwPZnsKJVkPSe4LlcsQTQEfhEw6g4WID8LXSylITWKxd7mRscGczMHWAYoKzZT1cS7/SEk4lA4tL2kdJKpnvCHss+vdS98BXu6dgbfD8HUUeie0sZ954sJVHdSzq2xWq1rCX8kg7ufxmSDFW3v2EzdhYsQyObhRUQINs9bXCsx2CEzMxkar9cklyPmeBrv027qQgkKARg1LoSfPDz4wblQRN5KWjtEdwU4HPFGebhInSTqRLmUE6aETzADYY0Q4+lILoz9zDdfKMqM4BTXeLNuuuf+paoYzO5VfrukE43EudMmbAnfjgFHbo725OXzWbHnaGtdx1eGxNPliAAFBJEOmKA9MNWQeIbhxl+LB4x5GXvJ0goGLReS7hUgbJVhtq37TIWz8VjQy9SC7NHTsz2q4y0odZlLz5hUOMeJ7iA8zL60Hbs3Tk6getFth/QnCEt3S5D1en5dVZHZCM8XMTkWPhQoB+tL72KN4ymo8R2dewBUpA28emVdc5LQ/x1IpsUdHN2J+x3rFtqZAZoJvKVxVPu49gbRRV5dGpfxXmgefNbPPYgI2yWwTMoY6MIP9ZMQZKwyivd76SjV8+9EveLo9QtYeOfbCGInXxTVzfKTFJuhKdhxjKzBWyPzhK052RTx7S7tx1B0OqF970lfc86F+jhQTp/Y1DcHixf8FsPiPgtvyzqgwDden1YrlZLjwBq5cGY5JcbjvWi82lQIEtX3dMhho0zB1I2FTgl+1IdjWU8hl60ZlKdIbulICrg2drkPHvs3Pswe6yzIWKx8K2E/pQWi9TU8EvOQoYi4WwPFJeXv+NlLvy5TyG680gf9Xa8=
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