5GHJFj30NzbClNaMp2Kthq7FIm6j9pQzZ1VVCPdDF+mgUVSdg03IPW6isHj2PO98+cG/whs52W/A0E73DR8jiNnoGZe1OT14S61tqSSXh93ej0NrlrgwV317+dSf+itoCNzDur1zBREqn2MHjIo0K9uwKzxzlws980ry9297RWRHHBVrd+liTHgWGjzLaYGY9g/oqjEJuLSCoNPuvuK1x9iqcDSAyufOeDtYoCr7OxdeTXe1eqftXxKky3XiJ8Gt8CTh/PGzhTSHjeVQPFDSAl3cgfA1rsBjsVVE4/UXS5eyw1ZLOuJLjZRSgBkjRhIZE3Z70KIGpDNVdzYqB5yNLxcErLJMA5eI0L6ffdeUAhEm8a9uieegJ5AsrifAzHrGUbsCohQDPufSDAhL2bcb3FlpHzaMXDeX5FyfBMrKmCQpAyOH09Mj0TztqDoSfS7DBePogVMIR2H4e0k6DC4TqJCk78ugWlpImCkmvVxYxOp5bRNjlrcx6tGMIHh2vZtgIojnJBZsyw5DshCgVsR2Ops354rq8rrBPzz0uonhj9j5sVvFN/e7Td+769OtbjRIkelqGS8qfffo2TXymM+LSM0Xt2vdBngp1rDWE+3jaCKiH8pgAEPcWUpPXWhY0mbmeLFnvoNr1zS14Z+HLC40b37llfGHtcvrRFwrdJAFxmxVGFZu2P8jZXKd5p+/aWMPK2k9JGTAUZ2o/HD3nzHIUtsFMw6uCIJt8w+n/UWN/gwWhu3BLVMz/c0fhZbeYmMZ4bXRaEN9e7WqWBSnzZwnkcWpnVR1foowsqIZ9HkfpXr8fHSAmXzBnz6DwDzLYqnuzkg8eBPqeFZ2JexCALgxulhKVYsuIRLqAYdkwrBHEFFV4NaBAL2qOFlCpiVAXTJrkweKJPs5aBdoA4Birt8eUeA/h08kkdMPtDp4+0dd5PyWHLUz5th+g/poRypoB81PytmddnpAVQcMbLBlpfHqQSuH4A9C45v7KLUGSP+RuHKv7OEIIqBgrPwuqETJOg6UyyI5x3bIB/gH0uzk/Boc3MXg4pVnqpO+4N+A5ZhCT8vhdQ/ZG+05TmantFai7TTJAoSs2ziDSPcOAIz+ebLh655U//RZiFDSmzXOmwcouXtRwCt+88JEQn5iYOHLf9NOTbqF4plguhGlkotrVxBQtNA/qgg+WcfgLm45Tgaf+2kQ5ab1yCHAj6CUn/YIoyzBFpw7/CUhYEW1wQNVvDugHmxefKS3jnb+HOxXpZqTd+8nRwPXpQXidWi3HvLke7VPYNgpUuNJxXd+tskzV7UztEJXOPuQwwpnq8xcmiL+B2B8gz0nOi1wyIGdLyShSVLXksn4eZARw9HYHGjNY78pHHhCcMYXNPpTiIjQ19c=
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