程序博客网 > 阿里云域名使用方法

OutputFormat类——Hadoop

来源：互联网 发布：阿里云域名使用方法 编辑：程序博客网 时间：2024/05/16 01:07

转：http://blog.csdn.net/u014470581/article/details/51498325

1、OutputFormat是一个用于描述MapReduce作业的输出格式和规范的抽象类，位于org.apache.Hadoop.mapreduce.OutputFormat<K, V>.   Mapreduce框架依靠文件输出格式完成输出规范检查（如检查目录是否存在），并为文件输出格式提供作业结果数据输出的功能，即提供RecordWriter的实现，输出文件被存储在文件系统FileSystem中。

2、如果用户要基于Hadooop内置的输出格式和内置的RecordWriter进行定制，则需要重载OutputFormat类的getRecordWriter()方法以便获取新的RecordWriter；如果完全基于抽想的输出格式类OutputFormat和抽象的RecordWriter类进行全新的程序定制，则需要实现OutputFormat中的getRecordWriter（）等抽象方法。

3、此外，OutputFormat类还包括一个getOutputCommiter()方法来负责确保输出被正确提交，以及一个检查作业输出规范有效性的方法checkOutputSecs（）。


4、FileOutputFormat类

①写入到HDFS的所有OutputFormat类都继承自FileOutputFormat类，直接已知的子类有MapFileOutputFormat，MultipleOutputFormat，SequenceFileOutputFormat和TextOutputFormat

②FileOutputFormat类提供了若干静态方法，用户可以用它们进行输入路径设置、分块大小设置等全局设置。

setOutputPath()方法设置Mapreduce任务输出目录的路径，getRecordWriter（）方法获得当前给定任务的RecordWriter类型；setOutputName（）方法设置要创建的输出文件的名称

5、TextOutputFormat类   是默认的输出格式，它把每条记录写成文本行。由于TextOutputFormat调用toString（）方法把键和值转换为字符串，他的键和值可以是任意的类型。

6.SequenceFileOutputFormat类

SequenceFileOutputFormat将他的输出写为一个二进制顺序文件。由于他的格式紧凑，很容易被压缩，因此如果输出需要作为后续的MapReduce任务的输入，这便是一个很好的输出格式。

7、NullOutputFormat类

NullOutputFormat是继承自OutputFormat类的一个抽象类，位于org.apache.hadoop.mapreduce.lib.output.NullOutputFormat<K, V>,它会消耗掉所有输出，并把他们赋值为null

8、RecordWriter

①对于一个文件输出格式，都需要有一个对应的数据记录输出RecordWriter，以便系统mingque输出结果写入到文件中的具体格式。RecordWriter是一个抽象类，位于org。apache。hadoop。mapreduce。RecordWriter<K, V>

②编写输出格式OutputFormat扩展类，其实主要就是实现RecordWriter，重点是构建一个类来实现这个接口或抽象类。

③close（）方法负责关闭操作，而write方法则实现如何写key/value键值对。这两个抽象方法按如下：

public abstract void close（TaskAttempContext context）//关闭RecordWriter，继承自Closable接口public abstract void write(K key, V value)//写一个key/value键值对
9常用的内置RecordWriter类

TextOutputFormat        对应默认的RecordWriter   LineRecordWriter   将结果数据以“key+\t+value” 的形式输出到文本文件中

DBOutputFormat       对应默认RecordWriter      DBRecordWriter  将结果写入到一个数据表中

FilerOutputFormat     对应默认FilterRecordWriter     对应于过滤输出模式的数据记录模式，只将过滤后的结果输出到文件中


需求

现有一些原始日志需要做增强解析处理，流程：

1、 从原始日志文件中读取数据

2、 根据日志中的一个URL字段到外部知识库中获取信息增强到原始日志

3、 如果成功增强，则输出到增强结果目录；如果增强失败，则抽取原始数据中URL字段输出到待爬清单目录



分析
程序的关键点是要在一个mapreduce程序中根据数据的不同输出两类结果到不同目录，这类灵活的输出需求可以通过自定义outputformat来实现


实现

实现要点：

1、 在mapreduce中访问外部资源

2、 自定义outputformat，改写其中的recordwriter，改写具体输出数据的方法write()


数据库工具类DBLoader

