UNygvrlUXH2+d2Vp1AthZ79z/xm68fHMFZwN9hqsZZOUY4WajUKA8R23P//2L3fYsbR+XDjFuERcjiFq+0a67WNYoGnJq7k7ynhTUAB666W/jZvpcWXC+ez4Go5j4Ia1GOx2D7ftMtwjVgCOSviIPXNCsYWi6FPhumyQ+OPnn0HD+Qo7Jjvxpq0EUdV1xi72R0qTvGHhpIhOyBtYiFyn35MlJV+ne/SgnEEfN2OIEggJEEpwG8i9x4GA8AWOSw7dUfjBJLJWaKJ+Yfpxa1nG+KrgrBPSRoQ4X0LO9JtMGgR4AeaC+q7zj6XCeEumZr29xPibxJXhXFT2x7kD5UNURgkBqBuUXHNL6KPLbsnnOZEWAE6vtFMDvil2HzMDdDGmu9oDk5rfjHz0IBd0OppLCQ2kjErf8P6ugow5BI79H8ZuVDkhRK9qhH1yPl/soa9EFjy2pPwRpRy/UNrqEniQrBnnl+yPwHm/JU2FVgT4P+VoMVRxvoQEtbyIfrP48ZawneXzQJ+RmMEiJEd3AgfWp1V5iOnF94Rh4SIJJkQJsxdhTlUFG2b5VxScK1DkmXmL9dLQKRlnIaNlolZ30p1kIJZjbfVbArrYgOCca6ISnLwp8v+1ZZp9Q3N0sC4QY96PD7P8fktyHI1tMuJOpk50WdicbR5M1Hl01vK+tJTxY70JvUBtLUjVWcwxGqF/f+SIA7TAPPQu4KWfHtQDD37aN+RPq5Qy04FKvmk5raR4GQf2ilNPgRhbMnY/QGQKXKGzTYGFaONMXfvGRQoO0F7SJv7xn8iLcqALIwFluhrVwB+7+uM0BV9jAMa3WcbzFxGLk3sSWoiE+6JvKEbA0oKJW4c2iCcqmbODC1Bm6qXzYmBqLrjLc27xCvjA1grO359YYb8WpaTt9f+xzPnvzO+kzg1oVg959Ft0yUFUKnu6PYkTvNe3GyzNZIE4i8fgYQjll8IRCyqYUIhauUvyFQ3wSvdgyMmjS4FRgq/ThegKisnbeONiYquT9iqglbLMxhGDJqwOxKFo+B5CM24pNTzf9fNkwzuViRq/eEMbO/1cM2Hnt+CMwByleCa59eRXb3LKLEbjCSILL/Z8nvI2VbME5CqNau4Huq2QztPCQsKAURpe5Zj4R565J9j/jlVcUKcROVYQwpp65rsp6EC9BFzFQYC5G8lhUfOlLOHSR1UlBGdHJI2hrkDWmXzq/4KvoSdEr6TMYJ1F6WwWZaGR542rr+fTx1i65cDMrMsiUZE9TwX6yUaVqInc05ipotZHe41x9rkiBpAcvWChdm40UwdyPgNYrLOfIUlrvz4Bp6ay2VYnWSgIjEjO+GSOruKOsJ5yf7i1t22Nm1x0zbMl+ojr60ceDOr7PovfQZuOCmQ=
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