DiLduXlBamCCm/O7MHedxHCMY3DlKEHuZ6fUMH1V+FUbRuPxsj3XoSXs3YBi9PG4odG6pVC4hFynfwITpzaWlLq8op9IlD8wBu2hKGUweiPkEGQ20/gADDJBdm3bRErEXbNfTPEG1ZOS4AqYcVb8a+tCCsWJYzgcDXuDNRNaSgad4hMPbiXhOPirnqN4hHz0l76v6pCMxHG3/t7DjGsyPjiHIQtXxHQOxcuO50NyQXfA70WXYQ/6kfg3mW9HlkPKwrWTaBP3/04TPPRVxwlRbKNQgSIJCCyJzgMe1bTjkmmbIW+ZqzZRZSnsTmaQI/7tNcBxlqPC00Gx5/VCs4pOFhv7CXExVNp4CT3iunzu+Sg6dvbyoHoIj5SzLpSi6h/Ja6uqIIfeIRFptcBFKw2O5jzXZ/PRCivRHxZ706X94h+DbdStqKVghCcGuvl+kvmPPW2hp+Zc48iaHFY4qnh5fzheiwfvjjf+vVLHRnpC0fLOjQ1s89OVtkraiwD3fBlXCkkC7SDbmNFIF2tzihPnbak6UfdA6QXr+4UQR597IrTh+ITH2En9b+yNODWXrpkI4W62ArYWjL0zgpYgsm+8ej3puZ3u2TTV5WK6AgVO2Fh3zaeZ6hNLhgaqhTre/6j4v+JsjoovbC+/LfwFJ+t7uLCYeyFHitO8vw5P1UuNXnfyItT+PSzNV+DXYD3HVCfCfazclia1t27Q3LzYTi7+VTiDLisdf8PeektMspeyEotfX1aG3cBlgphMV+GPDql1chxnd+pi8GHQaiZt30qS3OrLuqubwzu4UGYl5Jq2Ysr3024ro2W5za+h2oVaJKibZVFSL4dh4TjG7w4FY2LfDCEKs/FRXMEz1/8DEm08fENVfhiQJD0IL3efmF+mK8R0QvCfehXbskbDJK+IFEAnrMy1x8Ms5g2PIkMvDy3l1Kup4s+GO5+zZm1irmbHxGJo+pA7PLFEVyBAYgHPix5tmFHLc0r6lgyKkofAvfIAEMzqrNwig8z933ckqCCkkVJWCDJeTT3hakxojUVaAD8eqO4mnCDSjlbPcvb6YKhtBf/vUSjFJWVMa+90Ka0c52/rr3rAK7GIDZbQDcJDCFg3L5FCdVchpTr86o+ov+R0XN5Ufm7QJsfTIlf0S1FHafYW8kEPae9emYgiNPXXWAS0/NxlLi+nKZ225Qq701bD2i0q2B6lhpGiW/vApcnPwZh5n0KNo4+j6n+fiYhNzufQKGWRIzWqjYdtC3bjRGy3vZGMZCWL5RanP6V/eWbH8USXY1Ll1QOM67O/Pr9xTKE12YixqOfew9G7VpP973vk6FoBkhyU0Wo9Ha+C6pfikspfhaJAGaBlY+hj2aZr8vxaOCPaynJJ8yVgmt7WhJI=
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