enGV0wIdAJkyBW8b2DrQbbtJlWvacuUCAPVzO8kefCL1qO/vVxrbkpLzkRKtA+dRNygwwjVvPr05/FIVXBwAJrctbL4WQD99ZsRXnBirHpiGCsdoGtVYYnEs3R1MVFjO50fmr+S1Q5fziAEf6X9knLe1AFCJh6ncXEC/+9fQN8PRTaftDYCPtW4SV29yc1kDXRU9uYVIhuimFvT82zSanpUq7+5cjS/hdm+GyvMNLY1+yAcv5fV7lBFntx8QiCUcFtX/LAaln3X6GRTYtuMReMssRpUD4Gj84H/fvfu4rT3Bxgb9nXBTE7H8sVNBoazSynd0++PRlEva7WNHcT9sgws0czemIQPAcAUm3rIyvo2eZhvvG45Evw4opOMRBbBt+P4epd4Wfu/D6NbxYDkq/jbSfZLLY+poPr6Feo1z7b14zVN/80TFuib0IXFqGvgTsnpvvKWzSYXfkjuG3by2Drdy8JZq+4bjOwtlJWvqZ6IriH2RTU7dR9/nO13fILpN1UrJCiLCdMP5EmthdfxSDo9ElbBEg4nxt/SDE6VysiwMfESB+RGEpvGtLciEQ/ruCjMgKR/PIjPaR6Z7nw2dEHEZUbdmFIiId0cjRaXAzoQMrq+NtWrxXvndl0cGngc1xPDdDKLIIiLzW4mu/HFCljtOahoLlwwq9DA7KrEXYBybB1s5zzRMkKT70EzVti/cp9epYSBDHdTYd9EsU7K4lD/tzpaJb5KXMEnQ7dCHUGHd+l30cRoKxoDcvEaL5VR4moONI9GYvoGcoHvtJhS9aRtnnOm46MWV3Adajlg09L4CwmtkDNb8PaEQifc0zvta1npEkh2HhC48K12PDhORtfl0aPq3uC4OZekvvnO4qIVB836HOURZf4s+NANl1FiY9mM0dLCSiuQ1HUpG8qZWjaWJYwEqYVtzX+JZJcqpYB7/kEz7hR7GZUnvQX3/SLczc9o/cXLBKjz7oCtbJs/yyxShfmVuMqSr5WU7iqfZpBAEeFc/EaodNtJE82AjnfC2J23Gy4uf0MjflcIH8fghCcvlyLAGFsqO6yBC00KOrvpHzS7CRW+P3HL5XeozIfDni2gJtEKLkfFJl+cKf4zD9MELxx/XYzw82PDPvBYvbzobTUXxWMeCyfNFFlCa9BX/fxqvp3rHGl7tti39c7BvHJcGQmEdUXjD8kuhnEEqy0i14tdOWiZHdmh1We8XmVlQ1ON8gur63KucuYOvcTaL6gkSsVZYzoxQYrQTkhbaeBUsO+seCvu67GVa7CnmKEZzTffWe+lH1BcqTfU3a7TtN8KGFEXEICOEbVOi8U0VxCbMz5iZPSYSDKe4VymltkQY5o6QWWFfCt4TtyzLZcH57tPqwqz8CIcBH7sWomE=
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