O34nF3gzBxsPEHdWb8B4Bm5RJ9ERow0BWtMXhWSOZ3sMGBgtisW7MOGhGBpKMAMtWxutGghLjDIOhDdWDwYg62jOzMmnPUu2l8GVSjCO9Bb63JC9N5n38I/AYC09wEHULPQr+hTp9gjFU/ChSxyxUMLENsW3khJ3H33TixpYf+KEm53gVzxW+eF4LZp38W4aCL4ul7TpsYmt09cfIv68M8Jjh1689k6gDj66ZllzgKcCEwt07W3m8GBv1Qwk+VvBX+FLz0NskUUnnbfxxZAYx1Bzp30hmMPThmI2zqt6HTCEBDG807Rch24zqneFN+o6konOWV8aSE4cU6ahk2sTdoGYH+2dtC+O+FoUr+4QXKS4hcJl3+z3QMsJgNesQe+HALchOS1AzSon/SkOnUzBiIgRyUJumZtx1Nhk03//lxzsSnGpb2qK7wUMpZzeqBBcfpIqm8urA0Iozl9VVb1tFDNunz4dL1zODc4ZURpOZ73VuGSNfuEKWRAoKMklB+Ed6rT5QB43oB0DG4FSciXoyTvz5eiOZINawTHYsipprD1D/zJ0cbgjSD07qn/6KPRwwNkwzSeDptsOMX2n2iVthoAWmpm7tjVlnlWppkUY8CgmrNf+pg7lA/R6lkkUkijB9KWo5hRU1wEPfCRGk7vG7n/R6bkmNvX3fVwWQf2pwU7xSuqw0W2410knROzMnBNoKDxpCq8RRwgj6Eg98Nr468n30LvUC+emoLjfB4EpdF4A2dLCqJhcZAzjlHwUZuh850H+K0RvmCROpMbaICU1P/m9U+OuEPvUNUB+09nRWlXuZccYrLNbSKnzVv2b/RqljM68bNwnsJbFqWQPXXwN04mKMJDqRxArmPJCJsi8J11KPZpAJNiX32LA3/XKAMKNq1aEvoVsLBxigICm5y2L8LpHxRG6RdBS8ty7bFpcwn3foy8974D+cvJ1YlckHJ3MlI40ImU1aaSMD2WR7ZWxI4IM9Fgv6p2ovJ9zWvk7okL68W3A4HruDJgGU2jOT0xO6ZFftUKbJKrgWZXrwMV0IdSF5gf7B6G9BuAw+zSJMnnCOK8piJKvlvGb7cTYfdtuDFq7SrUX9atqduUb6QUqSDSDGWke6sU+URT5AFzKPvQQrBi9DNisEK3fifxVy6v1BL8briBdQ+AXtFL+on7TvoGx7H59MwN8MadhIamKtltyP+5JCtX/jlN1WnZAaUfxy0V9Q18wyLSTq2zvnYH0s95av1w1oIqTy4teI2vDCVAtc8NowI1AWQf6KWi2s+6oduJ3hkPbp+r2BNAwFGJLGUjNvekLUJ39m4bs84SuYkf1qO7p42m1R0TlDbWiLjuGTRo+RxBz3zkmPMCJjuQwWEksBfoFlJB1N/ohh4E=
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