agJoLWPiAVvpCaOb9U1fd1JbQbjIB+8f2qXiW+VBahO/7suA8v1hJhCbQuU0qncS+7Bgiv487qpKFaTV4E6CJDTeh+OeDboYoXfuoUSSwSGIh+wK6p9Nsd+KOdWNLaTFVErSdbvjXxJ0a4Y6+a6HTb9v0EQHDd167ouahn4L5WxRbWCk5F1FgAkmu2KrcCbqJTbuYXnPxY0weySaUloXUszADJGja2wLL2qXo11iJKMYoucGokThTsnL0a9KNBqbm8jOZjs/nKQZ01ilalu1kNF8jXF39U85SDU6CctP/Uo0aHy3+Kb595Xi2VknDnXGFzP8HsEtqltlsXW2J+/dXKz5q1jIJRmqg0pd4VKEaudMBJ4TeihhO4gFI7qSllqu839raBQKSuD0ni6zzQRbx9Jan6DgcvPbBG4yvaQHJwKAOqQGoS+G5hRLsOG7kLnhw4qlHQDNFYJDWWzdei9dxqmqwPov0NmtSpP72fev07cYZM9Ytl9whP6G5PpOkNSly10qwn3F5Jse7jl+jfs4eOXHJbAgUOW8SgvNxHfsO0p6jqpFuw6T6cNEBSfIusUGIGucLgBZZaLya1KDKCY0dGLZCs6zB1oyE0H2IncggfsQ0tqsbH4yQf2czjX9fLUh/3Z8zYhwkkW3o31hIKS/LEr5ALcwSR/sE5r/LQ+4/P10vCmInJ0PTBWLPFXidCYlNWCZvWvhgkh4jVBt8Xj0WIxspSgfj0LBa3yajuvGKd+jmMW4J+u6rxZA+z9LA7mZxRzFaC0Sz2pN0wZZB4V2prDLlMJs7sMOWFSGkue5FF8R9saRqE0DmumIqQA+6VNxl51poLKOHsP7Yq1xo8kwKmG4R2Gzb9TyzHqsljiYO0LzCP25s6q/u+0/oPI5NR1X208uQbUCspTyhr3vio0lNpUqwBSZterrP3WM7RJ9baC9tlr9L8c55pY7crTJhctZS8Qwdyt8IaOyoFNaeXoZaq+Q5G1HkQcEjF1Xy459sEDGv0s4jTT17s7rcSd4lbHDmemGNNAIsegvMyD6A29PzSpl+rf71HANLs7vX8NuTSU6fvHCvZn1SxiPZrrueD8WUHggS2VYA5Spwzbf3cmXJzhKHAn7IQkF2NSFMSo1L94XY4WqLXFF9+bkKM8Ewq0HMXqP+pKDvkkJ6NKaPZ7RXZdPivYKpUy06sSCC4oebYB5egyNrPWewU8ncwa6gic0WcyYhbh8OUKcurHZb7E6aqaqyj5Wb6ID5jjVMQC5arWd4M8/Bj5s+8nyK732I0omgtyjox739aziOZX0gI+rgitRHIc2AY/3T2L2bBW0gn+gHYa/7GyYasKa/qM/SGW5H0fx4lEztetQe0qkRrWouyHe3CQ3spfRUhOS87k=
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