86h8CWuH6gBWmkunrqa5LjW66P0HPwzpN7eAq5vy96/zFUgYPwQCI4X4NqvrpKkoYK16lP0igu2uNWqiarJ4wsGcEAnH7XsnqRV8W/tpmSaWuKEdMVKdD7crennCHiV9OIitMcPuBdcUf+aLH3C/1DjjquaOHM3iLalbE3ZqnFrwIF8dzvOxTdiBXqTnIy/621RTff0Yea/pUPzs8r1Z0IMGGMiL0a6utiQBrVfc9aqmqkrRrw8bgTx1oGBPjNnYnaS0pmzj56b0LfxA/23dWltiAuHByIqQebDnYQ8qtoC2dVGmSLqDBR7UXMeXs3MuTvy0C3HAkIxymkQtTUV7KYyWRHxHBDlfSqDgBp7FS3Et2dGj+p3+e+VltXO0MXf8V6U83UMKwl+Etn9iq11O+d80BlE8FkeHFtP8xiFmVsrZUQsFSf1rMviXN95yRChd4QAqzotnesMzPWxsTb59pptP8oRsZ39D7T7q4LyCseYrZPvF+VK6+0z9C0PRJ+ys/PN0v1Dv107hVglWBG31bhy8oKE2s7BR6q39TssXP8cAQSnV9eSwluF8Z6zvNMtNlopOIKgljxWI2PeVKvFEwkSmtdoE0Wn1/6WVNO15YG02NDfuIWWN0e+rO/pQlrdOBI0/pG8DED1WLjwQY6CxUgM7x+aM6qiZ8Vp92AeaJ5i6wCIhHWhKFthuiErW56ZSGs33GXzhUpAWc/oFnFD3uMlsBHowCQN1FShBnVeJsXocFD22lOumWKMERzvxWT0y2+I8BkmanM9t5YaQQNrqXu7H31EuqzCIYCX6X3qd3kcJsVOuesCpH96Ht28hscTQfcnylJO7PQkgrzigK8+VkvL3HIE+wajL3uIV7hfhA2HxV/NSsaLbKCIJ4jUg4arFwc/JfBvS3mUdnqMbz/0+PUsTgUVQUafJlGxeFR5D2nRE9STZNb8oMePaAK6qurooijBgWijxKw/ITDpRh+B63/xkzEy+BorZX/dtqYeFsiC0spkSHfx9u1LzNsccX8UEFIWM7zQrcSJXy1C45hpRD0tVJKUwtdHCPEtMDV0XBRmezo3uLRBeoBK+YBFIUA4QwqfoQBf2UfiYWZwruZdkeYAvbn1h95z0it4HfOcvSj5QBFFjnY/QJhAKNjbQ48U4+DRT1pKrEBtAi2qaiE3FFvUYE4SnGCT6Fa60k2yyB64tNSD6rtTpYQrbkL2dhi3FwPlEQERvrZbGHYMWnzsolCjis4VDDknYAM2LtSDn+K63CQ42fDf3/6NSnDAcdq6M2GZ34FPoPOXWOZwCOKtB7rP34QY5YaN4kPmIZ29G7NOVber1dwwf2Y9E9L0Zi+LbRd8Cyb3afTN/lnTnciO9nJ/lpdSIceQObYLW7mM=
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