pmeJZbaGmj6Uz8IUQgaB9x5OBSCIh8Gqarr9Xs92t5s934aSSNUw1mKG9+V9kxX/gyUp6fWzCwL3pecwo3E73vpAjDYOKFlnECFDXce7HYVNBbscKLqcauC1Dgm5RYXagVXziKhUqjP6eWXmshhpavmDUNPmVJXPnJt0ysBOMJ0UFIA3vHvoiEIvn26hWlC3ghGJBIRENDIqXngWZ0ykkXQmdM2gU00fV6U6/OnXc4M192qtJ9rQI+egb7vsYlsYEfAZkSkosAU+lfMe0wkTgEkd2THmuVglyoVMI6sA6pPwJs+zuYpXgNpWJWrPw0ZrEQErYWRavdswY4gAU44CbipyfvKDgD2MtfTwNw5z7Q313QV0PrxteW/JHmWnRSgbKikiEV9AaCvUSsrr4nAzQbyjPflg32Y+Z+vhI82xjIv+/8YZyuY4eaBQU5cbue25ED6GJA8IzpT5qXd77iF2nZxCmX8qXngxsT9D+2IBu/07Vtn+1wPBpeG/8W4nVuPxk9VSWgkDcO2EOY6GiqUqQ7FyU46CevyOmJyEmMypuwS2YjRzYz5eh+eYgyBy3RSGrH2TBqdRjFjo3DIZ5J4BEEdgOeiawIl6WlCk2G+dLKVk0IaJhQCWNo1POB+3M62zHT1qd7FRhQdJTJAz2eLWcFxHw/g+ykxiAy1PQllDN4dNEJ7w1OsvOSxPPHIfGpgPdtgbHhCLezzZ0Wl8da7Gxnv9+xg1v7uE6BCiOp70wYwqqFjdEniXHi4eeihLaQUbgQ5qjQIoG0to8MtGwa1ymHeyu8RmDF8UKNrEZrMaygRKL0jsYXqgX/gpn69nUwiAOeyfPQKxXXvsLBVJkKEWiPT4NlAjkYy5u5dDrowM/8iKeoXUlbYMMGnkVOvwbdmEVp7iu3i3gYaKdKvfE/MUSo2iSxvczrfyNdv7thf4EsiCe1mK5b21z5titVzyv/euM/3ja8v+tMEqn6yM1cVvpLZKkbt4QR+ZGfUbxDVS/Z16jHzpAOMXXlVsb3vQFvYNqtGpovzInZUq2zjGMQ7P0cco/r9PT2F1fJdV+9CEYL393r7cOFbHz7YofvcLIFiwkBtFrs2fJB/E4rx7JHtF7N4FnCLLmEu91+ZGT/MCAi+0i05pW70gcOCQJ9H10rg4pbn591ZjwD/fKMcaecHPH/a+agrrbmTHRnE057ZgTontMq2ZvLc40/T1mMVm093E9pgyJHkk7u5RgkPzXc5/f/Ah2P/p8bZQGz3GAsstb6SgrWrp9pBM1xOTpaEAHVlPEealtiTM0Bs7RiUcreNu1ueQcBmqJ7vV4TRvJYPH9EQ1BMxP4g0QArp0lnhvmNgYmjUTkzY9HSFVHNEMjlyc9+wO/NfuS/qXlCxtaw0=
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