O0NiThcb5sZIazmEQrH302virWz8kOoygpl7RK8a0mtj53G6re6MiwwP5TzKvdbkTnj4uTHLU7N47MCR0mfSIpK+axo5kB+J9Iy4+uCGuOcL81Nv7eH/bR3LE76kIilbAoJLkSaNLHg+aIL1l4O9vKGqgYJxWmu4x7/y+l8SAkOoLFc/VMbuZoJluQvA6Dz00I6bns6Bfy5GCGr1Z1yaXHQXRcUS6GX7beZunuyo+rWF6LYGDJelpbm4rQ58yDSZzlfUkfptQ6HisV9IFP43B7fVxsXQW20ignQICJd3ugmQ6VtQa+bs9sB/Gt+VDUUusFhSSiYWt3x/x/9IeTmje3SUhO9VnIqAbXyryfOoitsTFgimEO4/v5oRnp6+v0XMhEe4ENEgrPyqkrS253z+gdzcqGAk8IvrEvaWx+5bLNnMM6HLnzz7bpQ83PdYJ+CR1QuYwjxeAntlP3+MC4Dhv9/7azvWFVk2ASiQlVTFpZOM+yjy9yiXW5opCmNfi9XsRxvOTMUXmybFfw4XXLCRdu+8SkzY8Dbgq18MLApciMh5YCWyHtBaSRkrcZGxYoohH/GAqx7Q92keirgfZ634ESBXbFoEEdvjtXQXzkkTQsvQ9TSgpfpDrK4pVlkkfQgoE8+bY3m0dcayn531iBuDzHEtR1H3+skxeAT1wUH/dfvRiVsoK5CtEtDUvP6sbMMPH276e3d8jkEwbsaFeoWzyCJILIXan6+QhRa8J1AhIhs03aoGcY4e+oy1N0KWk3j5h+DsGLv1sSL3hjzkS1cf8J/DzQPf2bhrsKT8l/czDzD+yxis6aPAWl3Ci1eJLnoE8QvFkUFbQyyJeQlqXJ6GP2g5uYMDHyNFGqFing37Iqu++hAQtrwqO6i6eowVfNW5NHp43mzXv+wxKmTzuyN2EZlH2ygwkKBu95SlPzzLSAVARB4y2MXH6ZyJ0Wj9IQ6iHIjyIgW0+kgm4xE7wlXyCOdF+NoPe72fUynSPBJgtyqbovmg8ZlMjWRT80weElB+vfKAsHl+4ycIuBctPaEMukHNEppROKSlaLapVQIbw8etOx4qukZ4hBtbPTgkFjgBekhXM2eYiXmjXPfG63TiMwr1CrT2WrxKqKoPFO+R1lPpQV1bqSMn7sTbYeY/wLWddQj1eC3al4d90toOirpxBkk5anHhtlz6eOBMarEQL5/zYd0wfGOHhHeVmieYN86qr4xnK/MdBPqPVuXLjH7gD3OlwTCogjh/aSajJKlpkXtqVHtVbyIsmcFamkC7OrcaYnBlFOE4V7EtLvXQ/8UvTuOIT0ZjGYLooAIzXuanxRXGe8kq62A59PM7yGsXHPpcF3W6BE8sW6+kV6IvuppY7mG57E4rW9BWKq5n0S4=
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