no/6HNPDp8sUhRClnBJMelE7CpRCKSqGqCN4FH5o33XATu9Y6Ra7uIv79M1Uw3wQNdYTU2u9QtulASV1G3baEqpOPyKCwEZbPQ/AUc5uXPW1feJzGVKxZs17VX8wva4FPr+/ZkVqfE2JDkjXaZ6/N1C6s3owSTn1H0z+R5f+otpW1D1jYL8saBvaDQB5mqK2v3zd96VeLDvWl3ruzYiPO1ENKmKPVV4NyppCcR1d1McMOCvrk69b3Bm74S4s3VqzilvCZwcsD3RvALxy4uYIFIFHATnpV6r4YIAz+vDXmnjwPk9Ult6qKIpHweViKe0AvBM/hPlZu0g+RNBfQCmHW33SXV36S7fKiSW6oKaTiewkSiNcv86+2sBZEaI0AuGpfIzN+OiZlHFtB9t7Y2oxvW2bxj+Bwaz36d5njDezJNT8+49pcYWa7O+8RcHJoyVpZ0NgtrulIiV/an3ILtudhROXVqZDPPz/HlSAbpTGTt39fSWeKxCB7o+WkOMiRjkvLKJnHClcl6MEVi+uVMLig5E0tDxDDVJpgFk0TlHh/vV3rg24WdreXIXQzb+WcQh7bPofaVw3ch7j0lghzDQ4XSPbQPxJcaXqRRkqCNARd6SIfrjqUDJ62CPJxEc6iO1cSYVVdB8lNXVUnE9b0tveaUEBYA/dJKW8JV3yxF0XdREbQIElgnzgpqfhvcuf+crxR0f7cmvnxsZOXKQ+zRIlFFXZAmMC+hWIQCQsCc7nSkeT8ugJ16BXro0s6b+kPo53WXBeC2rGz6og7YUxLJVseN+XVA1Iwmnt0qoBzsH5VogcSFxyx4Dnejn8I3RexVZaBCj9rU9qGTTCBbBgOhWS3eG8QY6X4UVadbeuKHMV8FMxCaFf2EypoA4slW2w6gkm89fLI/ZioYvlWIjUMfwrri6rcBtyidQkUZlAEOFJyS7rym/Ms4asXRr9giWxwm2mWcjlvoYw8QJI5st/9PqnWwNV9mUwdEAMUb3WExsJWE1oIGUFxhmkmy71Oj/9F50yOK6hFdL3Engfp1BMlap8VqWooTs8Ylyqp+XnTDvBzhnr2QnxeiaKppEz6VQO4XsnMUcEBf8JNLBjQmxM0n3e/oz6lnHmlNHY3f/6dnt+3rWjQSkciz6DxgvulrmWIXo47kos1j/GHDqfKkxsIELtGT287KfwTKQNX1rYJQsYumFGIsNGxSq7QqIaNCxto+kiLRMxrOReI+IkXlHUzJ69ZIvKzJY4oU/S+Vp6Tni/gDbyHZes1SGa4m0QB5Pp9U+bprOCvMgwXgYj+1SdcIBVF08cZHDJREJDvPBRD/tEPtiVtYDonwPMlqMZg/2XA3Jjr/46JhaUuMT7yPNPxo/KS31qLvWiQpSy6N7f2ZA=
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