package com.test.hadoop.mr.logenhance;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.Map;public class DBLoader {public static void dbLoader(Map<String, String> ruleMap) throws Exception {Connection conn = null;Statement st = null;ResultSet res = null;try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/urldb", "root", "root");st = conn.createStatement();res = st.executeQuery("select url,content from url_rule");while (res.next()) {ruleMap.put(res.getString(1), res.getString(2));}} finally {try{if(res!=null){res.close();}if(st!=null){st.close();}if(conn!=null){conn.close();}}catch(Exception e){e.printStackTrace();}}}}

url.sql

create table `url_rule` (`url` varchar (6000),`content` varchar (765)); insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/FF/35FF5766-7DF5-20CC-9F1C-EFDA7914ED09_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/F8/B2F81273-378F-F35B-F62A-9B22579A6818_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/28/73/2873045D-3E05-16EC-9C95-1138894BE362_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/93/47/9347C4CF-796C-064C-C8C3-B1809A632287_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CD/FF/CDFF38B8-B826-7F4C-0930-DFD6B54FE844_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BC/EF/BCEF873F-7E7C-6DF9-0520-73273FD87789_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/37/C2/37C21628-285C-FF41-1AB0-46A95E41A90B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FE/AC/FEACD1B8-830C-F2E2-F15F-0B495630DB13_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A0/15/A015376A-02C1-8D8B-7F35-7448987CF69A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/65/17/6517A0E7-7EBA-9391-4D76-5FA445962160_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/32/0F/320FC71A-F7CE-E5C1-F073-0AD5611636E9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/59/B4/59B4D49C-740F-4C35-5678-CB9E3ABB0BC2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7B/38/7B387609-F241-66AE-23FB-0C383C7C1352_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/42/E4/42E4A66F-219C-23C1-FEA6-7F4623C27AC0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/18/A6/18A6C7A7-9D45-73A8-8254-D49149B2861E_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/12/72/1272AFBD-6A29-8CFB-884F-773879D9E049_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6D/01/6D011E21-E1E0-8900-B024-93A52D145BB0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/78/B9/78B90EE5-27DE-BFB4-7F04-08032672F2FC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/10/E5/10E57B85-1910-00F3-A4ED-27ECF17DDD0A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/BC/7CBC49AA-34A8-33EC-C923-A0A636918568_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/44/F1/44F1C440-6192-38D0-864D-989F8BB9BFA8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D5/5D/D55DA3AE-56B1-2A14-87FA-A55D178BA2BF_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/92/64/9264329D-274E-BB1A-DDEA-2F2A064372C3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AE/47/AE47905F-6B4E-A4DD-7DF3-239124C370FF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9D/7B/9D7B9F9E-54FA-186E-B0FA-3F5DA67C5313_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EB/2F/EB2F70AC-4F20-7871-1F1D-2C4825C78E46_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/03/74/03748246-8A01-B29A-D99B-774AC5828D5C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6B/AD/6BADDB90-D2D3-011C-3391-F3D6DB1A0C33_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A3/95/A39594A3-499B-5452-0187-2C36B4137A7D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/89/F2/89F23C1C-899C-E8AD-DA2C-4A469BFAA527_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9E/8A/9E8A8ABE-DFE0-3AE4-C3E4-31554B96FB02_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/61/5D61BF7F-324A-0407-6BDB-5F7E4F431F75_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EC/15/EC15A94F-33AD-A8E0-AB3E-0B68C0B5946C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/30/2F/302F8E85-DA94-66EF-2127-92A130193780_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/3C/4E3CCFE9-131F-7A93-BD03-D0FADCE3F24C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F6/77/F6773B91-65F2-C530-A76C-22632848BC06_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E1/07/E107043B-C8B9-3F71-8F92-7B59B263E419_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/8D/A0/8DA0A1B9-C614-2977-3520-87D0E440D4AE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6C/CE/6CCEA098-3A8D-C754-A3FD-39ADC50E790E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2B/58/2B587178-4D58-BAD7-016B-C92E816FC84E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D0/21/D0213C16-8F67-5EE3-3B0A-7068F76B9E67_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/30/D3/30D3F3EE-B562-02D8-E252-DB87C7D34F1F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/38/CE/38CE13B3-68B3-A3E7-1522-4AD6B0BDB562_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/BF/7CBF4383-504B-2308-0B1C-5C461C8A507B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CD/80/CD803AFF-1933-766E-1FC6-2932EF9B4977_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/54/77/54773D07-796C-C70A-CA95-84D7C86CAE93_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/C8/90/C8902CC4-F227-41B8-3F44-BCA8748BA7D8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/59/67/59679900-21BB-6135-52B4-50ED02C00066_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/70/6D/706D0C53-E613-5186-3237-E5DE9C4DB504_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/AF/1FAF9F2A-8C03-8F12-BABD-88E232F393E1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/09/C6/09C6B334-5F6E-17E4-FFCC-507542DC7714_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/D3/B2D3A2E3-E745-45B0-4E9B-4E9C41D4767F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E8/1D/E81D03E2-A059-F95E-CBDA-97DA51EE82D3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/00/37/0037DB5C-CC52-B933-7D6D-493D10F447F2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0E/B9/0EB95206-787B-CFBC-BF2A-B7E819944620_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5A/EC/5AECCEBC-E034-27D9-2299-688345BF76CF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/83/9B/839B6696-33E9-A3C2-759F-404B45A3F87A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/5C/B25C2EDF-93C1-AE4F-FF1A-B50A4DC0EA82_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3A/67/3A67E72A-B2DF-0450-584C-26E6B11598E6_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3E/EF/3EEFCA2C-E872-7915-2E29-ADF0B12B3129_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5E/AD/5EAD0393-4C1C-8E69-A8B8-5C88608CCB88_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8E/12/8E12BC6F-B9D8-C594-BE51-909A424CCD95_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B4/2F/B42F733B-F0A4-6A07-BF05-87CAA821D4C2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D3/64/D36426D4-4C85-A8F2-79D0-534C5C31C2DE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/16/A6/16A6FD39-75CD-DE3E-F599-56FC0C8DE499_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/97/09/970925A3-B6CD-E853-EDA3-FA07CED17E6B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/11/E6/11E6C6F7-DC2B-2EBD-644E-7C10C749949A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A6/77/A6775474-C4F6-2F5E-B2D9-20A1F5C9F3B8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A2/39/A23978DF-A27D-AB46-F4BF-A4AD21BE5A3B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/36/F8/36F8601F-DAA9-8590-F5DC-3E55EDABC612_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CC/7A/CC7A94F8-A149-5C19-9577-66B31B215061_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/0E/95/0E955062-0272-6BC3-5AC3-860484F9DC98_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/82/2C/822C1120-ACC2-E77C-703B-B1F7502792FD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F3/0C/F30C2AF9-6B8C-D2D5-D3B2-68B5AF44B4CB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5A/AA/5AAA200B-6122-B918-598A-416147E6AFD6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/59/CE/59CEA183-2535-60AB-DC39-EE6BBFDCB687_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/01/3D/013D6B24-9A96-A5DE-7D43-1322FCB73C62_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/74/1F743A66-576A-220A-DB87-79AB73E4C3A0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/48/AA/48AA1F81-115D-93D9-C7EF-43DB47C195A2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/65/F3/65F30966-9113-74CA-34B1-2A6F7F30CA05_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/86/CF/86CF4343-46F6-ED74-DD68-A1619080A667_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8F/CD/8FCD8C08-12D2-B69A-B8DC-4FF3D5A04E6E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/99/FB/99FB3D5A-1049-1A5E-1373-F2E0F1EB18A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9A/84/9A84884C-EB2A-8818-FC06-6D1E50B12A85_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A5/F8/A5F8E044-340A-04A4-D0C5-6648DB0B8E56_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C6/29/C6293A8E-9E2A-BE46-5C9D-47DC87BD56C4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E3/69/E3691DEE-BC75-BA9A-7B57-7111263C9812_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1C/0E/1C0E4C51-A422-18EE-2F83-51DE5BC56FC7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C1/F3/C1F3D3A7-15AA-0D2E-BEAC-26C6F1138922_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/33/5B/335BFA5F-18CB-72E3-8B7C-4DF8A92A9B12_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/41/3E/413E603A-0EB4-9504-B97F-2C12C7FD4A64_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/89/71/89718FB0-8DC9-FF77-499B-0830BBD0E7E6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8B/A9/8BA9C91B-CB99-5AD1-1DB4-398F5024CB7C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8B/EE/8BEED0F1-465A-BC46-EAF4-259F7AFB14CF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D5/5D/D55DA3AE-56B1-2A14-87FA-A55D178BA2BF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/44/10/4410E5D3-D977-A34A-1CE4-D6AC749BF2C1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F8/CA/F8CAA3EB-CD6C-49B3-3172-033A83EFF21A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/5B/BA/5BBA3B45-D932-1A7F-03D4-31FA432EDCC1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/03/8B/038BB91A-B9B2-4FC9-D555-ED803B174792_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2E/86/2E86F015-6078-4010-C00F-8FC5C330B88F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/72/22/72227A88-6125-9FC7-6DBD-18CE4A39E717_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/72/AA/72AA97CB-91F4-A097-B746-9F1A645948AD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7E/69/7E69B28F-0F70-66DA-5927-9893DF1FE4D0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D1/D5/D1D5C745-2446-BAC3-12DA-49AD18915844_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D9/91/D9910227-B7C5-517B-7B55-600019202A85_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DA/D8/DAD8D193-E89D-E998-E526-20F0E1CDE802_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EE/17/EE17D3BB-234E-CF5D-E993-2265E28FA0D8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EF/5D/EF5D9208-A434-F44E-A3B6-CBB51D7C0F39_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F2/D9/F2D9B062-EC3C-84BB-E765-7420647556F2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A9/B8/A9B8087D-E93A-083E-02F0-8F81791268BA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E2/6A/E26AA976-B52C-4A82-916F-C547BFF72A07_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0B/13/0B13E596-C27E-9522-A69B-F596EE180F92_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FC/A1/FCA1A873-FA1F-B4ED-8762-137A85B89C50_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/D7/16D76612-76F0-A2FB-0702-6191D75BBC03_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/40/8A/408AD653-AA0C-1724-81D4-18A92A984442_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/38/B1/38B1347F-89FD-562E-B939-BE1B6C11A02A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/EE/80/EE8026AB-1DED-3B9F-0F3D-50C07A12A913_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/19/54/195462C2-4334-E731-345B-10DC199C1BAF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D1/1E/D11EAACC-348F-FB48-D6E4-AE4AC7E7D4A1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/C6/FAC6E27C-F769-5D5E-8657-AA41980BA2ED_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B5/09/B5095A71-EE45-3523-8214-12B66FCFBE4B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7A/87/7A87AFE0-CBAA-9066-1C4E-32E524C8DEA3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3A/84/3A849D71-5416-DFA4-F346-8BE05D3D9DC1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/68/3A/683A6B38-9B5A-3D93-FF0E-FD2DDAEAF0DC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8A/18/8A18277B-A7C6-D49A-09BB-CE40D7624F53_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A8/43/A84317D6-399C-A845-1AF1-96EFD17AA1B8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1C/54/1C549E15-AF93-4D15-ACF0-AAA7EB371144_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/79/C7/79C70EEC-86DC-9ECB-D0C5-D452CE5AC6C0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/88/B7/88B79D84-F760-8F9C-C389-457EA68566B7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E4/38/E438A7B9-5CAD-1E4D-6479-3EAC65DF7E95_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/07/EB/07EB62FD-BA4C-7CEE-3166-239A9003B1CF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/E1/1FE1C6B2-92D8-F106-DE88-D931B5183463_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/49/0C/490C329C-C7E7-E1FB-3937-E79D0D5A4159_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/63/67/6367C3DC-282A-0881-5AF0-C1DA11C17A8C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D5/16/D516082B-6415-1814-2003-0D5EFE93D1B7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3F/D3/3FD32E4B-D317-AE19-D58C-A9A34811FD00_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/32/FC/32FC3623-BF85-5BD0-8BBC-F5E97991BD93_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/46/B7/46B754B0-0567-2128-F7A2-9D60EFC17CD5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/70/9E/709EC6EE-6BA0-7955-2AAC-F24519CA3D6E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/72/5F/725FDB24-4EF1-F98F-2B6B-A8313E3672CA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/8F/0B/8F0B27E0-971B-917F-114C-7FCDB9AB9E74_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/8F/1C/8F1C9AE2-0725-A947-98C4-59D0A597D192_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B8/43/B8433462-E189-9B23-D909-12C6D67B43B1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/CC/F0/CCF020B1-45C0-7FF2-3C82-62A06DBF28B2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/0C/3E/0C3EBDAB-FA58-EADC-9698-D46799F140B9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AC/74/AC74E2B2-DBD5-D8AE-A39C-B1D23CEDC823_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/37/4F/374FA2A5-0185-654E-56B2-BD7EA8F75DE0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/46/4E462E49-9415-A068-95D7-DDF592FC59F6_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/00/DE/00DE97E0-02BE-2263-1C3B-A7222C529701_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/92/4D/924D6357-00D5-36B2-F3D9-73ABA02EBE2C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3C/BA/3CBAF9AD-6553-2CEF-2D2C-F3EF83846C8A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/0D/5D0DB347-64E4-1C52-1289-F3277D6F7772_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/60/0F/600F7799-CB4A-5332-3C3C-3B1A42D1340A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8F/18/8F185438-E4CF-14C2-67AE-FF1AF940AEF9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/94/05/94056731-E0C6-1D39-6E2B-4AB562415455_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CA/F1/CAF11E7C-B6D3-F44A-BC45-46423C01E45F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FF/D6/FFD67017-62B0-D6C2-84A0-9CD59481F480_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/55/DA/55DAC282-2DFE-C7B6-8C37-314F61E661DB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6D/A1/6DA10E29-8A47-7254-F0AE-321D6BFC13DF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/80/52/8052F9BC-26ED-61CA-44B7-5B0211AAF8D6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/BC/7D/BC7D117E-061E-EB26-E2DF-C55DF99F74CD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/12/D2/12D2277F-72EF-E184-5BFB-86047EE9EA6E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1A/E5/1AE5290B-6E62-24F0-8219-DCF852B2B4DC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2B/9E/2B9E2A1E-0F88-4849-9680-793FF3F8C2A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/46/E7/46E72A34-DCBB-3668-247A-B93876AF85FD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4F/19/4F19AC02-C3D2-1088-A218-60EA5998E97A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/52/56/5256EB99-B178-0742-9F82-9E71607C0045_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/53/8A/538A2A14-00CC-ECB7-6B1D-BBE853B9BA92_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/BC/5DBC8B98-F66C-C38A-6241-8649E0FABDF6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5F/FA/5FFA32CB-C308-D8AB-2666-75EC388E89AA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/A0/62/A0624ECB-042B-734C-5C3E-273743D85B37_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/9B/9E/9B9EC4C8-EC8C-8E1A-6F8B-75E96E68AC35_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6B/FB/6BFB28F6-030F-6954-BEB2-39D107A96702_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/70/A1/70A1B987-C1B3-7F33-585F-72D784C7781C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A4/68/A468117C-E58D-9799-7E6E-F411B1E9B85A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A9/06/A90664DF-83B6-A14A-348A-5C2BB26FD67A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D4/5B/D45B4017-9CE4-009E-3226-8BA116792EDA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DE/D8/DED85094-0825-77AE-2AA4-26A3F604CEF2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E6/8D/E68D109C-0457-FDDB-79C4-F7B453E64EE9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EA/54/EA5486BC-4CF7-4CF7-BE7C-87D642007553_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EF/EE/EFEEDB8B-D53E-78E8-93E7-594D6E7843E3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F2/45/F245E766-D306-03F4-A6A8-CB3B50D53563_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/DB/7F/DB7FF5A5-ACED-9ACB-F60E-5BE80BDF7F30_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E4/90/E4902628-90B4-45F4-4A77-34F4B9D8841F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AB/2B/AB2B77B1-E923-C09A-B7DD-0E4EA3670868_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/40/A4/40A4C96B-4CED-EEDF-9726-B7AC0643B169_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/15/81/15814E4D-4ECF-B861-813C-6BE94A56BD48_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/80/6C/806CDAD9-32DA-A5F5-CCB0-77C2BBF24501_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0E/23/0E23CA00-3805-016E-2805-FC5BE327BEA6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/26/8C/268CDFE6-3494-3D9A-9A62-575B0F242E21_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/34/15/341516A7-E50F-66D3-F29D-89C277786338_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/29/6D293FED-D2E7-521C-688F-42429FD59054_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/75/4A/754AD40D-5B4F-FF64-F5BA-A3A19F5A3C0A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/77/90/779084D5-2F3B-FD28-103A-5CB111804040_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C4/E5/C4E54734-5CDA-9EF2-30BF-58DB7B0AC2AB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DE/51/DE512BF4-78F4-1495-F204-E1C56216A23B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/53/0B/530BE6AB-96C4-FF1F-5CEF-1CFA4008ECE0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5E/75/5E7519B2-D501-5311-4C50-4267B1281EFD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8B/8C/8B8CEEA8-EC18-CF1B-FB7A-CCA28D786BBA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B8/08/B80851C8-4681-0CB0-97E7-AC49C213AB13_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1E/17/1E17A7B7-7F77-81E8-387F-E417B52BC8C8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/D2/30/D2306950-702F-9746-9F1E-12B6D4B67774_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FC/42/FC424564-0428-5B44-A9AC-89316AA4A8F2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/91/B0/91B01CBE-7782-87D1-C310-0084A66B219B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/7E/55/7E5519D8-469E-8D08-E9EE-80C2D2A893BB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/47/EB/47EB206E-2586-C449-E1F0-1C0717960385_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/CF/EB/CFEB63E5-1A8C-4D6E-56EC-ED1C80660F07_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E0/4C/E04C2B78-2E99-6D4D-92CF-F6E752A8518B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/98/25/982500C9-02B4-4648-609D-4F8D0C9065EC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AA/A5/AAA5BBE2-5964-D23A-D1F1-46722921A877_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/10/B6/10B62FAD-F9B6-3230-ADD7-B857EC93F9BE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2A/00/2A00ECAA-0706-F190-241E-BD8FA0D0B20F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/32/E0/32E070E5-231F-E61E-13C4-D2453FF1EB53_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/90/56/9056D0A9-7B6F-02B1-3EFB-606F327AC8D4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FD/7E/FD7EB6D6-3EA1-57F1-8566-71CF64AC722D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/25/15/2515C80C-1BE9-0E9A-10FA-A47F62C44A78_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/55/41/5541342B-ECCA-3E20-3788-BD37965A9695_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/C1/85/C185146A-90D4-3D00-AE98-DE2778A43F28_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/DB/1A/DB1AC1EF-0873-EE1E-FA54-4749A5FEF4A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/18/59/1859D864-EF68-E289-B61F-6BFE47262F44_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/31/27/3127D4E3-5B02-D08E-0323-D91E6CD93843_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9A/34/9A347055-0CFD-4136-BCBE-FC0933F87ED0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D5/D9/D5D97A8E-A148-C6D4-26CE-D78F607118A4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/28/53/28532D7E-1D62-38C9-8647-5EC30FA05F64_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3A/67/3A67E72A-B2DF-0450-584C-26E6B11598E6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/0C/4E0C3A2B-6B8A-BD1C-1524-F4FD29A9C125_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5F/78/5F78F0F5-B588-6AB8-32EF-93901684A0FC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/E4/35E433F2-9B60-3D22-9E9E-2631C87A419D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/E4/7CE45F9A-868B-BD27-B92D-55EBA094A589_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BD/9C/BD9C1CA8-B6EB-EE67-57E6-0040BC321875_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C8/D7/C8D7DF2E-55AC-C9EA-9725-54A60BF1CBDC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FD/70/FD70EB7F-DBEB-C5B3-D478-35EEFC208FD3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/34/DC/34DC49B3-CBC8-D15A-0FB7-FFF2AA0119D6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/36/16/36163906-E11C-E93B-DC18-3CD1B6C6B6BE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/84/9A/849A8376-CA3A-F8EC-B578-E190BEA77826_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/92/84/9284D3CB-CFAA-12A6-08A5-04D83A8A191C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BE/D1/BED1E395-FCAB-CB6F-8000-F4730033C724_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DB/1B/DB1B9480-B6BA-9BBE-875F-58EA9AE23B6C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EA/D5/EAD5E11A-CA77-755B-FF56-8F1AF9EC01A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F1/F3/F1F33381-0DCB-BA7A-C303-D5C1A2AF8AC2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F8/47/F8475EE2-6661-7898-C44A-90FFE7F49977_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FA/6A/FA6A43C7-A2AD-00DD-EFA2-47E73ADBC760_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CD/1F/CD1FC58A-767B-BF20-1581-1C8D598F7281_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/23/0D/230DE008-5915-F5D1-705E-1BA7B8B37284_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4C/BD/4CBD70D2-4C0E-1E0F-5E42-2C252E899A23_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/6D/4E6DDC12-0363-D967-072D-910B07F3E625_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DA/AC/DAAC4CF1-4735-299C-E4E0-6659BACE6E58_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AA/D9/AAD9B086-885D-77FE-7E1D-1D67F521DBDF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C6/57/C657F495-6E07-8E37-6EC1-6612247B5254_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/47/61/476105C1-806E-8F88-4E8D-3D45F4221D74_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/8B/75/8B7599E9-F800-7010-6D7D-C47E3385F044_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/15/FC/15FC39CC-F21D-D002-5E78-09E363184141_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/77/B4/77B45C87-5A30-04B2-D946-E4C6ECA8A63A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/27/5B/275B77FB-B126-9FC0-2F78-1C8D9E7E2C6E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/51/44/5144AB16-8F02-BE10-66B9-C80744C7BD2F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/4F/674F7D8C-4B11-4401-DF12-E6204A8F8DB8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/EM/OT/EMOTION_1000_momo_01_ExkYJylg_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/00/2A/002A852D-C6DA-5A78-C879-B7BA8339C13B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/00/40/00404234-4A21-3A0B-FDF6-E6022186A593_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/31/2B/312BDE5C-A438-2A47-4EBA-E6780E696A66_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/43/60/43606CE6-EC9E-BF31-4CC6-B19B51B219FA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/45/20/45206055-B776-B753-86A2-251B5521FE28_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6A/52/6A52A1A0-5220-B7D5-BC89-1AB1611D2CBA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/A2/66/A26653C3-0240-2D8C-4BE4-0E1BF675AC36_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B5/4F/B54F2718-158B-F83B-B89A-4E0DCCFB4EB5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C2/93/C2933292-A7E3-6056-BD6B-2E3162F2FAFB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D2/32/D2321229-9AFD-C725-EE7C-A6AEBBD79C21_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/23/93/23939844-5765-A3B4-A5BB-D1C826E23846_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/56/5C/565CFE5E-9E6D-FF05-DE9E-489FB462DCBA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/65/5B/655BBC7F-FBBE-30AA-20BA-DD8B840D5B3E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/CD/67CDF17D-1D70-5D22-D829-73AE6583351B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/75/EF/75EFC3DE-6151-9250-67AC-A8A3507FC2B5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9F/FD/9FFD9F4C-90A7-9165-A278-E4E4BF275707_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A8/4E/A84E841E-7521-14FB-EE90-5E0ED4EB3CFA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C3/00/C300FD96-2FB5-CC22-732D-C9203EE0F6A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CE/5F/CE5F09B5-FF8C-CACC-01D6-1FD273D312AF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/08/53/0853FCA7-3EE9-17B3-9050-3717923A2ECD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E5/CC/E5CC8E96-2B42-E8A3-B259-B3F1C9FB422D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F4/07/F407C547-314C-FE2B-5B10-87337DDCD851_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/19/AE/19AE6CFE-BE5D-DE45-D389-DE75EAD5A6A9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B9/87/B9876AD4-9E6E-E687-0398-C198CB445DED_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/46/12/46121FCC-1462-E384-9896-B6F9A69C2BAF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/61/88/6188B19E-0BB2-0588-993C-A18F89858B52_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/D4/EA/D4EACDF0-1104-3A42-004F-8D049BA318A8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/02/E8/02E86B93-3F2E-37E3-83F9-5492873D9101_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/28/50/2850F590-3F58-DDC6-2703-B3663B700021_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/81/84/81849935-0C1E-EB04-016D-AA1ECC214499_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/ED/EE/EDEE9418-C6D8-C707-1BC0-58F0D2E449B2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/53/1F53480B-6D5C-44C1-C894-5E68FBEF8431_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/53/5E/535E0CAC-C090-1E4C-AE26-94BB1F8DF94F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5F/1D/5F1D863E-0CFE-2FD7-7545-DED235AC254A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/35/6D35EB7E-0025-D04A-7613-23AE05BB75CC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/78/7D/787D555E-32CD-CAF2-01E3-F9CED19BCB6F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A1/AC/A1AC6877-4951-EBFF-FC61-18C2D8DB1347_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B8/B5/B8B51A4C-6662-9BEA-B7D5-10E5C9372B87_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BA/F5/BAF538D8-5E23-528B-7894-4A6A9A4D74A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BB/3D/BB3D92A7-5506-97DD-1578-4F28AA8C091A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CF/50/CF504FFD-EDDF-D76D-37A6-BE1ABDA61EA6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D9/CE/D9CE3370-2F1D-A263-4940-7B1340675F0D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/D4/16D43BAC-1BB8-2FEE-8D7C-CCAE375D5BAA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/69/1F696F17-B935-8CDE-FDF8-717D49CBEACC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/73/A5/73A548A8-41B0-B55A-127D-DBBEF3013737_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/43/E8/43E84376-4CD2-E023-DEED-46A1E20EF7FD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8F/E0/8FE01B4A-0A10-171E-2920-DB0181409A0F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/09/1A/091A0E3E-021E-2ADC-7ECA-00FE3936E83D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/11/39/11395B18-2631-A289-BEE3-E614483B8069_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/14/02/14025587-3CF6-40D4-40F1-56A1D37FBB88_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/72/73/72732CF7-1CDC-C0F2-5439-A5906E92526C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/7B/7C7B7A1F-319B-34CC-BD13-C05904CF7F64_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7E/67/7E675870-1B3B-A68D-40E5-C3D5BD54F1A5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CE/5C/CE5C06C9-C954-C0DE-6E20-710CDC943151_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CF/62/CF62C473-FF9C-790B-0BEB-B77854959A89_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DA/94/DA947766-28ED-C821-9213-DCA60C185136_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DD/39/DD39ACA4-62BF-7A33-C95D-64FD079B795F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/CE/D9/CED9332E-7582-5AD2-A4D7-F9C2A791DA64_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/38/0C/380C88CD-1E00-5D1E-4C7B-B4D65271C3B9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/75/92/75929849-34B0-4168-8245-628A904E6BF0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BF/52/BF52B49B-5018-DCFE-99F4-3526631757C6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/4F/8D/4F8DF355-DBB1-B232-9781-54ADC2D02682_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6B/77/6B776A82-70F8-BD7D-9C68-1E7E5C5BB36E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AB/24/AB24AE94-B665-2812-EE33-0300DF64003A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6B/85/6B85D879-B7A9-196F-74F1-57F9579FA0A0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/82/1B/821B1D3F-AEE0-271B-43F6-122F90F61529_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EA/8E/EA8EC34D-0751-39AC-3572-05A88F5FC6FB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/05/C4/05C445FA-FE79-410E-1C97-5CED7B04EC5F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/80/E3/80E3B618-554C-B566-3D0E-2B784C1C64D9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2C/9B/2C9BFD6A-E523-6BFA-3600-7EB3C39BB143_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6B/3C/6B3CCC7D-78B2-2617-F9FE-44239165FCF0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EC/3B/EC3B9CEB-AC59-875D-C75F-FFBB1BFFC9C0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F9/15/F9153581-73A9-B27A-81AD-58DFFA083EA3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/26/91/2691C407-2E66-86A0-1A16-72836F3511A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4A/9F/4A9F6817-33DD-4ADA-FF73-0CF265A072D6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/76/83/7683D8A4-4000-BB11-1099-111895648875_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E7/68/E7685BBC-E4FF-4C78-574A-F797203B8D8D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F9/A9/F9A9A6C1-AD7E-A6AE-5CFE-B2ADF36C3729_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/16/0A/160A7C7B-BB73-A512-919C-A4E322B72347_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/24/0C/240C7B3E-DE47-6892-74A2-623B34922CB3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/D7/61/D761CC64-21FA-60F8-FC30-ACB898A1DF8E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/02/EC/02EC2008-2BF5-71F4-F986-5DD7AF24D0E6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0C/89/0C89EED5-AD69-DBC4-7019-15B525568094_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0D/F4/0DF45EC2-0079-5C06-4653-F230792CAFBA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1C/FF/1CFF9C0F-8748-9036-B029-74F746D9CFFD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/42/8B/428B87E1-F28D-BC50-9917-748E64369305_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/46/A2/46A28778-882A-1D3C-1D2D-2F5AFA2335E2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/58/9A/589A85AD-201C-5F03-05F3-14C6F66730B9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/66/0A/660A9003-E077-3A5D-9EE0-5D7811FD0AE3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/71/0C/710CD878-7769-E3FA-9C9F-444D0AB0B64E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8C/F1/8CF1D534-3FDF-F92C-6A2F-BE241DFD9C85_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9E/EF/9EEF868F-BC29-1D70-26A6-2D863FC3645F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AA/4B/AA4B4484-F8BA-DB52-E592-2CC472D6A732_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E4/A2/E4A290E8-4AC7-B510-435E-CC8ED752D092_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FC/07/FC07767D-83EB-349D-930B-B0F49A20B8FE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/29/A9/29A955CB-2736-27A2-057A-F1A1CB33FBCD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/34/35349A3B-4F11-73AB-4642-469A62ABE7D0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C1/BC/C1BCDA7B-BE8E-B753-F503-9CE4DE88FD73_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CE/33/CE338F1B-4529-136A-F7B5-C6851803EF37_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/A2/35/A235992F-8ED4-FD28-5AA7-EDE868BA1F40_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/EF/FB/EFFB1BC5-A9AB-AB63-1DAF-78C9E3544511_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FF/F6/FFF6923C-0242-9A59-AFA6-99D0390C2F7F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6D/0F/6D0FDFAE-81B3-EE47-12DA-B47345CFCEB2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6D/13/6D130AB0-7127-5FD9-DDB8-5ED398D02E4A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/50/A8/50A89642-28F2-2301-18F2-3EDF015038E2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/76/29/7629B52F-B949-BE0D-D776-BFF361C6584E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FF/FE/FFFEC1A8-81A6-8E25-DBCB-DE2CDBB1DC21_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/70/26/7026F804-6027-BBEF-4AD9-B3082AD0F2DA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A5/6D/A56DCC20-6C3E-B198-E621-3DE2D0507A48_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E8/E9/E8E98FBF-E7E2-9CBF-546B-FACC4C025667_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F7/B9/F7B96BA2-EF68-EDD7-1976-72E1DE3ABCC7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/02/46/0246F16E-21D9-3242-6191-E48AC1DE2C3D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/89/F2/89F23C1C-899C-E8AD-DA2C-4A469BFAA527_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/A1/66/A166F837-B43F-BF0A-343D-C0A420BAD364_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FC/8D/FC8D71E1-5561-08DC-5361-F2094D9D00A7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/42/8C/428C6085-B05B-E2F0-5B9C-1A36C960617A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/25/C7/25C7D64A-8128-4C52-30B7-E6C9FD9EF199_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/54/4E/544E0D98-B507-617B-E962-9785E344691B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6E/ED/6EEDD1D5-4690-4D04-DE4A-2947D2BEC3AC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6F/3D/6F3D1CF5-BC26-5BCE-8CB3-41346E971110_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/78/4C/784C8E24-187A-2F6E-E53F-C6A1FD948676_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8C/68/8C6817DA-2646-40BC-4C08-1BCA7D99C71E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AD/E8/ADE8CD67-6164-7BB7-0D5C-AF50AFA85AD3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BB/64/BB649990-84C2-4CB9-AD72-8EB0CB8EE451_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BB/C8/BBC8D6BA-B915-660C-A6AF-88859E786854_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/4D/F8/4DF8CD02-E9ED-04BA-4A92-BD21DE0620CE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F7/F2/F7F28807-B039-37F3-C900-00956A4444DB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/01/15/01156B60-ED4C-5E77-E759-9B23926DEF5E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/95/DD/95DDC276-FA08-19CB-F1E4-A70E119AD836_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8A/0D/8A0DA1E0-DE9E-AA4D-8159-7725938854ED_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A8/BC/A8BCFE1C-D648-1C30-3EA9-00F5CE6A9CC1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/7D/167DC85A-241A-BC7D-D52E-6A1BE96DAF0C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9A/1E/9A1E2C6B-8B1D-A7CE-48CD-81B2D820E7D4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9C/AB/9CABE1DC-BD05-DC7E-D9EB-499F2E55DEAB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F3/D3/F3D37729-5880-6E6A-CA88-02934B0A2693_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A4/D1/A4D1FDA4-40B9-2DBA-90A0-BEA940C3A867_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/7B/BA/7BBADF41-AFD4-84C6-060E-2F2085F3D720_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/A7/68/A768CF9E-C859-4D32-2572-5BAC43F22479_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/D5/38/D5389EFB-E302-0691-87BF-7FBB5DAFA850_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/EE/C3/EEC33664-608E-25CB-F67D-DE3354220802_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F4/56/F4565C8F-68C8-E81F-9EE2-F47EADC80D1D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/44/16448E0F-0D86-E7C5-27EA-4432FEC3E70A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/24/5B/245B0C67-CD34-AB15-1FAF-40F42B2749BD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/27/02/270204E0-0770-4C33-154C-D23B84327C9E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/44/B4/44B42FB7-27DA-F25A-54A5-3E0AED8550ED_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/54/4F/544F8E35-3351-3164-5E03-7B780A1E4097_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/56/35/5635EA2B-1780-267B-683A-F92AB867E513_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/74/E9/74E99503-D0BE-6396-BEA2-EB729D9F236F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/75/BF/75BF69D3-2B9E-71CD-6E07-9C1EFE62321D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/85/E1/85E1455E-F866-57C4-B75E-9B147CC6B2F7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/90/92/90928D1E-D0F8-AEBB-624B-63A48F2D6A8F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/91/3C/913CB583-85A8-6476-AD3C-03FCF05AA9F4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/92/B2923893-D367-C9E7-F9F9-643CF6DC002E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C6/A4/C6A4E5BE-40F7-8157-7343-AEABDAE1F8C5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EB/C9/EBC92C26-2337-F838-A1A0-383D9735B5B3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2F/75/2F758C9E-F068-B4D8-DEDA-46F36F67BD40_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5F/72/5F72BA74-8030-D86B-8F20-B6D72058F0FB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/1E/B5/1EB514DC-D3DD-5DAC-BFF6-459CE22984EB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/50/29/5029FFC6-6F18-94DC-AAFC-05A2378C6263_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AF/76/AF76EF79-7CAC-7A8C-59F8-C4F6D3E2D91C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/BA/4C/BA4C4460-7F15-CE5B-39DA-E6561D1E0CAB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BD/D9/BDD9FC6F-D9F0-6357-27FE-A0D5646DD769_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/2B/FA2B5D61-E77A-A0DE-DE64-1DDCEE517598_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/66/2B/662B6893-A282-6C02-E9F9-469B513DAC47_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0D/64/0D64B115-EC59-A88A-A645-D553E0807AAD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/15/AE/15AE3EC1-373A-E4BC-CE99-83EAE0FCEC2B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/25/43/25439910-1310-8968-732E-C1A84A3BF364_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2F/ED/2FEDE681-D9CE-D53F-7096-3BC1D634D7E6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/80/35802C4B-A342-EB4C-6265-19CD0DB4776F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/42/CA/42CA5EC9-4C68-DB8E-E48B-1649EA211EB8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/CE/4ECE1A52-3554-990E-9609-20D9A4CC4C47_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/51/32/5132D2B6-559E-4054-73A3-5172B56479A7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7E/47/7E47E4A6-CD47-9E30-A1A6-2081468B033B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/99/CD/99CD8DC2-0A13-0988-7D4E-4BFAA98020B4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B5/A2/B5A2E5AE-A903-8726-2910-A486BB2FE697_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CE/B0/CEB0B137-C9ED-4DC1-C786-C03225066FCB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F5/75/F57503AF-945E-5290-820D-1D51CFEEA1A2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/24/1E/241EBA1B-087C-C536-F679-348171797457_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/40/1B/401B6E81-DEDC-4BDD-4D81-AE0736885C49_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F5/2A/F52A5A93-1D28-F4E7-A557-E9719FA60E58_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/34/31/34316C92-4BB6-C196-6754-B273377D3B0B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/68/C0/68C0C0BE-36CA-EC45-542F-68AD8B4C0566_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/40/6D4041F7-8F25-AAD3-3E81-BC178FF62969_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/82/97/82971345-E9EC-29CD-4088-A53D4810D09B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AF/F5/AFF5C17E-8548-437B-3083-3AD2638C45DF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C1/3B/C13BC9C6-2CBF-D760-B6EC-F279F1A1B9BE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FF/CC/FFCCC951-CB0B-E4AB-E9CB-0FCDBCAD19F6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/47/2F/472F54AD-8BF7-1067-C39C-12F54A2561FA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/31/36/3136E59D-51AE-53E5-14B8-B9BCDC1CC1CF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/77/48/77488875-C9BF-3294-6507-B3FEE29FDD26_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/67/87/678731B2-899E-A413-D927-D3933E40947A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/6E/61/6E6169A2-FF07-3021-BAF6-67A98E2C1F3E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A4/C6/A4C6290A-5536-4B79-476B-6DA2129A83CA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/99/52/9952C2EA-5960-8DDC-0C01-D8C8372DBF26_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D2/33/D233E960-5EBA-DA7A-0E80-CD7B84AC45A2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AA/B7/AAB73CFC-D355-A826-9BFD-A79A6888B324_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3D/21/3D215BA7-BEA3-E0AD-96A5-3104F6B81079_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/27/4E273B05-5C51-9589-2E47-ED2549962278_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/D6/4ED6701D-B31E-80DA-2BBF-D41A6C4DA5BF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8E/BF/8EBFF076-F9EC-E44A-6E89-784355987540_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/97/8E/978E13CD-F831-D67B-2378-35AFA4B79A9A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AE/2F/AE2FC7DF-645C-A7FC-0900-91266DF90947_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EA/1B/EA1B0534-4698-A5E8-C81E-605E78F3B968_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FB/6C/FB6C5CFA-1476-EADF-AFEE-BF2D95271802_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F3/B1/F3B13673-B0E8-8578-7A96-AC47E8EF6596_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/32/1D/321DC350-C71C-ABCC-81F0-950495ACA9A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/59/5D593A0D-13FE-1D57-C598-25EDEB7122A7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/76/60/76603AB3-72B6-0EA2-BD7A-5E661A4B206C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7D/4F/7D4F19AA-CC06-E9F8-907F-7C083206D30C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A9/2A/A92A482E-CDCE-0AB6-F83E-B9FC46C7BC9D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/19/AE/19AE6CFE-BE5D-DE45-D389-DE75EAD5A6A9_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E3/37/E337C15E-DDDC-4FB1-7B44-F2D2C0B8B9C4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/73/84/73849FA3-0EBE-3F2C-3D5F-DC0DA6829CEE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/73/BE/73BE5323-C563-4030-6206-732A8755DB2A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6F/C8/6FC8F574-6BB5-98B1-83F6-C5C3C33BFFBA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/25/43/25439910-1310-8968-732E-C1A84A3BF364_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/30/50/3050971F-500E-B04E-B3F3-C2092891A598_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/C7/BF/C7BFFCA4-7523-6A02-4D57-F66E21A8A64F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/99/21/9921A1EE-119F-C07A-6233-7F96034CF800_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2A/BE/2ABE854C-48FD-C50E-684B-D860E587505B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/15/04/1504643F-4A40-D5CB-F91C-22AF5E50F8AE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/65/63/65637061-FF70-8CB7-CC7A-B861B5397E05_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B0/B9/B0B9D976-9180-0CC8-9358-D016F4A90FBE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/99/3599E01B-0D03-15C6-5D62-695DA530C417_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/97/8E/978E13CD-F831-D67B-2378-35AFA4B79A9A_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/15/AE/15AE1CE8-DC44-AE52-4D73-952C7A32712A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/22/BE/22BEFCC2-737B-13D3-12FA-ACAF354AEECA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5E/DA/5EDAB08F-2F5F-5349-C048-715C472E3E99_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/3A/673AB55F-ABAB-9993-055C-2CDAC1A58FE9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/1F/B21FC49E-C63D-1C21-1911-56605A6A1DBF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/22/E9/22E97E68-4106-E808-F326-F6AB0ED52693_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/55/5E/555EBB11-5A0F-45A1-7570-00FE261BF87A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/63/10/631077B6-6E98-590B-FCAF-74D8B210C0C8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0B/56/0B5623D9-7270-872F-D020-E58E36E864AD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/64/F7/64F7D240-EAAB-C707-F33A-659B2BC055C7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F4/F0/F4F0D243-13C7-0E37-BC5E-DBB4DE7BDAA5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/AD/7CAD6075-4E33-7079-B32C-9183C94F0303_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/73/74/73741BEF-8F7E-182C-9262-77BB228D143C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A8/61/A8615FB0-16E0-6447-3A2B-99BDF51A53D4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B1/AA/B1AA1491-CF71-7AC1-76E7-8F89740764DD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/61/5E/615E832D-2985-F24D-0500-7D56A563E262_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/26/37/263729FC-3E22-ED36-17CC-42142621C165_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/96/37/96376213-9B90-4C6A-CC9C-BAB6F93EA2BA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/72/DA/72DAC5F2-1211-8D42-DE21-AC9DE7C379CF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1D/E8/1DE8C06E-64C3-0135-3418-6DFF501F1A86_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/25/61/2561220F-BF95-49C5-459D-7131521CC8AE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B5/B0/B5B029F0-1874-B224-F8A5-0A0DDA92401D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F9/C5/F9C5CB1E-D0E0-0012-56D3-B68C46163A82_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CA/6A/CA6ABB0D-9FD6-59EF-0C1A-CF0C8B1075FA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DE/44/DE44C8B9-EEBD-E8C4-9108-B7A58823A7FE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/7A/EA/7AEA1DD7-374E-67CE-A996-A797856E52E8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/19/70/1970F8D5-F7E1-ECF8-05ED-AA82A8022514_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E0/A9/E0A950B7-56CF-78D5-E585-C0E76BE10A3D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6F/64/6F6424A6-6777-08C9-E482-FAB050944FE6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DF/84/DF843AE9-34DD-3D90-71B1-F1F9E562E1C0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2C/42/2C422C39-0B3E-6694-273F-A53298E20460_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/43/63/4363C68B-23FB-1665-6467-6159AB69A225_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/50/BA/50BA224D-EE76-F762-D46A-48B8E9604D19_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/DC/5DDC9844-DEED-ED24-8B9F-C40A91E91096_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/2B/27/2B276385-8F18-39C0-C3D8-7D74CE7332BC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E8/FB/E8FB4E3F-F65E-15B3-735D-F64682A5B531_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BB/38/BB38EC76-CD7D-C4FB-C30F-6279B388E569_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/02/97/02972568-3D9A-19A2-97CB-E6B9BF078998_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/62/D1/62D1B60C-1ADE-D481-9F02-5E5C63D6384B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/76/80/7680F2FD-106E-DAF0-BEBF-C622A2634847_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/11/5D/115D070D-7ACA-45E7-4B4D-5F00707F7FA7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/8D/168D89F2-4ECE-1D46-3636-E285A86C5BD6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/45/3D/453D84BF-0288-F8D7-8E64-222544341C48_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8D/40/8D40D6E8-B12B-199D-5E8F-DEB1AD586B01_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/66/CE/66CE998D-DC9D-4E37-A7DA-2A009A01CF53_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/09/4A/094A704F-BFC7-3BA3-1263-E91238002FB9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2E/05/2E05317C-C45D-956E-9759-11F309F325F8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0E/A2/0EA28108-B64D-5118-7DEE-74D76018771F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/13/9F/139FFD5C-FA2E-629A-FF1D-7FFD934BC328_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C5/CC/C5CCB269-6757-47EF-ADCE-B0A9A789B49D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/12/96/12964CC2-5A39-C64C-6857-4A13775AA576_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/40/59/4059545F-1918-E0CB-D1A5-DC75623E15F5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/97/FD/97FDC207-F7F5-145E-4367-7DEE94B2D9D5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EA/85/EA8527D9-F289-2A73-945D-68A53EF43AAB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/ED/A3/EDA30661-2B9B-FB41-37CE-F9A86AF2445A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/68/E7/68E7F479-8B7B-478C-4BA1-2AFDBA48A03E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/5B/FA5BD0C9-161D-9AB8-B588-3C86C993F196_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DB/E4/DBE43C0C-659B-6021-8069-CE0E5A5C838B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FF/6A/FF6A37DF-AA30-886B-200E-6E25DEB1FAD9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BE/80/BE804E84-CC94-E192-E7E6-1EC2ABF16384_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/97/6A/976AE656-C767-7143-9810-CB7D34CFC6F8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3D/21/3D215BA7-BEA3-E0AD-96A5-3104F6B81079_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/65/A4/65A41377-1987-E9C7-7537-7207A1EA96AE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/EC/3C/EC3CFABD-75EC-72B5-F2C6-886E96E63F95_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/14/4C/144CC1CE-F52A-5186-F553-D3919B302F2E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/AF/FAAFA1AF-05AB-A2E6-F94B-3909B0F45EDB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/19/51/195187CC-3B3D-9DB3-5D16-77DA62DA4E70_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/49/D4/49D44C92-30F9-480C-0FDA-4516DA568085_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B7/DC/B7DC8A8C-F1B5-3B17-486E-C788E52DCF53_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8E/3F/8E3FC062-AF32-4C14-A61F-58E4E8A1517B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/CE/4ECE1A52-3554-990E-9609-20D9A4CC4C47_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8F/86/8F863949-9546-3438-A9E4-9185CEE8FD70_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/5F/B5/5FB5D8A4-EA44-94C8-6AF2-3F41B0C1BC8B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0D/61/0D618D0E-54CD-2ED2-C06B-96F4381A872C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/47/D3/47D39574-8582-327A-8EC6-91D6FEA4A9D7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/76/2E/762E6C9F-E522-5A75-4A7E-08E77419D7D3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/8A/FA8AADB9-48A2-B7B7-9912-4E45D2EE5CA6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/87/E9/87E9774C-0E91-0677-6279-9F08A6CAEB90_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/07/0E/070E8985-B586-D3AD-9F54-E1683D5ECD48_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5C/27/5C27EFC9-9C2F-1A9C-31D3-C00038609964_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4F/E4/4FE471AB-DDDB-8E89-3656-ECA19C4B098E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A9/43/A9436C74-28EF-DBD0-6968-403E5B3AB86F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/54/5A/545AEFD9-EBA2-79E2-9A0F-DEC3A49C9D3D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/33/F3/33F3B3F6-E9E7-D6DD-39F9-380A8F0AB326_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E7/F1/E7F18893-C069-FE21-1B11-6C65F21D9924_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/F1/4F/F14FAF0B-07DD-350D-5F7E-8E00766141BF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0F/F6/0FF6A468-4FCA-F849-ABC7-996F937E5297_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3C/DA/3CDAFB71-B159-1658-AE57-01E9CEABFD08_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FA/DF/FADF350C-C20B-1BEE-E711-BB4C8BA3C650_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/30/4B/304B3CF5-852B-E26D-8D9F-367BF41EC307_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AE/5A/AE5A3429-3833-F54E-9075-2CAC1E554B2B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/DB/CF/DBCFFC72-5DD7-75CA-C5E2-830947B97DF4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FB/25/FB257FAA-0BEB-0D8D-EC5A-226E9B86D523_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/1B/93/1B932555-05E5-9A5E-DA18-63F993D0A982_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FE/1E/FE1EDCE5-0563-86A6-86D6-4E30B2EA72B5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/16/8B/168BEF83-5B17-88D7-B44E-080682F8FC25_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/46/4E462E49-9415-A068-95D7-DDF592FC59F6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/52/D8/52D8C9CC-D119-1AD1-CD69-5D7CA57CBE9D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/32/36/323673FB-D379-648F-B0DB-57B0D88BD8C1_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/7C/BF/7CBF0CF3-7AB3-FCA1-5F40-F83BA6C06BCC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DD/10/DD10BA80-337D-A0D7-4B88-8D2CC834F82F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/D1/43/D143CBF6-9592-ED60-1ED4-8E04ADC328F2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/35/B6/35B63882-CA0B-17E0-38F4-4D84271AF749_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/61/8F/618F6A6E-9C8F-B3B1-2350-F3CAF7BD89A4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/02/44/024487C0-1347-4819-14C2-65AA026092D4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/04/5A/045A92CE-690E-3D90-D616-4AD4296B2958_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/65/08/650887D5-EAC1-CE87-3F79-612E32F9E2DD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/70/A2/70A258B3-27B1-73DB-BEE4-CA427C976D23_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7E/99/7E997CC3-6154-285E-BF93-29124736A6AF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7A/DD/7ADDFD06-BAA8-8D84-2404-CB0D67D0A427_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CF/3D/CF3DFC9F-D594-0B80-3403-48751C412251_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/5B/DF/5BDFCAB4-51B2-95AC-0132-FF13EA61E7A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7A/1D/7A1DD3EA-5418-9CFA-447E-76C77CF1B8A0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C9/69/C969CFCA-F3AA-B620-4662-7AF54E07E4A8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/34/FC/34FC46C4-211B-BBC7-3E12-22DBFBA1DDD0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/37/13/371376E9-B79B-3B62-3047-1D74BEAA5735_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5B/3E/5B3EE3A6-9068-497E-B7D8-27B1F9CD642E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/83/06/83066036-8498-C4E5-70BF-042E3F01796A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C5/1E/C51E3059-9E4F-E8BA-AB2D-F611DBEC4805_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/79/67/796771F4-0775-ADDD-577C-5145F68790B2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5F/71/5F719F08-AA70-54E4-576E-C80F447F15CC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0D/6F/0D6F01C7-1661-67F6-82B9-4DE48F6076A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9F/B3/9FB38683-589D-1F78-68E2-A05125C55FB7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3D/5F/3D5F60F3-896F-D7EB-1681-208B00EA4418_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/BD/A2/BDA2BE90-9791-4080-0147-E6FD664CAD72_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6A/9D/6A9DEED3-FF55-7670-3430-15D9E532B378_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/F8/B2F81273-378F-F35B-F62A-9B22579A6818_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F7/CC/F7CC5876-CA06-3D75-B74E-19050CE2825D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/09/F9/09F9E094-A135-EEFA-614A-B1E57A16D186_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/52/86/5286A226-FC85-1D46-9778-C3DE4BAA0486_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/56/63/5663B788-A3E3-30EB-7722-7EA0AC2E1E68_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E3/DC/E3DC0A8F-53DC-61CA-66E0-6EA50A14332C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D8/CE/D8CE8621-68AA-414E-D886-2D944013053E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1F/1B/1F1BA042-E273-532E-94BB-264BB48FB271_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/03/11/03110744-0955-B27C-602F-76F76BF5F70D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1C/C9/1CC968E4-21F5-C490-5535-3FB843848A03_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1D/58/1D58967E-8FA9-55A1-9EAB-6862F804ABA4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/48/A4/48A4EF97-8F71-693D-4B2D-22BC4BC834A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/83/B5/83B5C445-4CB4-055C-1099-F94F19D0BBBD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DE/04/DE0476BB-EF92-D3BC-2B71-AFF653659203_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/03/F8/03F84B3F-CFB9-10A8-0CC7-1F710DD93490_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/55/54/5554C738-0D07-6C90-58FC-1BFC34AC3472_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/86/75/8675034A-09F9-4E89-A190-0CB0FA82F45C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AC/1D/AC1D3875-9F75-CCF9-D5C4-38060BA2B83B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/18/A6/18A6C7A7-9D45-73A8-8254-D49149B2861E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2C/53/2C533870-A71A-68C3-67C4-BB81F1CB9F72_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/29/69/29699F7E-3FE0-DB8B-1A07-0B7135B89EE6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/29/96/29961450-7469-CEB9-CB2B-B7BD04074CC2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/5C/6D5C0DD4-E185-B6DF-0CFC-74AA7233E6A0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A4/FB/A4FB5868-7A7B-DF3D-2D12-38BAF719CBF9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/AE/0E/AE0E47E3-76ED-4C46-3070-C99BA3D2B93B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/0C/6E/0C6EF09B-2E50-B622-9399-5B44F0AA4DF5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0A/48/0A48556F-AE4E-6B50-E340-EAF2707110F9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/03/4C/034C7A1A-F5D4-3065-38AC-6C00F8C65DE0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/2C/AE/2CAECE74-089E-EF5D-540C-FFC8A906886C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4C/A0/4CA0FB72-F592-3CEB-153E-AE493CF69BA3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6A/12/6A1292FB-ABC9-D219-A23D-1D3D49B3CDEF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F2/7F/F27F8B78-1CC1-E10D-D6BA-814AFD7C2BE8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/C6/ED/C6ED00DE-BE8D-49FC-DE36-9559845F0A1F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/55/80/5580AF47-8E68-AEF5-06E9-3E58A11CAB85_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C7/AD/C7AD1907-A30D-95A3-B0FD-E3355502609A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FB/6D/FB6D567C-DEEE-1D26-E8EB-129CE000AC01_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/9D/F6/9DF6103C-D885-60F6-CA8F-A7F56090EC50_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B2/3D/B23D5B4F-781D-5444-0956-62E64E71AB0C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FA/CE/FACE7063-808C-2F5B-6AEB-82A197E0B75F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/74/89/748989D3-2C29-10F7-C527-610673DFE2B4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/97/F4/97F42ADA-2E75-0952-D6DD-824F89689803_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F4/1D/F41D3356-3DFC-4D80-DACF-9E38B01D72B2_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/60/3D/603D13D0-9AF4-86A2-27A4-D6BD59057840_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/79/2A/792AFDE6-1EC7-3D4F-EDB2-B825CDFCBAA9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E1/F3/E1F3AFED-1B93-848F-E2C1-20FDDB24B9F5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/45/5E/455E35FE-7A98-F3EF-5E28-CF4A0A791E99_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5B/47/5B477D82-22EF-F7EF-9A4A-BECA431615D0_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E2/9C/E29C18F6-0FE1-E361-189A-6966E37C7917_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CB/14/CB146E4B-F2C0-5F15-CA77-8AD62BCA6757_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/gchataudio/75/76/75764157-378F-A8FB-793D-94C6544BD859.amr','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0A/3D/0A3DB33B-9D93-27C6-0231-9D114CE292BF_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0E/5B/0E5B88DA-A477-231B-7F73-6BAA1DE1DCE4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/48/8B/488BC179-7B43-81DC-AA6D-BA2F9490C40F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8C/15/8C150D8F-A27B-0802-DE1F-029870F87CAE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/8E/FC/8EFC9D78-9B02-3658-2770-4354CB71C7F4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/94/2B/942B312F-E12D-C7DD-B57B-C36C3C0500F4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9A/54/9A54C606-028A-101A-3BA9-A625D153FB3C_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CC/C6/CCC61611-D419-F756-26E9-C6CD4D6661BD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B2/EA/B2EAE5A0-6E4B-A6AC-374C-A193F0C8CAD6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A7/6A/A76A1E5C-C6AA-D6DD-48DF-A2FA7BD06D6E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/56/B2/56B2589C-1632-57C2-88D9-8C5A17CE4142_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/82/28/8228F926-6FD5-C295-D873-D662848896D3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/0A/62/0A621CF7-D892-BD2D-6601-2DC0A6B43680_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7F/0A/7F0A84FA-4A18-559D-9B84-EDD7B4ECFC0E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/01/47/01476B96-071D-66E7-AAF8-8F9AB1224F0E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AB/E9/ABE94517-0E2F-CAB4-EB78-C3FC185744B6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/E6/61/E661AC10-9822-9F3E-A379-5DC024C0C2AB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3F/50/3F50E4F9-E5D4-86AE-BEC9-86CD315FA867_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/22/AE/22AEB371-AB7F-A76E-7D53-5AD8DCDFC7CE_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5A/7F/5A7F9223-36BA-1AFB-3F26-30E0993325FC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/81/60/81601D52-545A-B6BB-17E9-F449BDAA76A6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9C/37/9C373F9F-2B88-2170-9BE0-A2F504C92F3E_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3E/15/3E158D51-15D1-681E-4668-07F9A9BFD9C9_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/5F/3B/5F3BD1B6-BE30-E145-11BD-0AA22DD641FB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/73/33/7333C92D-4757-6FEC-B000-802F683CD767_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/CC/85/CC857D90-3011-E385-5850-6B01C99B8236_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/CD/46/CD464AFB-AEAD-0021-C745-A79E8434E4AC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E6/1C/E61C8665-2CFD-DA38-60B6-D1320C9517A7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/46/85/4685B029-824D-A612-AA9D-A5642B1FF3A5_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/61/B2/61B2FB58-E4A4-B6E1-4B35-EAAFF5E74AF7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/9D/6D9D9761-05C3-F381-8590-A018B9212D46_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C6/84/C6841847-83BB-AFEF-4E66-38BBAEAAE5BC_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FB/12/FB12FF1F-DA66-02A3-4999-ADC699BDF1D4_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/20/E2/20E2B7E7-F950-7128-F7F4-54647BD16788_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/28/26/2826A979-35D8-2A89-66C8-9EA61EBC267B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/31/A4/31A49018-9EC2-8DF2-62D3-C3CB9816240B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3F/B1/3FB1B5B1-7A25-8D60-4FCD-14B35AAF54CB_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DA/3C/DA3C31DC-F74C-AC28-6D16-C8B5ED80D348_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/ED/2B/ED2BFC73-1F4B-9EF2-F78F-F48E9B6B10C8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/3C/F6/3CF6667D-92D2-67ED-E230-B9F1BFC99E13_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1E/36/1E361E17-FDFB-DBD8-C61D-F0A446EDFC48_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/3D/7A/3D7ACB60-33EA-F420-3CC7-EC86E21536ED_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/57/62/5762F572-9DA9-9AF8-CD3E-940EBC8B451B_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/89/11/8911600C-3B80-4CDF-B5D4-213AFB5CBA15_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A6/56/A656616A-7801-8ACA-BE90-7ED06F61A4C7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/AF/E9/AFE9000B-480C-2251-F5A3-876D49BFDB9F_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BE/6B/BE6B487F-366F-CBFE-8ED6-8F515EB94604_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/BF/EC/BFECCEA6-6F02-5323-D588-A841B2E652AA_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D6/B0/D6B018E1-6FB4-1EE5-E7B5-4C0DD6F9CBD7_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D9/05/D9055C06-D9A5-60E2-07C3-55CFC3F0CB0D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/2F/672FA2A3-D1AB-D4A0-0777-59158B119F47_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/75/6775C7DC-95FE-F032-87B9-E38D146AC635_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/DD/A4/DDA4A5FF-9C94-09EF-9982-D6D4EB325823_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/34/FC/34FC46C4-211B-BBC7-3E12-22DBFBA1DDD0_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/55/9D/559D6B5C-64BD-6DFD-FAFD-AFCB7EC218FF_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/F6/77/F6773B91-65F2-C530-A76C-22632848BC06_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/4E/27/4E273B05-5C51-9589-2E47-ED2549962278_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/3A/673AB55F-ABAB-9993-055C-2CDAC1A58FE9_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7D/4F/7D4F19AA-CC06-E9F8-907F-7C083206D30C_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/CC/7A/CC7A94F8-A149-5C19-9577-66B31B215061_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/59/5D593A0D-13FE-1D57-C598-25EDEB7122A7_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1C/54/1C549E15-AF93-4D15-ACF0-AAA7EB371144_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E4/90/E4902628-90B4-45F4-4A77-34F4B9D8841F_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/68/E7/68E7F479-8B7B-478C-4BA1-2AFDBA48A03E_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FD/42/FD422DBB-805D-786C-5445-E81D6FD49834_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/19/54/195462C2-4334-E731-345B-10DC199C1BAF_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/1D/E8/1DE8C06E-64C3-0135-3418-6DFF501F1A86_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/9E/8A/9E8A8ABE-DFE0-3AE4-C3E4-31554B96FB02_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D9/91/D9910227-B7C5-517B-7B55-600019202A85_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E1/07/E107043B-C8B9-3F71-8F92-7B59B263E419_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/67/75/6775C7DC-95FE-F032-87B9-E38D146AC635_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/5D/61/5D61BF7F-324A-0407-6BDB-5F7E4F431F75_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/6D/29/6D293FED-D2E7-521C-688F-42429FD59054_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/FD/DB/FDDBCA9F-DCDB-5C51-72BD-701B8AEC5D20_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/45/B1/45B19BE6-F291-BB36-6CD6-9D8B0D1304CD_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/80/DC/80DC2521-14B0-982E-032E-028B2539996A_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/C6/ED/C6ED00DE-BE8D-49FC-DE36-9559845F0A1F_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/72/22/7222C3D2-3D84-5388-C899-14148A7E1C23_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/C4/E5/C4E54734-5CDA-9EF2-30BF-58DB7B0AC2AB_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B1/16/B11664C3-6BE5-9EEA-36C1-3F8AC5D6A20D_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/04/5A/045A92CE-690E-3D90-D616-4AD4296B2958_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/9E/0D/9E0D52DC-6AFD-C03F-8289-E21E9C4CDFE8_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/FF/F6/FFF6923C-0242-9A59-AFA6-99D0390C2F7F_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/EM/OT/EMOTION_1000_momo_07_OVsAQfvY_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/59/67/59679900-21BB-6135-52B4-50ED02C00066_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/0A/3D/0A3DB33B-9D93-27C6-0231-9D114CE292BF_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/91/49/91494708-8844-7063-BC76-4E2C74719038_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/A7/6A/A76A1E5C-C6AA-D6DD-48DF-A2FA7BD06D6E_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/B1/AA/B1AA1491-CF71-7AC1-76E7-8F89740764DD_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/E0/87/E087584C-C32C-BBC8-C296-54158F1837A3_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/36/28/3628DE34-51FE-4D37-05F8-18D6734B5B36_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/B4/12/B4125CFF-EE6D-8238-C96F-839F085654CE_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/D8/57/D857D342-158A-C826-43B3-5878170CA3C6_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/8F/1C/8F1C9AE2-0725-A947-98C4-59D0A597D192_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/55/54/5554C738-0D07-6C90-58FC-1BFC34AC3472_L.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/50/AA/50AA8806-9817-7AF8-DB7E-FC6FFD718EA8_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/album/7C/0F/7C0F8574-35E5-A5EF-AB0E-F80B24DDD749_S.jpg','somecontent');insert into `url_rule` (`url`, `content`) values('http://img.immomo.com/feedimage/5C/93/5C93EE56-E1D9-061E-0372-7FD897D425DC_L.jpg','somecontent');

11.txt

1374609599.551374609599.841374609599.840.0011058615978837148460021381021527861386001262280124600142053242610.15.210.4474.125.31.1051113806cmnet1221.177.217.133221.177.152.242221.177.217.134221.177.152.242www.google.comhttp://www.google.com/ig/api?hl=en&weather=涓婃捣Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)GET40342014293200320000http://www.google.com/ig/api?hl=en&weather=涓婃捣590390326219693260959039032711629742095986939971374609641.501374609641.561374609641.561374609642.0211058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/26/91/2691C407-2E66-86A0-1A16-72836F3511A3_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20042358404500450000http://img.immomo.com/album/26/91/2691C407-2E66-86A0-1A16-72836F3511A3_S.jpg5903898033224736779590390344584647476359511421374609642.081374609642.311374609642.311374609642.7411058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/E7/68/E7685BBC-E4FF-4C78-574A-F797203B8D8D_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20042351444600460000http://img.immomo.com/album/E7/68/E7685BBC-E4FF-4C78-574A-F797203B8D8D_S.jpg5903898033224736779590390344584647476359511421374609642.781374609642.841374609643.071374609643.3411058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/59/CE/59CEA183-2535-60AB-DC39-EE6BBFDCB687_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20052798656900690000http://img.immomo.com/album/59/CE/59CEA183-2535-60AB-DC39-EE6BBFDCB687_S.jpg5903898033224736779590390344584647476359511421374609643.461374609643.521374609643.521374609643.9211058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/7C/E4/7CE45F9A-868B-BD27-B92D-55EBA094A589_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20047572395600560000http://img.immomo.com/album/7C/E4/7CE45F9A-868B-BD27-B92D-55EBA094A589_S.jpg5903898033224736779590390344584647476359511421374609644.061374609644.211374609644.251374609644.6611058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/C8/D7/C8D7DF2E-55AC-C9EA-9725-54A60BF1CBDC_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20047567775700570000http://img.immomo.com/album/C8/D7/C8D7DF2E-55AC-C9EA-9725-54A60BF1CBDC_S.jpg5903898033224736779590390344584647476359511421374609695.100.000.000.0011058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2935591806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/A3/95/A39594A3-499B-5452-0187-2C36B4137A7D_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET126701000100000http://img.immomo.com/album/A3/95/A39594A3-499B-5452-0187-2C36B4137A7D_S.jpg5903898033224736779590390344584647476359511421374609639.641374609639.701374609639.971374609640.2611058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/45/B1/45B19BE6-F291-BB36-6CD6-9D8B0D1304CD_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20047545155500550000http://img.immomo.com/album/45/B1/45B19BE6-F291-BB36-6CD6-9D8B0D1304CD_S.jpg5903898033224736779590390344568391271559511421374609640.521374609640.571374609640.811374609641.2611058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/CB/14/CB146E4B-F2C0-5F15-CA77-8AD62BCA6757_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20057965287600760000http://img.immomo.com/album/CB/14/CB146E4B-F2C0-5F15-CA77-8AD62BCA6757_S.jpg5903898033224736779590390344568391271559511421374609641.361374609641.421374609641.421374609641.7411058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/BD/9C/BD9C1CA8-B6EB-EE67-57E6-0040BC321875_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20047547365500550000http://img.immomo.com/album/BD/9C/BD9C1CA8-B6EB-EE67-57E6-0040BC321875_S.jpg5903898033224736779590390344568391271559511421374609641.841374609641.901374609641.901374609642.2811058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/76/83/7683D8A4-4000-BB11-1099-111895648875_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20042358374500450000http://img.immomo.com/album/76/83/7683D8A4-4000-BB11-1099-111895648875_S.jpg5903898033224736779590390344568391271559511421374609642.461374609642.511374609642.511374609642.9611058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/4A/9F/4A9F6817-33DD-4ADA-FF73-0CF265A072D6_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20042355944500450000http://img.immomo.com/album/4A/9F/4A9F6817-33DD-4ADA-FF73-0CF265A072D6_S.jpg5903898033224736779590390344568391271559511421374609643.101374609643.231374609643.231374609643.4811058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/feedimage/F9/15/F9153581-73A9-B27A-81AD-58DFFA083EA3_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20042729714400440000http://img.immomo.com/feedimage/F9/15/F9153581-73A9-B27A-81AD-58DFFA083EA3_S.jpg5903898033224736779590390344568391271559511421374609643.681374609643.751374609643.811374609644.2411058615938631275460028936538368868878015090167824600187182473310.188.61.172211.136.10.2954390806cmnet1221.177.217.1221.177.217.161221.177.217.2221.177.217.167img.immomo.comhttp://img.immomo.com/album/35/E4/35E433F2-9B60-3D22-9E9E-2631C87A419D_S.jpgDalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C)GET20047574755700570000http://img.immomo.com/album/35/E4/35E433F2-9B60-3D22-9E9E-2631C87A419D_S.jpg590389803322473677959039034456839127155951142

自定义一个outputformat

package com.test.hadoop.mr.logenhance;import java.io.IOException;import org.apache.hadoop.fs.FSDataOutputStream;import org.apache.hadoop.fs.FileSystem;import org.apache.hadoop.fs.Path;import org.apache.hadoop.io.NullWritable;import org.apache.hadoop.io.Text;import org.apache.hadoop.mapreduce.RecordWriter;import org.apache.hadoop.mapreduce.TaskAttemptContext;import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;/** * maptask或者reducetask在最终输出时，先调用OutputFormat的getRecordWriter方法拿到一个RecordWriter * 然后再调用RecordWriter的write(k,v)方法将数据写出 *  * @author *  */public class LogEnhanceOutputFormat extends FileOutputFormat<Text, NullWritable> {@Overridepublic RecordWriter<Text, NullWritable> getRecordWriter(TaskAttemptContext context)throws IOException, InterruptedException {FileSystem fs = FileSystem.get(context.getConfiguration());Path enhancePath = new Path("D:/temp/en/log.dat");Path tocrawlPath = new Path("D:/temp/crw/url.dat");FSDataOutputStream enhancedOs = fs.create(enhancePath);FSDataOutputStream tocrawlOs = fs.create(tocrawlPath);return new EnhanceRecordWriter(enhancedOs, tocrawlOs);}/** * 构造一个自己的recordwriter *  * @author *  */static class EnhanceRecordWriter extends RecordWriter<Text, NullWritable> {FSDataOutputStream enhancedOs = null;FSDataOutputStream tocrawlOs = null;public EnhanceRecordWriter(FSDataOutputStream enhancedOs, FSDataOutputStream tocrawlOs) {super();this.enhancedOs = enhancedOs;this.tocrawlOs = tocrawlOs;}@Overridepublic void write(Text key, NullWritable value) throws IOException, InterruptedException {String result = key.toString();// 如果要写出的数据是待爬的url，则写入待爬清单文件 /logenhance/tocrawl/url.datif (result.contains("tocrawl")) {tocrawlOs.write(result.getBytes());} else {// 如果要写出的数据是增强日志，则写入增强日志文件 /logenhance/enhancedlog/log.datenhancedOs.write(result.getBytes());}}@Overridepublic void close(TaskAttemptContext context) throws IOException, InterruptedException {if (tocrawlOs != null) {tocrawlOs.close();}if (enhancedOs != null) {enhancedOs.close();}}}}

开发mapreduce处理流程

package com.test.hadoop.mr.logenhance;import java.io.IOException;import java.util.HashMap;import java.util.Map;import org.apache.commons.lang.StringUtils;import org.apache.hadoop.conf.Configuration;import org.apache.hadoop.fs.Path;import org.apache.hadoop.io.LongWritable;import org.apache.hadoop.io.NullWritable;import org.apache.hadoop.io.Text;import org.apache.hadoop.mapreduce.Counter;import org.apache.hadoop.mapreduce.Job;import org.apache.hadoop.mapreduce.Mapper;import org.apache.hadoop.mapreduce.lib.input.FileInputFormat;import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;public class LogEnhance {static class LogEnhanceMapper extends Mapper<LongWritable, Text, Text, NullWritable> {Map<String, String> ruleMap = new HashMap<String, String>();Text k = new Text();NullWritable v = NullWritable.get();// 从数据库中加载规则信息倒ruleMap中@Overrideprotected void setup(Context context) throws IOException, InterruptedException {try {DBLoader.dbLoader(ruleMap);} catch (Exception e) {e.printStackTrace();}}@Overrideprotected void map(LongWritable key, Text value, Context context) throws IOException, InterruptedException {// 获取一个计数器用来记录不合法的日志行数, 组名, 计数器名称Counter counter = context.getCounter("malformed", "malformedline");String line = value.toString();String[] fields = StringUtils.split(line, "\t");try {String url = fields[26];String content_tag = ruleMap.get(url);// 判断内容标签是否为空，如果为空，则只输出url到待爬清单；如果有值，则输出到增强日志if (content_tag == null) {k.set(url + "\t" + "tocrawl" + "\n");context.write(k, v);} else {k.set(line + "\t" + content_tag + "\n");context.write(k, v);}} catch (Exception exception) {counter.increment(1);}}}public static void main(String[] args) throws Exception {Configuration conf = new Configuration();Job job = Job.getInstance(conf);job.setJarByClass(LogEnhance.class);job.setMapperClass(LogEnhanceMapper.class);job.setOutputKeyClass(Text.class);job.setOutputValueClass(NullWritable.class);// 要控制不同的内容写往不同的目标路径，可以采用自定义outputformat的方法job.setOutputFormatClass(LogEnhanceOutputFormat.class);FileInputFormat.setInputPaths(job, new Path("D:/hdfs/11.txt"));// 尽管我们用的是自定义outputformat，但是它是继承制fileoutputformat// 在fileoutputformat中，必须输出一个_success文件，所以在此还需要设置输出pathFileOutputFormat.setOutputPath(job, new Path("D:/temp/output/"));// 不需要reducerjob.setNumReduceTasks(0);job.waitForCompletion(true);System.exit(0);}}




0 0
阿里云域名使用方法 阿里云域名使用方法
原创粉丝点击
热门IT博客
淘宝小号一般价格淘宝小号一般价格
石青软件怎么样石青软件怎么样
什么是淘宝内置安全码
淘宝寄快递怎么算钱
矩阵潜袭在哪买
怎么退出linux中man
项目协同软件
天天德州网络异常
淘宝网卖家版电脑版
android 查看手机端口
php互联网全能工程师
mybatis log4j xml sql
python格式化输出内容
linux部署snmp
上海大学乐乎pt
武汉编程招聘
网络流行歌曲劲爆慢摇
js excel身份证号码
中国象棋打谱软件
c 算法
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 什么菜可以减肥 摇呼啦圈能减肥吗 减肥适合吃什么 专业减肥方法 适合学生减肥的方法 纤体梅能减肥吗 减肥可以喝什么 睡前喝什么减肥 减肥吃什么饼干 减肥的中药方子 躺着减肥的动作图 减肥午餐吃什么 跑步机减肥效果好吗 冬瓜减肥月瘦40斤 减肥该吃些什么食物 什么运动减肥效果好 减肥的人吃什么 游泳真的能减肥吗 熬夜能减肥吗 减肥精油哪个牌子好 减肥三餐吃什么 月经期间能减肥吗 生姜可以减肥吗 跑步有助于减肥吗 普洱茶可以减肥吗 每天跳绳可以减肥吗 怎样用跑步机减肥 喝柠檬水可以减肥吗 兰香子怎么吃减肥瘦身 哪些水果有助于减肥 吃哪些蔬菜可以减肥 什么食物有助于减肥 哪些食物有助于减肥 怎么样跳绳才能减肥 男子减肥跳女团舞 跳爵士舞能减肥吗 在家跳的减肥舞15分钟 减肥建身舞 简单减肥舞 李多燕减肥舞 跳鬼步舞可以减肥吗

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里