w6RUDqO+Sako8W4LmpTPYFBVuVS1Y6XD2Vil6WWq3WdNp5MC/BBI37qdDFlM/UcXfl3tSvBylUAb0ZfOWBqlQ4o+wxTmBElIUGEyHNmSSBhqPTF3tpGdc+0g8y//1Z8WCIcDXjW5VmxqTeyQTCSzYr18XjfBAhEaZogJAcDxxkVFDf5lMmMbkTDU9jzaJxs78+aZEQedKZKD8Eu0wgTDQIBFdi8PlLWyJMXK8gGTiwXkHUwUgxsRghiqEq61KyGqQNqop7jSSHk1lhiL38Dlay6CaD1o+wlTnmrGKdsiTEn2cUBfaoirLMyxDyr/myij/4tcCGsPvjFomDls0SKQbfKrEzHvXLePWuiYvoAmqVX/DXVP3z2RlkxIyD347pkAXt3Nhf/VGDWGUx2uZpJEoeLgpLtbzrtZyi08zF41n4WL5f0mZb8+wfEd0UyRMrnsMNxQ6+IyKRUcSNO/NCHvKClSpCVGzkTglcw2Bowv0Zh6nFxtZkeDDV65OTikRDHpBAwpz9OAKqSqF9qU5DyPELMTIOC9ExMM5N5zCx+0B+Htj71T+T7oOvLkckiYgl+RyJvNA+1chyI3+O1DZiUTwUT1Jsh5D6HPdYxAHXubBqvDzY4dWofNF615jLwll2ShalUpTw8nic9XQS36SGbk7kBDF45/vrGQuVHMAq4FgyB3lrtikN873Q6Gp0YA6Lp8Pr3t7K2L9ef1nmlHf3XYj9G/1tUETYoxMtZAy6rjEbVYBz8D3PC2tVGjO7ykocNtkMbspgUILq+I6XVtxjWHavjdad6a1Ul9IwhNinEOLfAjz76PZ2ti3yMTSxkzWFEX8/3sy1rJtl0IKbvOaScW1e1eQYgihbcAhyiVtK8L2Hmdy4DxjPIICSaEcj6QDGPHAP3jNEhVknpeyGtgJ1k9/AKICO23Ci3GIr8azSlql0H6fz2+0LIiPlJWK2qj+c+IoviCfOAzgTvbmqh7yIIpd0m6XQ5Nga+jc7t7yb7DMVU2eH1D10H2ZY/KkXyc3enZwG9/beGfsFAKAo0l9QGoXzOtV92zgQwy3QpFu+QdfdpviZ9VcoiDO4c3rvCeC14baA42Itzt2R94RFZHHm+hEOC1WdbIXN6IGjw41B67dkrZ87vzQWbQgxgpXNgkiV0q7cIe7W+OlxGvpeeE/QU1Ea2lwMvw5Psisj/Jun9holPenLOGx54vHaW2SU0RuZhuCd9JEvkY/bRBjbz081xw1FQ0TdGH6cQaj5A1Ld7Lw9C6R8HhZWHXMWaYSiapARNfxslaW5u3ovqZDTFkybGzHNiKNqkyPl9IT/Metfbsn+2dp7HyHpGd9Y8UYxJCb03LS81Z5KfwhTQdAbHNxhO7hUwYI72bLSMzwiiYsDY=
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