SQL:select * from knowledge_window.urls where host='www.enread.com' order by addtime desc limit 15
ERROR:Table 'knowledge_window.urls' doesn't exist
SQL:select * from knowledge_window.urls where host like '%.chinadaily.com.cn' order by addtime desc limit 15
ERROR:Table 'knowledge_window.urls' doesn't exist
SQL:select * from knowledge_window.urls where host='www.enread.com' or host like '%.chinadaily.com.cn' order by addtime desc limit 15
ERROR:Table 'knowledge_window.urls' doesn't exist
SQL:select count(1) as num from knowledge_window.url_log
ERROR:Table 'knowledge_window.url_log' doesn't exist
SQL:select * from stat.pv_date where pd_name='kw' and page='kw.anoah.com' and date='2024-12-07'
ERROR:Table 'stat.pv_date' doesn't exist
SQL:select
a.id,
a.channel_id,
c.name channel_name,
a.title,
a.html_abstract,
a.image_url,
a.html_content,
a.view_type,
a.indent,
a.type,
a.language,
a.refer_url,
a.source_id,
a.created,
s.name as source_name,
c.subject_id,
a.author_id,
au.name author_name,
a.teacher_id,
a.teacher
from knowledge_window2.articles a
left join knowledge_window2.source_school s on a.source_id=s.id
left join knowledge_window2.authors au on a.author_id=au.id
left join knowledge_window2.channel_data c on a.channel_id=c.id
where a.status=1
and type<1
AND a.channel_id='10287'
order by a.created desc , a.id desc
ERROR:Table 'knowledge_window2.articles' doesn't exist
SQL:select id,name from knowledge_window2.subjects order by id asc
ERROR:Table 'knowledge_window2.subjects' doesn't exist
SQL:select c.id,c.name,c.description,c.icon,c.thumb,c.article_number,c.grade_id,c.subject_id,c.created,c.hot,c.count_subscription
from knowledge_window2.channel_data c
where c.id>10000 and c.check_flag=1
order by c.sort asc
ERROR:Table 'knowledge_window2.channel_data' doesn't exist
知识之窗
