tMXE45qe6u+u6md9nh3g7QbyB1B7Jujp97W0tdNJETWp0TjH/skJw7KtctpbldTTOno2UC2UCxpeNJc9JEFIDjAgl1mEBGNLjbrq9DrPJT5jcj3Hb3IHEVXu4EK5q/ISC+J5xiaRswYW7PUX9c+IC9sS1doFfh9AJdKhBCI+QPSYZT+J/3TRZjU6piI0TaLo9P/KS86Hbh6iYLsVpdo9KYJgKQG31E8UfELsat9saOCUIIQm2kqkRlwJN5edwF3ascTy9oRZ6+jEPCMriYXawWP3dXpAstBsbWgp9dn/FNmkj8XV2CRYO8S+RaNOexukwSLWZ0H9bGyBadibpZRCm0PzyEL7scWPQ6h9FHZqRxpnxIisOm7FbwOQWf1wjuomxyYcbgScILxTmptHFgdymlMgHfuNNoHSaOGRlpbYVxTSZijDkJSHfDwpAbXyJY68M33weF39TTMbEPFk0LVej47uOD5JKbh4Dt8sN3BhUoGka+VbjwULm2/OBr13JJ2vLj8HAX1ozHO42umCAppiuV9FPnzr9AsHk13Zjmc4RobJFznnj2bfBd8s16GnOuvV4PVa55BjA8uapj0AY1H8Zgtw9XHfs2JWdu91uDVM3A1TQ1L/CUG9E+/ZVxdfrAiyCgYqZ15vqZZPsXszCYydCkK4ENZ0Apbahkz6aP9URlAe7FaSGQqpcxzjnmxw6Q7QgFaKsVtq1OC8ul+NQ+iGf9dq62shzN8GmRimmS+GV2hoXGjghPjSLctwQe9TRHu1OI2ciTW9MB6vjVx7HM0C9Wx/JL1F8enwXZG2bDSPHDuJ/QPfv+3C2jeWtL6bKhsWC5rnU4e96g4Tex7HrlPCYbNJNnI2K9yyhKRrFFkvnxXbojHy1zT0D47BU+ErQbI9ziUWdA2noJVIZZlGqV5Z29jBthseA5yRP3z1LCwWkANB+bUVJV1+Iwohci3yraTsR0P0ycQ56TYobeZAe55xZnX5QcrM41v8O1hWRVfJQe4RvjWTtoyhGel8fbtE8jZvlz0M12cRuDDGGOKOqbeu7uRgP2q9B+YvPLM8h8wSr8PyjvVZ/5RtUqP7SZWsOMxT971c1Do+6klM5Fz7W6AcQg0KFUNBOqd2JSmCtzeRsTy884i+Mv721iEOvNqDqsjofilebhviMtWpPs6ImwGKD7y59fyViQKzScRNc6cMYoKjV1HB9AqIYPm98XOPka7+2azaGkSfVQhNY9w21tE+9SD067NgBHZsOA9hWAoVFkW4El42zb7xwgUc9eICRoCXDJoAyLsgy6qd1ZfgoAsoATRYwcJiyL0xH8q2oxxCpZT4fbTBpof0PwqmVXgUjCRHe74Crov+uxEMoPap5WiiZ59wnfBM2ta1iZPsgoc=
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