2H7YRJ+gzYxyyEd2/G00HSGj1JYqNAeXG5ugeDtzV3AMn7es46bwM0I/FdAJW6d75Dtc4TXXSMZIf/eP3jCSDtdk8OIR6azZdYUTbQE545IpJdKTmrlCS+Wt5/8fHMYQXZiEYmkaV71B7kQafl+F4lyKSp5sywNGB6AWALnKu862n1DfBmba627Xf0JiFPlq36Ut0H+TVehPwfkuy3b717YRVwz4/7iVcpb19S27av7kVlumdgZteR6KADUGzSMgdvWXYDOrNnECHYU2jnLbTCWaOU2q1I8t/mG82zzc/lVwXG6XDfw3IWULzCOkHpNAAA0y1eW5aSfUYsgMTSiBUjJ8ozyrT+A2pFG+J7/0V96+6GOO2ola6HhKN5dBn7EPAVbSdlZK80wuaX9CZeU7pNENoZDF/RLX8O0lAufqCwYPfweTnOyHLTemxFnV+5bcXoud/opYOpq59WWwNWBHVa3oe33kJYi0w/e1AkvQgcSe8WM/SnxNfk2cPcLH1djzCZMuN2tW7hyqbsd3wmjoIgnoJW5eh2lLyEqUXOpVKWWnD4pNtm1VE52yFRIXDY6+63xY3V2CftfURN70b6BtybS/kTMI0pdL2CKQ+yPVZRcWPs/jImC3d1YDHja0JE2ygNVRxPWhv12XN/UXlqpY7JxOS+/15u2Io9C4eTXm5gNxav4XONPmCZMwtaDi2HP8NvW97hTOPJLu1ZSgfOBlee+Lpx0ojfJH2zYTWo9g8GPON7mV9H7zhkKCjoZoDr4lizHFn12WO7G9LOFSgszc6ukSJrIT0nh70koJ6aK1Oszd7G+EuWqlFRjntKC/QekrQcsdL239kwA2nn5BJl/iELANOeARk2SQW4ldcqHgm6wM6GnvdYqFusl5STxhzITjVDjffSX3FR8KYRTWDE2bAirL5ZAf/QQRAYiwCTT4geFb0LsLLXlwFPpW7Y2cgybPX8pOBXlSEbO3M2B6VqONRDAZ/gFXURs0SIZn9jqzXtZw8cCLAq3iFgqeqO+/G0jKh6G7LH391CBeSgwjLKXwTEfPZcCD7ZOoVMk2muoVxp8m0rab7qqp2XQv9qCTck0IcsK6asjGxMClwyiz03wBqxm2ZeTtePevYs1nQ0Y7N6AlihsUA9rIvtHLzwv8N9ZoxUELoXIrI+bPoiXLsjkK5fgGTP3sH/9ZK9H7rk8Rc0Q/FwMhOHHS2wQ+zOawz4gR6DW7+OWDgB4jNJeOGV4rExEeCkDa6i6vBg5cfbniWTIwdmDB5cfxHGzR4cRELgLJ4symq2Mx9DYc0zHb3k8/eVNjo4XnZhti+cDzaQUbRlEAX8lcna9ORJu7vmolYLsSMO21yK9RvodvNmWOKwyXuBQlmjbR81qacK1GCfQ=
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