czO4eGNoi2aClI21OJOmNYxvG5qVXxCICkp4bI0Gra/DwKRUYt/+/g7SUuHTarZJJfcG8/dwySt8c97OXCJ6pCm7GHmcnHGzVmgDfz0r5N6RLGb+OdK4gTcIJrL7pu3GHM1NlPn74lPuGYRJ935HYi05Bc1X+Ls8WeI1qZfqG3vCNBw/A0noEgHiLayyNhvGBmGEVjIuBi9qNDS6lsgnU+d8g2IraM+fJEaxKgHnj1TNiQzUTRSMIe3QBrvQfG9IbJyqw8KJo8uCzYHkkOoxYtCavILXvZImDJjTbASkX5jBft4SBdQDfDzxWMfywL0g0dfrytoRMx3ids1iljFYE/lJNyz+C7TjrqW0i3lNBNDnihJIvB8cmWhI6iI0rC6DBVD8BVGYqykhvfWDFs+0m/X1jyLXbR35RMj8CCMQDZAmcpuYSPVkMCtuaP4IRLRStf6PAGBQq9MrJpaFyfLuC8AAvYak7Nia07LTMOMIZiVxmi36Genbx2Rue0N7ViYruYOkbZZjOeUzu9UHiDuSlomOFsx0UMzzgm/8zozMlXYPlESrB1s/+sKS/MNFZYlA8ENAGJay8aPnUOtd4yKG9E3dGRLgk5c+4hBkmdeckUD9h9DAnPgIgxgpjkpUTZwsY5ty304B3JdeumSc2GTM6AQ7WTkh8Q4+rTrHI5sr2JrSzbkYEBY8qdYfOoOBGlOVdzXmVhbo42OT/AKMBV3gXmIoAPWP9EUrgcSaJRSh0nU58Jty9iDCrs0YsV5+bAHwlGD4BkNyLwaX8kWmFAeeKwiTYzXtrBpbq8vHMvVMGuXg618c8X85YUNHf66BYFfXp+82f2yI74vDRvgUf+/sxQh2CPwqqKGUfsA66XpVup5CDrEQypAblctuy/qyrv4kw1KlkSIZqHrx3vef6GKnXGclC8tlfqaHhWJPdkUHWHVt/CS+ozEpg3q3SzZr6KogApuRG7hed79ehMoh/u3LjDHg68/PIouUPl/UUiBivI7xe4gGUH5pDqDxs9PNjQk8UJoEjLVHkB52NeRuxiGg7CUmNA9fZRAEbDoBHPMHKif9ankVCy78F1lRNihYjCn1qI61NJgqJYOpxnTj3JBqUy9c4myOk86cDqVRAah0rRfzEYPeP3G6WRhezYG0lUnYlmQS8PKGewpFhZU/LHwEWwjfgFK/HAB3c4Mg/SNhwTYnndua/7wTyjtqjWjic0hYATfiHawl3yj9CNAlIkygEazc+MmvaT+N+3+c1evIbwiG3zeP4kXn3B10SCHTP4aEbnGfN5AhvC0zOa1tQDFvNrnkhC36um8Gwe5FIvkywouXUVjakYWZ/kYLQ1A/rHpO5sQuihFxaY1h/huhs1J0nFXvL+/9AfDAQUxS9es=
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