2nQuPzDwmjsKQJmsl3UwLXmWjOMthwCBVEhXY4b0w8GpQpPo9dapGViPxzl98vNfOoN7q18Dt0rfWAbpcwsoEHMTWHh2wyf1BM7bH8HpvGVauKZT3FwlPgcjfjrZffWtDVqPovo5rKzXaLpzoP00fcPqX1uKd9XO5bzbgSewTAtUqPJoDs1E8hOWgZElmtIETqdBaqQGk/yaaqfgmYbf3GDncGEDzwqa8WkyyQeKG5sG3EiYf2OSnxuVPoHL9LYL3aafFEfdZbawL23R0Y7KCjb36nqffW1pCohOO/MwSPheABDFwy4L6SdHq7PLffZE0b4I8modK8SuY/w4ggZ73uqY8owUTX7UOO7VDQTdT0tLZkW0IKPx9u+pIzO4Yh2TXLdWlAi9CntvMMAu8xAt6hu2u59w4fnTFwl0AEItQ1+36j3giX467jEC7Ct9F4sXc2TSPfJBIFAcCAk8Ue1ce/5DunZF9r8+Lr7SHBk1F8QrtreNKV3c0qaN/BcN+MAxjbnb1vHSjXzZNO8znm9sHLZxO6/QS/9DTYpeJ0AN+iKFO/suYrngf/zW9rxqOoKLhPy8AZwEcEDzssXZNQXITjhubzfOWFf9mQvw2rqv0xY4fiK8hk54RzW9XNK4pl6LtuYKEEXGiENqvACHtH4j3R/8AZHEJj56w7dSYxb+4kXp/bSkBCuO16Zp0WocS3eZ1DsPRvZRE0xndhyCWJce1ddtDlKgDkala0p44g0muuhgoAqb876gm1BzDP/Tu3O2t247n77UBM323OlnIUz7YNAhqwUi0jHk15e+5skkM1ZatZIPBbVlQtDlxviM/YnnQkdg3VHWOxdkAXfbzI+f2HHm4QQzzC5GuY3p92GablQqN3gAa1+XhCHsfC6xu2E3lPFNbrAUtP1+Sxmnsd9qhnuOha2wntk3cX35LT8eVx3/lxQtg01L2xWenMcZe39EiqY8RM0ZomAcFM3izGGD+z5ZpWnadR7DCgPTr2ozOjYnoCpUmGF5zKwWHW+p1GuIQjUJeDgUYf9OC6k7mn1eCLIhokjA0TNr34pZmmgAX6wzaLrdiAoh77ZfVTuDs2YcuNxjCAvOPgJXlToNSIGGusJ0yOI2/yYRHItnncgcR4txLxV92P6OzWy6P9Zw68pIK+AW89R2rZTiGh3soTIMfMPl6HlvCTBDqDWVvbWM95uyyov7Ma3HM5ZYCfY10MLHDJWIvsY+y7Ocx9ehFq9FNhIn6kvUt2/Z54fd4ooB6LZZfCwrqc1v2xsbTOdMejU4Yxf/UfgSSh/oWvIHnPxIXWwg9lMJaCGKxfvtA7ZJqf5JY8Q1IoYGBEMSpdmH6qljjkDex/nHVhLjyTnQrxCWUdWVE0pTILXOpQHWJ6M=
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