GRBS6dRnj4dAxOX921+7vgIDHSjcHPZDI386aDjr6vYD2giStdiu1KzoeiXXEujW7FaT/zLLStCOTwOZ1tT0Ht4i09gIQ+dSVkwzY1MJvatkfuvGLgEp9rFQ9qeazw0s5nXd3J0xZBrWqAsAUFdIILOOaaQPjhCb2SwZ9on+sq6AxmXIaRZCKPw+ZtPM+yULlcU2Bxo6hb3HvmBIzwqmCVn6e+p+EHx728NpzJYS4dtw87ALyC0yaonRu+HT1niKRaFcNDQC3ZgOPatMYqMqmfZXm0i1E0Kg5cQ9ogdqHjvO+BdP3EjbQSNC2UajHWkJfndNAMwEsFttos3xjlpW719dfXegiYSUpp7z+APeP3nehN/Q41fJbCyr2AaNdsaIXl8pPnPuH/lmqprACn9p1j5fZLtSahLqlV9s/cuuilyLBkQOnYkylYepOsJQZjbaMQ4xca5DOzSiUldjMu5P4+fjFmh5c/L5OMKvd1t4JdZCXHumeCcpzDeavHiKS4f08Tx9xfnJ0VtUbxGFfhNQhDrmhmuZxb8MVJWbHwsliz2Z8cnKdGHexQO6kGj9ysei7UbWwLs8/MKnumT2yAb5dsHBkl0CHIyI2amnFChUP/hjOAzs9LMq2eI/cDPkP7hAv/BBdfepGaxNIdmy2wf30OHfK6r8HIZeKRYv3Cqf5LWCNZmErei4EJwBbpXtIZBta7mVRXa2hjneYOGpJl7N1CbgnsgR8n8Hg51OnAfP4Y88OacCW/EX4CdyV1g2CDhCbhU13CfkOCQ49fyRojLjZk99Kk3dKiPwBt6ksA/tISGHC1cIBBj7HuzfKIA0VHaFPEchKUXSPFw3wVCCcxl+fXfJwl8IVmtn0FnFw1ybejQWEjeIW7MKIcW4g965iXk3SheD40XpbW9lYavOMPzAfCJH08sMhz+GWcQILMGCa8OScnEUEnG32e6sqIeBpZpUiKPJRpkGroD/FxR3H6w5IEvW5hDiY2aSfD1SKEqfMKNVLNJos1MA2jdlkRe+eHDg8jxbL81h//nzblX0QnHE59SfEvZeWR+pBVrcMevVVIMJYT/kQBBOci0K2qfV63fJRhX8eH7YLn7GfD82TIcdd0wPzcQUI+2ujs74YcGQ0LIp3+rw1CaW+GrmEREXGGoKteClDXm1z+TwI8Q7IdSNdJ8mzfr7rulCdoMAUB3nkTu6itGUckrXSeF9zfXSdjfqBGjrtAaCuI7VE8c1KKPRZJXs9cGT8bmvMRokH6fmcSPA/1pCduLSHoTuF2+zQZtL4vwvBWaiJvj+ZXpecEot8ca/CXVm8PdBDl7QQ1Pdu/hbTbPxgFz5rsAOAon70eiwnrstZ+pB72U23/PM21/RI3GxxJhzMoZvWThVFiY=
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