yuc9u2kwrh7a9VdAzUwE2GEjkR5sLJ6CuxRiIOCZ0O1c/54NBwxMRGIn6IFsXfSK1+PA4cXrtTGrdeW0BSd6VKUO1vdy5dAFQhVZaY4E8BS8lExkgptbAmzqFp4aKpOzGpG8+heUkWyxc+Y9Y5ASxnJ2VxKkkcxpy0s+Xs5NyL51aampd+UAgGHVTn+1X7Lh55XqDLv70VueRSm9RV2Z3K+XH0ECJ7Lzh7t3/3xzOffC1GSY6gqfKCDlKctOJCbKYx6O1hR2Haig1uh2Cj/3J+AYxgBbveVpf5HaXRk1jt20J4lpMVXMUUPobyv7vKeEkIGSuoCogmrayNJjATRZyNEcR/WP4Df5ZFhpwPkDsQn4oBcEUrAxCQtfBRrYDYlkQ0Jxl7NsuB8YzFbKL7H4wNw5uUyrZIe8SKf4wNzV81RN7uZmPobNgwB2Y+JobLR13jrEFRxhzsDCRolh9JPAzUjG6UpAYOXp14B2mlAFmzYMaxuTdKuFtfXzgOSuKlN7b1RXZ9WSvUKP5s/79RAr6wG+rD/+CuDz8uu0gzGtizC07sIlnU6j52UyINeHFfNyYbNMG7ywghMrMMVFac/GY7+EmLCO20YanG8wZOBo4OoGhM9oPNwyydQ3B/kEPTM/aqukjGXi5f0FQh9xLRL7NlY5KwRseTthIqtmDmUR+F29JSfB0lx5KFztblnG0HRiPIv36nqSRzv6/hspIx6Fw03hlUz/TyTsbVUb6vb42NJcRkROw5U5wOUcXOtJ4ks0hiePezILYIwF8nVTupO6JUbE+PC5sN7dSailz9HlXRYTAEX9gO+m8jucR16Thpg5OwLvEAzHkudX09daZWo+Sy5hCZBTUau8gjQOYHNnfnRj+PDuxWtCr3G35MKmYxTEoWRl26HhYgFrbS7PrCNwEdnHpJUuMfYjfadjSjMRxumLrCTKGhhdzVJftxXZdBPmAJZaSAERh9nLlV9A5DdUpdzRJbNzJZK1osvYvSWedti/yZ2xLcRpghAHX3ITerSmLeoGoKugFtffyLwuUOT8UxbDfIY3PEGoe7/rbTYT9Mw9AS1uIkOsQKizS5r0JBFJFFoEXKyO45A6rYcH45eYW38Jazol7jbzd8zZ/6CpSDUvYXzoBk1tIRQfBR0T+MsphheGNGO0NgBjLsWZucayBuc8TJl5o7D7FN4K6krF5aRn1+/nDmvkhyrdt5MaidMJtKlzxEeDBtC+01omsQ1dgIuOXKIKOfdAAf2arCcHLPwnD+xd2W4NroD2siEwNRYjh9tRaSUbtQe2eu0H/kyuvC/GPTaZB+TyfRyUx4KFrwhO8+0rvc8WS7dh8YUa2MWC6BknAlEmGH6dfBzJDzZO4BzS6Ys71S+tGKZ5Tmc=
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