tTb1hIqpcZUwUqnrLEs3HF/MM1rdCLAWSUpgaF+Ge3kaNf37yM2dIXqlD+416aJ5KYD2O6MOeVj6rtPlrmEG5ytH297elDbdpn7LSDPkWiDxUp+HDVQyulxUYumMwN0B6/R95nbvZtaxuFUXNB5TObyVejGgvqY+fP8Ab60/Xb+NNj+DBsKrynMlZqnMQo1miKBwIZzz70cCxFcmG2b55M4CFDTzndztlaS9K/H0oWOwLAmZ5M/ZJMU+HxbX9MvVR/G61bRqL1sDG0Rh3juq7BiuY98XU9uicRKMK9D593w5yKybk88bR32MNc7SqLujMBQhqLhWqKzEwrOOXEbhm/bQu/3ujtsadrB+K48b3jM750W1dXLmAhFTJ290gIDJrYEEvsHTRWLiGsfASp/uhplRKJtQvwG3oM8BcBk53BRPPzaxBT5q2ANJ+mKyD2WzuehRkfAaY28KOA6XDMGiU5gjLoBfPVkZZtcyAaVKpz/zu07Fow0YrJn4q+fGRJ6c2HJOAexmZZ4WwaFCE6tFy9NHYUDW40HbqgeNMgfuSAuoNev7Smp9sNZ8Q0mf2Sgg1uiD8nFQJGJ43IxAls54qIvCEFQ9fvDJlWMWpabH4vpnGiaK9XT4PIGWttAL6jgwiQUey69Zrj8JnbsyMqr02rMF3Vlurt6z9w09MxrZdcSIPZ1gINOCbAgvbF9++AHrgAxu9Et1QBjkcw6FkJBLiT/vvgah+h2upmPtsNaVOnJxBNppTCmeLoGLrVM6Hy1mQunE2GE4oLJMu/ZPhQfcUWiD3JeTJplrghC7WGuj/Cisan8f59+tlDKFiJoSJK18Xel84h9zHwrfSb6SMaDSE5qppAJp6tbXdpaNYH1LFdXyXJKGYerVQIyeesDXROwkdVjsa93o8DWTKSEzMJvyeKzUecKlTjU9ggt6tTX2uXEi6JlekApRCtpgxCw5hjpRhCc9tEct6VjfZXepYu9SjZhLhBEsxJEngXd0LTY5t3usc4qiyYAQWm0VCAnDsu46507eezxx28+O9oUR/mv1P5DP2aLd6EseLsiJE1nRC8Ajklb65g+y/1Da+3hNL2FlpGvTAWsdshH0puvU7K0nr0D6dmwB1+EHshXdGASs5+Ht3K658W2BmuHrk2NozBCXQ81Xbo0JHuSSyYqHgttE78TPO3n1bu5yIFpr2pIhGOGGAwHaX5GH/Ao97tVoDMudTnJOoUD5VHUoGwRHby1LYCg3NGX+uAhxSnN4kGp2d6VWlKTmS78rsYX9baLlDjmNR5pWsCOP4MgiypbUyHHUajLCFqHp3W33LxeibdhAGDhtlq/LAvjprLskVeNRY2GH4uKJHPYeL93+vG6IcpJ/ifawnhy8tBTA+O7fVPA=
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