1uanX8sSsmgoFoZJizSS7EavIbbNIjhzO7kengIKbkP4Cn3wngEJApoFnBJb6SMvndCjVbG4sXfJZBlePHph4SBma+O46EfXT4KFi4K5qrFf+iAPG31Obn/kT4V2Ki74DHZQx9KOvm6UlyzrnpJnGK18nvxiLnXe6IgoSNvDSK1XM3xocHYs9QiGGZyzneKLbPD9wDT4RlZHgbSrtt8UjkDfSDEyRRhUi7GkgdLYkMKncplMASA8Nqp1YoVvvmRvLKQQs8rOMX5IzeYKzzsDTF2YQVHI/tSuht8AMIeHPOvQ2ZtesKnuY1k6cBUyIIdeqhExsRcys51jNWDM+nl84p8tT/wnZIfz1rYKu7U4LThiW8VJOidxvx+8sH0f57KLM2PvG2OsOwVVNg6GLwmFcpUOb5GhxAUIiNyCuDqmv7aGDosonBjgmP5VjiR0tqpsy2L0HaV6plWQhtnc272m+GH6FclVmaixuTTWPziqXJLGUMCfAJjMEciFMU23vt4QAaZlnB3RxrQ7BOJf+/4rbpKi98xtrFcVF1tR/5xHUVAvGJUwBLYDs25hdHWysudPVQ9GsrMXiIa7KtcYQB1u8qS6p3CD8v2BiyKgODY8cfaFKYQCZMMOy90smowXg1gpdz4hA9MXFExUJL3BqOZt93BpcJaXXfZ5ieHgwacmL2AfVS0oC7cFrWuKmgjiOLt03ZQ3+sAMAgcF0dRvNYs06ctepnqB2d/2mt+PbmMpC0W/pod/A+cxC1L9Lr9X3oc87xOJ7A14coUQn3ZOITEYxdEqcs2U+rmY5cTUQDDN5oNs8wBOpORteMmjp96428yLF7GhHwZEtBOEbeQ6OPclwDUxI+38h9lQaYHdmZTkqbTEV0RXrDtBPRjpDZwqoMSbwDCWw2dhrj2R02iAU+oKflbcG8WM6Be+d3DySYCMKHsMo0jCMFSWt8WkTz9A6IY+r7OGGeNNhcgWT8aayzEFp2lp9Z09prBbvj3Jiml0szXMlVzfrRSkbLsW3WUM4aVXSxGWZinKfmmTjKJhBPCin3SO+VM1DghFef0VCPSyx4H3U1aNb8dpORkzUDVqTpc8uTsE3Wf7J1gDLR8/vpdYcNzXHqN7g1zESVF0hrcvsELqLVewe5ofCIi0wiL/W759JB+sUOLfvLyfDJmE5CO/BDLbjMoUdKtFG4I8mBAewp/XFgH64lllF3SZoB4QdnDbLjRgEOIF5+b1H7cWQB7lHpKDujzN0pwic+zyfCyZPO0qjqguEr9xkaFE65ZXa5Rpq+C2RgOrOmLoKETvwxq0qI3VOz+IZRXLhZNZa0KZF58YzWcUuxqHtHCntxsvqlyd+NOrutpsM0gbU2d4v5GVzNHIQ3cJFUhBuB5S0Mw=
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