qh+IfnkW8XE1zAWydoQ5bsDLTmURXn0IZDhlBdXh4fbUzmhWLHM70WYPYDkhtTEg+269HAXQwYqNDxuu5k3ajAXO9iDWrmPz/DLAzD3R8PoYLdg17bcSA6+BzZInIyvLfkw7VA+CJa5BP2stlj5tCfQwEgR4MslhUSE45AlUio72qtUkgQ75PoGo5VilQmL8jKQ3panwWsfM8URRhtopZI9jvnKUCQZddn0qB1TMXcOlCEMaU2DRIW9G1hxnfDUqEduUJzlfIt6gvxCTQOnNApw03faESf8/TCOqV3ANDRxA5x/Gzej/tNHfHXQEAxUWcjvONmX5Vkul1wNxcKAinwz8VzkxJplFk2DWPDoTJl3RXMhE4C/xLttSH8lR2dTnEWMnqpEmzw7FZr9wcmqVNYWPMva87YrZnGRz99U1BWHnnxd/jSDhjE+Mkv9XEWBdUZZMX9mITV5QFFBwbl+N3sokntrhr4kGv/9l11vyg9IQK56h+XdfBv2HgxYRXWXLkLim2lZuDd5Sd4oeMyNixfuVdaMiClRFL0ZVtF8p2qjh7RM5R7NN1jEkwyLHTcHzTjdBL+bPOIkcRCZdSNM6lJszcDVmVN3DHr96KxmiFLS4a+r5LdaWotWnDxExRq74W5Kt5COakupK4IgCHLwgVkPrknRnrUn0CFP1DVw18meOkcu1ILKzVNF0nfSQT9IA4y6XLuRcKnVOfaU/14qgLG0w77Hee+S+on+S0meYcw5TMFhJB8oJKCyDgP00JBzAHC1kZbJ0+YxnARREEgOeKYXQa2ElC4fBaeZcJiVGLzWcs5ZDQT3AY/tO+plnQ3Empfx810y65PYFnhs8Mqj9J4dZrJndJ13mGErtWOefNAaa5KkjXxCLuTVo9rWqE6Kx/HA6ePN5+vgB08JlSUGKKVP+TlIHOmVB0g64h/X0k6ZTI5PmIui7S+/2O/lyD4ORrX8prVarC9/mvAsoKBDd0EKuaL55bcPC1jZpHhRtD6yliuAWOlfmeKBfBS84HV12ZUv7VWEgsNCnEfl61mnT6QpCLbttQjqradKpaK2WwMICkoiPTYQGjBcE7Bfd1duzaDqwTDAwnKeAOSV5HKexVAwrg0C5NwOgpKxy8Iw05NAcVU4hUnyX8lfgjpwZOQgVr6cpY2Emo/9WzTR8AsWHuR+5B72va8EtVtJuDJOh4JkYj8H50q03q9TGSFY+3j8szQHvj1K6Rh7c87jCH4iD+lnyx1wkBV4wuRzSZVOavsT+7PbCZmlG7gyU5gBWRK8V1s4sJnyxYuWiaThEkbg/5rYNSpIMHmUn0MKKU4pejdvPCsVj8TXNdb2+DaBNJE+bDNUp8nOtcfQOquv1m7RTKtJnO+8mRgOlBCOt7bM=
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