hBRHnKEr7M3VBw1VZdmr8amlM8zjP1XxeyxzDBjHr1MW3a+pKXJdQzWHn4C9QMm3mjzWHFXjkoVuX15e7GbMiVwdgpmi9zeVL9Wd0DkU8pNy473rSy50/dWEo1QOPhMuw7FQ3ftSnFuhgB6J4BystzHKUPcimdx/IHQnDP4m54QsyHVVq6LU371vWaGnORcA6NI/AiUEmiYCyYOx2446N0vm8S3PgGqaCggGMU5QoI244MPxxoi8It7wFs6BI4wF0CFVTkIuc6StB2K1jStbu5thrtzBB96acSLGQiNlRRZ0ahDzduu91NtBivWXt446UrBvR183XzNZry5tcwriEECmKc0ZDgMi9SxEPlj5Es55EMgwam3iKKRh8KEfKJZhDwgYBUWehOB6ing2CIR3mArFno/HF8bICoLnEd2NT5U6pvIfdJFMfoFndywFvK5rIMGB8sIhWosG/3meJF3JFuxyuRgMszT305DSPsSlVhl7Kx4mjZjL3CINZ8x0T1XwfnnAJZbeT0tOpf6jGD/qgsN5iiLNSteZ+TeIFYYX+K/jF6r/0kNBoMNlrd2TR86dHN+4Iql7WNGplFnViA8yXXqnh1g4HjwGltcjwA49MXPijBkr/aCgizXP5U5WvOrwcAbZ9CqJO/4GguuZ+2kpQuz7bAV1iXTNvssCrKxwHgjo7dhTqL2RxoUwxTX/xCfxo4U07pnQIbfAf1PxCq5Spre94i+Rvbx+TXlkLXh2FEL3o609kyYY5urVfBBi0y3kW02W7nBQCF/YAjOpVdy1tATNJLXEysCHdmaxZRQqREMpV4t4SbZKzHQuee8sudufj58b1I+wRaUl5tujCccpL+tMx+PdQbM5v3B9vtnXtnXBULXAWRC/Gxus0ocb0eF1KCatsOGv2wZSD7bgIAmNvaJbdCaSVMF6qvcZq00UfariWYOWl7WjTtxQxIin/lSnpVKwXk748se8wgRpUxSjDqZyCIG6DF9p7c1R9F4qtuIHm4sBsZi0mDSQya13QvHhvG17H8My3FSAZdKQho8f4sBOwTJpRJ9U+n5flNIj8A3SfF0SEMc0suDO7o7wmIKtjEdIeU6OW6U0QmufxcINIHyRozhFh6ILGvqFYHpRZP6Ws1HexmXsYm68+a7IUEF0C1nJG9Rn/CjONuA2MwK9/i6BnrJoFNdIZcixEx8gaaNnkPpvu3YxUHanr0iOBJF74NOV7qTx0PVNzqN4nGjRE+CyCyL+2KBNQnJkIj652PbY/wTZVZ+DGI19jI+4fIZmdkMUD1roOTw1RMfToi5i+qz9S038EOZsP45K3xpQgOZan5bxjmSYsG2UM9h0lOrWQ4qS0EwpCESfwbJwJLsycCkobBocqtey7bI3x6I=
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