gArwk48b9RHAVqY7blEoRFN5OyzqIB1ARhtL1Raf3NGC/J/puTkbUPW+FQ+OnK+upumXVeHX++ZLm/l1DC+Gcb6Y9KymqIhmEqG2/ccL+kjuEyverdHxzXbdJ/mx3BDdv9PDDbxqW1eSXxQqPuoutHvw52iZqgNaHHR19Qx8onoujpriL8r4G1eZGZ1QjxYQZtj5ZS/QJKmfUxlJujesrln4tq7fBSbaHuCJCjeqhrehsMxhAFVDFfB0QCcF51GIldE5CpNI4qYe8ip/Yj05/h28aH2YHt9ZyWy/6invAIOYXqeC+UzPBTl9Z3TffCkd1XODdPSMfhaSOvcwG+QIzLW2lAdRleyRk9yIPOkbwCc+5I1QiF4DHlWZQL6MjlPevS5UC+/oNZny+C9lZsJZK75AugNVQobYNmlc0vtm2Dm+EK90yf/x4HoF9GdP6lCmcXxw8CKHGS+Rwt4CiaulhAR5GLC/3XEhURJ4aPmhMYiSv/BO7sTLTf/lSbIA966sYdC42PWkwIH0qwd03cRsVxL86fuZHzR2xVMyg0DdXk7EjanDfY1mOy2sWSIGmJli/IHpqHL3rO24q41Dp8JkJSMlM1JOf6xvZwAl3WReJAMMAI/i80p1tyEAx8ru3BfNLywLyrM0/8qKQR6cafTpQIqH9Q5ilVtXK2m97N+KtBrL36twydrm6ULdk9L64b9bS8xvJeKuR/0Wa5pl7WYbvsX59Lw5alJgws62lt+w5YATyPnnonQV5fq15pQ4TTZFVqxZ4KJX0x+I7mBtFqM9Dp28/haM8+8phbsVTk/PaF8+qqZTv3d0S+cCDR1bWjCEIN2FNG8AV2lMx0oQItcNIG4Hr5Y4DoipH8xPHac6bwYgsZgIh8ELEvP/T9CH50pdRt96oYGdYyW1mt8PX+9iEbgriCTiDLbGJ8R+ixn99M8At+YZi3T+bUUnwq34+uAtNgy5UIqETG0aiplHPTqDPA8HDDjyc1Xwe0MMUUd8FBNX5/qbY2mfRqMLF30Gs1jstNF5kzH4/BYfXBSeojZHWTzjKxO/6OxVEv5ozjwu/boGmdXnFGNU6kCrAdjc2pG9VY2rI+HW5yjlVh8uhbXBQEZ1uoFDaCasrSFyDm4IESB0bxCJlmn3Wnnw1upOKNFJdiXQww1jHXsyHcj2P3eX+hxeLyNT442XPFU4oDN0uIR4Fl+LwRw06weJQmKuqXPshab6Oiftbj+453HpuQoDQSVCSvar+j/Eqq4vDjlHgtk1rhXwpBHh6teL5KPwqe8kVhcFULQ1xVndKzAtqSkQfAcY7s53KByrQ2JKRJ25Gvl0JfOrC5GE+1IpCinNNZPnaKFQ2t/BlOfxgg/v77IgPZwR3RGbR376t+1cMHQ=
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