qqO8p33usb9kzrJ8gO6AyXIOpEnyTL4gaZV+uewMbbKQAQUcIDPjRao4iAP6Gflaqp42trYmZhsxVQVKNMSBPvh+0z8sPqbc5xO/Hkayh9KQRuEU9H7+Jz78IbTUI60F4ywR7zKK77neIjG8rwnct7rEWf2fpjwhiaAzYU/RwSQfyIldoMhVIKCU4p0AEvVUe3k0CciqpHT6UVPOTiu8MTMVVeXM7sW0dR8lKjAag+viYrsu5Tr7cvfoDPu4gPDkxImVmB88M74iH4AkNdDkLztf0qUfogCuiSKyp9D4uDenW/wBANtzdZLdrLxu/u9e72P0P0D7/GyQkKV7DW3TLRt4T8xq1fYVtvCCWO7vSSQofOLJbVJO6UCS/jbnfcA3jS/l9KfCcFOmS8sNFZ73tUtto8nQcLq4AOYwmr0W0dMXra7+tLRYNpWBc1YFB7QoRQ35E72PZDCAPMi6yXe9aGgff3EL6gCqAao8EyTFi7rOPjVaxq62zVolisgtC4yHZE6am36g1Bbra/kLw6W6559Dk3P/G5BTqD7KnEKBqtmNfjOi2gsRmTP/nJsv6a8mDKdSaJotOowyOvWT8mjL8nHd/TMGCW3rZAJ/nTta1iLSIuuKB3wGM4jCqD5cs7dhmHeWtB1OZgrbSw87MRvnT4YRQX+Of/cbp7cU4ZMg1oxXyYX/lGZXOheVQhnbVdCikKFyvZJ6bQFvcZeh0W3axcFvObSd99poZmFtKxDvCqJaCzk7P7qYPxk8Fm8X9IxgR3o5kCL2F0EQGH8Kn9Ilj3Ao42iJMtzCdFlLF/iXYU++eL6ADZ+sPnt2UK17Yz/YRW/AZbZgvJSO6hC7CaE5K4697qUxM5rto0R7Ewd1CjcphBQQt7rzyk0UicL85spmKL7/zNfJqbbriqHDmu9nhAH/xjY7KmW6mkAa6pIK073z2u40PLV5itEMiaf2h7lLebx7bbdzr/KMR/IgKrtIP/ykMsihAdeH4OINMBMbkl3RgMCcsSgrv3xupl7MCUMcFNWnNk0+Bu7wFh8vhEjnLV6SbftbiKeYdBJSxWPDRIIASYLEW46CwCYiXDEzK1WgPzrqzX2NVgZXQt4j2hmGHikHrTdMtWCB10knte0ejK6NXywiynahl857dtBfyRy6lF0YVy87XQeZJTVSjzggC1iyK2rmsfzswqJQEMoOdlnlLCUpX9ftkkR6D4CglolEsrqcCG6X/+mNJWXx0Aihx2k6q1FFmVPod20I2Rkr6jt/C0QkmyWwtRhKt0PS6x6Ft2WhqR20uHb5Zb74X5CQe27uUj5aqio5d033I/s/OYV3C+7CyrCOqR7RIhjc7rSxHYmpxlTNUNJE8i8YkoDgLVzOiqJsf2Qc06R0kw8=
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