v04BxHSHrDcEo8+txY6RoHcdQ03s6m5257MT2PrwhcjyvgxqGmtAY1mYRuj23+FXQu3myb7vT4tnDsIV/pvGnKjcdrKqPrScSI8eyVq9TanQMk0lK1+TyGLrUOpkd+4fdo4kLvwhDeZNXMVMCLdAFKOM5Fa8p0x/ecFQASBaIgkwfYCIvr5O78582BJ7yaQiw97mSll2tqRCPqynVxz2CCEs5vKsTNYEgSZpKF49++V+W7BQRUg91FRIqqVVYRDnKLmOySIIUCtYiImiR5VrQKlVebDV3YtjQXu6eU/Wz99PpbHo8sBlu9prs6yEqJkyZKpXYHUsSLVPEYnxNdeGqucChGJHch83z32W74MB9WwYeHuoR3Cb0US8/cJZeoF3P1+zIMKJm8HEO/3vDricJCutGSDBxw5a8E8zCzVCxrdPIu2p2wplpA2WXOckDvES7qweMgm4xoQgJ3qr1Jwbeywxkdaqp7OFhYSsDbo/ZcRK0PAPLiEnJ7ifWRBee0Fipa22SxpXdaKwIiOeK9Sdkpf3sx7U2cFzSnsW8nWtw3PTN+/MLM4Laaepkmaz05REEXbIAT8LpmlLxhxyXAXJFW7/EXiVu359p9DGJT7ufXxKrOfa/VYaTpwG/Px8pAeGgghpm2HtWPrtpF8vVf1yaenCSlTNBl03W5jKZOgj7DQR4/7GVIEfYINoboaG7+PxyNiFTYhVlDQo70OCtijMpRtfUoDHs2EsBA/Qtti4SX+TEmDwpY0Dvw9rHJ+xuaNOPHEWE/3jhjcucJ776glSYgNFJkJ291yoHVarZ4wZvf+ffQdGj2v2Nn+pazmJdyOYWd6CKDBmQOrxRQ+VMISd/nOnfYvt2R90l/rkgZoYoKuEWUdPVqJUVJkzeJgNHtswBvoqaAnJ2L9kdo76VZJ/ePeND0yqhNUm/LEyiDgrLZJ4/Eo40bBzpDPdIeB+3iQt+nmL3GImF+ISK/rm7/IMFAsL5HjxXmRaQM4fOyXMHzdmkKFcykIUI262cx3/VwNJAuqVjscHy1rzSD/REd9KyoMkDoXvKjVJkBdTvA0yGvbVO61sztRsAH4U8k1aqhoVoUswrxEUN26IbisBf9zFUU26ygXThEt8tSTvtaVaXF0gAgdEiE/E87seSe+rwriqtq/zGBowUn+P4EJymFxJsWRbZQYy48/vxLzF7hpi27D2IkXR6DHNrelPeshqvFn82fV7y1HLDenRvpX7HXzJrI2Dj0NMMn62qFmfeMCgBA7EZuX+6Hwiu2LReUVynbzM3FZEaCScEoddz0nWKEeCzafpwGBwuibxXywYV28EAln1t/LuFQT68lcNDjL62R7/fNsdgCbuVvZWL79BXn1a+ccwiIBsIFbvM/aNcx4=
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