xUcw8Wwq2vlNR4UR4pQjW/3nreRWaWYxqFwshWz4btDBvxJg9WhQ1MvIUzFvGpvrQjv58ZkZPPeHtoJtxovmf1QkzhOu/REevZD2LSd+JwaWss2c19xjW4zwklCj+60NfnVn3hHoEgtPQYQGgMiM8yJPiACii2mkAEPYFYt0VrDlsjqiZRLF5qtyTVUIRFKnlFQlTqIiol1W0CHUlnc4DuSUZPg9Yn5yiAjUrdl8MgtXsKUp+Xdgt9I6PaKmVyWTTtp6wi224DKK2LtVGDHzwwIgE5FC0dhFB/uUAfllxfQukbMoeBsIQjy5rhO7ZZQE7Tg9n3HzZwqZS1aKXpoHy5R5wgf/WJD4Elx0v5+fVd6A2ZtMM+S6D9MW+3P6uYJUJQ8OPBv+ud8zyCyEEBr2Uy6ugGXUbWQ+PnzYfJLpO0Kj1vy1uyI71zIDSMWTe4eIUjCD8lptY0MOpyDfkclL4P+lGZF6PjZSyaSz03X/l8LOYWPuKGWmO9424DVHx0wImMO63fpb/P3JCA3sjWy+9lpfKiBugHKFM8PeTpuEI64vt90QvMGFog2OATQbV5S1wN4PdKsxCyZ49yeIRsjOB11AawjXavLqI5/itnPSdmEqGtTya6mCcnNZb4HbiDvtl7NEEuZGFEP2/E9uTJmwq09W0wND9zGtwEva6SJPE/ClML517c4oBPrAHlH27DJt2BiaO3mBtuoU/B706Vtg/tMDmgj9nrxuNwGp3q6apmike75GXJQbRHB+ADkUzaP0nJR5zXqjLeczB4U1D96ZDcL0ORxLMT4+ozweYgVDdQG0EF4a0ruYHNYYE/g82LwbiowMiz0IS2TulC4BAeV1QWazX6jAB2hs+H6SzYf9XGchUQjtikBDTcrVDZwkBr/W+Vz7097jLos9vMhBQSLxIqwTuNGfyDf1Q6N3cbq4nRSI4pip5XB4WzvahIh2utM+9CozjhStK/bxDG7KX9sTH+Zazi8VbtWa8Grw3aBBUf5ZaHRdNkA/Hq4W5ZsdQezcDf5QTxg1WSusun8KMOfcFALC81KsvX98Rej+NS3GEdmtVFkl5LfpTcjJFl2DGPKa7hCqcil+DrAuUy0MqTcpSq2rY3uWGAtxo3ZvDV0QtL1UGiOdQHPmnReblAHj3MY6QO7aLsg+US1KHsX2e7oIziteR+ePGHO91DaS+RtwCwOKkvigkyEsk5nLVl9nl1t2qKEVXVMeCAsCL4/fWwF7hbUYvQhXbY7Q6JfPkyxUyP7rFfIwPbJULXQCkRrDifcrcOTto6+6nQvADxker5DqURMdPtfHrucXGyeCNTC6c2NQSM+45jVvl+PlYr+JQTfUmWwqzr3Xw2AJ24OXXA00oWhHaRM9TwdRu9NDma4=
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