转: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.55 1374609599.84 1374609599.84 0.00 110 5 8615978837148 460021381021527 8613860012622801 2 460 0 14205 32426 10.15.210.44 74.125.31.105 1113 80 6 cmnet 1 221.177.217.133 221.177.152.242 221.177.217.134 221.177.152.242 www.google.com http://www.google.com/ig/api?hl=en&weather=涓婃捣 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) GET 403 420 1429 3 2 0 0 3 2 0 0 0 0 http://www.google.com/ig/api?hl=en&weather=涓婃捣 5903903262196932609 5903903271162974209 598693997
1374609641.50 1374609641.56 1374609641.56 1374609642.02 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/26/91/2691C407-2E66-86A0-1A16-72836F3511A3_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 423 5840 4 5 0 0 4 5 0 0 0 0 http://img.immomo.com/album/26/91/2691C407-2E66-86A0-1A16-72836F3511A3_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609642.08 1374609642.31 1374609642.31 1374609642.74 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/E7/68/E7685BBC-E4FF-4C78-574A-F797203B8D8D_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 423 5144 4 6 0 0 4 6 0 0 0 0 http://img.immomo.com/album/E7/68/E7685BBC-E4FF-4C78-574A-F797203B8D8D_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609642.78 1374609642.84 1374609643.07 1374609643.34 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/59/CE/59CEA183-2535-60AB-DC39-EE6BBFDCB687_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 527 9865 6 9 0 0 6 9 0 0 0 0 http://img.immomo.com/album/59/CE/59CEA183-2535-60AB-DC39-EE6BBFDCB687_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609643.46 1374609643.52 1374609643.52 1374609643.92 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/7C/E4/7CE45F9A-868B-BD27-B92D-55EBA094A589_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 475 7239 5 6 0 0 5 6 0 0 0 0 http://img.immomo.com/album/7C/E4/7CE45F9A-868B-BD27-B92D-55EBA094A589_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609644.06 1374609644.21 1374609644.25 1374609644.66 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/C8/D7/C8D7DF2E-55AC-C9EA-9725-54A60BF1CBDC_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 475 6777 5 7 0 0 5 7 0 0 0 0 http://img.immomo.com/album/C8/D7/C8D7DF2E-55AC-C9EA-9725-54A60BF1CBDC_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609695.10 0.00 0.00 0.00 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 35591 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/A3/95/A39594A3-499B-5452-0187-2C36B4137A7D_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 1 267 0 1 0 0 0 1 0 0 0 0 0 http://img.immomo.com/album/A3/95/A39594A3-499B-5452-0187-2C36B4137A7D_S.jpg 5903898033224736779 5903903445846474763 5951142
1374609639.64 1374609639.70 1374609639.97 1374609640.26 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/45/B1/45B19BE6-F291-BB36-6CD6-9D8B0D1304CD_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 475 4515 5 5 0 0 5 5 0 0 0 0 http://img.immomo.com/album/45/B1/45B19BE6-F291-BB36-6CD6-9D8B0D1304CD_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609640.52 1374609640.57 1374609640.81 1374609641.26 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/CB/14/CB146E4B-F2C0-5F15-CA77-8AD62BCA6757_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 579 6528 7 6 0 0 7 6 0 0 0 0 http://img.immomo.com/album/CB/14/CB146E4B-F2C0-5F15-CA77-8AD62BCA6757_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609641.36 1374609641.42 1374609641.42 1374609641.74 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/BD/9C/BD9C1CA8-B6EB-EE67-57E6-0040BC321875_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 475 4736 5 5 0 0 5 5 0 0 0 0 http://img.immomo.com/album/BD/9C/BD9C1CA8-B6EB-EE67-57E6-0040BC321875_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609641.84 1374609641.90 1374609641.90 1374609642.28 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/76/83/7683D8A4-4000-BB11-1099-111895648875_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 423 5837 4 5 0 0 4 5 0 0 0 0 http://img.immomo.com/album/76/83/7683D8A4-4000-BB11-1099-111895648875_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609642.46 1374609642.51 1374609642.51 1374609642.96 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/4A/9F/4A9F6817-33DD-4ADA-FF73-0CF265A072D6_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 423 5594 4 5 0 0 4 5 0 0 0 0 http://img.immomo.com/album/4A/9F/4A9F6817-33DD-4ADA-FF73-0CF265A072D6_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609643.10 1374609643.23 1374609643.23 1374609643.48 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/feedimage/F9/15/F9153581-73A9-B27A-81AD-58DFFA083EA3_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 427 2971 4 4 0 0 4 4 0 0 0 0 http://img.immomo.com/feedimage/F9/15/F9153581-73A9-B27A-81AD-58DFFA083EA3_S.jpg 5903898033224736779 5903903445683912715 5951142
1374609643.68 1374609643.75 1374609643.81 1374609644.24 110 5 8615938631275 460028936538368 8688780150901678 2 460 0 18718 24733 10.188.61.172 211.136.10.29 54390 80 6 cmnet 1 221.177.217.1 221.177.217.161 221.177.217.2 221.177.217.167 img.immomo.com http://img.immomo.com/album/35/E4/35E433F2-9B60-3D22-9E9E-2631C87A419D_S.jpg Dalvik/1.6.0 (Linux; U; Android 4.1.1; vivo X1 Build/JRO03C) GET 200 475 7475 5 7 0 0 5 7 0 0 0 0 http://img.immomo.com/album/35/E4/35E433F2-9B60-3D22-9E9E-2631C87A419D_S.jpg 5903898033224736779 5903903445683912715 5951142
自定义一个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> {
@Override
public 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;
}
@Override
public void write(Text key, NullWritable value) throws IOException, InterruptedException {
String result = key.toString();
// 如果要写出的数据是待爬的url,则写入待爬清单文件 /logenhance/tocrawl/url.dat
if (result.contains("tocrawl")) {
tocrawlOs.write(result.getBytes());
} else {
// 如果要写出的数据是增强日志,则写入增强日志文件 /logenhance/enhancedlog/log.dat
enhancedOs.write(result.getBytes());
}
}
@Override
public 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中
@Override
protected void setup(Context context) throws IOException, InterruptedException {
try {
DBLoader.dbLoader(ruleMap);
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
protected 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文件,所以在此还需要设置输出path
FileOutputFormat.setOutputPath(job, new Path("D:/temp/output/"));
// 不需要reducer
job.setNumReduceTasks(0);
job.waitForCompletion(true);
System.exit(0);
}
}