LrT7iNQlAui2RMkhAN7HghEBxQwx9Porfgulw9xkvRC7ZqbZ68zrjIiA8GjO9NokSdEa7fDEx8x2O011FRApJXFQjzf0107yBmTUPjYdUYBtUzvofB8ubxc35DuFuCZLfXQxeJZ4ZBR1E5OLCbZZj/ESnHs+jC+z7qki4JWvrJKcom2n+YdFio2+yr4eFCc5GXW3lrd7O+aFjY+AJZqr5pdOp4wLnLqqcdWAhBdfHfzXRdKLJQWQJXGgGlX8F4bGvPyyXzKVxzkQKhVyZpkJiekYEeG2npYF+HDPhQjZQOyEE8dnOo3MktV7sO/1ANd20tYQTV6IcLppxanx2Xmxvsv/QVkuFi9kqz4+CQfKN0KaSnr98/DtkUSag7xSxBzhAdOO9w5TVqMTOGzC347ojRE6BHgYRd1ZizfLYF246b1kKknrhgGUa9xgel35lTFsbBBmhDwaEHEuw/Ku2pnDgCDp9rzWJqeLgPtTDguYX2PWSxkPsk5LEbNhpxkhDs5kKriv1DurlNSmRu/NhnJCcj1MKRtaNpZVoTrgINGbiKLpZqiYiV/Vgx02Sl/0JftPxrkiGSJr8trHBVojnn5kw1XveK0dTWDMI54rVIH4NyPBP52KbGzJgwrJ0gk86N1y1OFKzzK5+uuhnAmMCkGM5dnac47xUPWJB/aY0r8ZrkRQZPsCJvbo75TKm7+knka6kVXdYWNVBePuZdfg6Cozem7I4FS+7KmAgkc2rZ2lHObK8mSee0gf7hpzBFCbGV0UkNKm912nEryvDyNZvQbV0jqrxsAdrP6sEnY7Z2sqFGev3fsm9YbzNRJq6tNjWHifGmx5JlwX7AcywvxN+a/TSaZT7ZNmzGtJW3ICLDFSeyHU3YUymIrFpXUED9BSozJCve1bFIjovJt8vqXSwPDy2QYMhxleq1kW1mXDMpQ+XeZSX+nYVE8p5HBlpHiVCXkUxSQDD9ge34Q7LID/5hWLUxqPqeorq2ezaQBNtSju4+xIhMWCWeoQwrlk6fdGq08vkkGGaNPYWO/0c6SZ0qYlZjpGpgdA1kHPtTvUrH1NS+nf15KrubVFumD6bmfzgRnAcK93WCg3MbcppqQAZejIWA7juDNtE8d87rAztjPUNWxYldIMGdvH2WESk6L3Yj1M+FiKTkoWS1g2irT/8cn4OJ8cy7XWBYm3RfB6dgo/MdFzm3sr1YCINXAPPbIkFUBbNvX+nVimH9fOldDV/oPMCarGEqzQzrrPlCfCzfy6403m1ctJKV/4xysODTAVxyIjHGSB+ltxYBPFARQzK7RLpfEL6mRgDd7hk7O1zLcwZ38eHxOVxEx5vZDRYrX2XYGggRgjwD3RFB8FzYEL7NUOHzwH9wljBhun1BUiREo=
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