Ef0QMR/Au2eJGU2gak5TD+y55j/3U+ggcwlIxwWATLwFBWyuwmBI7/FyeRKTs8v/6APzg80rUnzCL8UIBFTCyA/XLtJsAmsUjM4zGSSuLMHI3y4AC47wzOGsEuVGsYT8c0QU/SbqAXayLgj6iujI55VMUT/2yXHoFQk5S4gIbT5f11ZwJJA6ip+uOZRmHYJFVws9O0pEllDu9o4GBlw+Kl3QxlDeVIXKhSlN9ezk+Jamtc+VCl6JKQJfkQx6+gNpq63EePGMt8WymMDiZW4o47jMbRs3SoUT/pS5Cb0jypTtWrqUU6n6Lyn6swczI8pBIegRLiR64+WOnQFmwKTUX6IqN1xeR5QVRy+lPn0hBSz6+haz71LPWD4e8pc9BnxFVGtJmhnGBkt5I9eN5hlRfz2MOsXCqQ9DQG94ykr7Wf58d5PBXB7XWOSz/7liU4A5y5uy2Ztuh5UOEN83dj/ajyoOBtfPx32DbwZ69vbDWbsMQbpM5h8bOKm8q6e3NzKuKYdwC3eziPYwpVuOiUpPPLhaEbUcKE/ivEUlaEo+7RRdhqadLr4AnTKsKgwynqTIdouEP0mPtkypT0ChJis0EgLmQAKnMt60bJXxGyKRv2oA0jSCMk/jiD8naZTGfmKkIxp2jo+OzpKVe7x5oSX38gGJLYQYycvY2C69JGX1igZYOo5Rm+OafrRRMHOSZ4uCrHzZA1dEzkdEFxx8sd+eyapfe3UUr9yZSQM0Iug2JBqikWmydH/RebiaH3Fw1SzkCPUkQ9KClNfSUaKev/iFJKdIaHrma1K4P5ib/evJY5bLYIIRVowmqxa1VrOJqyfZjuRxFNaQtHqq0b1+xFYh1lDve3DMIiEye09CsrDOSFzqV0vqAgCsCcfYJAJjvwTz1C3LMv7Y8MTERqVEajCuOWQLX6/1G8lVNna7ZbYMP18m30Dk2JaH0h4o8EEXtpN45Tiotu2fDJekE421840isQUWVoj4mlvqHxbmWPJwkntDCTmvLiSoS7SSMTMa7Fgw06wUIUFYlEx+fcFIh8uDArUMcH7Og5hkS1H1M8IBZBpQG2lAJPq2pWS6clnqega62wSBpeOv/fWVfPr5GnPwQWSjqdyIMQZD8Mz/ghANqx2ZbPH8+gZ/peqsWvY1QpTTnp0Sb2Euy0kda/ZeTceozyNdox3RRokuJd2uAE4/TDtE7nSE8DSlYCHZnyjUUhVrUmxj6Gv0U4UQbSUZyq0SLP4cvPaZRr9H1P53OvkAiFFneSk2LP9Kz0ZpLKrxEFTEqyR/eEow9VueXjexdoyZ/wUtouUSMs66qAVzouvyGLUrXRPSIGmJSrAQZIBvd1nmT6BaZrYB7iujVIf5FaN3DORhLJOsB2RebdauPLo=
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