wXZVCSRqL25WQ7/Q+iaSiTTtCgpNdwO3NNSUW8iJ6IC0CzLxrwfPIs3IzOG+dzl4W1Ev0oqeQvMWOImObCjVKRpzFxUojnGtxEGFxeFT9ZNFqAEuBfQbCGvDA4yoxLCLQeMMZZDCTglV/umm2+VcLNzeePGgAWfVvUUpYNAaSxVjWdIr/V3r75KlaTRVVdNhQStYtGwXXSMRxAkc5v+LWTYLnovFadH42G79qBL8N5Z81xu4pDhM9G5RZfNqu175PK70PjgQoQUo0qV+0kUqsefqpjBMUF4umBDeEN6OHN+sxKj2dy0xBNWbnvGCJa56nnI9xc+CEwypm5BV/9XyMwWwgxXz3W6678h8835wvl5/1tvUtmndZHOV7p5YaCBrQcPljw4yURnDkBdhVssH9rvvPvP0t9S56wdJnQRC5lUCSsjC6fx6CcJiKUXpkv6Iu87671Dab3Nnp26oXwO+JaEZyLxFBTjzcmUilUO/+9c+Odt8jZgPPigFJSJChxDc7p8pcnGKpZgN8AC2WJEVkx6ZnHMpAEjvM2PsiqYVB9DLKLUcnUEHG9ZFvRWxCLEjqkEaNRWG3FSVbvtLnCx84kXV0K9Cxl59NZWkci/g30yeBAOuX0lkLnE3OfZPmf29piH9Ltl4nxZwYATwWVA6ze+i5Dwc1NHPiEtUrIy84E+uMkSNXrClO9pD/OJxvxbwRJ5uB6V6GHzJHUQAPnp5JnDjUJ5/55G366pIJq78+z1swGlFkEM7vpXmYSU5qhXcrGc6HFZd7tBxXxXsaHtdaUmqLEKbBWa2qpkdZuIASYrERdPij9ADG+Pghbmv5JffPTgjAPbb1e/iP0Tu0UQpqxoGXGmM2A7H0Hw79IXEu7Vc6GaMWZVkoZq6T5IFpZqPLf4gLEQ09g20rYqfgMlPAN/62N8XZMPSeLFPE8Ob5A/naAIfF2GO+/h2fLAbhkXV2Mds2+Ho44s9w20JSel9HDcsFGiUeNp5Fi7LhVqjvIfumC9ooUzHpdAtqXgX+BxNRkED+MDYRFVeTSeTOUilEefU+CM9MuMiT/BqUXxQ6dcdtclj8xMsEmXC7CCdhJQ5MBSfH+D/yVYqHotWPXsL+sWP0dSCi4+DxBVNQbHfNUAO2hjwLXPHzEHWHAb6mzoYfiOvEXMnD96VxUjd2nZ0YaUAlgSbeBIS9NK0eS3kFeGWgz+wQjtsqbucXgW4jY4GyVghpViMDuWcTEYJRrQM00q6rbkztswnnin4FFAsq6/3TEPwVgWXZu1S935JJCyMFlHHuu6RMgQyLdfSFxZCNxqURwj2tnvy8jLCT6qakfBLvia6scsGsB5DWDvpxYHzpQH9fiyyklXgu9bcCOw1XiLhNXHzG8ru+HLWRDg=
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