m3+Y4FQS1V2gMBjY3lIPURMLSTTqF3d07fsqhW/c9Mglwe+V8CadqQ4OF1wfYMgixVyrqqDeEg+YHWHcVGAtBK1nXpHl8+3IBNwR5j/HLXY64V9nb4RrsuHTnbXbzOlEhpwr6z3UvQbbT0OR2u/JFJ7+MpOXVaHo6gtAU1lbTMBHp9f1a9IWV+nHTVQkUuNTJbmlHE7WIgX3O/lB9+6wbrrO9aoKhHPPVq+h/zKy6oTPc7npF4tK06EIamBfe0STFqBl3FeBVo/FB1shvHkbrfB7HkFaUsRnnvBEJKq4XU3ZkOrr7GD2wJWJuRj+hnpqIdkz6bsl7vVZ7o0B3fZI/ylFCcnoGX2L5c/VnUKv581NRdb1vg85pOfDMIfDcrDY85odtF361Dfo6+MX3jjqAnpC7Kcpaut3UbHd/xCgrAPLF2T72wWaKCSd/xpaS8ieELkJrIw082SWHzV5ciy8f8VIMhzuxb0XwJtXJFsYotku55Bfp+7DgHDv91mkr6AEzr7fVNfPyi5dsYcO0Q9uZOJRfMYMUdeDq59yh7YmuPkvBQMB2+a09JgtAisDmy9d5tHnu8QyNEh5a6XCXYUuQKxDYcgSdTXYKuofYi/HJ4PBN9dX38SS3CRrwMqde+ys9s6LVQnTWcHfVyXMl5C2H5kP25kkfQIQazlzgElKsrn1XY6WblZoyHmlcmFyp7n+jN6VSB2KuMh7G+JhWM/cIKme/MG9NLuIRNOQRoqsioJzu8mVsVImrtAN/4kE6a62VhodzuXTSosqio7wMX9VDWSQc1/Gk1JzyTBQfS3P1I9anw025G0mqso6icxG10qaXh4OKZW+g+mNj9bFrNd+/Ajkb9RrypxQfQ7dmyDGDzQ5UzSlwQ/HVi0RMndZ+LO3W1rgE9bE/+HbEye0ldwKwQKa2+UXinEm8oyp3JX5iNfQFJSFncapw41p4l1x9RAniSy5c8OABegfnYounOyV57CHwyUgxnNcj2isHgJFnWN33iL4yWCBeMgbNyb8zZ7+Z64f0YlJsT51WaajDqFdFS4cL+lVFcgCXjaRglg4G6IiMCVHxy+fCfU0jTi9UpswkPAAsDtm9piJm4aqcIEEDaC8iGZlJnANaUr5F77IOfz5JJvdpEZOW7573aO25HSeFrHjQ3MfQJNZ+69VO0OmIiL/Xl25zw/C2L50H63itI3wCGIG9brKTD095XyZeJq4CJpOpQYVY0qPoe2F4jg6Vpp3genqKuXIaUutDA/JvL4WstCf3YhohACScQj8rqLt6ROo/qpLG33uDTvZzoKdj7MiH6ZhMFw916NLrfkP25NRA6dP138oPcBsNsPixb/kgFByr1BD2SGbKzkqGthhlM8+YF33ADy4FcLJE2c=
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