wlhFOsz1lkgRnk4hFp3kqfm2Ns/GNa3GPPmY4HbcAchAuCoHvWbRUUhYvOWmsN2YBzMj4pI5qbWMsgNjagZEXhHghZiDF/HwWQ89GqhxOiKl+9e0UPs+4YnKlOxmSIQJoYlyN0Gyp6MEM1RRhNhJs1r8Y6BrhxhgEDNMb20Dy17OWxxCLu1Zmo+zukpqXma1l7Nvnfz3OFlX201TZpmIS4lIIG2WDC85uUAZb987AnyCjuZoKvuF71NSA9cNwqOZENvk7GeVMibgr/NphA7sHAOWiMqrMFK4nBN7lxgU1THGjUZFPgqZ/YzzzRsgSvaTQdVPx1o5nDRKRoUr//j78nWNN9g9M/oJ02br+hNGRyzsYERRqtdR/9Kdw4q2EOWHLHEKVOg3XQnDx4MBiLEq2q2TscnST8xBSGNVdv5tWN1kBPIYWJfC8+p6uhY+c80ghL35+K4WZDLp9V+Y5PkE37udpQWCqVnmHjaVLqlc/Ip7wJSTVJfZjlhHEzROPViOWZ0NsHRfZ5Se9GHg24bvuVRZ72Z9dmDwzdfBBusD1CGkYOYIFgNsraRgmIryCFoPlNMmr32SJvE2hVyzsH5nOOYqIto4/UFG/XP4N6YTRl7aqK4CFknSj0ITMurNi9319PnVAn2aHGNuB+pmk3eNRpWFKqjWNmSvp1iFdtXyq+PlV8JKHcGhm7sdEghzw0leJ/1wErFCzICyYjz96jsUjR+gZh5FJL1rZCse0dLbTwxsmKRuK5R+URhDLaOEj15e//OVAnas0pc3AsaadJGfatwhjdgnDSH8Q8QqQZx46tpjQF52iQkCRIVqkv2bj3MDsy/vYdf5/MO/OoWXndD5DFaW8MyjZSpcigkLZu0PS+vV8uhyuuo0fsRN7Jeshr7DJBgEnDSdJJFD+QxxHaOON4unw3jaWOLlSSh3KNWAqLC5OCsnNa6S+mOknfnZn0LrC68jI7SP4xw3bAHrA/r6iL2bOMrQHMpN5FkZ2dy7uhfm7WrkYKBmzCRqd8WdIHvzO/ZWX8I2swTC7YsrZzu8SRQZ5C9xKSgpRz5tgghzkKhzH04PAqeBr8LoGTliJji8kT1o6TLPVn1fURI1GEOzYwYqmo7ke+jEjpAULhmuHLr4N6boSfpsRNNhV8QZVo9CTGOd4hyt2fK0Y10YS+BRQzn2KQV/ZAsxByarhL0zy8H6QVMqfgDrC7Unu+1rpk89QyQ9++2PJJPvqsHSuYyeoN4ybZM7Ydu3NqvO4dgJksyOTFoxm/f0mcK96s4a6dJLCw86p1eR25TGk1dhilEOsUMWkmKuLZMNeFs/iq/h4db21IcYBCg3KJMXJsUPM9i74p2fBNgJZA25yHlr6xYSFze4ROHpcX3832THyJU=
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