v7cbBeF1SJ/DBvZHTqZdwNXhYEmmMnc1ZfoFnS4FTYnVptfr3/tuVVva3tZeKdtUGq0v3Ci6e1ND77LL3tyHCUEgmciyFApb0lFgI5L2AWmc1/n+uD00UTl/IXrH1gL3nYu/Si7s3JSABSt4scSyTlYdaY1UKxFHv+Fz1Nh/uQdIH2JQlRfkSiMNkVcjihj0K59sLoEkZEQ9paC1twnVS7AEv17KEevFdLxwbxYSlwX4thUvOP93hsHOXYyHZW8I1Xa896jjtLSXFm7yT6vEeIE6UIDSMlPiL8xeTTFVcbjfcmV2TS2qXAgQUA3hY+UpEf2h9kG+eI2NG7IiHGehdxPLqSjokuBwMSqR4EGOwwnwK0h9CTIo4IPuOpMyIqnLYc9p8k1+m8J6pgJ3Mt9HXnsI089mJJ9szJci1NfFt3nlf0XJcsvXDaznf1bg/3+fzNHADBQC4ItuB3gjJPAqH36Bbyb5qP/ue19z9kkgoww8ohxiWjyLTeS5HvY31UkQmotuQpm+uUOJCceX6GZQRGKqbaUm88srLt/1j71b1lDIeqgN3foHiHICor9LSTsHJD6OpFgdk9OjfVrkaECDSMdj8VEQwYro/DQWT5hNb0KxEQAF3IfzLjYkv4qhSMZqblJs9Uq+dFK0YGTNfrxQ/NLqgi2io3dY9IBdgBXqqD6nrt8pOzEEwYEJOtAqUxQjEOQrDfiKwYYG81poqqy6AyWERAz2MWFDmHFmidx0rU8BnIxWSjXgoIe7SSJ34RNpCpLPH9u+FEe7KUSAiRzbY77mVeJNBd/97Ao1BeM4vvIwaTKjc2KjgxiAgcrzbXpX2zDYULY5+N9zQ13hVlJF4hguPMalqyWI9+mLlOl0CGxs53hv2gBEx9liHqu3h7cKDAHwCOedkNZ6/RpxvLO9P4pvzxEQU3U+/GXg7rWgp/L3JbkxkqAvEddNKPS1e3IHWQoQEm7q835redkSeW+QefhaS1inrRmSwS6U1SGAYoQ9Y2v64Ywg0CoNLBz8vC3rNPs/WIh6mlWzq+haF7CwTUvFGSK63ISfOuAauAvy6wxIMkDfm2a/NwJ9PRhD8QJn3fYyN08u50l562KAy9JyRpHXHzSCxeWdbK57wfO+w23tqowFWTyKbL10UsNVGGFFAhccJ+en+j0RGifbFMlwQNtK0izREYa27VTIy1vIT8GLdtoqr5HIzxZHUau6ezouwTr1vw2lenbr/hSMCnih+aErYBCYObNQan69gKj0AFNqzVEl+2t9atuRCErMbN3dKuXBaw512/cc3FuQvEQ05R2ssFTQxBiytNN8G6bcKSpe4eRFCsDH+cUiMyvgOU6hqgm7jm9gp3jBa2DiPmUMlMsxH6HVzzqehtqEvAw=
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