OzgL93xG/9UOlecmopleXRydDNzoDyicAFyWu6cx6Tfe1JgakTE/CMSfEBY69wemf281eEq3H/D206ceMZlr2pqQD4oqDMVnXOjcokaAQ1XT0gs7E4nuUE/UBAkxABy+haieATypIOyAzyeJnJgb/jILmGEu30cajRf8YceSF79nfkNvMXIQAFDm0i/JJF4yE9Ne4yiJeMUaidg92ka1m/jgV0Pam6hozV2cVkUny4bAIsAcCPeIby2+7cFDoxupzvBT2y1fxR8XxhqEvldHqqCgW+NfMFLmEXYM4zkgpfUrJm/PlQycl9JLrm5/wW/1n4MkaVBQ9/khYhnM5F8tuH41/R0QI720Q4/tlSUUXpx2uQpeNWcMEDr2LPeYEIOijbYqWShLJSboSgmGmao+a3RYOVlwgQOEhftWeSDuU+WEOyk0RvH+shwfDc0BEXUdO2OS2JJ6Cue0Fr38oMxe2ZXWKicBu8fNlispAYoIPYIDojqszvmVJ7TDil6vgwHLXWPi1tA1ODL57PmTxxb+x+sArL2uHIQnUAKcY3X4y9B2+DlD3cH/Bmwv1xqjGOTthJhK5wUtquwzPUlGzWDUBkm5LAJF6p0rbFOw3L4gIkvhy+HxEsJWClq9fMz6c7kSycQRPjsrgd7vm5JSpQtHkDIE6vv6Dqg8uXGed3Gpr4CJFefJ/dY1s9fVCd76w+4EWZG1LyLGIHyHP+PH14LhGI8wfFMFV2T0KlEsT3CKLcvi91X7kk5Vq/L6ccASa12pXfJ88W3DOtfVBX+N0k2efMoxoOEFuyNRAmaAgrq+iGxahJDnqHUdIf9+FYjbr4mJIKVE8KeVDE3c0dhj04RANqC8RVLYDIfzaWV5KtE74636iuHCtZzmi8IoMJAk5lzt09LlDXoavIPr8gUJudmrwj8ESUBui8X3NfLxhYGA8pKjuZcuX9Rr2fOHE/OFB4kV+HNlTDWt+IVwZeKwJ3XJ9lB1aZDxK+MCfSTNTuuD2eQHotMXvyyKdZ4dZjplLuBLHmngtCnRgOOtTfQgjVp76j+LdYNlRPcdlY3iM1lEOjhCeHg4xG7kH+7SgowIwO9d+Gx3qzTw5mWMruMgTnstaUMmFh7/ALmMKQ16l+Uot8cJAt0bV2BaYyxf7EcGhAHhz7dQVDEk6dD6UtiKU0ZUHCVEJxkbWKUu9K/jwH5DmUgwfJxi9maXvIilFT1DXw27C9L+2QgoGPwjqMxdq3T1qzm+C7jmv2hcW/B4Ow8iqRobKQAWOIwf4vRk+FtnglTtj/qifE0ZqcFl4ffcBoOE16DSJ7Wd08bRdqJQCkQaWd+j4N5myJrHHHbp/RAfbE+06pVUXRItIZFPjppDWExO4R2G0ySsouQ+3KfPR40=
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