0Z/3BpMZbYmHbctUXk6uoIYABYg6hvlIiwU9geAhg5G2RlRLSdUK1+2j4RHfOxkQiYLrDuqPcKisXPaLI74EZ6OkUGLq9pzK3hbfcFNKTtA01A3wvvqQHYJ5iwJgG79o+Fm+6RDlBx3H2gdYvehD8N+18VysllY965PdkuO/zwGIIArdvBmjSnK3FnkK8gxZz2jmXLUnsXCw9nI/4wDIIi3EkekuDsl9kt8g/GJ+SVbOcNVaBBSSlOsqj1KePg15IPgqPeFigzMquMZblMh8e6iKXZG5LMv0Z6e31/3gNLzLe7hwE93t7NzJI8uTDLYw3A+VUCjLGZalj06GZ6I8EwwfGn7nDqfq1TwD3J3gTEPT4oduEGuJ2IB1fgIGar3WjvE1Snw7FMv1C6vcZU20uz10aRbuGM5L4Rfj4ZSN1f3gTfeJSfzYna1G3HNCc8xyad9gcCQMmk3DV/zsF0K/2zNC2BCoIgtSUQjto+pZgARgZFkcG+1AGtxR3G3uP4iSEhAEI+rdLGiSKeAj8qDPnDmG4PKnxAN1k9np/UEO9MVI03NEXcJcReR8AnAX/31XzYtp4NsY/vojFTkT6s4qzvvDM2ICUT/bAdq7NqH3vBB61M8/cdOv7Sd9TfdzXRWP3dh50/MH4rxoSVpZSAGLHNm5/AeQe5xrCXKDN6Df9GWwTLSrMTbuVIzpUYrzLfM26b9N2uywVGmt6M2eCCkbrag0ugeMkBIrB86ZDiCTgtvBsQJzNvDuBASFIwHf1IJ2Cq4ps5eRYTNMtCP++z+CIdx6stjwaHL2X/Wfq8/nBo99DfXjv8SKVlauKyXkkRrD9R4gGIDITBtllV8ipnj9JtR7wYvsBTX1QOdcDnDtBX1fBSxAZBAxqlJU5iKqVCEK/7MIT6hJPkLst0H+dueaBWGLYbyT4u6wegprp9ry/Yyvfu48g2YBA1E4YTlJVsYari+EH+nRWGz/nsgOjMgRkvI4fOzZuWrg5cN1pPU+T29mxEkrXEu6Bjlbb1BEeAP+mSTRoX4G+lVkRXYpp7ELmjiCHzcFZ/jM3POluf7D45ZoOd4kjdZVxjEpcYnBMyVnJdpNN6Y8nfON1Yyk00Tup5Y8iF7oGXfHFTlhWaeauTGj2M3EKAIGNiotK4LBNg+a1TT8qDjHSZ4x16LbIaiELWoPmnCrn3nnGb67A1WGJUF1FDFrUrEVxwaQwz8/BUsydxs9+l7Q5V2u66dsV99qs0kTzoAGXKJJi/wmARenRqTBgS24lI7z/69Mk3SIyaVt65QtV4JzFCgwgx+8f2v2+/V0wb/AFvA8WNy6Eipz8ytePvWz+ZAq3O1sB3Aqf4+TlE5pdMxsNqjdAwvsej1UHYENvbvHJVi3J0GGVlI=
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