vnGKj7wjSppyZyKN8crZ2VqDt03Hj7NzdLpYTh/Q//hMbAnSntIi8JfAtfP+3GWR0NBUgxZDyrc/HHzNs8awjFH87joJW4qRCVCMkLCO/imXXVfCjMxvom1Vfu5El1IEtlzGlG0VAXPbB+CJ29KQusc2mNS4Ex33+EA41iovFH/e85pu1GhRnE1UTpcolmVjwfkpkyVy+Tmok3cmh+LBwB6iT2QZOSjSPfVLwdh4S5ly1caIb+v+Apc69DdvSDDPf34AQqOCMO7+XzLaXD5P6p6XCJCc9u0KtrGzcWqmTfoQy+XgBxesEezh9Dm9daRxlYOSc6IGEUDxa32JFwvb1bsyliP0wQSQSXME9284lJ2I3AvlNW7PHg1z9/mUD0rvXmmEwJku9fEnEGrqKqCLdOcsAa/2S6XzKvXzaWTvxBvr+J7FF7TteFCu/9wY84eRAxhzavsQ3w3CiwZvQdM6aDFaz9YJ05UDY0vC1yRJpLdGUg/469alumZqICSS9Yf9/AiHaLbiVu4znph28UD7KqV/W38RhAdLQU60NeGcgNKBd6twJ0QKilrdv7pm0k+xh0VD2G+wtStx0W9j8pEO65yGleuLrB11hG1gkTLlYOBAYK/sKAUo/A6jFN634gcAyrNk/RLPn3npzEelpRK2NJfVIK3/Umh8ltpa8EXDB+2lTaJGxnnFTf37jkjGaK7vpVRjOgGB6BG5ym/ptYuqzG5ueyEi9CM5xez+bSpgRyr74vR7rqm+lN1iu6fZmUuYhe5M4VDIpn9+zl9aa9rZN6PwQPo+/09oWUuCYx1MlIC61tZcX8HmY6P1gnOR5sbl7wiir7GMtqi6gPRbh4l9TMvi5vX0iEzPkUbH/KGbDJC89uMYSPkn14LoD96c/aFr8CO1zt4R0/3kealFrtiQKmBb6otol5Y3HOUh5YNNnWOsoy4iAOaWAxQ7s+GCWEZMTfUD9JZdIYTduB+fF4s1XZw4Vc7do/OiZPsGs9Gv4ZtwElkPnEbCfDmCGZP3IzAHlNwyC+AEwTZ+bpO8UibLGpl23Vdn3cY7mhcAYWS+auge/nqlzxgArKK4QmDEda8YxEYHdr5d4FiWeyGXMXfSNVWmSK/GW2UWjd8SBouXZGr6hteO+IcoXfc0fZellQPa9OCB854St3RhRW/FgAJaku9JEQiQSC+MFawgwSXD461y9I4JfZApVBRtutt3d34Je8CujMeauTVWaKkbZPgMSnayV3hDNc+I6pz5Zl6cUtacIvrNPtX6e81OlXmw+CAymD90h9KGN9TY+eh1wKSaJHP3rx7EJaj8PwfLkbmQ6GIDsgp+a65hPHwsFIg33W62ghAToeZzC/z4rxuss0QBjuO7+cy4fLkg1YdpEqE=
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