MZkbXJbiSgI77GVTV4huwUHA45A3FfcCrSMlXjofeDxvfcvEW0bmao2/RwaARmC0cqfboy70sByET/0b73uHwok5/AInLl6ER7h/19+n8rw9N5AGtPfROqh8wCoQVvho3uSiRmlnwAj8YWeyZOyCxRw8yzk4VXapIwogeAsvBQ8NJoHJzc8tVSkv50XyA7wW9LQ/Vx1643UqtJb+ij1bcMzhc0Qsij0l8pLTba+2+q7f0oa5dySuZ0UhFrl2JlKxdwhyjWvmswakvRGLALLquSfiyTDGLBNVmn4FyCt0BN1HVfDTWv2NcH4e5V8fjjY5xkwxdG65OstVqo4bzjG0/vqTzKdMTUNhxOCCmTZFgIKb7tlzTyQxK48jcXk5Nuk2Mi9Wse4+nBhtazigEaX72F1yYdj9FSbGlvXZ5jGptjP2THkHnhV8N0aeGIhNBtO+zjBvP2+o2zUFho1KkRulInfHvPZddQdDGVGwQR+4HmdlMLDm53fwHVZBlIIkXRmdZSD0Cp2YxSVfypAFZlTDmPpPL61eVZOu2rbXQltm8lGUa9lmwkmD8QqlO1qR+MDszb8zO4otteiAehU/sZ3H0SSGJWX/lpfx/xGIis+6ypap9BAJXaIItXtlXiZ8Vvz4bGPd110YXCsqXVXs5xAw/oVVxbvWl94XGnr7K86OW+Xhx9Fx81m9wGuDVJbgIYFwd9ffu4Y3zeMZR/7KZVJo/jvsdRsk3Mvx8bQ2DCtVTWb+TSibNd7GFnBL4Q7Q8qoWDQfLyKiBhx1YVY4VyaFyiKLvrmdoAzzuevoJOAkwQEtDk29M3D/i9oXD/WMbvBi5/vlxzVgKcPxBSG3RZ28DUFMzpgC/TGItpLJGANc5bLW84bigyDMPmSWV73vpLqzN22TI0rkqDR62Fbf13luJc8GpAqQNZuSOjRjyuplyaadAaeW8YDfM5LeecHjIPRmve6RQVWQsEXDiayP54N6hdteborFhzSDtoYcO1yh0O1JnyUizF2jnwJvyWk67Fkg37oyrSbmhxc34f+cQnP+qk2f1aWKHrH54yrAhwAnX6OR2wT8cD8WVXgt3hr2DGayiC3p+Fp/TWD4vUAH3NE3vAdxbNvWmigC6thkpgHLD8DVfh29MNUmx5BASRYukyYs40vv7XkD3XhxJWIVHz7+apWjeY+5r4+HlQVu44bV3UIyMbiMjoVb+7LbxKTuTsISkCX31/TBX0N3tCjK3FyI22rYDLSRrFBrTkXtShLNFgmUFdCLYeK98sTj+/FHQqmkpcmwXU8QYVfkiBYaxPEpKN118435KCHJahmdZfl09aV5w8xkc84c6p2nUcWc/fW+2ohY45vVXVnzmtczWCO7Q+PatZrPLxxJ74Gi5/xE=
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