WuvjXa+j/PmmhaajBhNhrA5tecaiT9j1Jx3QSKPfVWteS/mx9iINE6XSPJXebyW7mpVDJaTTHkqGbWgxESRFhdg1y5GRyAFa1nYPuOCA6hf14wx2XRO73ThDXyUKphle6q5SNkuDxCsqYJJ2Lkkc6c2IT0IbagOGfYnEgiwvAR1OE9XYXdGt7h8gdqp0T7G2Wy84pwAsOXf40OM7yxLvah0CtJm2msJ6aMnkwDgZ4wm5XWEmJZSmz2wb/JDL4RikRsP5Jhjxd18sDa58wM6MkwWCk3Y66I6eRcXZNWUwCt4WMTO9CPZ+fcJJZfiuWzsft9QtaN6hScWLMCBSvc1nhCqUS97RQtf/9rJFmCW50DU2sogP+WywMnF6zripwxjmvNVmUYFqeLcdL2wt7MEIYK7FoPHCkkEt1bGZekz82ldu3U8g7ah/HjAjNtEwLKOQara6gEVPvm+cwhaBFgPwHzZ/KFw7D1LPLMFnIIdBkSUK2jvQDDD04sHB9yFaKln15pN1aK422kXKv6UwMCkzQtbo9GkING9vGp+U6GFC9iFVWIuzCUV5KKXtwbp+wkyNGeLPE6kfLq4zX3cOxkfjc795EuiS1KdDJOvFFn3JYJnmw/j96efNvkjtXiBGznDbbV8UVanEORrYf6Xy3kS4HLq9inzJYsvfkU9zZTuWWy8QRCEKAISs2yurvCjyrpo5M5LxF0MntwODfIGCWR2PwpndHUQHBI40wH4GS7wSqwdMpM0ChHvtY/R7gnYERHhyqgjBa7TE2vEe/pVg43LrpTDf3H3781fXWqpkU8O4QICP2fqq0HhIi4zxn0KoPGwP6/xFKR5HAjvAwTmQxrXY6igPgxV2rdWRYNLG5RVYsMkxem89emffaTTqftoPmmh2+KQsiWzZ3eKEgmDfRctPCoXzLhEVAhAhU8AGfN8IbSUfSQRJ+u3TxmLjNX0LmoiBacDK/p2beVpj9nxnfaiMc3/INfaZKLTWKGOJGK79bTXsp2nwh9qW831nH8yFDHrfFpAWiIn0RNAyBvDOnrWWDBCf5Su6boP2G9cyhWeNs97hTGid+Rp6DEQ5ocnr/0QGXhZLHBiZ8mOg0HEtoV+QffE/5zs4GE8aHu4iQKo/85VGj1bojPqtfHxe/Kw58n1stIEg2kS+57v29cPtXIIVlgaEg5vKeOFs2SagSsE8JOyeeyRsznsV4aR4ir0V7B2E5TLkfBxDafdRmDXANuwbV8cocRM57XZRi+/grIiecHIr9dAfw5aHTfwPTAnKXj7zdrzkMWBH4fxLMzajg/nGT9ncdPyTcos5A18SRgrAw5UzWyqaI+vcIFJ+60M17Yl6FeXGuHxhnKKDDB0vC+wZEeewGDwr8TPtoAmTx78=
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