V3qJhXYiUqv/+pCOIzZyugm2/BQu3bJ5auBVC3xLTYn5uBT278bJkYeRzaC16bNn1hriXk05vmIrJ4DrKq2Ra+rjf2oqsv88DEPFfVTfwhOIEDXBK6MUPkygki1cH3xqqskhIz/AgSHp3EFRe3m9GQDer4fQl8JrxCh4ZOwS27UVrxDaizpSHdhcGQ1Sr7pbOATGapqpwtGH4rZqIGIKTAwwHibfaJq9CtHQCaOJFmSzT/hdDa1dmNDpGykt2uKh+/50K0zOQsCX974TGRoduCmikGeTmTumaW2cHl0K468otE8SXzmAEtl37N8xnZ8eB+ycin3E0SttVyZVov3LqUcc/0E/U/UBsAyXS4WUbf9QSIRmR42PMsMRSBi8ZosmjePxYQhqu1tlNkuq80lMjaqhpjWLX3YU0qc90D1SIImWHiYjshI+dCaE3FYOeRIV1/qkl49yfSNpbFIVLe2lqBASO4lJoOdHkAMAG/80BmLbEiYrwzekYo3ajKCbmyxVNcC+3P8hvrO3rs2H628WkzmF5IrYIdOwTag4scar+OSYOrSsQy+MvUN0MG68FbUmpHZ6gk7m1S9bIuQkBDAQiTEq3Y/FA4gLW7+405PxkHXGKytYsTiSwAM8TnpwkIJwi69Nq7LPXi84Unf6l6x14gqoo898QhG3le2nUb2h1QiP+un+x6Cyij/++dl5J5QCaCDZg0Rv/St4J7N97RT0k2jvm01q9WA5nFYfaiYZArxA5P2nfxIOomMI3Okhu+vySO2re8sB+ET1y2pPOBEdSNV7moZ8q/mXm2e0u10oigMn9ozYqCIFXWl7SzIafzSSJ7i/1b3Oj3kQlkElGK+lxFlonzle0YOygtmr3b1QJL9QjNwyTiqrUK9XKvR6QYzwpMZxoNzYRncGmYZMU9CNH13MoPlE+nAJ+iAfwdjNLIVFTSnPD91Y6Tkq9+zSbw1sFpK3ny6afo4ecN3q+UabOorBtBCXpLYZxblxmHul/ZGPiwuSsnu7DMbb1Xr1LwlLfldiiQjDgGnEoqmrIc8AYan/gDBSoXIGVI7MHEx3ngfE3Sy/S6aY6XsPrrdYsrn8n7oxKXQnXZ+qkRHFKvut0knG9DIQbllvQXjmBRgfX3WMEzaNnFZLu4BJnDrQwG4fonqEmqayFv9kFqNln+tZpKV7uQTiQdQ79bhFImRv6psRLNc6boOfvMpg0dTdctu7MRy5lBu++PWRqZHzLo6G/YlUxKLb/K7/idrnBkKlwONJRZ05VrpLPAVUPyosLCtfWXd8FKS70pg7I0NBP2isF4NT06o9IFUXbwNjCxESWBr5UFExktYTZXZbJT9/4+4UXBctvfEFQzfZ9N9HLghHXseCh2wJO4py9cn7ZjI=
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