Kafka Querying SQL Query

1. SELECT COUNT (*) from Wiseweb_crawler_foreignmedias WHERE site_id=90000and (Gathertime between'2017-05-01 00:00:01'and'2017-05-10 23:59:59')2, SELECT site_id, COUNT (*) from Wiseweb_crawler_foreignmedias WHERE (site_id between90000and99999) and (Gathertime between'2017-05-11 00:00:01'and'2017-05-11 23:59:59') GROUP by site_id limit the 3Title:'иртышпотоп'or content:'иртышпотоп'and gathertime:["2017-05-20 00:00:01"To"2017-05-23 23:59:59"]4SELECT site_id,title,publishtime,gathertime from Wiseweb_crawler_foreignmediaswhere(title ='%водная%'OR content ='%водная%') and (title ='%сотрудничество%'OR content ='%сотрудничество%') and (title ='%китай%'OR content ='%китай%')5SELECT Site_name,title,publishtime,content,url from wiseweb_crawler_website20170718 WHERE (title='Public Opinion'OR content ='Public Opinion') and (Gathertime between'2017-07-21 00:00:00'and'2017-07-28 23:59:59') and (site_id between129494and130357) Financial 116886-117064Financial129494-130357SELECT site_id,title,publishtime,site_name from wiseweb_crawler_website20171024where(content='% public sentiment%'or content='% Public opinion Guide%'or content='% desensitization%'or content='% data de-sensitivity%'or content='% precision Search%'or content='% Portrait%'or content='% Wind Control%'or content='% risk Control%'or content='% Content Management%'or content='% Big Data analysis%'or content='% Large Data acquisition%'or content='% Big Data mining%') and (contet='% tender notice%'or title='% tender notice%') SELECT Site_id,title,publishtime,content,site_name,url from wiseweb_crawler_website20171201where(content='% public sentiment%'or content='% Public opinion Guide%'or content='% desensitization%'or content='% data de-sensitivity%'or content='% precision Search%'or content='% Portrait%'or content='% Wind Control%'or content='% risk Control%'or content='% Content Management%'or content='% Big Data analysis%'or content='% Large Data acquisition%'or content='% Big Data mining%') and (contet='% tender notice%'or title='% tender notice%') and (Publishtime between'2017-12-01 00:00:00'and'2017-12-08 23:59:59')

Kafka Querying SQL Query