0g6WR6oVN7u5yL9ZhcFYQ8TCC5YzEDnI7SeLcf/f70WB9Gb2jafQxh7i7ymMzDTUCrAJkwjR3F/EsDFjTTx0x+iLAEgaDncqMGrzKKjpmMtgfIx4rDelnRupiWgJfDXn93k+zhRVDL1XB2ZpCqzRkxZfO2Z5hl33sVDsmA5C3Duqe/7IVwvEhKDzFyia0VWv829RaHYWAzzYOQnHKoXGcG/P/vyUVeO61xsZDQnbMsliB8TrAjTT3cK30/cA9Qit2odczy8NqkV3Ks80bAlglqZuoX1PXltyuCVw21WAvn7p8vgUbPvNtYK0PoQqnAlXT+OlvD8laDAEw1X1cGbGXi0nzqGbe5vdW1lPJZqfVt1ElCC7+PCuqwMz8OrvbC1TUTHZaNvGQqJQNb5V2EmZWzj80T707VYOxxCC2N4C+g0vZF0f6D1NrtKKGZvf42FfSGQ/v6mm59zL1eAO8+dCG8661o1fx5eIzvqJfMj4sa5h6tbHjA4LUsV2Ne6Dq9KGV/fv1zUHUIWAJzewwjyK69jmyA+/baj3OhUhI6PN+DTpyuDG4O4eeNMJ3F+Df8V9Qv8u9oSKqdCWgFkwmVXIwAbeT1EwO2toU05BX6mSac3GlA0F3GqqA5iXe7Z8nauFV0Xkq1ERLRKfjc4pm3qV6wW6qeIE6Md/4J9+AOVlmwGNb0cIasfvumrwiv3qZz7s0s6hLJb4D3Rzxwd+oYPPG+7I2Y/W88XscEoPnlQJIvrIZIo+Tgl+grljJgOTgpk0ZCqglc7TRqKOrWbCr5oeLNnMy0jg3LQgH1k9eP0P+I0d8OcGyt4+ltbHAfb+ij0RjHbzM5koSJgWn2LYNFtpuHh0lNfIrJRwBTCOREECqdBQNRikrRoliwN6Qvzjqk6m8vYGZPgucfuSXnQuo/pOCGQa7iILZ3xdmeDOBaZATEf1z11VFSpEYBmZO8wejmVQk0T4w+cZwXezzJOkO/S9ykxnyVw+2DEPFyceMggqVipyGgvxMu1UaSgF+T/7k+HsKp1Mdr+xYgMzXrT6IgVpZmHOykv2BFZEvGBrZ6ydxC32sETemxSMmhomhXKp5Y3fU5kM7PUR23gRtxYJ9AyyPYYodEjROIc1VoDcFpltBy5fAqckk0ODdcVeBtHthbJxIy6y70vrevLD6GiUvNSD+ynrq1iB6LAoXy8BU7MGSjn6Rb6tsGNzTJeuyDa4J0/ytw3qft3ggrEH3/KTNAuJdr/D3InppSHbOJFSPVMhe4C/bdSu8xJjHWpFd/XrYZahIgfaeCUjk7GZDgkuIAGgUxtDXuVypXH26H1ZmVr5IlwQS9rRNlHQaZcwbtf+wU2tnMrIsBc4V1btPob8VNDPuMz+/Bv1w8hvPWM6fMI=
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