KjaQ8Fxy9Ywk2EvpIJTvHmjSbLWhm5F7XHStJrKc8PQQW35OmdOX0+2FmxHSKbN2FCgbgrii4654n64XKTwrep/oYubvGAbbGQlDIX1OSRL8qvDKetbiU4oceHFwJl3GdBO7pjkZcNnd6nBoJxgKn1WArsATyvF7+XdIial0LOok6V22rWudmKBKhVdYA0iohgjEMQoV4+gZAIaPqIj3Gz7FcyoMS7CU1+dELTUkSXGTpWnKI6IPK9W9gvnQifgx2DU7lapTBtinP3SfK68kwqqMfFkPnkOgNChq+mpyc4YdSXPUO9mrm0JdnpO58eStNKJzk+QpI/G9f1J+aRZpP5wtwDzki7w/U8cSEgBknLjzkXohRJUcXoKYZQ4RFD8Am0pQCLLJz5KnkUXZHuqlCT3n9Kzb21kkKwEPfLuakm8kMRXYSNnnPCrCxdeBo8VRoD7QG4QlcUvrEsoafjVwAGoIym2z2jqvcJKXUncJfT6X9slMGPHBbHZ5RVpYQDtuD6xg6pUojp3apioEeONbLjm3h3Y58idGmZUOQuE1nMVezGB7eGoWngrUuK6ihjXlcPEyJW3kk9H2hFkW09cjA6N66blvgYSaGi92WY3PCwlXo45kV33mqtvuyTX/8Q/4RuRERRPTnReVtezwo0dQpjWuOEMtfSsKB8mjSLPm1A1mElyLTX++oB/zgSfP7H9Whs5BBpxEK3BHMpHUfM72+Xk5EVCPj9RCCukJSMirwpD2EH/3GxJAZwkn5jrLef1rFk7Kx8gnM4GQBBnsuKL94w7WVqvjHuOACSXUO5PybiY6unSASXKjFTJqiPF7kAA6ffKvL8ud7BB+tiYv961ltUqT4VeaqLP6Q5sYvf5ESffd+YuFbRuCKZ6kZ2SqKSq9UDKjL/eIIMVg+92lS1UP+xk8JxkiaakEJgBvtCesMvYgaFK0LS5kwuIJo3QWLoKKGL7/J48udSnr0eCIJnqQxp1vmluzv3lLFExq9zyfNJ+Ao3SRVnHYnXvqeINMe/ZvZELTMsRzLwUolYn8Wd1TW6UGeiwzxxhDFBPIj/mmuh63GPyLvOa1T1Upc3IbKjfITaUQDFzkB5IfyU93zeX8r8ohuoHViyf6Ir0QNbDTDp5NzpMJyE1dC73MudTt6io3H6lS3iUvHE1b3Zh33ZTS1DtDqJOIlG5juxHuWowz2P/XxgapVLRYlLzAaQAS4GAOA8OTD68wPsmoI/9S4nRd003jmajtxUm6MeFn2J430RXjVZ875MHO2hg4j8HZXuyLl9ZC4KOusYuIWt4VlaatPzuW9O5P6DL2L5jTBWx7tcfUAX8poG4LYxSYSe1f/W4wsMavBDdSc+CYUSlWgO1O3kXv33HjraxV3XdmfCk=
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