Daqitgqpt71sPVhO0jo80xkAo5UUHJd8ZeiPOt5YD32btRQlorYBLRr+rLbldVscN3wezaR7nRBdCRGMMkRJO8tLMj7p6ZRnGT29xK146j7fggdBsYboedp06/Xq93JmMSaiTZEE5v+Q7iar0cvny0q5uz/fjRadBmxXIPECXmU/OLmomg442Ol3NNc7WOfHMuOavXwkmxTNyqgxDFN0JY8ldqGJ0h+RzvW0ArtviXzZjJuk3pN5YSKIbpAg24yB9RDFU5ZZHWbFGIjWngUIm9Bgh8yGTqLJ/5DmbMOVTsVumjfVEPQHUYjbWhtQ/vA/X6gqho3u9eLRpCJoVeL9EatjlGdflpoI5dbTbDAeHN3dmcCKq9GUiksXTYfmLEMkQi+pxMiabzBeRSPczhkE2O9hDzBNIhR7SwItjUA58lS4A4LIa/7xeFlkB2LN/DcB68MLZD1tOBidYpbKLxuI3ZVaG5H050/4KeQoXaOTJHkYIPzXq5rhy/rItywg3w4OEEKTJ5PzQTC8BYCjGMnu40MK1InRm/y/oJGRuYA4tvlcoec0lHMSxBRelao9KyONmDOfkwE5ZAgGWG2zCEu/NhD9cLd/mp2jm+uHxRdgoaDyXzxHjlJPM/K0l4/I8Kbdtx0BejHd4gnZreAHeQ8/B8x/Zol/TNJcuCk4US0wUCUmBIrKQOMlHDGl06JYOmhzOn3SmyMcTVSIYfUtrhqEkyW48PZTDgWhngiuhpSpPgsAp3/V8ucaHBieRdU/kK6MHlyYCQbCqbExzkCxhBjaKUPylQGbKowQ9LuDfYmQ4wjjdO0tyZlOKEUKexzIAPNG/nuoUe09tmolNHuC7my50KEnvltbDFDqP1eyVZoAfnCcqN3KMy/bgAFBNWBnhtib2/MkUZpMRDypYZuIvC9bqLd7Bi1VvPmXQNojk/joJPdpmiIKZa+dUPJ/zTM5mvnFnl7j8JpbmpuJFpUyN2iHrqOzsmRyt/dFROQo+x8V4Xcu6uSauimp+R9Pq0OOizEg/DtD8jG+U5Uwr2IxnosbmRMplu2lC8WY4hscj854BZHqanPThIuJ+BvHmXvB5TeJbyUBAsURKIudvTTcoFsFIRfAO99C1E4J/DCLEVUgoXjUniFiIr/V0iVHfN2iDDyLrMyt/Ok6rnVD3pkcwZbLoM3x69G1ht5pvRb+DfNqSMYZbrOJR5nrZXvGQpLxxPRpp4skfTuoM7FHVu2N6J01h++iwq1DoxGrDiF5cQK5uyohrw2Ij+p+zIKaFkJiDAap/K2YQCkAl6532IEDhAfH8tG56B/z7vamrSKyH7JD96B0eZ5LucfIQU9UZHbgnXqJEQSD3i+BkBw2gLANbmv1yGgt7xW3+U6y/lz6sIs=
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