qse9tCCgqQuaGj+4eYEXK5fmYhMowFmb9dLrV47qGnUpDjDfafKUUl4rKex0eOA6aAhzvZdDDpp0CDZA9VIUZYeBGvm9QrVqW/dgEUTKJucplSdUpB6Cm4w2cKdkES/vNQjT6TYN6ZG40hWTwKUROQ4jK+FkGOYBD0u0edKn85jIoho4ZaJaZV8u6fiyHyGexEU9vqmrnKtSvtWfqEzLO6lxT5tddZKWYI6p6cBIfXo57melexRYi5rmZap7hG67sXYpSdoXP7skmvs5HjnjUZFnJOeRIPosm6aLLl/FG/dmORgfZ0ug4p8gZKAVhtPpY3lctw8ThPp5M+uRxpqWQSOzhz5UectUp0ar8XaADqFmVn3OsU6Ug4E70dkvqvKE+XTj6De9PmQgqbCgXDQnJsPRZJYVBaulI8t38hfahgmrVtM/4hx3F6YaM3yyEVEdZO8m0dZNFfTAMVIj25Neo8QSMFiWBcONCJkX8rE3CMDxJasCrHNR6garpPs7Wj+N5cUjZi50+zWkyXClxoEBm/QACzynwvLRKi9x0l6xXmzVuCDRoaE2bZk/rCZe553Bjjlu/VmTUOCb4tFVn3G0dhrfKbkRTGa+gvLxrtULGUV+8OTnDeJzaC6Bz5EpM0fx0lXyzTqgQL9jOGmY4tEXkfO9YWeukVUjNcNJfl1pV67K1CLTwXLJvWIaBC7HYz610oER6hx45ccHVXDTWGAEs5X4RzKmRchRDMzPawDSdvtz15vExihs7rynpG2Alrs9D6s76Uy8cYpff7FSXwLUsXBa/51EPes/mMn3WMjBqnKahDn45m4AIdUMI8E11yN/MVCgArbW7aas87sihSzSp0vmM+TbHz2gxl/sEy+gZmd8to3nHmYwdnXZAKViRiE8RjPuNL/AyXNfl32g6b2c+pZPQ1nQ+EnXETBmRu190RXCz7MH5cDGqn3AMRIjCWcn0kpoXiUnq/PtJhE9hhA6QrZAZmW5cYMO3JvGFO3gqMlXlDBgAaEL48svlnN90Iz6tHLVHEvxKZv0BLN7+0zTlNf7Yi0v1XIEogSKwwfpjrtzZKhd1+XVRo55iyMdWPlAAXxTtnKblsDy/yX5qVJ+cqEW2dGz45FTU22I395iznKWn17I+TKetVK5DN89/eZI/AS0HPeadQjaae5GD11ofZbWqvokIg1uyZxhqA3UlU+Gx3HU9XLdzDC1yNIzmnd/B8PZlQSvtVEJEG45Bit3BScSp9osM31lNpllgzbpiAUQebAx3v1zN0gAjSMuUZSBTe0UmAfuLiXPr7g0kIeIF9kehrQljeKCVBv5KlXKj/iftYwJvT+UQJ2t9qWXRQWf1NYHpNx33u8Dbut6AoS0unxOaAmOGZP1z1e1RPI=
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