WMao6FGri3lhQz2iGvAbJdnuMSmq1i4INovSqmXHXRHVYaIUqF2JJvk/OJ+sORwof3Me+nAQng1Q5U6xlU1cVBYPs8LnGzd2ndeWAMiQjHUjMVueJjfNYDntYtZOMe3hHnLOOQbLA/t4OC8/hUpquj+TjCIUipYKwTNAmwcKr27sy0D1E+HMm7KNkbh1kH9gVTf6dAhM0zvgpo1j01bdzmaTS3TYcqHrHuOedf0wJl7UWrPfvQugFOhFb52iMPZvEEKgffrHsELZDb+APUJZf4OQ//IXn2CDhVyiqHk8itWhNVO/TWWQpwfgzcQ9aBd6vMT5qxXohGDW1gJDqEsRbsGovgrcriP0x0jenw3z/Gq7LFATpyyZBsTvSl8VpCbCxXbuKG1EU6is5kGsljHXYh4h2m22DvGr8SFbmShi7Pd9/mBwJPgovEc2lf3hj0nCBowrpyEL0vC0ICjacD6rq4T7mL8MFDf237yQ0EN1oKcoDv1Sr/XNQn5KIDyKWnD2s07w/OC9R+9unD0H6qNUR4P4sk+dR5Lm4/+oKO4lGj+ve1rF3YaCsvolnVewsZ7icDaaVgMzA/84Uk02VFtFHy8Nyk7WQMIPofKIKxZRbKLwoC/wQfkFGAZjFPRXmcNBM1nShJe9G0JKl5AqweWl+n6Mg+gyBYUPVdPIifKTa1WdkCciuZ+Av68aui0S0XnmlzTyccGNi+/Y6O8DI6d3k3ZeekHn7lSvLH017uJK5FwoMgRv7Kq/Xo8v481ea04h0/mnqX2BhLkfkkqbeYC2fzpeaAzrDv0QnEKczwa48TPqoL+AKjllI3j4Zi/eXEeSb6RLNpxTfoxQtt2m96Wp6N850D6ZbL10r4o5uVs9n3Umh23oIfK7lgSntkBDnySXt7GoT6a4P7Grpb0IUm4M78UNIZ5tiUD2dBI5T3JPlwu901PzTSmxgkU1X18qY+O2eUpmOpe3DfhaEyhCmksfBBnTs0nTYlTEh9XHbO5ozP5ScOjlMNv6xjC2zyvvPh/6fAxBCPSnyPPkPzJkMa8yvdzhNGtY0ClLNwAnZdmdXSz6nNw/op6lczi0fPqpW7tDUo2kcdGPbL3N1s33Y7gDfWf5oyJRWt89Pw9pwnEjHOmd7+VJr1CjjFiRitPbytPzsKgjDPvEO+6hthY0JeoJdkmL43jc+7ngU8kvQsM7sntmzMOmBhlMqwpsjifo0IvwA5yfcTBEhA+0eP9kGSQkRLIM4jRnqx8v82yQG3VqjUoFuP4txL8/UPfREluGZ+o7H4zMMrwGT+DPRhFY/mCJd5XFzY/GkNthbTz4Rq5b3GAnoSaYzB22ok1mr/mwYZ+47V6e4011pRXFUAx1aSTu0OpspwOxILu7uYAOxKQ=
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