pQfAx4ETnjccYtnanX27djTK84W8a6AcXcWTXKDyR35fsYhb6feamgKIqshtiHribE7LsrcHFbrsUOvc90YrQ4XZJI1Msx5ZRRe1rIuy34DPRsdheqantw/vTper/6FeiHNap/PRPtW7J6jxvAmClkBaDxLm7Y8yIurPEOlaCCS7RnoSM64eC8q4Xw4uYfAr0GoOc68FhWgewZPx+ut9nrBq/UjZC6+68uOXhOTLNKaJDg0JeyfUoRpkhVzRLlc32BcRtxVxsawjMivcsbVeFKqBsc7rSGcqoJsGs5K3pOXgD55fOXH0rk+28KuGfh8If+TP+SfZgqp3DbzX7KrIznphxxnLODZ1uWEWSvd9MwFdmir2BR9U9puzuaGwCemYMo5ubLXzYGIQvddXtEcnlLu+PXUBk2ql3mEeFObcnP8RrWgv9HZo374Eqy8lYQkAPcMJL9vKgCB+f9yVuEUAHGn5bVbKTQWue6wp9pO1P7SrRCzptg8eY/xDLqir4C9qsZTHJ/IcYpzRTcUKBlJL9hmeVb+r+6CEPXHH9OIHf3jdFwHP6y7fi12kx9wu4ovZO2OMuDSXKjRfrsRHWGF5TAan+7/aiqzCK6Pe4dAaOcVEuatGP7qUy8UPa1y0quJcj73+Yv4gR41EIDfS4eMmG/UScUebR8lEfxnY/KSlg6tp6EWnr1t+nVb6F7mS9A18jKgyhDJ4A02LkyDUCQsZY7B4Ngy2TEtb6eZHi9FeoQlvnZ6ZRVN77bAi5V5Cy8IRcKZw/M9G8X29qkTebYsx5MfaN9luBJOnjn124LdCRWbs2k9tU8nhbGpdoGe/MaYn3/n5Tja7rd9XCK1BAPm3dIMBbbfJZzJ5BWA5L54daDaTX3Z1VbiUq9Tak9bS6p2YV4arCELDPeyBUgIQcB4vP39IoM3upBIjr7kylc2EiNeT7mJNtSmi0Q4Iv2Sz3wi22nItRAaYaCSRegloglzDrSsfsL8VfvIL7lGyPDW6MztGKlFAKP9oHtoGFLjFOoyTs0f6oBLoylafPyNHiC1Q3jvxZGCMXa9x2ty+aOsDnZqEb3Sj8HsPooqTr/roTpHcks9NBXaHjHdflxDwqmECiW/sIRs4MdQ2U2PlYN9pnl1I5nJTBxp0jMykYW/zU2Z03re86/MqvsbQIDA/UYmHSiC3EnzM4WIHQDGBLzQoUwA6mnOGXNfuNykU9FtrLgwJ+3XbZtwuDo9e/bNKrqVxqex1uzo63Ba4lDHXe01O5O8hIKssx04hgyiH67gLdJgK3LQ885NsBt9DgKbU4gNyeatKWjjiihnvL8gz//wfIVx2Fcy/R4BW4CMVcsrVkV3bWx9nB+q9hxTmIeIe3OyvVH0wwppHR4FaM3LSeAs=
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