nvfv7g22TAD8f/kWwxEpNuTIH3fstGfigOzTwSBnyJsEWHYffXo0AOg4iDnj7IgCf3ZrWk1GM8RBMIGVzaf+EAVYLJfLX4FsP36vidwMXtF0j0nUYwJSwctWL5Ngh2FPgDIj7D07w/Bmuev5jLLHrY8osLMa6WZh++z0qvxY5Z9imotMKPeYdH++91++JrW5zIKL186vV2t77ND3QAXgjGHOHx7l07oBPrROWqN7FclotMK/3cb9ym6J0AJ2zyBgiitGS/T33awYStjDUohNx0z8deQTdMxrvX/UFmdUS3KErsoKWQ2h0b2Iz7FAU0Abv1eySYUHgopAXYKxFBsT3+okhUzamSPR6LjRa2LOBbV8w+Ad1B2eWdA9YqkLbqbiTmBK1d0vMj+eEYoACGI+lcgRtAC8hcKngfXXNWx5aygrU0HTyyrr6ZEDFNWKAOoOWPaAmIVBJ79RghCg+2q/XPtfRhTMOgeMpej/HNw+SFlaGBCj96uyrLJXX9zIstFUk9aJ95rnIVqDIsx5e64JUdWqyqyL8eU3ugn6E2HCIR5Hp9W+dzmaNgkQZWH2VZbwgfUQYhgOC7oL0juGJxw6OiT6WWwrFjcBrXGBRcBSNE8WlcoEFh1R1/bOotgGRxu+kNS2pU9sOX8eJJgjU1r0/wHrltc+zty+nZWx+J2ZPJ6Cm2nOdlHiZFskpCX+qAaU7LrSwIivLZDrSOGSJ0ELQCMM482U8dTU7pFwWc7HZkyY8X981+ebHhy8BGnithWzR/X4sXP/w5TvgutNC6iw+W+0eLUtfTtumCTxTq7ViV2buNqxzKb7q8MFNKq2pv5FpwL1E2g0hAOc4g0ipAhOxz9nJ9wY3a9DCnhgalEMONfeIywQpzMhvbA342WjWPAF14ljLWJJdXt87WIZLVsZuKDhjMXk1F9f5DYG3iQsQ22kYANMItFhwV7Q6Ui7zvcoYMITBJl4sNIKFxTZJe200YMJtTTqOoPCHGpgrqT25chT3jgCRC0lDn3QX56kJu8FLbBlL2L9cEIlH26dJRDsC1fPhvr6qftJixpsm/Wfuj0jzW6NwwDYjAILRlLIEOZxxizOYMQEeuEyCiN+0AXj+ir9j0CdwIYNdKP9Vy1MXZrxyvEZBeyaPTxScIFrfM7VYSpc53jw/k9g+CsPz+Y2N9zSEU7PDH4orFBeXHhcDZ90hGnixl7jmgkaQ5PvB1kFIDqObMfzUzRqOgwL8XvsQQc8UQ3hK6Ek1To4sP/LXTCBGK5HjEuVdPS233POeWZb8IZny6YPW0Xqm2bskm784V+WPfNdmWOfyfPM3/NwO5I2ehG4sN+Yn1IHB+mJHI9CU9V4WimohyFM55TV6my/V3xKAcSTpUPaK3y0keY=
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