wOumRKZyG+QzEir8TmwZZYxKo74KYE4TsliqSsU91lvSn+rhB6dKw4hjvG3kozu7jQ/Slyo1/8ymRqmSlWUDm7SpHNfS3DN57tmWe0b03jguB1GsmmVKUIzUvuizARH8M/jpngH/jmPHKlvcewc2ao5en6A5/TLNTmDZHuBqnYcvD1DBF2FHUyAVNuYbzSsYVFSLJpU4aRhoy5zNL8OK+rrgQnq684CX32SoYGbj61sU9ZFLZyxCR3LNF6h4LrDpyjFKN+hRXcYPzeNuZl/ntZkMl0w4iD0iWw6FG1Z1udp6uihucy6t0en87TLNrxL+TBF94ElteBg/JQgi/AIYiCmd+yF7M+pL0LDD4dHqNXhzVKOoDCCuIU6HLh1hT5FKe0Sc5CTqvTAneHnLxkTqW3sFLdV93uKiAEVtWhFJ/8elr6J0+VuKSl2aBvIfQUGz0Sb01Ciy1PCTCJ3COBz01NkFZaSaQOcrKhooA0bizqsrXdz8v06xy2BDXxmDoVJHW2LgfqcllGPGkJ1XWoTFVpcGz3Gy3sRMdJXjs1wmkQDhEVCljcdsQyFEv5I8wdSN8xHujUw76BIi7WmJoTPCXO3ZFDFEHrYqoURT/UfXmrs7CZctUzassLUNf9aH6o6CLIjf3leNYQ91uXIsIACVU2tXv2xnXpV0lplWWkgiDvpeUs/2GwGHMgZ28f4aPS3gS8W7kVobWyhMJpsjX3Qz+v2KUSthNQBeJBohfKNWT1qTcaZ0nIf9N/j/0xWNzkqS8rOZ0EJbgNBIJz0+c2yO/2+ooSfIhiBTtB9G3Kgxl0Ggf8tpUDWUu1eUKZCS6h8skm7aQTaJ8ebwytH/PCKkLe8ldLE9+VdXSqQLL/LMHnzvCZRwrnXGobfj0AVKGBLWPGNA5oa+8PZ7lMcf/nmd9CYt9uvC6bQghW/98mVdkq4GNrkOi0ND34NcHWTgoShNW+uEIe0pOljKZuDrtyPlwsW+OryRvh4WZkU7OlD/Xvoy/fXOmgqz5CxoPhU273Ui6Orp+XWr6W2LcYCLwraX0KTDrroU6iuXMx/beCjJr05/gRqWajgUGUDJE80PXr3k/AmhCXwgdOK7FDWeUePutyq9YKiNNMQRAh11qFrAnS/Zs4RxviMNBy1aOQFssFv/WehuWf4p2fTwJhOVrEw+58bE2Wjorb2fRzRjVmVt3LMilJd0qkMEd/QB4um6g77TtaS3gNY8EeeD9+xsGd+MHOjZ9pHa8xe5DKTg/8I8ZCzhH2gE2YjUrfDwKK043hASLTO6JmCaUzLPkz2Rk0x21jTGYsdzHvHBBXLbeWf8u7TGKMoat1hNiVxukbF6OPBLBG+4aeYmh2voc6LY0fn5YpFi9whDxnqIrHptYs8=
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