5L0UgCq9DpOutFzy24Pd7+HjQ+YcF077K8HagSopb3HAgY6+nih6pElRffQHlOKQMu8vke017+4KbBuaLAQJxcy198YCAZ//nFx6jMawd/dqG2xZyEMsP8ByTE1ofAN9YBNd3dXIJ7hJRWzoK69Ivh/aeAxxccZ0fZC5ObfW9CNxUchV4gIgnhgYd821iu7S7yvwgA7WNw3GFIhP0LeN06k2Aagbi3y3pwkmcOqcXwSUl9tmdmKe7XqQI8MyLnAz6w8F/ovrEMoex1dHBhvoE60MBCoWttWPO2CIE+OA74AU/yWSFWzGtPYQhu0IkCfmz0xNpaFKuOcCbbn/zYMTHtX+leWi7PTD1C93QAioKiYhWoZU1ZzmGxZsEqjEcTc4FleqLIRV7kn7+OIK/A/7GoBb4V65dP+rasK60xNPakFdtpXsk019j47SHxxz2Gg6v8IgW1f9ZFOwTQg7YySYDfN02Ot8vvnVvIv+RkiozOO5HbaPxsu4T5SWcXkdlL6nHY0EoARNtk/gNB6qxTlMeR8UzCuxUg9uVXgPydP0oFrPblOqRkS1bt8peOv5NtLdiPvFaOTv5f4VI57p/zvyyKeFhgj2IhpNKMy/l2EoZRXlF1SA3gBT3GMySbUscRE9Pef4AB0q2HnJOKOjb3yOwVj9dSHq/L7CrdZ/HfAaQW49XBMAHuXzz5du5RFhK594BKLmg+S20U1Ukfp2CD144V4323yur/cAJ49CK/S0vbP64oPDIPl7wknMiuAOXzUcQEC31reQH2xEGmV+TfEP4YOGCMweysg+0KVnSDa7KaUeiDaKF4bHuBl9ZyLb9Vv60yZyrNrG+1N6rdTlifTmUCJ/Xx2KNxjRWMwlmmbcH1+iJGMX63ICIcwA6/zsghjCaz+2tL1biOnyw3vWBTpP8ANQ1ydbCLArWd1h3e04L9jNMyo8MVsOZvDuHSVa93L55Ul70EkgjctGUgpCZWjYj0zkNKZxPhEqq3EsnM0uwIIeFMLAcki+943tjQNBa5arDUWsy9PdzLyQv939LXBOIRdt2jXFFINUprdcRgxqs379Ww59kMAcQ2TCxpr3XARrPDczwSWfMBCdzpqsJaO30iIApVQFFoxNd9LAxii9FoTlr/dx4a1caUEY++TsKNohwpuMWWXw6Wjs8ACypxhT/VEgg3I8EjzTaeGHWzEroHt4VMNfEuFMrkZDWxv3cfRuCKY+nwjVnn33pVjldtwQt/2rBWiAsJV6KiWx4emshGIhWjz00PfhuXr/cmwpBjGtUjKSfGER6Ai2y9f7iT/u0Ec/NktM1Gd4kTHHSMZ4gfCKK3tsCClmah9FaQeP+P7UzPjEyZU3K4Xbae3/L7oA/mGDmYlwAV+kYD5JEJU=
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