HsHXUrr7E9R+8SAM1AbrkLuEOy6ebR0CBUdXW+0omndZPqPcnNCmzEj9KN5oSRcovm4cHkSucfKYIas1/HiE2UAzcBMwBDXhXTGScUojjxB8Nz9OSCfozBeYzcqagAbx1NNTdRejVgJ5jM05je3W24tDjAzrB5NSMpvlkvtCf6TRpXzArAFuE836i0WrQU09vjXtrTvfq+dYCuFgOVjdMtUQPXxvRinAgJnbx7rHaeEfs9iC6MdCAq96OCZ1vgBc9svLrclUO+Kx5GzbceK3xLJrULYNzNhFGcRfW1JBKQv1j+NA8TLFXJTGFy9LudSGKfXjOxe5MAjtU7soA6Avh7gA6Ha3A7unQiTa6Ezc2Wl5L2sILx0VCizYZm5EcBkrEnsMkqNCIF/9Ie9BO+hhM6j85azY009krGh+Ag4sE1bZYIPuvPU//7EPlYBnZaIucwzEkt9gXfp9U/TvCL79gALSiReFXmadWpbYQnH6bDjstEhgWP1+xN4ano4LVMJAYHhIm4UAdYsC4VPlCSGW/q+SFzUtPIDZiFVTA8+KN7f0jWSmI55Ewk/v2TpbEg2hEusio+Dow8vocpm1B5kozyMsED3/TikxkijbCuFEtaCKErnnVWdjXKFUL34pE61S7vrEZuQYdYgicVamIlIXnypez8Evjy7sBZtN29m6Wu06RUBk3QMEjiAskHe4AHXjHBcYwsBzm9UjYiNYSqdnGzz6EX+xp+XCdjr62eth0zYTp/g/hKrJaJRpu5c0b1zHKpHnuLC9wkP3KtWT+Bbg4mFoORl9AcuXHUnFDspwPz3T4f2NwdGEb3olb6kvvQk9a2DourUoMm99WdHIAT6MhnCgn7KS+JmgEaLbqLYCitw71u0mIPrvAqadGKfHlGACQA4v1ExIOp1KuMQymQrgKmCJU3nTRLIAgxwuhE7P6EEg/C8N8b5t4MyPtArnRXWIB7tznhGPLt6d3TvQtysqMXE89d9XrZH8cR0il5tVsxDAgs3z90eTcAGR7gOmGRVk71PSCx8DEMBeuFArnKf8idYVk0vP5hf1U8n2KJzDkTyzF2sLKPCVcrPwtZNdbM90PBYvjLZW17C5hd1dy9lDtVt1K2M+MgZsENwDRwL46Ir1p9G4h6oUrHqmmpKal8TMVL0eL0K9J4GzFlqOEYVBjycx1g5xKvErmln2bO2/O6xbW52LdsVIPJtpI1c9LJmt0K9naQpnHgXTez3WAsFwOGyNI6x0B1epB6k30ApgiAQHvqh9ooTyhJ/KJLFOV1utqEORXPw9A4ahZFs5szPWVQwaSnY4lXjWN2D5i139RCw4QLF6DFCsXRrDEkBXwvtvkprsKRrDOYOfNdKQxkRBDb2puQzOe/coLnHmykU=
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