cPm2w016MBSZ9PefRiQbwv+yQMeHObB71T2AKZeMOqW3ZNMigE5FPmWWQq/dWjga6EE1K16nfBulxcUX/qMr5EvyZ+1LIcg30o1e46L3UeHKRWR+1B4CLz6ap5URNU0Fj36fEfNQCkCmFFbUUgcp134NmeOOdGvrrqXeJnCfsFmSWwSWZScpw80ecGefITz3PCtpAZIF3yI7hqkJnzfd4O6l3Bqqez/aF05W8OJZRdSXCkAA1sVCL5jVu54Vg3Nd0bzJdrtJcjCo7BegxPWq1WLRZ0bA/h3QYmedtcUkOPZRss38Q3SAmQtZD9uO5GvziCS0+4tzGD5WOrhL+Zv83qKh06cHB13nVc+M6vssxc//i6sebkS7EzKuVWItoMibzIqLDKkvmuJfeSj4IzIA9i+ZiqMyVGJBMR83iX34CIS1WzvMVpIRcTGJq4ijPKe/6W+ujhtVh2iiAE2IYNB2kvgOJ77SI4T/Dyd18VboXa5lx3NACkcN/rZQItqmcS83w2CYDaqYXdhf3wYdkaKhIt4MjsHaCp1yhlXdIWWi5WQHYv6nvoQOdT8ImDDtHwXLt2F1N7+tWewjmn76YePu/iRDfjy6JC1coj4wB2kQoeHSwFm8IZHlmNcAcKBL5jcXn8D+59JxsBkP4JCNZF9ApIMfMST1VI30WHuo3wjHJTckg2tApHGAoxU/4x7xuXoMHqqqpuuCbOkGDFAqTc52K8JCvSFDNdVjqqyAZYAHX3qrFA7a7fON3iXtqqArqrdxb2O9Lz2+WqnW90udQIJBp1uMhlsKIo1cxiXsRMNfmKH+yhYw5NHPFO1dupk9vZHZ02zvZxBfg9twIxzVSzFKV888MIgtPorCNUHq+imtR9BZ0qgXmSYoB8cRjQevpSVyXIZ7hCf5N3F/OiHJuNK26Ow0YUP/j/NvCWzIS7gIk3ZsyeUFpCclLBbZ6gyIqgwP+2PQTWFOrMzpegJmi6DUlvzM7AZJfOHcVo4aP8zFNbVk9NvpNEWsvDRQM1K6CGLVmGtWAH9HveI6LDr9lhYB0m73KDlRO50sNFY0VbdWhpFZeJq/H2ceMQ6yYDEUhRPxU2wkYYTRp7XA45Of56BbSQDI/5pUzb5IbNG32XWnw3llw5nrtVnHuyw/VGywEjy9f7+idELPEOeFs1bBv1Xsteo8dJp1WJA9RX/+AOEiPigP5vgrrSX7jCDSmfBlmLdsXLI2ovCwL+4WpHANU7VTbLLjOtoZ5BnKOcV6qlPGDVHwZeJqzOxil/yP7D4dUM7LzEWRZItL+wHyGYWMKTb+NEfXKQ9LCJ6UG5z0wy0aEZOs0TvtU1+klwrz/J3+Uaad0fGmuxZPbsc9EcblNOBYjyarvaB7IVS3VS3zTT4=
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