摘要:
1.group by order by select siteid count(*)as 1 from webdb where gathtrime between '2017-06-14 00:00:00' and '2017-06-14 23:59:59' group by siteid order by 1desc 2 in limit select * from sitemanage... 阅读全文
摘要:
1. SELECT COUNT(*) FROM wiseweb_crawler_foreignmedias WHERE site_id=90000 AND (gathertime BETWEEN '2017-05-01 00:00:01' AND '2017-05-10 23:59:59') 2、 SELECT site_id, COUNT(*) FROM wiseweb_crawler_fo... 阅读全文
摘要:
1 SELECT COUNT(*) FROM wiseweb_crawler_metasearch_page20171214 WHERE (content like '%内蒙古%'or content like '%呼和浩特%'or content like '%赛罕区%'or content like '%土默特左旗%'or content like '%托克托县%'... 阅读全文