sHnwkJi402SltGPOQ8L/yJuG70uHRLASxy4bzP8PBS1ecrezvHkAvxgm9WWIhA4DAvwNEiejdyPArXKelGbdOPT6G7Pj0+ZFKoSCaEKg/VO8ECxR/M+TQNwP/H1Qo/tBJX1t4IJAUqy1QrPCPyfOyfW6g9Dp9l0c7PkHC9UleM/CT0ySAsDLjUev/wwfXfQEfuL6EkhN68DvZOESjH2GmWsz3oaPprGK8XEn1/Bn3MA7O3H4M/L7yBoPK7q/2ki8q4EQHoHARjpmasQkm5LLy3FZ502494pihtgYk8k6jsvdMuWQ9Z/8W72h01wfueId6mEsaXzWh6610RpkZLDCq1nCe8246PtJD7ucYNxcyuXGkA9H0uECZyo4nQxbjG5eCX8GOn/QNLeTECUkT8uSp0uq0cYRNICX/iK5BIerWRoN1vaJXfCHYFJjeS/aeIXFe8nrRVpPyWEN1NYRydEfM2IUckUpUotTdJN2bpmMdQKReSTMX2Tctigcte/0oKm5PNnHVdKO8BM1khiYT4CWUPdTkP/ff5kSM/reFtO7qeWJ/QunFBxeB1U1Aqwlb3URKPo7fA6YOZZZmsCHz1EmP0P16AX4avdcejCWO0dsa+QObAzDUYmjvPWvy3sYCQMBvOgaoYk3xHYH1Lwl1UjIfLMFy6CQW8908CLmIOxZ1cKd89JItRBRbwfSXFlHb1FSqPJ5PcpUm36rNU9TtOeAml3QA7Dg8PY0m9I3Z+BFj91OV812G9Jwy5R+jwNuuiuUTdRzzt1/QgTUfvQKdApLW1OSQnCcC8TfRBCogO3kipbsJO73dmWhibBH/dhUCob+OYKZJHGJsCmRY9gFYHadakAumLSx5z85UoWcw0InyrHiJiDBqyYZXqMzUXeZTYgEUZtiqtVK6iv9ILMFRjAPkISRhL7k/6yQnFJVfr2kqzKUxhr9irAsHIxZOfiq8jE1ZQEcN+dOb2fY4xkWsmpla4/E3ZggVpWef/eobSuaK78shcsQvXwn9qN4yz73I46lCuubPSUqeSoMlDk6Dk+YAxl4j38q38DI0ggqZSG2wAwzle+rr/j5wNImzdsfVn5eCEFwzoQaUL7WzfBnvb2nJ4oeWZ+RFSnFio7oTXYz8Wyci5ixedT/0klDgWda6dSye0dpq39aM4WPtdYbXRpKxqgGweVZ79041R389A4j2GZhx0M8984oFBVQ+NMIFFsG7SMmX4zc6i0Pu1AeHYZgJcrxwFD7pRzdt0h+RYn2NmAT01uBp8Rnq95zsAOrbwBvoCWsXBIKSgvL7v7p8i8x9o94n9D/pHHG84pCLZ+sxRFJhKuSucVU5SR86invgwF4HWt+o6Jf/2x1WslJ37VvbsTtMtrqeUFhOcXpXWo=
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