Q7ws/NWwA7URqWBHYWxFCQtBHp6LSnPOU/yxMysxwVfQbNzWy7yEbc0QNSjDvl/ZdAlmDQdNJYEVl9jnqgf+fYelu5sNN0Gq2zdf/37Dujm/FxZwmQSz1Q18y3mZ+bRpAsjtv/bYIzVo1U/DmWktAlU9cOAgTpEd14WK+lQat/4g2ij8e5rX9186r7GFunj0z990aEG7iY2KSulZbHr/OlJVkMlUxNeQalC3bJzKYbBelIhJEiZXT68DUEkmJ8GeAuiPsUQiQcdIUf7pw72cW1Y2LEWfXMyLMBMwq5+c5jdLuXHNdE1x3ImqHRJFbMqYpm4tbRN3prqQs1XhUkwV+aYwEKaoERA+DA/R3foqmyGDrw1wT4XmgkvulORQ30ixmIdnP9opCI75Nl6Vxen0s9E30Mi9I6dzPvIg8mmpiy/OMNDthSLsQx3fhuIeQFukP+vfRetmpu7rA291S79mPYE0TmcpNjBOeS31/byudkROgJNHjOitZNA10D39Fg8ftdVhmETQ9UrcB50Cx4bq4pkmCCYSeZvxCbjBribhIfIIF1LQR+FvFI8x8yNqRlHECCmBfRSnuALm1/jgUhHJ0wA/PPIeqxZsYR5QgYUgxesShj+6lvisFcs3YOohwr2Cktq5cAxTvoU9s6BXFb9+jDRec0PZcbMWEhOuzd4cLYq5KMl6e1D5PmmA0oTbWx/J/4ziRibgFIE83RuLWzYcszY1OhaPQeBvePwxdNfG5G+szdlljvzc2/p1Ai2D4Y16YS6AKbwg2aSvG4Rjm8I7W3GMjawMGZb4NEOXWxjb4Z/wLjc3sfSNxER86ss9HbiT/OyyeLJC34Dm7WZ5IWqpzHF4eDpWTryUF0tnKvar9owgU806X1BsvzUy2ve0IKnxTLNz8IESqdj0njoc0ahHo7Qu8Ii6RJWbpjHNjefoS+YZkwiUv2SSQe3k9BeU1bfhFd41Tt8jQND0q0u4oM3aqNukKiCK9LXFa8fmcxHuV0Mc09mdM5Vi5CLLfOUGP3fIM5T9m4EtcA3SRBpjdKl0suawYzx7lzROEJSKeoFNVEJZo2HMVrGO3X2kMYjVj+Hz8Emm0srU1exjkd7h7ypQF+yXMnNkt8rYzUD/zhjZJeNVOKbFrJwN/UE0egPZUjcUziiFzYMy84Cs2oZc0BMMzGH3RymNGzAgszDCS9R7rXfh1UBdVsLUNavW+MHr0BtqjkcqY6rgRcaqmxTHu1kM7FeNF9ZvTpkLfijh8z45CBtASQXqdfL9u1dCwOf5Bjv6QlbDQpPLRYIzWFSiHVjtY0reGMkHW37e/Lah/Eqj/icikKiypyevqRUPScLCKEuxbJYENrBA4qoAkXxbHeaLNeVk95jcQM5rDRl04EI=
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