8aT6MaiS/1pWEeKgD93Y+MqLuAnZmEp5q6iSjtK2iL3XXhnTE/ChZ9eZbskAqpcEvX0FIjSMScHtslhtIB78GeAbvgh5tBjJRJJdxxeQuNaqkyYZpd3G1ZMahFI5kW+0lAHFqOD+hcxB/akcpAJ2Sri0jrYr65l/Xk8xsK43DSR0gZKklXers6FoHwDDavOrEg7VVEpYktwb+Bp7Tv5lDtPtmXjmSxedAKhKKLfVJ0+LU3YJP3qkqkIDu7MDKED6zDycdRon0/R6/y7N7P9qlvdgkrnzcA67oORRhPTXBYvRnM1yfP7zfDQddd/359KCbvW72nz/BBXonbbapkBa4jjOmctC/0yxqB4KDa0r71wPT9cwbiOVHbRKhe386FP3H2yRUIrChI8ALlq4ZnpZinZ6pSKkA1ei/CFxY8h/VkNpnpKJh0bJm+RBWPKczMMnfIjY47IM1pYKRyMn8e5lavmK0+cqjGG/8SDon7Lp7mhIw+vHLrBk+LfAEf11MTjF4BNwcKhP7utdW3Kj5W65TqpIOFapgnhibn0USGZRTfO6ni93dDSHhtN96518bCUdxKqsrkjkc+Dz+QMNNa7wxgBSWWhtlyekTh0su+B+anHnOba8DJsnhevsHLZ3d3Nf+f1ctwe5VUghaNcIs00wt/flgFTSpJ+WZrCFFkZvaO1sdJyAfZ0CmcAb/ybNojkKfcgLqKbKo7J+xWY9kp3/w2YdSaE50cLPnUOiqmErpfLwsXjWeUC4OvZZGzigY0IOhTaYEBCvjWfUtp+wqSkwyb/++2SJfa7fJVxfjBRJwplgN1N65M3Gi4hndBemBmpzFdvPIV/dZSuip6Uce+FfokPDWWnyYCtprAD4gBWvikaem/V77ButKhrdOo+ZEQcwmVtiSnQclw5PlK0B+m5X6udsd24vJ77nJEj+sKr8PLy6007e7JYWQ2x+wj4tBfUTBK0dLWwLFI5/EolpA6kWLVwx9NEMLf36XvLMcLSfc+4Ff7kFuiaQxqV6L56UeThHEp+VQ8O8DzOShAB7SYsjgjWs4yKxibMcSNlyw60ntm4lgS5SWD+Uk/jiugju7OrHZvJPKxwgG+P3Gf+p9xhtA5mirBl2Gsz9TS5Z23IoXkDBCD8gyRWPouVXG/FehE8P/nwrN0iCZD4v0kzvSEUlV3cVsDntPCYQJuPPEAJ5MFYAOm9ib2Yzvn3e0L+CgKZMEQwizpG171vySTRn+1nf+/tkRy4SQy7LmB1pRUMoQ+6R1cNCMNaQN5rjNxTdHo+7NetXL5T0Z0f/XC2MxO96SdoWiAPz04IkNY2+HcLpJE4arzDUA0SJyxVG5T1cti2PWvyjmBWFL92WB5SzbICo76/WebJtNXw57AUftrw=
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