pGys5iymVzGd7EwnR+pYtQNh7yVsKWS7oc7AaI/6s/TBYGu/4fijqixUADykCfI06BgiPVtCMvE9qU6LCLCD5FgyynC4oWcsRMVW+vdAUXQGHS2Rjb2ZFiPYMJ1PwlUQ3Cz86Z1GDz7SzxO0WgdKc+wQc/FMyk36kSbxEXfivzWcQRRp0MIF0UIrVwV1cfA7E1fGHDvHtcwjxyVHAVyJ2d5JkPXNaY4GKCUAc3xyEFlMm/FWtkpKE9bS+J1YDtr7APa5w+U6+gTZ+PoC1Qgyy5eKYSyCQAKmf9a+v7aE2D2GkU6Tqm1+iZVx4NkXi5ESdpGVlc2HLZjkD7B3HkZ3kWGQNHKwBEWStRZ5Xth/XT9cxidqeK5h8NctYlYhiMBme78A9Hni+Lt8/46NeNMCmrrKPqvTeSNmsa+sb3hUiZJJzMGNIbQaquiUZMlpAlRql94CjZqTcD1SWdcxML/rSHjr0QjubOS0w0scTeJeppUfqV5ahyPHOe+CLExQBTUGkdb5Cwk1w2xyWhoGLLXNtM3B3yzitGLdVJW6Uj8iJ1zsN8pIlhfAq2pIGUVrhiQLMHrnGu8oGoSKtbqU+W+T3tgTFBQ6unJUcIvZTiBL+Hb8MRCBIAkL+rVu+brIVeallAYSCjU94VNE+u+flNgEgZKGHV4zqb9pZ789j1YTsmVbo8JOmIRKe2HO6J6NsBr5LBmncAIJEPTy99GG/slu5C7AhcCFotKGoMzKOuVJk2NTqMFtPPPebl+TLu6gNjd80BY6pOZ6k9qhYqlvIO1sT5gcuTx8GxsniizuL79P0/E5cacuacvPwdkG+/hpM4Y3Ji01ko99m+pOec3wYsPQACUytpQ7XMLYLeCU+dqVgxJ3xISKjRP/oN2unkKs8eC5Bx21n3OsBXE6rC+f8Mhj+P9uykKJLjLZZeFjaan3W7+ALMRAPSxcBkynhRLm67+85boyZ8KLvzzWhc+BBxKWxNADqVUsKYLtoPVhSo7tq2XHI/8XLUx8JuDBYswksJyxiABOOo6fkvzy5pFkUM8u4gerSfw/GvXhjhxQOoM01zsXUiJnWM4WvOU5DsvMJ3qgzuTfdrnyvEs43VPIigbLhPXZF+byjwE8emMfty96Wi4CYwG0G3UNqto/sGoUMXP9s76G7WvIp5eQTCvRFNCTB+XjXrR0tjtVdQCQ0kzOndM9F3FJVtsUWfO68ab3YAw31/qQDJ/VE+D1+BmlxuH911CnR5mxTJl59+/pOCDrmxbqZEpqL+WOxSH7XLNipf11w2a8VPq2uC9biESuAstHgiq/1iZbFYKgA3tdw4rYg+jH7ODbNjKGZxmPArI8beeP6sSHO4b+5znrAvmpn6vy26D/7WGVQcNEoX6Pi+I=
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