LhahOcMcr3z5GjTde2uy67XpnLNNLt+Gm9mXdJ6rrOSVkW+mn5SASgvZ/fYfc9JBmaXzZVdEHWocmDDzJOi086/7YLm1RqnoX8prz6Oesqz9EGR0hs/JfGTZoG0UK2bsYutgMhKcHSGDuuSzin2w3h6m6ylkNFbIp78ItUGKEXEvfaz9wgxVUU1xGXZ0zPAmnqCZUXg/5BGfgWOcfQV++CUdZVALGFuyY/9C+U2LdEOaq9SaWCaXMP59OT7G5vXhNgNYXWQXfVD+6P9yAZUNHZ1PB/FNll05xty5HLeyxsf1QscN18BoRLYobHz05jBv1niCBjIGGXQ9VgORaLvMYFaLp+nbd5lqDBMtyVrtLZlMchKuZN+d5ArYEs04XoIxiCK8ndIrrpzcPjiwUsuoMam4VBWT80fowfmaNKCV0pbx1U88jE3vV1RJFe/f9rG2b53B0+B9gRKYgAYnDiqsJY1QpLSJmjyg5BOkedBsAPJGKtfj0ym7Qwg85D/UQoji5c67RbMtHfOF20bbHCbqdWKWcRMXbt/eGlYNdvpbYBrjXNe8G+Qb+nAIDuPUPKhqCBisOE5VTe/t4dyo96N/DVATwVFKFR0iKqlpwGluERicN6aiVRgbSoKeXPFMMNuKHA3XeicFxBChMnUHDveLfbLGkQ9p1O+6E6p4Z2ukpNTogL6yHn1gJ2qYtyAXBtDqslYbdckFK8hCfrSdoy5RhnUnw7gRK1PxUJcTbYcldpIrnjQAqfGy53KVQcampvsipjoYFhQvltwZzB7eGpx0hHuBBsIFE+RYPNPCeJXQh62mgIv/F6F/adgq9m0ffejiAq16fMURXH0dwSd7DbkS62cXwJyN1S7tXa1pvEXirmrsXvI1jlXPVaJdVRyAmH2OwSdXgCYK7L1/zVr7Pg/jPAbZt+o4NfKyP9zsfjXRhi+gmbAkNsw8RNicJsOqCXPpR/UhoFWTa3wA+orXN2NoraK4ptm4pa6TiiBDGaDTBycdDccPaE9zThvG9zsLOt5yyySRKliwsjrm7AHUqV2wnGuSH2rw9pWwGsjkZik/Yk20gjwrdCpHkLr7T6tAleE2l6KPWv3YW90RXeXkvZF3thMn26sSvkZDq/IrLxxo/nTqcMROGyF26joQcOV41/Yd4npoS45IOXpSnCfquWzsne6NykVPBYSciE0zuBreiw84PkElZuLyMjuFctTsCS/X6VFlbGR/Ich7ttc6KFHcjmeuVySuUxJ0F5E4ab7mnTH5qMhQ//WSGJaVHO/wtk80CAvNGuOth0Id26t1UD+JFfRbzqcmgeIzpgszjo70WRLQqcIUnF3smKFgiYeekOyw9xmQt0oFOHWbzcMMtjd2icb96J2arPby8UbhQ6g=
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