5qK106LLtQWU4DwBX5ew33PHIvbAXlxj7pMGEZtAr6LjxnoP9oVELoPX6KBQNgZecyk6MT+dto2jG0YsAJUbpyxjeX3UPH9YuMmcXGaeP3P9jPPJlAZpf9oOiJ197nqtjk1QcNPnnlLV+qOs7RiiOBTjRl0s+OYTpT9jF1/eFOqJaEhEp5FFZj59L0CQmTJkPU3ET92asxQVmvAY3mzH7hhb9fFVBxvMgZQbiLC2YVLuMAzrLGVLYE4rwIfGwRomeRfSob1rtRs31fQY26IHgMYotkyjH5E50EDKKvkKt13nuhZGSwOL4SQ5qQebYItmZm3kYR1ak98ayngG23sDxNWv+aUy+HmS1Ym765rYyeuvXo1Yh6t6l1lCv5TQIWKTMHRABu+uKjkAPh8SjEWGcBeoWNVFwg/DmLjuIfmvCll2rhLgptLY3TMb3i5WaLfhcS8z8oJCECV9OJRqlrQMM7ehgkPBY+zPmd/MabpdATT/HBhLvk6FPbKPoejg33zXT8RWV2ot/arkqsRESv94ru6KC1CTzT58ZAZWEFUvTMa8N0PMG7Gr6i5ACy/D+OVxxqy/5GDFa5rnjUtXNNJWxx8pkEgdNGohsa3E/RCLgd9WrMizefpf2Ltnr+VldDrshJMW/2Vki3mWcS2cKiLkSV+mvLWIWzXEjcZ4k1xH6Y87JKJlruW3lqbCEylcwCpWahl6HHRKwgSkRKba6f95fvpPiSgbyAbAt86EIDHq7lN50uE/HRuwY+8Ev1KHWiPHPHZmjJimpg/BTNDlRTzhETUtry46z31rVArO7Rd8o+ukHcc+mtpVetMhmfQc9vccZJH7182QdGLxW1P0KTkHNPt4SnpO7fXNMsg87k5jLm9zib3qx32bu67Qprh6t7kcLQxOWzLGKBoGqRpoPjz62Bw6yZrTMu/v70NXmce4ZsWkJC24p4pGECICufBvSesynC1D6Lm0+LOTd/em6EmmWM94GqPx/YdjskrvZtepB/jeganUrz8+qPfR2uxdVyl/m0sSPwA9u9iCOCL5kCWCvePgBB/cvS1+tangNaLRAsrY+ivZ4ibPCZJ4FE9ZmtTJfhwIxI+/Nozws/3DSpCsmj57MqAfmFPnkvULhqAeHirUEj2+A3AwHkYopY9K3m3gIH16j4WMUocdBunszgpV7xpIovG1t3Uor/6Yyl3fOriwxBqUflV5BsX2fI5kWKv2ZN184QsQzrU9X9H5inraWWG7cAa4oDc2ejry9SnrXmhMZQK7VISgiD1Dwq6pnK8fdgMar3yXLXmNdET/WysqbWTkiavu2PipWmPZwhWaMeiMNZEScfuVSBnI6/f9OqxS7PgsqiHrhHEXGbgtdeh8fGRrSVM8sKvgS5cqyoQ=
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