05NIiOmV9PvAVH6hNpiH1LEEfgUCXLLZQV8JqhNZhOs90G8STag13+Z384C8SGLCIGuoWX6VbZ3jUoKUBbUZiIluLiG041CY1XCXzQXhrKHN6npouozjuPhBrhr6DXWjguQSaQY+GWJa4ZGdm3caTCkAcvflM6X5sf4igsFEA0VJ6DC3qyY6/Ph9DfFIQ4O+kXq4dl8laQJvYvkg7kqHr7THbBeS2IAcs+xPkPp6rJ3sNr1rA0Vk0kdKuRU9AI/SRLWXZKPKZwV4rcXqViO4yDB7p6k9E170T2XX0O2r0sHkCkZsRD7VML/bz7MUNDxjHYmwaF4Ec3I2nJKETZF2l2bRleXXi8agPNoJJIa1clmlgr3+zbsz//pWtkXgVFvrOhLYSSWJHamiuDhaEkS+vXCbOya7aOPNNCcuKD1UUN/jJLDSvNw5crh1BN0o7E3FtemzO5R9bOkeZg4QMdWOUbG2oWAN9pFt0yAoHzkv4c64MLD7udHWF0/drM5jE9Jhs2wTAWxEYWxf/ihBx9qUS0moset6pz63wF9aXzj9smXtvCgA9Y/Hb59xFFB0ZOhZtz/gnY4CiV9JbAh3U5zyRzpLoPZHcFLeRCmND02sisSOQhM/SzItg5cRAe9w1HREpioRdoqgLcZ1tNROzEFFpsHRyYrfdLcdHRs0J/U60Vd535udTB1KrQI3xXnPCW/qsbCx2/HjPYE0BUP6nGYHP8HcawYFbXf2v+XOh1f6LaqS9FGCThSUVVoTOdLh1LEpCDaN5NhnhRgSyh748WK2gpfopV9czdTIeWAF9rCSnvGehOk3Sb2EViw6mRPestxVUzDsIU3PA7sz7znYHIVkYIISFZ4op6K+FBk8VZylnO5SCtAO4C0yjsRg+/YNh1Ap6C3bSwT/+7oI/j/Uze74II31pK998voPNES+/Yd7aC3JMATvx8MICcYGLfF75ojhAUBAepwlN/KihoeiWpvJ5Rug5LhrUk4jmAh2JJKSUcNmH8fYOqsN53a5G9HLaOYjqBlIFBLbBVlk9c2MBfVmbCdpOh63uNuO46Hd+Tl2n9P80PbCFSBpQfgXAYFsAT1agqRXWnWrpNWrqgHdcXICtixu10bb0oczoh4k6DSArmZ3YdxvBYHkNRJbGOIdD4TYC1fqyJuWml4VPzkdhw0Tfd8jrnBzT4knrCWeGDPFMqFVwkNEtQZmsX7GeEBl0lm2QvN+DNtiOTzbLQLXBqBRMzvzd46pjigPyYC9+vSDIGyXrO/x1HMWehevQ6lMJKikAouvSBiOml1m51wHHQZJppYaxVRN87WNly3En8ILuJ13Xca1KnjHuh2ZY0Y2cO8PhAX2LpPEHGyC9pAfwmdmTclJsOjNAjZ30wZyDYs=
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