A8RvYuAEvzXaInUIxsuj4YyX0kING6hLauZG7Mp8l1XBdcSZRzNXHtMTsCNMv30y7STtNVuCtsqHUdoB1aKMtYxkDxfaI2LNBNGMN3eoxAsH667pbkJOlonHzUPGZ88zjdbnvabYNh2/3qHrDbkEzMg4Wn6nWKs26RQHPW8tvtBI1zGUN26TCqDptgVuzoN/eEexUMsKtoBuf0Z1kEqocKyIxlK4DXbQC5/CZduH4PTN11EqSKYke7R8gghLeUdC/8MVF2uVEeNb+TBR5c/pNbl1uBFsrIltpYaqVzpP6C16JQkrRLDHGMSfJV7xp+VhKA5gSsPRk2G/KZvOz857473w0+GzntInayTLlSqRl9mHmOxy7aU7MbtRpUDQGn8j2XaFYVI93nCm9nBZm1bz2Twv7JFQ8y1tOhn/iV8z/umw7Aevxuq79a2OeCG2lI8is3xgeavO5zvGYOSR1Frnx+7l+spH5yg2ZgeQCc6HyyQd7WExTMxfWLwYCyYf4IQlY2nAwfXc90KvXN5e9CH4Ap5rVftTGUOFMzFK0TYLdXsM5BDdj3ZWvgcQIM3zUFWupxj6qktjtUIVnXNNTkSxCc+aqdEOi4qTNejbVz/B+e3bVn9OGo/WG46R8EPi0J9TqfmFpeXLlHDPxb5LOqOH3gAA2gT8akfOkrvyhXklmE+pzgYsv0uo3eHkoK/JaMFsbrfgCaHtYFrJzdEmBcWNVqlugtdm4Fgn5AfKTOQuA8sGxyILJSWaehR9DFRWGfxjeQohHK1/pk6UdkT0Ob2nsPhu2akzyh20/0Lf++Jckc5/AyGMfM1bj+UkgtDZrAr8Ekv/HiglJcdqPREho0JfB2V8PFut9ypGvBMw7Ohw5dACGknTOIDEn5J7jxl51zhExJzo6+xK2QoodX6j3NwQjWrjzGBW/Ns3AEGdD+y+AQPuIShIagSQ9hJTWzL0hWVd/c6RDHc4u28kH6F3RI77P7wms9j+YzW3nTZ6LVxhPw9j2SWNXSkwDKq62314WChsrui20Y6KOh9VZ3kY2IsQibO0QvULDu3lF8Rp6GNbpbyJ4tnsTDzRBJc10sNeknx9d/do4AgeMQ0sFrgf/DDGWe+3VvJ2Cr6yBN/DK8r4y5ICRcabJcBsT1qw2AT4+JlGk0/XKi12YYGNtVYMTuweHqtPZtSqXxXEeQElpK0iEKamIgTtiC73EWL/8NQppCYggxpgCCVTCwm6ahkpC+E8Fvyj/X7Dd+6vhA3RhxcoLkaJ4CYwmkpVbcpnJ2pxzW2mT4jc8sIn2tF4ycBxDjsxRm57+jRh3LNRZpCBJn9bnP5Gmdinqou9sZqPq42cj+lsYBKJZ5E/Owbam27CD9j9ntCduxTjXGdgZNzBTh0=
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