N3zBPVbaSltkQhqt5uE6Dlq1vL2wf02+mF3h+faCQcfMA6T09cRrNWqC8T4IiPEErV5quRITuCE09DRVpGv2xkK+glj2cCOHhKa2Nq6zsAINAjkFvR7SXiBWMUiZRknnNCsXwyyyck0WceclzrqkLwFRCpgrKa7HvcRe+4oXbG/6XWfEYkfvTDM9seOiDPfo9uY0Gv+fvWsCTUhbGBkO1fbX+ca6NuzTL4+79XrV9mFZqMpKKukToKQQj8/J2r8Ww9XXL6rQ5UOPf6vdOH6W/OFvFY+EPj8O59sOFedkTs79Wxwi9y0s/dAybZ6Vc2W404ehFDEei6vN33O9iEjMoa8/5J2zoclNdYiiTp/KNSBHtx4QgBv7iBi8y0a5A+X/kPnnqI5KjhMALPiROfbsBjVZSUTRpOC/VmGzg11vIMByCJm/I8inWR5Tumxs5hQM4tpCGMCGoMJ2KxoQgs3458JZ7FQ44AtFvKyaTZZn5UTIJsR/Y0u8G32LtEICy0mB9wtRirAZtYhSofhLVD9dEgZ2CNruadfAixAxzsJzGzR4SWIAGKcWy9NoVAnzrB9rGcaXualIuKPw9IuOR/KagtRKx1xCjJW3d8Y+VD6pe9x0rc3qN0uDhYom6IOoaugw/qffMr0j1Lm4F62feCztCqQdST1hE79VzndSZj4EHMO0O2Oy+RQeryTQYN+skpiuiDqguU8pFhmhloq0KfVJX8PiLcN7yHfCx53EMe3QMYeQPYWsyZIWvnwBAfroPPSK2iWF4qEvM3NBlayIw5WPmS4ywQ6qi6sYpkhGt8RB8aYVleCDSdvTID+lq/BrqQey5nMPE0TNZOImG3IMg2HJM64MQ7uK6bwqdnoJengW4hn1uLCbwVwXFsoHitl6CzMofQY405YoQxpqgtAEuhiPymwHc4hqqnCwAeywurv2x/576njsuh1TzvAUzaIJNEq4LG2nfOhZcGboXzqmNi7IwwGnGcWQ22vG2op8Kdtq21qiKnNOYMalm4tXaX/4je9j0qfX9XkGN/DD45Ymkwz/HsJnOJOavWJ35kfRPCUv6hoRPb5hQ7276nZda6vfzA8f4yMxv9aXvMVOix5h35qdtfJAZ3Z2Wtf+PBrmefXLjF1WXhy/6PYk9wcbKwDXAkO53fwtA7JC6pnInmrAfOz9Mns1MyCyD7Od8mbEC7OSSZDO3YwbtpGgtXu4Z1vWjEFtlpUtfiyJsyxPaT6nUyrGjij4WoZdQ5D/12iTyeIChx9bf7ZspYMZonVG6mojDztS89p+TWFQLhV8l/jE542XahT60d+9vgfu8rFU7DvefXS+xF19xkoS1UuVo9zFHwwMa1sWuNc9PzItZgXauLBaT7C2/jAdRuFk7+tdwe4=
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