IoOIrH88HJdWS5cnXZhjop7/A7DbwJGoOP0E1hh2ZqROS3v8MVDmuGXAjnma5FFbGc6Yr5JjJwr8Bgc5g7tJAFQQFNYm6+NVUp3TR2KcFvHyIumNpSUaI7McrdvB4DcuCHGnnH4ij3rZxb/aEtfzjEiv6eeIfyVlOpjAxscb6TUoV+AsXChOU277r6TNQIh+7Ewz/8QjyI/7mzWe88BpA2npCcu11zyU5FNaSCHcn3se4AqIDjoe4XW45anpg+eIa4fRP0AGfxcLuYrFIbg5f8rw+gpGGaurKSD6RujewJeQdXTUn59KSAwDxUgPSgHjwo34JMWTi/HA1MoSghA7rkx/j9tNFkhueCxK1AJCgC7QdyClxxeYssgsMfxTxcDsMqMZeFTW74pjU6UdXsz4UrCN4szTi0b+sIr7PPVWhTHcPYTQhSAY9f1lhkxXarkXtM1yIMq45lYSpA4RzYq60CGE60R8q0R+FN6Fn1/PjMVlVm+gdSxnTYyyDSghnOosw0oFViyIDo4GjXFj+0iNRicei8o0kWmRMsHGaOuachuXyU6WUZ4CDhWdHOdBN6pIZE+F3wCs+f6man3H/R/7RlzhOIYpzoI7a00wgpEpB8YOTM1w5XWuGkA/rcjPix0hsjOAagz64HseVuUY08fAQR3rnhB/CXsNeK8EcQY7WnET0rbMsfojZV1VZd64V9vNhUSsTHRSnEJo6Bc3whfrMewfxetcL7X/fLxkkXwvyhUZyIlmHpwFOHugkUfUiu/iVkkC0hjrKyw/INbQ+HxzQFeeArhSwH/+TvNhhtbvfmz8gVFz5kg+d11OC6QQIa100hou4HpcKKo8uhx+61w40MDPNTWMv7ojmMBx48w2XvNin972RLpLGPAfOsdcQzSsB7vh++51IjQmEPISiq5LFL+g7hi//Lpc6GRLeCz5Hloix6P0and8jSQSp17FHzjXs+cFlwJvuLtKhRtxbD5OB0UWE/CVFJnbrMsDYp3qkUrbxlj3o1A0Tm0B/Upa1YefmdiHxmKuoPbEu3kvv2BPxuc/z2NP05bOFvNzhA0pZeKm7MbzT2yhEKzvENNqKIY9Nr1jHwAG1EJYIdI3YV7MjeutzDi5qxAJZw37mWsVigXTwRQapZpgpfMU2Fq6An1kTAwF7D5BbGZkXDU+vK8RQTSWDvnEh72m0OpWVN7omc9vfdra1a/TlM6+SCKjmzC2iGaq2R5Y8+tPgdTPuddFM9nJkOxGA6M/FIfK8hYOP9L8nRdXRk42r8EQCf72w1s1lZIxDj+NAaxWor4oIHUIyANaSNt1I+cVU7qbyTb1mS3qbavj5rGMTIvYY0roPBhNSl8nhl3IBlTu2hLmjK3hF6NsWpCqqJ7uFdPTMrM=
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