query("SELECT c.*, (SELECT COUNT(*) FROM persons WHERE category_id=c.id AND status=1) as cnt FROM categories c WHERE site_slug='person' AND status=1 ORDER BY cnt DESC LIMIT 20")->fetchAll();
foreach ($categories as $c):
?>
热门搜索关键词
query("SELECT tag_value, COUNT(DISTINCT person_id) as cnt FROM person_tags WHERE tag_type='discipline' GROUP BY tag_value ORDER BY cnt DESC LIMIT 30")->fetchAll();
foreach ($tags as $tag):
?>
最新人物档案
query("SELECT id, name FROM persons WHERE status=1 ORDER BY id DESC LIMIT 50")->fetchAll();
foreach ($latest_persons as $p):
?>
最新科技资讯
query("SELECT id, title FROM news WHERE status=1 ORDER BY created_at DESC LIMIT 30")->fetchAll();
foreach ($latest_news as $n):
?>