kvqLW2tDJYGHyKtI/q4VFCuRpzReciZ2BNH9vT6OqQ/xNZFy8QHC6/STZyM1q7gtpABd4O1LIL156P60PVdsc9aVhhmgx+TVyEweMT8ghUo8PcGDw26ikWqLCrwMkU0+HJJzjTeK+5KzoyHHXpkU0yhp5ZH9ojMPcsCs0GHmBn8yp3LSlgp9FnU03A6FXfCPdvUCXsq2dujAAi2Wu77xccmim0741ka237DJf1iZZlwQ1s4azR9Q3MOAdiBilrhqOLE0p5/QeVKnu4/K7FZrxtA1nQNFuaczCyvZc2zsxjCOY4SMLoRbVFHI8q1ckEgcnaGJdYZMxqKQsz8X+wrqyG1QqiOXrcMQMRL7F5zpnXtpQ1P+i8cKaZ7Sd8oqeJ6EczoxoK9IdGQoP2eK/gC43Mb0nNN1oJrbNMDgsZ7heK+Q/ORzrN+dKJyJBwhYmQVvk24n4UBRDKdL5VgpduhiTzTR6qIkqg2dfnyhXDQUFD/IONbjADvq2V6F91XyFAoxQ9KuTtnghCS4ClIMl6ghRzl0K6HbzUN0OjpjKM3Vjuh+wBdgI2hdGb7X5r5a7p1BZVwTgdcQthhYWwfZKbgEvr6V9LCuGDtE7wzLv6RzTrz02y3WyGcGi4g9TMQX16I8+TeOX5WtghhJM8yD++HUfFYitTQCChNIwqi5N7w2I9D4cAqD3YR6YGJkP1JrYhWA5/74nJEYvdpH+q/p4X93HfOU7zdjoqVDTwqDuXiNITBnynx9Xgpp/20/ppMylkdlcwnuC2xd5Tpc4TCI6WyCTE5TePY9aa4rorVtvykhLm+AxgygAd5vO9cp6wYJcZXMkj19iHG6wb9U6pph9yuQis3TX7BrgJfo/bMmwfgZiLsLs9apTZefFpm65ljgO5o/zwf5zCqd3ApBTVmKltbBWhRp1o5CchzFDoTOZieoRHYPhk+UrwIYE7PM5PIzlJW9k5V99Z4o6jL1cfOWmA/pMeUTcvtCKqRMDul2qn6Dywb3xizDEdcRh4CJEzbAtvOn23rZQtZAbrV/231cmJqCeiaNBD7xhnr4jmblQBEKLctCcXslCgIHbZ5CFR+PZLxcy8dFzX2NRWq8cppA+qGFTf1DXtTHYclaEwODRuu3cQ5KwKZ3AFGxRpfcjqEE42KNMpDCti33OUQRBvMIf+2l5wEQBIlloi4MHgHebxryf7+fSd/+Q+ipQeO8pyTlxJGMh6NB2kOKE55HVWt+gCt5t6hUCCvolu9KRiOTjsVIc6oebGO1NSSxb//obLvOe0aUkAXPse4Ra03O04KPPCRnA0+xwuMxp7O9YgPm08MY+vaZeDb7CtfUG2q+DxvBHVVJnG1Hto6a271/Y1tiVlMVm++LMFVeaMSA0LC8hbs=
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