Q02iDu8iC+RAvnRvJDZX8GmBPmj3UuggYmBz+rKFc4Ga9pI5SQ8Mheqry2g/vIdWE5c6GXfG99RvzIXT95Z2J5SBV5cYtoS+e6C/lwPXbd8y9AkP2IqKjBUoNuKzBOlic21zhbMhx0WE2HsnhUpdNst24TXrtzoCmFNoxwo3jRNWs5p3lG2zFE85ejIqdo4Nkl0ChB81ZpRcfBHFSsKZUg47wG2fZzv0hsTQsVw5qI3tf76Q5sPgweNO9j6wBQ1mUdkY/5o4Ag/hTawshjIoffXeQ/Fu1PeYIYYWz1q3fXss++L0UbGEgwtIrT8VTMM1qqUqkE066Ybe1dcZjmbfKzojyD8AjPjwvFEzZ2CWTVLl7FZc5Fkzk1krjurOT54iz/Y77Q2XxXeT0WDSUhyFr8sLS0erePCXm5fp3j4crmhjXCKLeMryY0lcTSq1YVdUDYpUcCaqbLNp9tuusTjtt0ZVIiRIz0v/bLQhNcixRBFrqSdXWEoGG8c4AS3NlIC7BQ1C5bbYYbzguoTQCtG/ldmzcg6EIYApZIw0u+aki4bKaNlldLnCBdVDio+O/3jbcFbucf0ju9rT3/IhLio17zKb974I7tRPEd9je5UQw1d566aQvb1sZLeqNswuU/k1AGt+YYLMeLv8kRuPi4Nt4P8wOEjamR4n/HLoP7s2nZcOkxYAko7k7/Q7m6nfl7LgNss4C5m4YcPZ0+6aipaw8wCqw6pqFjNDJID9P6P7QvXWlvCeE72fB9NADj+pppaV367NupZHoxYp3KdOzNs73uJ40UuLUbbSjuQFsNic3BfSQ5qoDYKILqMX8QPt+IDCYLkiN3Ezvt3xwmFv0UXVNPAeo/TJhjvWb7Tzo/kH4zd5+7Zr2BFYLPq+Lej/VB69no0UV3pDPnHNZtAQwagA2myIf6MadrVbz2zJdZ1BTSL/frPfmxdnoU3bqQXb04aDuVt7s6bYoHEWcZUOZO7PrQLedtm3LSX/7Rv6D56VNgJeDOJkK2ws/R1rhNb6H5f2ii7TIPRO/LvtMTEut/+srBwD7q82Nzk7qKFzjmNM9G/5PexrmM5yHT3ICbeb2S41PiDo7IPT6gDHZ69ZXVdIHpfifgyGg0DicMUsjmz3txAaBGZTAHiRZmGS078YzhcJfwTrPk3WpBxxesK0rNM1oD8/fpnWzwVVYSU1JZlIaegGlB+K3jZXYz4+cRHhIyIxxVUeNC+cR/xQKqQiQEnSLF/6Ux5KSio5xTwLkPG2Ldw3ge9hg32pS3Fs7iLOyjO3SZzU2BWGIU2Tra0/HYO+4cw//NTRuKG+ZcSIDiG0N8un4LOzSMay4bhHsekubcIEkO7wa/S+9F4BQrH2j/AR7F0WPf8dEwGzyjrH/Fc=
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