eHpGrTg6NfW61ltXzQGyGFQP8eHtmu//6AJFwp6qtCXLL68Rp22bpmQe6H7PK7hBl3nJ+9OGqayxw7zBm08Y7Yn+4ClHLnPkHUAYiI+WakgLUFa1ps5VHrhtsDMuVbPv6DiUyCl9QMpLSMubQop8iwuBERWHIGAaR/cojvcP3uZa9Qg2qF5yeAehlYaLTC/05WJ3yG7pqP2IaaM+irOBa1zO/HNimBx8JaS2Z0m7/a/yIxV2dBwQwAacpnf9JywfEt50z/Ki2vCu7X14OR5+/jTPMnpviVosgKTLw3hoRSdvPsxuTAYtWEnZNsCSR28btH0wHlt8YADsF85ogzJlHTKTcY63lFMt6UQAaCzp/GX13VU0sJnhYUjYxSoNqukwdbXaBBqXVTSzsZ5XWiD+ImM9bH6p8luw+kfEIjNpDlDU65Ne2mmqEPon91l8P3+j8PhSaYrTDkIoLVMQUXYx3gPh4YApa4oLWlY2NbWKlcdZsfh04RGN82jqvCfyvu/EG6cXK4YU5YZyaE3BwZQKX+W8UbLilwgac41vyCWPsKFfviwgKo4wo3NNyEiQGuNNd116AzvFa4+5GXmw3Hkdiz61wKw629q2eM95hQNLtNuLKaduN8IEWkjZ15o8aKZFpv31jRlrzh7MHu0Ui/6yw8kwpp0etbA+PIQx/T7NCP4ECpQMhUwBsagaCGQoLFfru8bwh0iM7Di3ZIOrJ0AuzZ8XwWbr140gqeQVnMEJj9Ir63TGIsA9Is21Sf+PpEKPVGqekjVfKdvcNVumdbt3zG9HTAxDWAT/2mjFu82q6fd00VmZHpBnv0Nk//x9pqkWuQO8RQdQz0gH1vsI2rwY6+nQNDiDeEf1UziuxNg2r6NTWnm70rDd34ue+HPIG9YfIrygOh3JJwgq2CbFPswp6tK8t8q076sSlcJH9gQCZnHvNd+AzA8TUMZdHCm30kBZDRIq/9cUXlWRH+mEu3kqFCsD1RvD9dXCOC8UEOnnHdqscDifVTk8j6z4XAeVHkd4jreG3W6BQwz3NOXh8nZX72IXtF+atvRYsbDZCikE/wR3dOMPO7rWVvXCCxfXFANf6+hdh+2HidPUJeaEp4gF4bYUyhqC/wRNmHMI+FOJcbMRvNwX086LAckXu9kusd4HxcldfWZQsKKoZPG5B+XbKgjlWYgxOraiDWe7R9Lcd0oyEHve1ZajVSybAF6dTGfMaCT6PhK8cdiYajmOmxJ18sWgezJa50tCyhmaJvGkzC0k0DY8vDplu6N3a5/s0c2o5lZ5rcrJB+sdBaOfWHUR8jhg2DYQ14upt06IQ7wv+wZKNFSPXhzzg6E0ZjdsRUX9EhVMA0NrNxtNypioxQT7EGC2YfRHLJgjFCPOscM=
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