iYW2a6G6C+1A15rvpGNjpWm0nQ4XD6AeficdhrOPOxk6RU3/ycpEktIJstjc0SideIT1lPoqu1qBV6jPrGusH+AEmNuTdPn6T6t7Xhyv7Ilvsx/fmMPmhPHBXV8u8AzTpa5O3pMekNaMd7XNgCOkhgUJowHq2YkmGo26T0EB0E+u7HyQfsutXHg1xVpY34My3VWEL+BPaXVn3gyta3VfjU1PU/rvhpfLhDgCBBv8iaW8nu7sPtEkfz7qQfE9LGy6U/6GYLbCff7wmf6qjQSR/S2FN1V9sjwkHfeOS1pEdWyljHMojQgVp6fRCbfzB8xkXqzarNQ5gYURnZTWMX6Qo+xdN63INdgZXvWsasnyFa5LYM+PTZU5f7oV/fDcZaSkWi0YSpzTBHdEVOoQGVHdBlpARzbrbXp/fjVG9dimiakdfPxHUAnvdT0J0gaIXjKuXiKIqbfxyFa0Zp74Yu4kkJlgWVwmfSmpC2h8uE0duze7ThzveVF400wkNX1L/xbu5gKLYXelGr6Yr8UqUc3cS30RPTvciUH90UZe8O8t4SociNs6Fok6FQ3qSnTQoiS9aU79hYl/MIx9Kze8zKZ+Oghr3W3mp3f6J7dlUAsLQoRHvSdS11GQRz9f6+fGGORkImf+Vp7jvnzeIhWeIBV39wGrkBpGV9+sKCLZulvV51zTHhJcFateGKMvb/UGEkhs+yRd3ND7alxrOxWy//Rcp4oiEdhWiyxhFtxk+cct1/+v/zuoeUc+WWrWOZt3ESJaRTfZuqTCEgnhIpxQNj97WIwJJbmqckKCtP2O1VWnXOyWKE9/NiaYz7A0DMRBjMv5kj+5oNRkgmEvAvsAZtrO1U3lslXvl8Nafo3lKZy+wt0VbZVpUq/85zNYAPeMpXuDsKA22p6gP/HQgiSeEBEMaMz6DOB9hdySSJ2zUSE8m2lVUNvG4qRoAVAhXOcPK7fmRR0lQDI07LUtApqT1MfUQYvqa6OV/SSvyufQbaN7A7f4fMSzRB1uLSB6mxbtERm+EQ8jJ5vvXA1hvNGitcZcYX18hbje4yQ+UPqapuALdexfIXA296lfw8YSOmebLbvlTafT6Cv224sxdAGf/Qf8XYHhRcFDfKKmLEtgepi9OxD9UdQWOYd+HATjlQTX44dPYGaUrdQoV84/RYjmrPp/ro3T5yGOFqTvsKlVzM3HGNBWkUolJN6S1FHf7RpPmLW91L8OU0VKb4SRAn0k4LX/GQQcVe4HZMdXm1mBfXJwyXVk3wxPAUnKZBuBBSbG//pxpVltZ6Cd1tE0RyyhPfJjCiDRUrEUItfXq8KeBHmHMtVdpLLw2kOK7XeDRHBydha6rnzpaA3hEvcX/BtIbPiXSc4q7ZNvGqV3czlBOOI=
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