-
Notifications
You must be signed in to change notification settings - Fork 250
/
beijing-config.sql
41 lines (40 loc) · 9.79 KB
/
beijing-config.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
/*
-- Query: SELECT * FROM housemap.config where City='北京'
LIMIT 0, 50
-- Date: 2020-01-03 18:50
*/
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6278-487f-10a7-d48f79','北京','pinshiyou',5,'{\'pinyin\':\'beijing\'}','2018-11-04 21:26:08','2019-12-07 12:06:13',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6278-487f-b9a7-d48f40002','北京','cjia',10,'{\'targetDestinationId\':\'10\'}','2018-11-04 21:26:08','2019-02-16 23:04:52',950,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6278-487f-b9a7-d48f43','北京','fangduoduo',5,'{\'pinyin\':\'beijing\',\'cityId\': 2179,\'condition\':\'p1_i50_v3\'}','2018-11-04 22:07:22','2018-11-12 22:26:40',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6278-487f-b9a7-d48f53','北京','fangduoduo',10,'{\'pinyin\':\'beijing\',\'cityId\': 2179,\'condition\':\'p1_i50_n2\'}','2018-11-04 22:07:22','2018-11-04 22:45:10',0,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6908-487f-10a7-d48f90','北京','baletu',20,'{\'city_id\': 238,\'pinyin\':\'bj\'}','2018-11-04 21:26:08','2018-12-02 22:02:33',950,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('01382789-6908-487f-10a7-d4903','北京','anjuke',20,'{\'pinyin\':\'bj\'}','2018-11-04 21:26:08','2019-04-23 17:42:50',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('013900789-6278-487f-b9a7-1001','北京','ziroom',50,'{\'city_code\':\'110000\',\'pinyin\':\'\',}','2018-11-04 21:26:08','2019-01-19 19:23:53',960,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('013900789-6278-487f-b9a7-2010','北京','qingke',50,'{\'city_code\':\'bj\',\'pinyin\':\'bj\',}','2018-11-04 21:26:08','2019-01-26 00:58:41',950,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('013900789-6278-487f-b9a7-d48f441','北京','hizhu',10,'{\'city_code\':\'001001\',\'pinyin\':\'beijing\',}','2018-11-04 21:26:08','2018-11-04 22:45:10',979,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('0e11e2f4-31fc-499f-85b8-6f32ef','北京','zuber',20,'{\'cityname\':\'北京\',\'pagecount\':20}','2018-09-28 23:54:30','2018-11-18 00:56:03',9999,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('0efafbde-6063-4f05-bbe5-acefe4','北京','douban',5,'{ \'groupid\':\'opking\',\'cityname\':\'北京\',\'pagecount\':5}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('13a279a7-b7f8-4041-95b9-54c211','北京','v2ex',10,'{\'pinyin\':\'beijing\'}','2018-11-11 17:21:53','2018-11-11 18:30:05',960,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('1cc6babd-e968-418f-92ae-8918b','北京','douban_wechat',30,'{}','2018-09-28 23:54:30','2019-04-15 00:41:56',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('1ee9a122-ceca-4917-b8c6-f3d954891004','北京','douban',10,'{\'groupid\':\'26926\',\'cityname\':\'北京\',\'pagecount\':5}','2019-01-18 20:01:02','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('1f9a5840-7912-407e-9994-c00407','北京','douban',5,'{ \'groupid\':\'beijingzufang\',\'cityname\':\'北京\',\'pagecount\':5}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('294b84a8-3580-4e5b-b7a0-8fe4d5','北京','douban',5,'{ \'groupid\':\'257523\',\'cityname\':\'北京\',\'pagecount\':5}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('2dea7422-beeb-45e0-a71c-b3a26d','北京','ccbhouse',30,'{\'cityname\': \'北京\',\'shortcutname\': \'bj\',\'pagecount\': 10,\'APIKey\':\'cef8222092f74b95a8b24bc4a9e694a0\'}','2018-10-07 23:54:41','2019-12-03 17:18:34',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('30c95150-a92f-476b-be94-340a350337ac','北京','douban',10,'{\'groupid\':\'510312\',\'cityname\':\'北京\',\'pagecount\':5}','2019-01-19 14:12:16','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('3aa97d59-a4bd-437d-bc0e-0a3c81','北京','ccbhouse',30,'{\'cityname\': \'北京\',\'shortcutname\': \'bj\',\'pagecount\': 10,\'APIKey\':\'cef8222092f74b95a8b24bc4a9e694a0\'}','2018-10-07 23:54:41','2019-12-03 17:18:34',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('5cf4a4d8-b839-4d59-8e1e-75890d','北京','douban',5,'{ \'groupid\':\'279962\',\'cityname\':\'北京\',\'pagecount\':5}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('6240cb97-e283-489a-9c6a-0615fb91aa7f','北京','douban',10,'{\'groupid\':\'35417\',\'cityname\':\'北京\',\'pagecount\':5}','2019-01-18 20:00:33','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('62544fba-ccc3-46bc-b07b-d87000','北京','anxuan',20,'{\'cityname\':\'北京\',\'shortcutname\':\'bj\',\'pagecount\':30}','2018-09-28 23:54:30','2019-04-15 00:30:50',500,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('62544fba-ccc3-46bc-b07b-d87396','北京','pinpaigongyu',30,'{\'cityname\':\'北京\',\'shortcutname\':\'bj\',\'pagecount\':30}','2018-09-28 23:54:30','2018-09-29 00:44:30',990,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('64c27f1c-43d9-4144-bb77-07f369','北京','ccbhouse',10,'{\'cityname\': \'广州\',\'shortcutname\': \'bj\',\'pagecount\': 10,\'APIKey\':\'cef8222092f74b95a8b24bc4a9e694a0\'}','2018-09-28 23:54:30','2019-12-03 17:18:34',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('9bd3a571-fed5-416e-b77d-6e7113','北京','mogu',10,'{\'cityname\':\'北京\',\'cityid\':131,\'pagecount\':10}','2018-09-28 23:54:30','2018-11-12 22:26:40',970,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('a4a3bac1-9c0c-4def-ba15-645173','北京','douban',10,'{ \'groupid\':\'beijingzufang\',\'cityname\':\'北京\',\'pagecount\':10}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('b02ed68f-bdb5-40b4-aee7-8ce04a','北京','beike',10,'{\'citySortName\':\'bj\',\'cityName\':\'北京\',\'cityID\':\'110000\',\'pagecount\':10}','2018-09-28 23:54:30','2019-04-27 23:56:03',300,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('b1d6d07a-c0d4-41a4-9780-c991f5','北京','douban',10,'{\'groupid\':\'26926\',\'cityname\':\'北京\',\'pagecount\':10}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('d0582c9d-ddac-4b06-baa4-657dc8','北京','douban',5,'{ \'groupid\':\'zhufang\',\'cityname\':\'北京\',\'pagecount\':5}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('de909d0f-d287-477d-be73-4fdf473343f6','北京','douban',10,'{\'groupid\':\'zhufang\',\'cityname\':\'北京\',\'pagecount\':5}','2019-04-27 18:10:28','2019-04-27 18:10:28',0,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('e00936a4-a558-4f55-9aa1-ec01bfef2275','北京','douban',10,'{\'groupid\':\'beijingzufang\',\'cityname\':\'北京\',\'pagecount\':5}','2018-11-29 07:07:39','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('f64590ce-7d9f-4316-82c4-32117a','北京','douban',10,'{ \'groupid\':\'625354\',\'cityname\':\'北京\',\'pagecount\':10}','2018-09-28 23:54:30','2019-04-06 20:04:28',980,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('fcc5fdd7-78ee-421c-8khs-kkss09kk','北京','wellcee',20,'{\'cityId\': \'15102232786514309\'}','2018-10-07 23:54:41','2020-01-03 01:04:57',500,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('fcc5fdd7-78ee-421c-b48c-063891','北京','hezuzhaoshiyou',50,'{\'cityname\': \'上海\',\'shortcutname\': \'sh\',\'pagecount\': 10,\'APIKey\':\'cef8222092f74b95a8b24bc4a9e694a0\'}','2018-10-07 23:54:41','2018-11-22 09:11:35',-1,0);
INSERT INTO `` (`Id`,`City`,`Source`,`PageCount`,`Json`,`CreateTime`,`UpdateTime`,`Score`,`HouseCount`) VALUES ('fcc5fdd7-78ee-421c-b48c-0900901','北京','nuan',30,'{\'cityname\': \'北京\',\'city_code\': \'bj\'}','2018-10-07 23:54:41','2019-06-16 20:46:52',500,0);