aguIokoTjQWvswfPgrRJOmJ9GSHp8FdvRxVjvo5lt4SOUWh0heF15C9Fc9u47l4UZeVLMjeCOqEIoEtIEJC6w24P92BNSsnjdlXOl3cgzWd+n7nRJYv4h5oIpF6b6qLsN8iMayxrEhooMzaBxSi2t9I7iTzZc323YC+Q1aI9DZGPdsvGPd5ebnRvHVA0R7mrzPaF7kLmLPvqfact72JYRuGVkADcCkPTJ4SWzHFKi3agC0R2/Q1g3CORNOx/2oe5Y4S0FLZq34Qjj0d7mV9oBaBeL30EmdAFg6EEzEMPy4JynoL+UXw7KqaMV/Eafy0jDfN0MSLdRZTtunTgyk3o3dtMmoQ+8uTouesnbTRMLVMy9EOau2iprDFOxZ1jHtTUGpWPno7rAGaqoqpLs5OnfzaywJLYGqFOtAkVM137CJYtX4UGrwGZjP3n+3un+9thvCpnYYtvlf0tzPWHHecYq8D8fSUx+VczFvm5V1wk/bwwqGqCKV/o/eAWDiUukTR9N9mVn2JtG1LdMW9qLLH7eWVpHUFVpZJhARAPg5froMUcho6mwCtXzO5dog0jBAV/VFL5558bM4s7pDM//gJqZ4pMnllFndzrC4gZZT/qi2usJtJa9owDiHYKAa5cB8yMEgMudRcp0bDduVISF9g1/Ihn/GVFszae7DjrnJPgnGDtq6sPbokg4NsQvV5HKYNNyUKOTYSkzRIBQtUHoLGK5gtnkZrHcuYlfBkjLdPafN2Dx+45AKwc8WbWMgdUG7jFS5OBjzdGdIVywd8r0n+U3nFng44UW8yiSGZ+RD3al2HQD6kVfDunNMSe5f+vygVt50F76fLstjPKXFHOAJX/APOxvAwIVaXfxUaLF8DB/eY9oiobq7F7ApinXQbwAYLVI3BP3ABzFn5eRLpVARwvxFGtWUBsXO8VZE6zP/XKnBCtit67Ng09E97oh49aPYvjLRxA+zZbNdJPw+qMyqkbeJ9Cr1zAxbnjn8NLTe9id16w4nonHD35x9wkK6vruTD5cP+dmHnAuEu18u/0kMX9l2YF4DTpu9Crxp/lK/WS9q5FvXSt98HsPyHPmwJRWRzM0vgQdjlkxhFTYikyqq7wm5mriVfaHkzLfNkbB01txh+9DQMG6ZUOVWLnDONgfqLeQLCsDpKa3AIuEYMZYRhLAc1a26MlL3TQfSdcBJmyWkihXDmSXmk885lu/k6eBBXCXo0IGxGOy+f3RpphdpJFdAD05TUlshJM4In+qG1y1gFKnDnpRvAMFyYYXgsRBoQpwbfpCN7spWi2eYnutK9OQGibqPAX8fT+3qif4GT8/aeBJRM79YXKDYkxm/Gz0CE8LwCcDfv7NFPs6RYsbHwpH5OkaoGx1FbQIHvUsDo=
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