w8znTX3Z1ii8nhoAvmoN+dXCLrZFUK3+5vjrNH5SwI8Oj76wnIlp/WNV5PqND+pxLJFbNnjCiRTs/dT41c637472B1ehigw2gVdrWk1AHCpGUY7iiozyWW0hMm9PeVFUrvJLv9wK7SL+WgOvR375Pcm4mmmS5MSfylhOm396iT9YEasaMRPcy70nj886hyHYeOm2LnUVSbw1OfxXvtsfptE+yqbtbEjTTUZG59OX2Ol8dZ+KJq7xW+hLIPF1PmNh1BpGYjC/zcppohxnlB8UuNyxUJflV4thHhshIdCTVtiGh3AGSw0bPpwsgFvIcl9Tq4P+YSCY+bfe0yEj9hYSOIjCOuKupQ30v1sNIbWVxbt5mu0zTCsCe4QTjY0U3neUHacilcpr+b+IvTZecD/04i9/lfxeQQWlGPYVbvt/T6jjyLG1JvHJxcDC8NDDfP2oyK09jKyB577sJG0r2DAz6eOL/LLBLbdtIZQ1x+W6ON0bq3KcY+BGzlRF8zhbgjsa/oWnD3NKMBwEMKX/fcxG1M6dOFoj8j+pysaTQ/4PqolNKUJ7+siFyP93E5debDHrjpOywFLJwRW+qr5FPDWQqVfs+/yvzD1XvjMLB8rN6K/XUGTBdSUeVeCSR/AfGip9Yz5y7lhH2ASE8Y2N83aSxKfidakkJGi+FXskTxE9w+nLz4ysfb30ok0gnQ4hI+bDUB1jOanyo2LebUEzwgKVOHhPgNn3ykzZGo5tnjNyNvYg1EspcLi4VJLSe/KCIRhpFII/OLFZpilephrM9+jSOiSl97gl/NGUZuBpWCvL2JmYh+OY9tkJHcckCaGeLDT9Lhk3XsbhDUbYQSGHnDzoP8RqBlW3kGWRnnFw6hyvrh4tM7gbShfM62tmnC6/hH09V6X8B2MOa3tXOV32Rdp4syHJChYRQirNTbaoA7bFMBSSo5XBSzr1f11qXy/EruZsTSb8WMZIH8T0nTxQrqUJkySL8MqTC8K0SX4zLn7mtJ2Z/FVQHVUy6SZkkm1CPf7Iu/iSmC7A/9/gCtXeV6tSMKG/BPKQRkTaGkGtq43/J48aLqODr64rlqg/AIxbNpTYxGFiJqKtAL4v4LwAx7oq7QvTlcOzUvmTHJsOpYLg1QCnjssk59Hal+a0utl9FfDsxy58rYvWwIqb1RG7bKQLa1YdCmxkSslLpk+1e0MKNbPMJ6TbLzhFDi0N9CBA0F/Wm6eUCttmviqdW/4BSbiAabaA6enQ9wkGfPRrvVMvGg4ie/TYvMBxFmqCKt3AVZVzAh+EkRpAZcN7avdL+WRcjwo0CrXXMG5gVLGwn4nVtHrbSTNJXwqbXri3p0g4t5o9pWig1TOUc0pEKpgRjhKu0OgA0DKtQgLiIodR76Q=
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