KomP+OX1Aduyi0H6Jk+Iw20a37/knIwKlrm6PsL0ZVPA17udD2yy1TY7PepI/QXXUxvLrH/GLOINYcZDgS1kW+MUWwIf/NLPpJ3XCHc4lPrLdmhLdRn9gzDnOgQDUfYoLk23mdP9qIe3RAQgPY0nIVpuJD7n896dVguch5pYILijavOtOJVOudaZkQYZyxQ20a1WPQ5mhQhCCIEZJm0z1usZd3WPxdBOkmqPT4rNt/3IpPeGN8B7GN+bGbddeevka/roPQQ5gPxTWEDrFikFdYVi2FOhBtmomNfijLn/hJP9659BA1AiCNfMPzckDW6F+R5jwXrI3G7GvQNLBg7FhoV5l8LtszLEIDv+Ed+UGjxrVh0tJuvWLy9DzFkolYSNAkejWuopg8yKTrNvkXMUEvcK2XlVFei6TewDucQXQpb/w5QKUJrCsgEBx3ZHgKGPKplViCybTbNFSeqrgZx3Kk0IpA11ksNva+rkKn0v3HdDJtJ3RCgSRlShXlKyZ3tRglamxK6pC0rBqNwxrCEXbtw4LXWt+zmYJU/l4tyRQhffJUR1Gu6yAabya7L8mRYW6G/Zq7SuWn0VSHs3Qm71HOLqmVPxUoFcvqp+oAHUDwmJYVHAN8FzoREwuxFnNRbaZxhh83mz34spNKYKDsanAbvutUTHGp3hpWhz7BQ4EyNfC684NkK8A4UXMbXR08LQyhphuVNILd8W8TvHURJ4c1CFsOEhZNJ3rBTgA3dJFJJWoDI5mxq+K+fAUER0jh5iHfNjLxClsvxxzpbtCAqCzRJj01Vlf1Olln2u1KKMUxlMqVnfj1Iyz9pq7tjXTb5sBAwnBHRMvs1d0e3szik2yPuPuxHiwdBRFEOupgo2KAEQidqMibsIHhAVsJSatj37PaFTOVwXhWrFgtJoAgn6qWIDVDsTix9Ww5xB4lUyzZ7rIoGENYhKDGN6KkVog71qwU9gAP3jl+b3IDQobknWUwVDnT+3qVcEMxnJ4m5h11uYs9L+qOtMOHJboRXACXahel+ubWWuq7Pu+za9B7QkfIVHPncd/mamTN8n7Ftu5/Y9eaghBdxRscvk5epScn3oPThGM7LaSkqd0AB0/j/qs5vB488v5/jY1WOAHZm6UPtqgYw0Jh3DyQ908TbGBypeOD6vg5T0xGaodsYY4d3ohdVHnbmCSVeVPRu1xz4h2uGk6HuI8y3Ztnlcd2Wwa7tkqok4VRx8omZL3ZMnfb4xN6d05Dw9UCsVW0hYR4yU5VXlTijgiLWqo1KYPMd9BNQkP8vyyqTB5tjeefsgf3Vuvrr+SISUKhv7S0gM1g5Ly77J2XXI7f03N7n0hnaz2rAcZICt+WYMDDP/QrTgFk243+sXi9pentqqUDbn9iM=
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