7XD7M5nWrMcjWvLcfne32n5lhL9dK95CvMIMSAlRIKXYIpmA+xqf3leGpjwGHJi9puk7/eeWi6CM01iVoidQzn0ljLy8Vky92YzMTcVCYyhrDHZWAloNOSeD7sn+SxBUiu6SS0O4yWIWA6yVCaREZWMwFfDckrxQO8HKIcV6tGEBkY4UdBVBecN3x1ACpOZ/T6UQNVn4CdvnUAF/lYQkWIuoSb8HCobg7kZzwpOZn24DPZrBkclWWmPwe3BcKDbobPOcV1oD0WxL+F4A/GP8xRZhig0rN7wfXwfuUch6O54I8Pa51s0xXL4LDWLzaDFbiKVN9abblxog9FX4cQe8wOLRdO6/LkTTYxi2YNYQcHFNLv/nN/mBVSCOANp++EbZ3zBmOTwWF5nFcx6nNcCP/+89LNEsPs4YEAAv2prrtuUb5OvU6QTv6vWOQT3307OG6G3dzAT+luhBwymERLISNZKCLDIm4Z1SZDgJXi0ppSAg5cFCOPuq5Io86BWSCcrsub+ZTD1GuT8cudg6CC9am877rB1BWzEU8nJ6oxtl5SAs/fV4QzlrKRFDWasX+em4do7zAydgetCSq5iY8qfCv2TsVK+p6pbk4ZrEv5RIPIC56AEoJweSABj+CynOICpZIJK1OSE73y5BzygotIXVtaSIgHidvm66i0lWaceEV9lU26QCVp2xgQyl+UECL69n6o/3U8U6Kq3DLvDMjioXF7n+whcWBjs5N9id99dneit7mtAUxrjkZCs9YMDe7KM+XhR7XSycOC9pqKr6enpbm7MyxUA41hPtlHV1MVPR/FNF5xQAmycSyHOaP1PDfp98IXCBPBlv2IqGq+rQMOcyjCW1cIcL2TYFR9UBHrEbi5S/cenktT2J2HrKVQ1/GD9OP0eGlGQFvP+N6ZS9/RZ8RZ0u33X7DsMt5qEsQBlSH3ed8uYOrZhh5b5DGhIEroZqcLW7gBdCL41NzmRzhEdM9NGlxBxXepw7+l60vHopAmJC5rAbD3LEh31oyRdkqjoywQphZVZypqhkRYBN8Bd+GtvmjIU2ZIf7G+3ogdmbblATWuBp04HdIovoDccRH9nRO+vuXn3d1DvKsRmABG4nhXpM0d6Gv4vkE/UQcybyEscRpkDqRp9y0FRDmv3EDwLi3jI3EOgup+lBJwMvByEep6svqPEwVi0mUN/gUP8PNpRlMoU5uEjgxV4GQdReKpSqgZ5udjU2nSB8LowlNffq3kPOSdcbvBs+24lsa9UxHSq3OEgrC8vIIiaLLh67v+GYheY7x5ieHK9eoEWI1Wv8fEtKSFHzVYjZkh6V2eunYp7aFwvYYUSIun0jRiTT4gKpQwWpW957uXEmXkt0ndbH5UWR5FFXVo7271cd5nI=
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