VDOoQrceExlMRk3vNOX0uJ5YIZaxDkZGA+fZ43FwaXUZ18ZPHjCCKCdaeWTyolK3sluGSmiCdB0GadD3hZ4F/dIVYi1+qJeoGq0XQd0aFlB7NwYDlEcC6cSMQ4j8neVWHz1fMMXLaxaF/q4YT4R/NUgz76dOc5YtpXr41D77SmLl9bbOJVkEI6GNT8KJsNkOR7jx/jWe1OBcdDArUDZPmub5IIdAh12vTHsaVHW288yQJu5kvi4MYn0jhbzbQSYa25kAE1HZ4Rdjl6302dEPw35XwwnkE0c4VjSkvpYLbmo8VLTLGGqnolh4tC2PwBR2PsapRVwlkK7sNzvzvFiFPxfBUBf0wUqQkoAhtaRuP09LNp+pAYGl/SrUaajnob2BVEyHbwuiLCiYXarPBxYKa5lR6ACt5QMe1D56i3pdcbM8ELk2bL0MNGARNLyVS55piNxWqjyxbOoCpvPn5SvFtyX4vNFOI2YcF7QFJDN/ONpK3Hpog+B8REF2250M97YnVmSWVatwZQU3FfJaY2bUdtm7Jqp+T7ikn2xDj/Zwc7AAMvq65K09hJRxKBd/Z1w+BrllHi4CzEwjeI/6XmmpmdYxaRxErdOVBVQji57OFBfXz3KaB/QWmNhobYXcZrS/5T6/zAC612QcXZOqEzQ2f1DKL1O3ot6WjWK2yWFnLfQjLzyNkbwlnxxkba9bwzc/6BGjHiWpM7ydajFLSKEDPqR0rbxMZvb4t/zmN9TKrWgnfsqxS76IsPyM+BnzSXmhOZOie0IguzD/sUgvNdA0YoGi7+4tVba8VnUC1lkKJmSKMjR28G4JS3/46yuEbzeVdhHbj2/wTI+AHOgBWZO+5h8SFSY+XV0q3n9MGTRjT1l9cFGdmZdrZ2oU1GAKfti46A6/+ZArg2t/oe9/O6iETCJ8J4JgezvwgNVjYWFsNTCw2CGYuVnuoYd1tuKPVFC3lmzjCtYh6s+pavurH1v/kLKmKgf+JmU7B41VfinGhtMvvr56ZojU6DlW97VCe9LEzY/koQF7bC16b3iOxpMMjSK+DH58OgKgMc9iSBbA/JF5fXQ9Z07uzSQ/JsfBAEPKs5/RJOr7LTfHdcGmlWQC/TDKxAFQsLBAQsFDUk4xAUwp+Od8CeONJ9YS4Q6hJnae+9Y2bYzZyqTvsMzUyYGXKpmHySSzWIiy/rn0WKcxzhschSzuqJEcBn0tEpVknIcdCao+eAwzjzmOpabKmAf5sulg2cnQ6uUqawWgJuHlXLt/FlRaTUWwV0PvNsF+87IbLCWd+U5rsUqDqhoRhN6SwPyq527C2d7l9jqvujgv3xsP7taVGOOUbZaXJASWQGj28E0kP0EXQkckCCZ8igcaVPGu6//eiG/B+AWdS5Q=
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