/P238OGnhvfoYt2PH+MI+4i/cVrfhjaixS4zsmjmLcWDPjwmXoEfAtxVDjouoAId5SdziHjrZP918dFitZyzl8md+8GK2v2kcI2qxbocAwOeELONj9yLSbISWVQxgYJIML5f0FN8fpEsqDk1sKPbhdSKb0FDfRFcSDIpQMWmE9bWALdi156vQAZCwWpV94wVsuq5zCsFfHUSdJjx0D9FHW8n1C6Evrwa4WNgHSz08vBqBfMfm+zf8VkyqTqKssfzvuGGPNXUU83u11klC984In5IvnRoBPL55PA+Viv+HFqdYZmYj8+HgyWBf9tEZL/Gayp0NuFAL5j8zktgyFva6dDyD37zYGk7EaIG3NK/iQ2yKP1R1wN14zLl3jEnlHtB7pAPz5R0msew2muxDV3lzr7QyyYwy44MRamlKe73qENb0rdUVZLW7JrDIUzcfEhEwZTliMLHbbus4JK4lsK4GJGQanj3rDMdqdiziZBK+SHOHYmoWHRBd5gpkqvOyY4qK0yJTUXuw5oY0Z+oiO8GX0rpwmzgkD1tIRBSFsECLIjHfyyCwRMY9HnzI6X4wNdh5ARZhJMm/trrdSkK804o1qOgZrPvbQcxVnLXNTIreAXH/vvthh1AiqqM0qpsUZApmV5klqihguMcm1bklAKrSBIJbRqbUzk4euQLttzZB6tx2v21B9ftb0nZmjvLNGO5F8k5PO5EDfCzQGCKHOCYqEidqUjyMivt72Ss2L2IWnttzivukss+rL9miey2YsNdXSdw+/2uHRQiRZc5hOv5wMv3jaAuTkmeyYiNRb2aQ0DMC/FJj/XBaSUVNi4eehlulA252jFQApJiu/qhxm0o8YYFqoeV9/07fSrmAczBTosz/oXqbZKrXPW3+pu/5o1DrqSFlwVNlV7ahExDmut/G3EiE/VV9TKmVlRbFSbpYMsuKS33fb0kFeosXCrg9IghQlaMI1aVsNRGB0TV/ZkDAArGDGFPyf0jgwz6ApTPdf4yzmiPYNqUm1NpWyk0Yf/BlikGMKbPySDn5I3RDK70ZQO5uMfKLK2ydz7AqMCAt9WlmEuZCtH9LrdMZA0dVIER3741XjktWwEESCjcPFYkF3BkDgE9vKQ5HAGbDryBqxReEOy+lbEHAst4UiOLwh1RzIWeAFpEClE3CZgLm6pgR3fFiIRMi19kcEoR13w9oW+1JHGg9uy4eSurUpHYN+G+kyY9fIzcLOdgM+tdX3TwaMWhpRX8xKBYlUHqVX0/5S8nTBwwVEoqgUVmXgzmqOp4BtLNUaR2P78KJlqFoI/Hy1BHAznprUR2q8R/2ycLLD31OYAUk2w0ABFfwKhGwFozKSWxLlMrwhmnJPztSjn0Z+ieBKXYYb87xTN4HuG/9S3+oQNBhnlMvhQ8UrxyoigeU83KJSHW69lFEwFDNXGlIEavGk4YLTuzm8mNpAwpImX0hBvkQD6gJXtaVUWKXAiwhZPmU9BsQgobCtWRDKAN3SN/fQ4eFg7q/SwygHIpOZoWd0SlyxztzT9ooYoPpsj63FR4BTTDzJJdQRxAw5LT5XlCZMMxmuSgYmM/dOy4m6yyTNphBYNj2Gi1oWacKpwvtIcEpfyt27tOFLnbLx0iex9YAsBcxnKHi+2Sk0quIENzsttwNMrPztAdQOVe0lD7ka6orkr/2z92XOG45jHjHlv+8s2FX4nTXUCzBfkGuoVpYhBxCJZw6jeoKDE=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100