yIqskB7mcbiRa1wwVc4T9N7TM+/+QDAJNVYTa4qoGAUZ5yn0vXfIY4Lnj9dB+2dKb7rUAIo0nRM1ygBzj91FG7IZhhbdrERU7WYr0u3x7hhxBb2c+8iPWEV4PGAAjkkO+qNGPPu7ClRclQgOw02biNUU6q7fapkNF0FMyaVEeaMk8wyTOmvBstv161kEyGvPPBxjyO5I+wJ/A/McEgi+FQsHVcu+Lc2XGDn8IJ1s9l0j8yrNpplyCAxgBI7OV7HdPDBIq4e1y2gKiAwrQ8WXiN3uC4I51Nmc2ZKDZsr3sYN+D9ZZ+diyZ3RFRqMfMx++x7qBT0hhSKIv17EciiiE8FDo2yaNVrbLHM6lnsdrbunId2BRkvSC+4eJZ1AqK9YnJ1JEFy406JeYAc1PbwMNZk0dR24DGde46YW82eA0UYhdmXVqhD1vDk14udS18olHvq1cOHjfKIvo7dId5SY6vtqbFtuAZ6TzbZ3DwrEcf8ZTQZq60laWgEatG1F8TsLYmTZDP9Tnjb5jrSjR7HJQE7/I+A157Qb0Jamthg1GvC2j0yx+dM+CUJ/leOiGnL085Kvav1WrHbnghewJPkmnnFJlzEZyNIhVyrHo9wjS4EP9JCPO99ztoUJyu08F+rK/Ib1IHkwC2EC+dDZx+VXIKHFbTNzmCab+xbj557wY7AutgKzqRRzjPrbUrObU8lheUSMq/J8sMP1Z1SaO7ETJ+kGtt+aTb0IWgCQL4nssPiCL0m/GToT5FhCHw6TtcEYDE2qKBqqmTPgJQb9IgcDOSN3AwFMey+mdcPWpDiBCb0/SOwHhdny+DyOXuyyb1pGcIzPoaHBMck+ivnx3jTVPrROVqv1wiJIFrvhy2w69JSGzDaQyrhu1sq7LhlaqPRwDo7RwyOyvt73LTP1Ow0Go9AprBZMeKyfNPAAqtMIcz3f2/xjedmU5ak4iXEWOsJH8ygaR3z6z5b1V/lDqH3JVszGdAwOhqrvLte5egK/QeOzfcrWcVbdeisQepdeD66xsTDbBn61x+9R/oaBID3/SJqCH9ZrNef3AEgh/Az78w/rckUQM6teTxqXUDXQMkHA59+E2Iwq9h6fuATP4JhC+nkSdfBHiWt13qS79baLlTYwIlaqsWi6m+85/xTQpCgrJJwQnPnLES2b6BBGr9cncy9nHqIPpMp3v6CFIpAhkVDAEdxexbz9CV8Hfk8XfjTi2EB/o+H+Xxx1HYYFuQjF33aBT4bJkUvAIBvv3O9y2AEadiccsCpGLjhk2avdYGPe1HCR+jLFw7AUf2ZE15X8hz9+bGZpXi+mLWtTKXOOFYma4W23Yn/sTZMTvkNrjOsWJx5wUTRG5oPK4kl9ME6Pb4tXYqStO02TKpwcXXnQ=
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