SELECT temp.account AS "account", temp.name AS "name", temp.join_date AS "join_date" FROM (SELECT person.account AS "account", person.name AS "name", person.lx_date AS "join_date" FROM /univ_demo/person person WHERE person.status = '在职' AND person.person_sort = '事业编' AND person.staff_type = '专任教师岗位' AND person.account != 'ZGZFDX' LIMIT 0, 500000) temp ORDER BY "join_date" DESC LIMIT 0, 10 WITH TIMEOUT = 6m
/**
output()
count(10)
**/
;