sPPRLAcKmgWQV//CEO8Xg8wFzUAQJDpDqzLGvwmLp9HeOGbPbYJ50QAHyCZ1YCn2kqpGcNwGTsflKUSjvNVRRSjqvujDipR5sooNzp5K2uKAqOvR72VDVmyINEcqWHuUHT+iKWLSMlf8D3QeCGIvUNg5m8aSEYtS0KOMf36VR/AhV+qsxzEJ61yeKnqR5BF28usj7rlrKnNtYraAHP3JVczK79aLdwI2g7OSaJMClwvbpVlsAclJkG9FgsfRplb8uKzs2oWmix7ZOJtPB559eXjSoBp6n4OWDYoDSLYJiEEXYIsF+q6cngkiaayHCwPLAswzdoQdZkM7onXTcolI5NHxlxgJLv97vRT/u+ykSw+lNX8yvK7eN0cZeo+DJMuZw1KMMBzmUV8YH8797NsiqKDnDwoggl4KpwEhqtADzDuOIGBjXrRVWYBAhX9AAYO+wNodXLDJ3NVEhEFBSxHxJuhxv7fQ4DfjrPa4q71/4XGbxHwXHOUZHpYvWuyrw03VMvID0o1rwsM7BxRMniJSsteDUlkvTNY0doWVO2WV5UREeh4JMCKd/lQ7V7mhgLnX0UHFwUp0UXpcrDS0LudGRWJTXDPD7KQn86F7jcd9etKBCQLn8OkSOr2kfm6IBy/zEJquk1juTsT0zc71cuy26dYBXHsbBwYPoB8RrUYnSND1cbzv9giOsjUBnoj8BhXes9wo33CxhkmfUZfBlO4ZWcDBrNRvRD1Ole763jcRWsGzYnRHxA+dxX63FVqHHLu1Iroe8XX+Kas/t5eZDokoINB6Yx5KNogNgYoBPPjV3JhQVhNkJbQos7O/oY9ACtneVHYvbOE65xALLOCVLBzbwVao9/WaKItOCgJSyjD2dOQfdd5kjqIiIUMQDK1Z+WK70FCuWA53wFwmvNq1mW1hSkEa3R2V3CQa13zl7rGbyJU4oOacfrG4SJEFOZEHnX1oFMKsnWppJ9easdWsty6gmh5Lo2pnO3nV7LSalPRnceMiGyhMOv4ZBYGJXcF53W/4Okk+caPdECWoMvB/X78pHISBotBN5aBR491bBm+v0kyulbImItr5zJEGuBWUKybecOEyZUhuwkt5dZIrGBuva3W+GGeaDuXZyAugDu8sp+wIZutVIqIfLk4QrbQUAHbrVqOrk7/stAZ7mcSR+YW09+dXW1uUTK1aTGQsooBMkvCrvpp3vUxGvif8IbeS64US6XxW87dkrbu9r/5iSSuC9oGIbcKcbuaQ7BZAeFAnz5XIK356lHLzVn0JKauNyPrxepRz738rrb4XATkshgGCpnTCctDmTWB0X4MDZHiCAGFe9IcD4V87xDTpzYvuTeozUi5kbvQQ13tNQiCgJMxZCDa/+pOjoHYcV2Z+U78=
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