Ka6LFvIgTwIOkp5aBtUHFz4VGcgBuZ4NaiJloGuuEDSoxxvhNcIDNM1pwUDLu4b2wW56BGFaHoxx3RCjhU1TWPkvTYjzaN52uos74/260zCudYDzSnqgS3p18Mk7xWq6xcMDG5kU0iW3L74sKXV2TrxB+h09Bred7Qy5LMtuMJEd84BwKaBg5OidC3fVBO/z9Sy3+Npcyv/ox8Dml+XLryfwq5L4yt4Dw9BXTLFtn61zm1Pc36D3PE5jzNuzVVTZ28whRPGbAzpxxlTWjsUvRcWzK+RIE76jrhkPIpTv00C1stRyyVOSBLveavUiy4iLbnhB2RDAprGeFkA2fR0Sx9wSKVDnj1TkiYo+gAHL3ipUHjw89W2I88EVk0QNv1VBFIFQdx0q2KeYr0+z1tIpoCSve7lidwpEDjFjC1YlKqeVmn27z7Ph2wvUVgg2TjX8ynqODYTQ6T+d9/3vDCvK4RfzIKcn6nIjDTRx+88EVnitXNkuG1M/tVIZ0d0uy25CvsfaN6OY+IBVG+i0mi+06Zsy6oNK7ZaDikg1Um1N8Q/ptcuAh+9uNtfcVZgI1P/9LAcFsSzKRMpQOULMec09FklDSwwBXhdCEz7Nt4C26RViS3Nr1rvOIXJrrRIjDAt+Va0O2LW0odSRvMxZXCcRpk3e8/zaO6SgH1RZGGuEqDqB4zduh9yXqyO0m2dhAGAUuTnNQwWBEmnesk19x5gim3ZNDQbSoMXI+ylsxarPJmF46eZ0frhkj8j9LuokreDf0tsY/nDWQXaYx8Tlog5+ZDtB1ya8iZFhuQB1Z/2eSQ+SSV77aSukMW1E8YzRW9iuh6nr4JaLPlXCoNzf+BihTbZm2CMgqCjBPwqPK06OuUAoisR6WpJiEAJD18EZu5tS0nPN1lvf/33J4cb1j9NgXI+Yx1gX/MRsn2pMHXtVyQQfUKgzwksh/JNznXiJ9RQ6xkxIg9/xld/oPsi6qTmTf4pFkohRpjcVHI4wF6a6/sX/7DyeakqTBYuc/unhf8I26iK+mDrklbYP3AtpQyvDSvLC/JNKRGKrRzaOF0KpJxwpSBtQ4cdodoRWAC0bzbK9UmfmA/Hn31JmqGcQQRjuibxECyCwmwEbufUA7O+GZ+hd3046kPoLRWXeD26yBw6uEJF7yv6m5rIuQg3ha3stixcV5Lv1RDu2ajHx4W/Ej0nKKzzfa+DGRYVo3Y+FdzNsySW8KLKs6D7kzZ0uTmUrnHRt1FvntRT1TuwHWR7fUpDdATV0pGDA4DYJ/wI2RSwB8b7D7Q/XjqpaeOhc/Mm7BJ4q3QXwwukCJ7+4WYz3mufEVzFIVTvqeKUQlxJuGSGVQ3KD9VNzb3ROzzronrR7xIuiq4NIbNE8s59Njeo=
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