IPjhUmTHpwdIFkVuMRth9YlDrHdR2TF6kjnxG3t3slyS1lvhmudlYGW//3ZjUYcPKc1t8c4rsMlSE7v/7Nw/bq2L2Cfy1Sq+HdYGnSfjURomKJwtN6+PLBrWYJjbVg/SJuAEAwP4xQ+Wg2KsuCuDLAVN02yujHYSVVZsTSu0ZjVx2cHC9D/jBYs3fu54zISjeTtXNs6yGlvyVW9HwdCr3UHO1Mnp9GS9GsQzfvWQXMmAWqlPPf6WpL/lKXZ0LKrtEgfE+1+u5x8NeXRS7sshytgGdzKKVr4CJYlUsSexk7UBoS2PWJzGcS7VXhzlS9Ax6molxblY2IrBx1UMFOyqPCLjnMMqht9b2VCu+yXUqQ3tiI/uTwEKueKuGgduGC3DolhVgXRwdtFDcpaBIrWqu1X+IEKXnI8U/bZhwCOXXX970tmL6tp53EL5dsqlfJBePWUKhRhllg0D5N9719Gova9HIihLBKnOSHi5upXc97Qlh1gqYmKPiz8l21tcHV8RmY15WCTyE/fj01ojdLD7gAovF+gkNuFDaGLJBz2iVpJx3JR4OZk2In4vyFC0Zg6wfUQpoowxz0JQ8x6WXB2wTXx/mKxtaUK2lcYbWmhqwGHwSm0rA5yREoI9zRX0OpEvfUr6euey++DtO6pTuTOybQGCo/rLh4gBC3wnymgRoHnx8VdzU+mQUhRkkYqRIEFLMLMMCoG7oZbp5uMRmBjaravUqX8Zon76wYIxzDAaXCDmP7ZZQJ8P4Mt3dU94+dQi5xYCdcU47csC+TyXuaPHP2k9Hxfrq5S9UIxPROZY1DX+DrWSUkK4Jz+mEWuH+tlZzYZMLN9Edv/PsofT6tgKCzQggxZzMduUaORUuPg93L8rAQmkgA0Wy+kSBXktO9VZAm+IrpPQ75vIIBPkxulbx4dYhgBVrnZjZGr9t6XuAtpxLzzYo5P2CFqS+RuNpToucLcazTEcHCzFHOPBW/iWR8fJrL4umbCWvF8f3tqtB+kgI6NLn3o7vVNpUhd7d9A3VLZClSKeJe5FoicGT8ymSMMpG5u9RVwCGG7BNBz4UVT8DsTUrPuGkFmxQj+me2dU7wNOOMH5/kJalKXJo959G8kZUnNavGSvQMk2hSls253rjhdi/ieF0WPLyuBBBHX6eg8EM+1pOuOxo5a/vpojoz0Xp/+UTg+v2Pu234VcIHcpzCmFXAWbYuWOxJXDJUCAWvY5N22WvfqKu4JcPeKIGpquAqN2AKejjTrGTgbDHtKxJee4Kv7OT//5Hw5TG34rL2/foe3DXFE3iyFHVgx23xh68+NU9tMxBRlpAKvwbqZ3PaBVgdztKLNVcSfroBCH8m64VA2iZ1SEn7sCviZLS5Ar+1c+DQTkW7YpWCo=
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