fdt0OM85gvxw1VNEKRh93EyUfoYosvY5QzSUJzD6+nynj7Hb5NoqHNWxJar89yKO5JFEdUOYnh3rCzJxALN9Hkr3+8HrkJ9DaIWRZtXcrnpEVOriSJD8REDAgPn8eYlmjP3YzLEYWXd0Tc4/1wUgnuQx1QcpWVVxJdqgeW+L/sIKHDwyjX2utTziXkvBFpST3jC60GdqAylw7jbQPGUJxKa1i7/pXCVJbIACrz4Pc2c0TTAPFgGA2RG2bcgXWEMPAAfdiF5MYE5RITc9dWfqfirLrC1tkiVNSwd81TRQqalDiHXQT9FWVkJXcZ6FpVVtz2bMfYQUSaUYSDXGF98diCklryKiW+cgW0CbPrVu17SjTzLnrTT8hrYWykxLEYph4MZ9Y0urwiz2TxxX1rwUoFkPy4Qr/tBHqA29VNoyukjnZR6T2Flw+ljVSFnZW49BopdoubRPCf7FfjtZj2DrW7DxGkgeUt9jV/bJIJTX1X7welt2LSVR1XalTa5bwsvhyXtgqiG89QWIpSTPdwliRXsB0ZkQt0FXGHF0/fdg2DEoJf8rN8RaYHAy2MI4w5r7DY+xQV2HAsnKnHjvxGlQAHQrTtAx47/zQYzLCBhBEK43IZGCWSbaud7riVSrsw65s0WWCLRGa9RlXsrtC6pydifvW/ScVApOxbBB0Hnq7NUmvwsZrQbik0zxUiQ2Pswz9yCsJeIy/eWmVwJ7LwnNcTgZJbleRPQDx8EOZjI48sojAum1Ql+qIVQ6fVN68In4xhbLSh2PL1X+e/E0ONNeitalsT1/AUl8HQ+bpbdQondU9Fts6cWZ8fBlRrVkReDIEOeByqQheHUjZ81U6w6L1Zl+PxxyKyO8QbzcVpxEwzH67U6pbOwm//0FJAP6bwxgAGIMFxa9E1JT3ylDljEdFNzWX8Vaot0a+tkywEC/VwKQp/PAgQC5mgPVwap41EyjR3ZNdcCMSRFPTj1G7JwKPXtvmbJBWhfpAVgG5EjQhEO3tMirbtJtvzLMe8r3YWVaAIqUWbs8I8J1lEIougkvEiVoS7Ph4z902AxbdSBnwEo+8n/sKZsusrufRYubYanC5xI1hqb0W+lDptVi1W3Q+1GI+YN1VdUm14NfkzhKwiSaDy7GswvPjU+kxZKjTnFuWQrmfWCTvnHw3qNNFuL35QnRDllQciBYBlQtpBBO2ElVL0pniUzYgQrFJAHvYf6UsdSDRmU+3E46DyD2oBp6FDVtPZld1a0Vxdo6QvkKC+ybrnXJGLXg1xpYznykgyb6U1v53jUPepLV3oXY1Xh+DHRAJi62n/qNNr8pqPiimhZddNl1jfrSPdULliRveBbpxwOWKHrj80/95/A0CsV2rinV3eIiRjFza6pQILc=
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