8Ow4/Bu76htIW5iDDvIJOxR06yJpxAxyxejDTNz0lXhwXIaAnaGLWo/vGKDjRgKWaE4IlYdjLl21mfWjObzxAtgPO2Us52tIL3EE2k8gTEtXFpc7PqoUBiSWPGMaoKJe89KQRmt8UOy4sC3kKYZZlyl7vWkEzzlEq/3hLNq/ou4K0ig04LXT/yezBR7TsDBXVhDCdCgIABjoeEy1gj8YAyTJpKzEXCe4fvjPUvY0ScCRRzC26yWWRHZkI+xrRufrKvVSidH9S3gHfZMzBF3ve1q7hfAq2aJyL0x9Y1AfUC3S3molU/sp9nt0OWYD5Dr8v9qVa+Ugt0MdCVGlZ4n6s5kzgskbclxrbYaT6wJg/KMyT34YUO+TcpoHSIgyjuioiX2yq+79d+CUQkSYY1rDrU64pGF437YZQ/pUypEg0SEJEz5od0nCEq8ywnSVf74V9692VMKYewqbPzSwVwmX3+C93+sYqT1I1LHvW2m8ejTTF/k1s2CfT/dlWtO+shhBgKItVksed3gSrdZcTpw9pgWXK2Io3bdDmtyJH/ik1WACPFUuuxAlEKeO3BW3BT8uQNO58IkLaEWr6YHsNwF8HCJ4a6OWtTZPrioVhwW0zt2lHS2v0y88psfBmJsg2+ArXI8AVDymTYwCuioIhMhyRB4iycBldCBChxrj9rtEOSBwSso/l3E4a6FXciQfPjX5EH/o1LObuSnG6RxUYI0OqbPvHpB7vDQNVKuPVVylfCgM16cPBrkAJBM8kbhjlnqxjq1dxHKxpQpeaXAe3P9OqR+litzCC2fpRKl+yw4CWEblJZGkg6qCPT7Tzxei1smrW5qG+p0Zpw3exnZGFse/tc89ys+BSHAXwR/BqSky79U22guKCzlCtyxDLZKWngIDzrSXGXSZNZPw0qm3dI5iR3Wjj9RY+aP+PBAeGVe5umAk4J6yh/qyoIfMKipkRkMrYfSXrPs57+RlGrMuhW0t7wMSi8w25C/vFGVJJyAbD47cHwE+b7aLYnpEIyK/MNX4rK1ViAPvUezaTxQggPVxCrOJoWUBrfWM1lVgWygXpI11KbbQ+kU02/mBP1J0T8Hvi2P+CdBxT3xi3cssdplEjMJ96n3t/rfmRDdpY7EUgNBawdrYvA3p2gCvijpxNoukgQY8VT0Pi+v5iD7iLU04nwaiTp6/dWYZRx709mTftQBTF1Tnot2ru7sDrfoYCCUv8sJyxYiIyko7fs6ZamBAsE/K0BrCHsEPJNLHBFDExMNnPYKgoOFRjZjts5kddGLLajMovocXqZaECgHkEyEiBTb3howp8K19UB+i0tGmYrEIixjy5WemKgX7pAQQ3nBFZ++iCXcf1TZjtcPr9miZeBkkAyLazduFe9AYRZU=
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