Y2pRy4wp4M+oLq4UM7TwCCXHW3FCoViOVDDGp+GMHyc5UqM8I5w+yhnMq54kGfoFccXjLG19oRgl+LLvEOqxD6omdH27DC9NZKG+hoF3RU1P1cd00v3KIsM7HeL7gcv+oBvn3AWKc/RTKfPnOcDDFi9EhRa4cP0H10UrE4fY5yysqJClpnI3nEvtneNRhC/m1c88ovOTYjFNzaHcR9JuKI7Z0o7aJv6BUWfr0IXJSpoYwEbgh8+ppZm3p8ta8pHdEgYIJzLegc6dY+yXB/XtI0YywJcIEIivd6K9Dnw8IkM6/inpd9lIrmv0oy9BovLctiwvew6IlxlTGxPdDGEgkKcbqp9BOV06PzGLLpEogJmDRq/HrP3ZeEoKm3RZAxOvMJhcTnDaVyBBKfH8TChES1LDLDh7ofNkUNqcxhFXaa+np4viRjZvTzCK3j4RRnRv2kAF07gLAphcQKxuFdzQZRROX0+bKCf26z5E/a4oFs9BfrPGPrUapsj/lwDZ8K+rY7WqZWXKSsGoXhUwEtApETIfLT61nBmK5ZitnUOqaDQmpNGMK97bexS9gA1ct8Gu/kNvTYne896G5Dv1gPLUF3bvvu8mzuzQoepSwnOLoA4nWQlxickYnXhNttVwnHEdzQ+9zPuSl0J9yaVjWvqc0TuiV+L+iDiKGbnXsYeQ7TwCp5T5DkqHJ2TbtJDewOP/2fmCbz93GVjLDO8pcLWlQgHdGkC38/xN1hcsP72/86B2MJXryM82L7S1OsCxNJGYD3MmhXPUpIn9WcatwC5Y8lVfNXLPsd5etWozB8e6ml6G9MPrNPh31C8U6kGY5NzCj6+3TT8wpsLkw4Xyra5/cmOZztBMl27NpVSK+p8xsUJX/tfem2IhQAJkgctVshoUUcte522XfrBHvuhpZFpJtB1jZXUJnnN8DdxuejFjJd7ANC/8fR8tSajG2D3Ph7Si9FI0WYFXdwxfhUGQsFO892wSaCt2WKiYFvNSa33i3WYzAAmXLSNtBIiHHCeFxwJF9Bqs2/Gpc+43jcYVV86lrk5NJ8kSg4Bb59zj3RcJJvksUHt3xmGdjbTLGOuCg+LPsz5pMvi3qtg2GUxL7PQ7yol7srjvTByMWndHmFUM5lX5F5mJM9C7E3/Vofz4QF5wuUGDwmPGrCBgFEh0usN7ECxLcxQc50ZGSi0nh3qDBkLF8dQYIqQvY4w0cIxOXBU3hglE6ulj2fyJYPyma0cIx3V5BtjoxqQL+E34D1HzK5JpggUfoEd1emnAOSJTBzNOj0Ij7Ap44a9OHQUTzy9sJwgvfFByvb0m/ojIx2MXHaTr99f/jWYswgFu5qtSfpvOx53P/W6UT1nYfFzSVGLGUMwwnXt1hdwX+YKyH2Q=
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