AvBqYYdDRRVgCLdxfLPxNTxEvEQqkGdB5+zRLOTrMqtGo7/B/VOdZ4Z2wwp78fJkeoDhqudnQTJBbRvbhSsWDopvgrquPC1cILefdRDcsvB6hIrPhcSmqDS1cJF2rFTiccrx8X1REfugp8b2DNX4WY/yiN3zXaBLfR9aDXaPMb9Z+mUAyKxEMB8voQUhuOQ4HvfLsF82c/DuwEqIE1nZM3YFgmMF54fosggMO6w1gRQQFB9udvnPQn4C9QihxZUfkF5tt9hwE6wxlYV0ZZNTiAWuFLfHH5VD7quahRgvlAlU5cg/zyYz0mcEqeaA3FdLDPRSWsZOOHs8JxGlvms8FwYuogXVXjERmpwnNXWBrVKMh4AwK4nqRe6EwbXw1KPbW911/VXPUb9sXS6EqPYtbuzG5uIEY6qmwJW0xVoXzWr9A37mwBU52RVrlB+cqAJRfc5EaXUGC1X3LirblihIIpX2scXCnY8j9QqM/uQQtUp+NzgBW2VzMXPT94EN2irx/8wRXBG8UCExjKQv1+alWrI1QZ6Rr5v8uWqLVLNT16yBjOE5Nvh9crJZXtkAl5WeprhIsrXooQlBDRSNwHpbBQ0qO9jYEpZV86gWIgQimKT3NVpZJEJSHnVInK1myySjdnq7s4hoiHGr/grj5xXY4ROhSewZpzmnxvw9UIifMgJ/44TafoGvNYQmKTLhfikklexWJmZAE/8b0WxgJTgAehqhZXCFs/GXa9NpwO/cSoVS8i1z0qIGvY3gbLYFLlYBC9In6I+AuRO/w79ryjtIKhAuFTnVDDXBTCdgggxGo8obkMmsbozb41bgQUbWiEN5lOv2JULyB37Ztg63sTTGbNoDZqVruGto/x5Oc9T14c6rhbjOZcX4K0IWJoR+GUHzoaVLeCwqzS+th01a8bdShnPCegyFms3rSLuqFeTVYZQRYszfvV6Iw/Z4pv4hujLQGPZzONc6SA6623r++QoiVizdjhoWITHyZ/2eZBMAN2xmUvKew7xjHGcvOd2qNk09Y/jn2RuBAoQ7/MSnbg6fXHXFV+8kL6s9qwvvwn/GWhJzLjH/o8A1in3j7DDLO/aWMCFEDhRmKt3SxXLJC8ppjqGMMRVPmnlUL7hHvFKEG20yw+Et3SZyhICBFHAZexZtVDpCfunttDmjQ7jeEkYpm+2CG7eos1Mk6lOAjtbNacJSg/aPnYG4avjDSPz8IaOFXBo230lQc2Qw+XAjlQ5ZR/GqyBvDMWAVZKO3RXjgkC2rr8KusEzVPwXOjefiCYMKZmb06RBN4nn7VbVJnZ1a+O94ouSuskl6TTjr/7uuF4dunmIZQnDmTWI4VHhdrmsm763WjsNnJ04ahCLAoX/Hngx+qlw6ZCLjuss+UJs=
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