pdhXczbNTY782FCvtc2U1p1DQGLDc/sWr9+KI8xtyKlQ62UvWUJgGV0CwT6XBwx9RF83KJw3gZlF/esWSOKcLb0XUTJr2HgHV8Mc/t8gHQlRU8uLWb4TsfBPYcrwpEmvdI4zQqUg/M/GFd5Ht/vGVgK7QXBRpgIweeRHfG18GuxTkO7gP0MSq+DW/Zw5nal4B9ZjvOQCImjJNlkWrgDIBdGVbIhJnN2DrC5bImPRARQuNe7r96Oc8KrCRoKVae1VZnuc+Y/PP58JQ/tdbSSN6SeRZrWrgUMPTbGApRBfA8v8cmjf7sFxuZC7w0x8Xhi3l3zW9ItzQK/f3deiuJDw25GXBEb+OWjJwR9DBYYLPPIEeF95CVEJtAJ7JPgsuT8+STkPMmYR+vAlbM0rGvJyDJWdP2lJO1c+SgHIfIqsRK0QFPJZEnQj3E/dMpoCL2WX+IOtqYmRo0ojpGH4SXti0S5pMcuhdNsfFyKRb0zvywLq3KGVOVtFw/2y1AP6ukL3W2eogpah2cCU/hoBfESbYfKRPQEiLr1Ck4jHIRhlaGnOlwWT4xJpjCjRWlMAwPSi5cLa02oGp5NTJ5+zE6Vrxj9X7NssUM3PT+p5ysZyYo7pEjpSLC8esFpBCW2ITumJv58q0j0bVODlH8fap2U86n52Ys7jPpKbCEHvCyHm1ybDpwNXvCg/MTXFmC6ysUz8cZwVI2ASbTGlBx2GcFgjNDhR5akSVqskstAlB6l67tp5gRnqsFjUgj/s4/Bqewgpz91r1cuP40Tb/orbaGMWbEpJ3T5UmFxjiFq8zdkP78xMXAheskYZe1F2OhQHbGW/4JxDIZ/AR+RMPHkonfAalQKsFLEWe+5GQz0eR/yvsUuEgEoj5eApbBPXLpnARlFmpOQ8ilku6mGA3/eXQZEvSRii/31zGjZ1Ga/Q85ZMVLcqi8/eJlWh9EAZfWvcfyJreN8ZZ4hxAG3hQs5hb7/Q8HGK1grM3oDaINZ4IFpCy2Yzog7d1SSbRYlBxrvQcneVf0emHqVHkkClUIBRO+cEg98FPgzoSeMVtG7Ta0Le+b3ufIGWyQ4DBnXIDc+CzhNx9Am2tzxnClZNYWHgCQSwIE3MBFY3uNKcxYz057xmph3DB7nxZVejKxwHytAILRTdeVAx34ZLfil+fKLUMHO5nIvYG6G2UYUGwbGTgvC9pVklxc3CJoMh9jSGIW0YYSVcWSgHMbv4f2mxG62jHrCjRpKNOMlgo0/28LZRVM6FOKnQXtyXpk/J28ZjomW/N49e41q+C87NLzJvHvyFy+JaXpnrmN5YCmlIUxNostCklKGiD6h0GLYHk8pidGI1rAVTkBW9CloUSyFv9Mf53CGN/LU7M3W9iL/sYdzRI30=
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