lmQGjVdHNiWMP41w02EJf8MAQopyBsy+sudzAnntjI8bbgJbjX3oyHZF9Azt40msdF/sto+C9NSFrs0hPGSfzodbmmyVBT8MqnukFk3J4PF7qdiZJG13I0rE02XCKMfrlX0oKnT8kb7IyU7P8QMjFo6uotFwS6UzdRDeUH6EcExBsr+0qwV71ugPa42CjKy+nV4Jz0ONuGOoxKn0EQIq1IXVfK/9SkN9cMPYxM1vqhZ2m0uRYfDq6CrrmiVkr6Y3GluZsTLmvpliG6tXVegwbSVWkvKc8ED0/yCYE0BsUR3lNCZoNueSXDQHRgB6DPXPSIKy3tsU620FNaZkBN3dK/nAvcnaNrZJ+AXiOLuZAdv3fxLZfRrX9idJ3/S5ViMSyla1AmzCG788fwrbDoOkBP5JiYCadsRXLIW/ap+r33vd7F9pVdiUV8DQnrfz6DJVXXWLdzHo2sFqZ2/Xqye5AzF9m4rZ4hHA7cPoI/u7iaXHgwkEDrdxRhjVnFBdI3Q5eJwDqg3W3lCuESDHRLLIv3tCNMgQ8TbuBGbwIHnzQDWnVlSvdJwVC6bwd95IOz610d/c9Jof3ntX7E4O0eFU+fwms2OLM3/0D3ewGxhwKt7Te31fXPbm3OeduvpQPW9ImuzmxtXM8JgUHXbom+XHISd5A+8fHLjTN3RUK1mUJC08FutbM6eH/q90tku1kMckfDdEl/4uAep2nXL1dReTmqh7QoRzOxno8nL4Zjz5NBwCHi0xLEab/4XpYeudGpurXup/5pXFh9F2sLqHcGVsxP6VcUuP014ztag/XvlYYiROngREtR5LOx73PoiNeCBw059eAeyAFEOOlrHx97U9JynvYi689Wr5TjeFURx90RWGRa8Tld6p6XMSbm1pPaClDoOpmoXj5w76a5zclbdpIA3ZOPJS7IAqjep8ktdPGjklxjqTWk/ppxWauLLx+ssuFeu2fZqw0v/DM+jzqjXH7NEWiUwWMk+wt4zyVy3UkaC8+oZoZYB4zKB+PIoB3C3AbnZwebNtgFXRNf/Sexcciw96blfzsY2kUPqWRxAyAGom9qKBa+EEZbOQgoCncH+EJpA/01mpY7w4L1p4DUP+r7TWx8rGSczdGXXeueUZ1348azP1+ND9PmUYrzA5L1zismaGguiPAZUk9Bm4cId51rMKOojcpPrv8Jx0vl74mHu/+sPSB9YMJd7DmZ17Z8XG2joe7lh6mCqAlayw3eIjiU7ZjVClO07dettXz8+XphwGAqUrNrf9nRLG6+l6qcqtPcBkUnBnXX0Vfb/PWj72G8DQrkXZvfKPSOVyhA5flqYHOZAHyVw/iEpXfJ3qTIGiSkNrC+MyBx6EN9isktcnMJSL9P8CPdIN2ynNHDs=
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