Skip to main content

快速入门

基础操作

欢迎来到我们的基础操作章节!

此章节旨在为您提供上手使用 ArcGraph 的一些方法,帮助您快速入门并运行 ArcGraph🚀。

准备:理解 ArcGraph 图数据库核心概念

为了便于您快速理解 ArcGraph 的逻辑概念,我们给出了与 MySQL 数据库的对比。

ArcGraph 中的概念MySQL 中的概念
ClusterMaster-Slave Cluster、 MySQL Group Replication Cluster
GraphDatabase(DB)
Vertex Type、Edge TypeTable(表)
Vertex、EdgeRow(行、记录)
PropertyColumn(列、字段)

第一步:运行 ArcGraph 图数据库

您可以在本地使用 Docker 快速运行一个单机版的 ArcGraph 图数据库。

# X86_64 架构
docker run -d --net=host \
docker-reg.infra.fabarta.com:5000/fabarta-ga/engine-arcgraph-tp:v2.1.0-20240301-x86_64

# ARM 架构(比如 Mac M1/M2/M3 芯片)
docker run -d --net=host \
docker-reg.infra.fabarta.com:5000/fabarta-ga/engine-arcgraph-tp:v2.1.0-20240301-arm64

说明:

  • 安装 ArcGraph 前请联系 我们 获取 Docker 镜像。
  • 若下载镜像失败,请参考 Docker中如何设置 insecure-registries章节。
  • 不同版本的 ArcGraph 图数据库所对应的镜像版本会有所差异。本章节所展示的仅为示例,旨在为用户提供安装 ArcGraph 图数据库的指导。如需了解具体的 Docker 镜像信息,请参考 版本及对应 Docker 镜像 章节。

第二步:连接 ArcGraph 图数据库

使用客户端命令行工具(ArcGraph CLI)连接。

# X86_64 架构
docker run --net=host --rm -it \
docker-reg.infra.fabarta.com:5000/fabarta-ga/engine-arcgraph-tp:v2.1.0-20240301-x86_64 \
client -u arcgraph -p arcgraph -e 127.0.0.1:8182

# ARM 架构(比如 Mac M1/M2/M3 芯片)
docker run --net=host --rm -it \
docker-reg.infra.fabarta.com:5000/fabarta-ga/engine-arcgraph-tp:v2.1.0-20240301-arm64 \
client -u arcgraph -p arcgraph -e 127.0.0.1:8182

第三步:增删改查 ArcGraph 图数据库

创建图

使用 CREATE GRAPH 命令。

创建一个图,命名为“fabarta”,命令如下:

CREATE GRAPH IF NOT EXISTS fabarta;

查看图

查看当前系统中所有的图,命令如下:

SHOW GRAPHS;

切换/使用图

使用 USE GRAPH 命令。

类似 MySQL,在操作、查询数据之前,需要先切换到“fabarta”图,命令如下:

USE GRAPH fabarta; 

创建点类型

使用 CREATE VERTEX 命令创建点类型。

创建两个点类型,一个是“person”,一个是“book”,命令如下:

CREATE VERTEX IF NOT EXISTS person 
(
PRIMARY KEY id INT(64),
name STRING COMMENT '姓名',
age INT(32) NOT NULL DEFAULT '16' COMMENT '年龄',
INDEX name_index(name) UNIQUE
)
COMMENT = '人';

CREATE VERTEX IF NOT EXISTS book
(
PRIMARY KEY id INT(64),
name STRING COMMENT '书名',
author STRING COMMENT '作者',
INDEX name_book_index(name) UNIQUE
)
COMMENT = '书';

创建边类型

使用 CREATE EDGE 命令创建边类型。

创建一个边(关系),含义是“人喜欢书”,命令如下:

CREATE EDGE like 
(
since DATE COMMENT '开始时间',
FROM person TO book
)
COMMENT = '喜欢';

插入 点/边

添加两个点,一个是人“张三”,一个是书“《三体》”,命令如下:

INSERT (:person {id:1, name:'张三', age:30});
INSERT (:book {id:1, name:'《三体》', author:'刘慈欣'});

添加一个关系(边),“张三”喜欢“《三体》”,命令如下:

INSERT (:person {id: 1, name:'张三'})-[:like {since:'20230101'}]->(:book {id: 1, name:'《三体》'});

查看 点/边

  • 查看所有点

    MATCH (n) RETURN n;
  • 查看某一个点类型中所有的点

    查看所有的人,命令如下:

    MATCH (m:person) RETURN m;
  • 查看多个点类型中所有的点

    查看所有的人和书,命令如下:

    MATCH (m:person|book)  RETURN m;
  • 查看指定的点

    查看名字叫“张三”的人,命令如下:

    MATCH (m:person {name:'张三'}) RETURN m;
  • 查看指定的边

    查看“张三”都喜欢什么书,命令如下:

    MATCH (:person {name:'张三'})-[r:like]->(n:book) RETURN n;

更新 点/边

  • 更新点

    更新“张三”的年龄。

    MATCH (n:person)
    WHERE n.name = '张三'
    SET n.age = n.age + 1;
  • 更新边

    更新喜欢的时间。

    MATCH (n:person {name:'张三'})-[r:like]->(m)
    SET r.since = '20240101';

删除 点/边

  • 删除边(关系)

    “张三”不再喜欢“《三体》”。

    MATCH (:person {name:'张三'})-[r:like]->(:book {name:'《三体》'})
    DELETE r;
  • 删除点

    删除“张三”。

    MATCH (n:person {name:'张三'})
    DELETE n;

删除图

删除“fabarta”图。

DROP GRAPH fabarta;

复杂查询

ArcGraph 图数据库提供了强大的查询和分析功能,能够高效的处理复杂关联数据。本章节将详细介绍在 ArcGraph 图数据库中执行复杂查询前的数据准备操作,并通过示例展示如何构建和执行复杂查询语句。

准备数据

为了执行图查询,首先需要在 ArcGraph 图数据库中定义图的模式(Schema)并创建相应的图数据。

创建图 Schema

在 ArcGraph 图数据库中,创建图 Schema 包括定义图、点类型、边类型以及它们的属性。

img-schema.png

创建如上图所示的图 Schema,语句示例如下:

DROP GRAPH IF EXISTS ARC_GRAPH_TEST;
CREATE GRAPH IF NOT EXISTS ARC_GRAPH_TEST CHARSET=utf8;
USE GRAPH ARC_GRAPH_TEST;
CREATE VERTEX person (primary key id INT(64), firstName string NULL, lastName string NULL, gender string NULL, birthday Date NULL, locationIP string NULL, browserUsed string NULL, creationDate DateTime NULL, language array(string),email array(string)) PARTITION BY HASH(_ID) COMMENT = 'person';
CREATE VERTEX post (primary key id INT(64), imageFile string NULL, language string NULL, content string NULL, length int(64) NULL, locationIP string NULL, browserUsed string NULL, creationDate DateTime NULL) PARTITION BY HASH(_ID) COMMENT = 'post';
CREATE VERTEX comment (primary key id INT(64), locationIP string NULL, browserUsed string NULL, creationDate DateTime NULL, content string NULL, length int(64) NULL, imageFile string NULL) PARTITION BY HASH(_ID) COMMENT = 'comment';
CREATE VERTEX place (primary key id INT(64), type string NULL, name string NULL, url string NULL) PARTITION BY HASH(_ID) COMMENT = 'place';
CREATE VERTEX tag (primary key id INT(64), name string NULL, url string NULL) PARTITION BY HASH(_ID) COMMENT = 'tag';
CREATE VERTEX organisation (primary key id INT(64), type string NULL, name string NULL, url string NULL) PARTITION BY HASH(_ID) COMMENT = 'organisation';
CREATE EDGE hasCreator (FROM comment TO person, FROM post TO person) ;
CREATE EDGE replyOf (FROM comment TO comment, FROM comment TO post) ;
CREATE EDGE knows (creationDate DateTime NULL, FROM person TO person) ;
CREATE EDGE isLocatedIn (FROM organisation TO place, FROM comment TO place, FROM person TO place, FROM post TO place) ;
CREATE EDGE hasInterest (FROM person TO tag) ;
CREATE EDGE hasTag (FROM post TO tag, FROM comment TO tag) ;
CREATE EDGE workAt (workFrom INT(32) NULL, FROM person TO organisation) ;
CREATE EDGE studyAt (classYear INT(32) NULL, FROM person TO organisation) ;

创建图数据

通过创建图数据的语句,将点、边以及它们的属性数据添加到图中,为后续图数据库操作提供数据基础。创建图数据的语句示例如下:

INSERT (:comment{id:824633877018,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-02-10T17:30:51.622+0000",content:"About Aristophanes,  author-director of comedies About By the Way, 't Stop, Dosed and ",length:86}),(:comment{id:687195079894,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-06T22:36:27.118+0000",content:"fine",length:4}),(:comment{id:1099511761484,locationIP:"27.112.77.149",browserUsed:"Safari",creationDate:"2012-09-11T02:01:34.893+0000",content:"About Kingdom of Bavaria,  size only to the Kingdom of Prussia. Since the unAbout Mellow Yellow, t",length:98}),(:comment{id:68719620861,locationIP:"49.194.208.50",browserUsed:"Internet Explorer",creationDate:"2010-04-26T22:18:49.591+0000",content:"About Robin Williams, obin McLaurin Williams (born July 21, 1951) is an American a",length:82}),(:comment{id:962072693254,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-05-11T02:41:12.119+0000",content:"I see",length:5}),(:comment{id:1030792475457,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2012-08-04T13:57:40.286+0000",content:"About Azerbaijan,  high level of human development, economic development and literacy, as ",length:90}),(:comment{id:893353490440,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-04-21T00:36:56.843+0000",content:"About Horatio Nelson, 1st Viscount Nelson,  Wars allowed About John Rhys-Davies,",length:80}),(:comment{id:206158755519,locationIP:"77.109.222.191",browserUsed:"Chrome",creationDate:"2010-08-16T10:06:21.445+0000",content:"thx",length:3}),(:comment{id:824633996211,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-01-31T05:23:39.002+0000",content:"About Andrey Kolmogorov, лмого́ров) About Theodore Roosevelt,  founder ofAbout Pete ",length:84}),(:comment{id:893353464876,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2012-05-03T20:10:50.186+0000",content:"LOL",length:3}),(:comment{id:1030792191617,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-07-29T13:22:49.799+0000",content:"About Benjamin Disraeli,  the party, particularly Lord Derby, tAbout Midnig",length:75}),(:comment{id:1030792312598,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-05T14:57:01.360+0000",content:"I see",length:5}),(:comment{id:755914580593,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-12-05T10:09:40.545+0000",content:"About Humayun,  earned him the title ’Insān-i-Kamil (‘PerfeAbout Hanseatic League, ants",length:87}),(:comment{id:137439290004,locationIP:"46.231.193.21",browserUsed:"Chrome",creationDate:"2010-06-06T23:21:33.654+0000",content:"About Mao Zedong, haoshan, Hunan, China Died September 9, 1976(1976-09-09) (aged 82)B",length:85}),(:comment{id:1030792312141,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-05T19:04:29.103+0000",content:"yes",length:3}),(:comment{id:687195079891,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-06T22:36:22.049+0000",content:"About Sammy Sosa, our MajoAbout Salman Rushdie,  Fire ofAbout Genghis Khan,  th",length:79}),(:comment{id:962072934715,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-07-07T19:48:20.997+0000",content:"About Nagorno-Karabakh Republic,  Republic (Armenian: Արցախի Հանրապետություն AAbout I Ca",length:88}),(:comment{id:481036663378,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-03-29T23:24:16.988+0000",content:"LOL",length:3}),(:comment{id:206158767047,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2010-08-30T15:23:59.466+0000",content:"About Neil Diamond, red internationally by many performers from various musical genres. Di",length:90}),(:comment{id:1030792312428,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-05T19:10:56.556+0000",content:"About Fidel Castro, hey unsuccessfAbout Ovid,  Quintilian coAbout Video Killed ",length:79}),(:comment{id:962073011270,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-05-23T08:50:15.425+0000",content:"About Humayun, , Akbar. His peaceful personality, patiencAbout Antigua and Barbuda",length:82}),(:comment{id:1030792285837,locationIP:"103.4.20.110",browserUsed:"Internet Explorer",creationDate:"2012-09-06T09:29:34.041+0000",content:"no way!",length:7}),(:comment{id:1030792162212,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-08-19T03:11:59.731+0000",content:"About Ghost Reveries, what was heard in previous efforts. It is alsoAbout Electric Ladylan",length:90}),(:comment{id:1030792311835,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-06T10:00:51.866+0000",content:"LOL",length:3}),(:comment{id:1030792312481,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2012-08-04T16:29:05.652+0000",content:"cool",length:4}),(:comment{id:687195079884,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-07T14:38:30.405+0000",content:"roflol",length:6}),(:comment{id:549756126406,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2011-05-07T06:02:14.448+0000",content:"duh",length:3}),(:comment{id:687195079888,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-10-07T06:38:26.194+0000",content:"maybe",length:5}),(:comment{id:481036497897,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-04-22T15:28:33.210+0000",content:"About Jacques Brel, gston Trio, Nina Simone, Frank Sinatra, Scott About Boris Karloff,  his",length:91}),(:comment{id:1030792191618,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-07-29T16:52:54.729+0000",content:"ok",length:2}),(:comment{id:893353223107,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-04-05T07:18:19.907+0000",content:"no",length:2}),(:comment{id:412317198521,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-01-08T03:49:31.677+0000",content:"no way!",length:7}),(:comment{id:824634014664,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-02-08T10:40:53.294+0000",content:"What Have You Done for Me Lately? is the lead single from Janet Jackson's third s",length:81}),(:comment{id:962072693253,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-05-11T01:36:43.867+0000",content:"About Adolf Hitler, strust for mainstreAbout Francisco Franco, ion and var",length:74}),(:comment{id:824633996216,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-01-30T16:28:22.458+0000",content:"About Andrey Kolmogorov, atician, prAbout Theodore Roosevelt, hero was elAbout Philip K",length:87}),(:comment{id:893353421361,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-04-15T00:13:43.194+0000",content:"great",length:5}),(:comment{id:824633996217,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-01-31T08:27:04.882+0000",content:"LOL",length:3}),(:comment{id:481036662991,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-03-30T03:13:22.932+0000",content:"About Pope Pius XII, g lenient policies towards Axis anAbout Me Against the Music, . The song won the Hot Dance SinglAbout Pahlavi dynasty, i (reg. 1925–1941) and Moh",length:166}),(:comment{id:68719620859,locationIP:"27.126.153.181",browserUsed:"Chrome",creationDate:"2010-04-26T04:00:48.992+0000",content:"About Interpol, ence, one often has a number of data points, obtained by sampl",length:78}),(:comment{id:1030792285836,locationIP:"199.103.77.189",browserUsed:"Chrome",creationDate:"2012-09-06T03:55:33.438+0000",content:"About I Shot the Sheriff, en by Bob Marley, told from the point of view of a man who admits to having killed the local sheriff, but claims to be falsely accused of ha",length:166}),(:comment{id:549756126407,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-05-08T01:39:43.863+0000",content:"About Pierre Trudeau,  and aroused passionate reactions. ReasAbout Freddie M",length:76}),(:comment{id:893353536615,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-04-20T11:28:30.859+0000",content:"right",length:5}),(:comment{id:893353223100,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-04-04T09:06:56.792+0000",content:"About Pharrell Williams, Frontin' in 2003 and followed up with his first album In My Min",length:88}),(:comment{id:549756126405,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-05-07T04:17:11.944+0000",content:"no way!",length:7}),(:comment{id:962072693255,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-05-09T19:36:10.420+0000",content:"cool",length:4}),(:comment{id:412317197742,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-02-12T04:46:10.373+0000",content:"About John Denver, d adult contemporary, in all earning him 12 gold and 4 platinum a",length:84}),(:comment{id:1030792475467,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-04T14:01:22.510+0000",content:"About Everyday Is Like Sunday, . A mostly instrumental version (containinAbout Azer",length:83}),(:comment{id:1099511761487,locationIP:"103.4.20.110",browserUsed:"Internet Explorer",creationDate:"2012-09-11T07:59:35.930+0000",content:"yes",length:3}),(:comment{id:412317198072,locationIP:"196.46.21.47",browserUsed:"Chrome",creationDate:"2011-03-05T07:39:15.459+0000",content:"I see",length:5}),(:comment{id:687195079885,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-06T23:26:21.856+0000",content:"yes",length:3}),(:comment{id:824634045418,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2012-02-21T22:39:58.321+0000",content:"duh",length:3}),(:comment{id:68719620860,locationIP:"27.126.153.181",browserUsed:"Chrome",creationDate:"2010-04-26T09:33:28.949+0000",content:"About Otto von Bismarck, rman Empire had universal male suffrage, the elected officials did not have real control of ",length:117}),(:comment{id:962072941171,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-06-22T15:14:08.112+0000",content:"ok",length:2}),(:comment{id:137439289870,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2010-05-07T06:14:26.414+0000",content:"good",length:4}),(:comment{id:206158767051,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2010-08-30T15:24:27.797+0000",content:"About Neil Diamond, n records worldwide including 48 million iAbout Josephus, nity.",length:83}),(:comment{id:481036673597,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-04-08T11:28:35.443+0000",content:"About Humayun, day Afghanistan, Pakistan, and parts ofAbout Andre Agassi, e t",length:77}),(:comment{id:687195092171,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-10-22T09:14:03.332+0000",content:"right",length:5}),(:comment{id:412317197738,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-02-12T16:14:10.933+0000",content:"cool",length:4}),(:comment{id:1030792312616,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2012-08-05T10:57:19.111+0000",content:"no",length:2}),(:comment{id:481036663573,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-03-30T09:08:32.206+0000",content:"fine",length:4}),(:comment{id:687195079882,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-10-07T01:56:40.533+0000",content:"no",length:2}),(:comment{id:824633877031,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-02-10T17:31:13.367+0000",content:"thx",length:3}),(:comment{id:68719620866,locationIP:"27.54.75.46",browserUsed:"Firefox",creationDate:"2010-04-26T05:00:12.835+0000",content:"thx",length:3}),(:comment{id:962072761041,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-07-08T02:15:57.332+0000",content:"About Saints of Los Angeles,  band Mötley Crüe, released on June 24, 2008. It is the band's first studio album in eight years, and it marks the return of long-time drummer Tommy Lee",length:181}),(:comment{id:824633996220,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-02-01T03:39:52.967+0000",content:"About Pete Seeger, ve All theAbout ATLiens, try AssociAbout Cuba, proposal tA",length:77}),(:comment{id:893353494752,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2012-04-22T12:52:16.622+0000",content:"no way!",length:7}),(:comment{id:824634014661,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-02-07T22:00:33.249+0000",content:"no way!",length:7}),(:comment{id:824634014655,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-02-07T20:11:10.203+0000",content:"About Augustine of Hippo, thoughts profoundly influenced the medieval wAbout Republic of ",length:89}),(:comment{id:687195079886,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-07T02:10:01.191+0000",content:"duh",length:3}),(:comment{id:962072693245,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-05-09T12:43:11.708+0000",content:"About Silvio Berlusconi,  for his dominance overAbout Ecuador, nd least altered historAbou",length:90}),(:comment{id:68719620864,locationIP:"46.19.244.56",browserUsed:"Firefox",creationDate:"2010-04-26T04:01:19.734+0000",content:"fine",length:4}),(:comment{id:343597708049,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2010-11-23T07:06:08.028+0000",content:"ok",length:2}),(:comment{id:893353237444,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-04-27T18:25:37.769+0000",content:"About Costa Rica, the east. Costa Rica, which means Rich Coast, constitutionally abolished its army permanently in 1949. It is the only Latin American country included in the list of ",length:183}),(:comment{id:824634014656,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-02-07T23:17:34.540+0000",content:"roflol",length:6}),(:comment{id:1099511761482,locationIP:"31.209.120.110",browserUsed:"Internet Explorer",creationDate:"2012-09-10T23:33:15.980+0000",content:"About Kingdom of Bavaria, Most of Bavaria's modern-day borders were establis",length:76}),(:comment{id:1030792312004,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-08-05T07:23:59.708+0000",content:"thx",length:3}),(:comment{id:893353490443,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-04-21T00:44:17.149+0000",content:"About Igor Stravinsky, y the impresaAbout Horatio Nelson, 1st Viscount Nel",length:74}),(:comment{id:893353536001,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-05-04T15:19:58.331+0000",content:"About Viceroyalty of New Granada, rresponding mainly to modern Colombia, Ecuador, ",length:82}),(:comment{id:962072761050,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-07-08T23:06:58.279+0000",content:"About Austria,  defined by the Austrian dictionary (Österreichisches Wörterbuch), published About Saints of Los Angeles,  eventually scrapped. Nikki Six",length:152}),(:comment{id:1030792312202,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2012-08-04T10:23:31.377+0000",content:"thanks",length:6}),(:comment{id:1030792162208,locationIP:"79.99.59.182",browserUsed:"Internet Explorer",creationDate:"2012-08-18T07:15:43.453+0000",content:"About Pyotr Ilyich Tchaikovsky, ut unmistakably Russian style—a task thatAbout El",length:81}),(:comment{id:893353494749,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-04-22T01:48:48.515+0000",content:"About Steven Spielberg,  Saving Private RAbout James A. Garfield, . Garfield was thA",length:84}),(:comment{id:962072934712,locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-07-07T16:59:11.739+0000",content:"About I Can Hear Music, r Music is a song written by Jeff Barry, Ellie Greenwich and Phil ",length:90}),(:comment{id:343597720504,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2010-12-18T15:24:00.939+0000",content:"good",length:4}),(:comment{id:962072999307,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-05-29T09:42:35.288+0000",content:"About Adolf Hitler, i-semitic newspapers out of distrust foAbout Charles V, H",length:77}),(:comment{id:893353237446,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-04-27T20:55:10.979+0000",content:"About Living for the City, s synth groove (provided by the enormous TONTO modular ",length:82}),(:comment{id:687195079881,locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-10-07T20:11:29.948+0000",content:"About Sammy Sosa,  became oAbout Friedrich Schiller, eventeen About Eddie Mur",length:77}),(:comment{id:893353421359,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-04-14T20:53:54.604+0000",content:"About Joan of Arc, rge Bernard Shaw and Maxwell AnAbout Leonardo da Vinci, s technological ingenuity. He cAbout Luxembourg,",length:123}),(:comment{id:618475627816,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-08-06T00:33:49.592+0000",content:"cool",length:4}),(:comment{id:1030792312641,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2012-08-05T05:46:16.955+0000",content:"LOL",length:3}),(:comment{id:481036663273,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-03-29T22:20:37.481+0000",content:"fine",length:4});
INSERT (:organisation{id:297,type:"company",name:"Aero_Caribbean",url:"http://dbpedia.org/resource/Aero_Caribbean"}),(:organisation{id:963,type:"company",name:"Mosphil_Aero",url:"http://dbpedia.org/resource/Mosphil_Aero"}),(:organisation{id:955,type:"company",name:"Pacificair",url:"http://dbpedia.org/resource/Pacificair"}),(:organisation{id:2407,type:"university",name:"La_Salle_University,_Colombia",url:"http://dbpedia.org/resource/La_Salle_University,_Colombia"}),(:organisation{id:182,type:"company",name:"TAM_–_Táxi_Aéreo_Marília",url:"http://dbpedia.org/resource/TAM_–_Táxi_Aéreo_Marília"}),(:organisation{id:989,type:"company",name:"White_Airways",url:"http://dbpedia.org/resource/White_Airways"}),(:organisation{id:805,type:"company",name:"FlyMex",url:"http://dbpedia.org/resource/FlyMex"}),(:organisation{id:5526,type:"university",name:"Josefina_H._Cerilles_Polytechnic_College",url:"http://dbpedia.org/resource/Josefina_H._Cerilles_Polytechnic_College"}),(:organisation{id:168,type:"company",name:"Paraense_Transportes_Aéreos",url:"http://dbpedia.org/resource/Paraense_Transportes_Aéreos"}),(:organisation{id:296,type:"company",name:"Cubana_de_Aviación",url:"http://dbpedia.org/resource/Cubana_de_Aviación"}),(:organisation{id:985,type:"company",name:"EuroAtlantic_Airways",url:"http://dbpedia.org/resource/EuroAtlantic_Airways"}),(:organisation{id:27,type:"company",name:"Líneas_Aéreas_Federales",url:"http://dbpedia.org/resource/Líneas_Aéreas_Federales"}),(:organisation{id:965,type:"company",name:"Aerolift_Philippines",url:"http://dbpedia.org/resource/Aerolift_Philippines"}),(:organisation{id:184,type:"company",name:"Companhia_Itaú_de_Transportes_Aéreos",url:"http://dbpedia.org/resource/Companhia_Itaú_de_Transportes_Aéreos"}),(:organisation{id:951,type:"company",name:"Airphil_Express",url:"http://dbpedia.org/resource/Airphil_Express"}),(:organisation{id:141,type:"company",name:"Air_Minas_Linhas_Aéreas",url:"http://dbpedia.org/resource/Air_Minas_Linhas_Aéreas"}),(:organisation{id:271,type:"company",name:"AIRES",url:"http://dbpedia.org/resource/AIRES"}),(:organisation{id:961,type:"company",name:"2GO",url:"http://dbpedia.org/resource/2GO"}),(:organisation{id:1609,type:"university",name:"Saint_Thomas_Aquinas_University_of_the_North",url:"http://dbpedia.org/resource/Saint_Thomas_Aquinas_University_of_the_North"}),(:organisation{id:176,type:"company",name:"Aeronorte",url:"http://dbpedia.org/resource/Aeronorte"}),(:organisation{id:137,type:"company",name:"VASP",url:"http://dbpedia.org/resource/VASP"}),(:organisation{id:2438,type:"university",name:"University_of_Ciego_de_Ávila",url:"http://dbpedia.org/resource/University_of_Ciego_de_Ávila"}),(:organisation{id:5529,type:"university",name:"La_Belle_Montessori_School",url:"http://dbpedia.org/resource/La_Belle_Montessori_School"}),(:organisation{id:964,type:"company",name:"PAL_Express",url:"http://dbpedia.org/resource/PAL_Express"}),(:organisation{id:169,type:"company",name:"Aerovias_Brasil",url:"http://dbpedia.org/resource/Aerovias_Brasil"}),(:organisation{id:1211,type:"company",name:"Gadair_European_Airlines",url:"http://dbpedia.org/resource/Gadair_European_Airlines"}),(:organisation{id:5866,type:"university",name:"Sabena_Flight_Academy",url:"http://dbpedia.org/resource/Sabena_Flight_Academy"}),(:organisation{id:778,type:"company",name:"Mexicana_de_Aviación",url:"http://dbpedia.org/resource/Mexicana_de_Aviación"}),(:organisation{id:792,type:"company",name:"Interjet",url:"http://dbpedia.org/resource/Interjet"}),(:organisation{id:286,type:"company",name:"AeroSur_(Colombia)",url:"http://dbpedia.org/resource/AeroSur_(Colombia)"}),(:organisation{id:5686,type:"university",name:"Infant_Jesus_Academy_of_Silang",url:"http://dbpedia.org/resource/Infant_Jesus_Academy_of_Silang"}),(:organisation{id:136,type:"company",name:"TAM_Airlines",url:"http://dbpedia.org/resource/TAM_Airlines"}),(:organisation{id:135,type:"company",name:"Gol_Transportes_Aéreos",url:"http://dbpedia.org/resource/Gol_Transportes_Aéreos"}),(:organisation{id:950,type:"company",name:"Cebu_Pacific",url:"http://dbpedia.org/resource/Cebu_Pacific"}),(:organisation{id:959,type:"company",name:"Air_Manila",url:"http://dbpedia.org/resource/Air_Manila"}),(:organisation{id:801,type:"company",name:"Nova_Air",url:"http://dbpedia.org/resource/Nova_Air"}),(:organisation{id:1857,type:"university",name:"Instituto_Nacional_de_Matemática_Pura_e_Aplicada",url:"http://dbpedia.org/resource/Instituto_Nacional_de_Matemática_Pura_e_Aplicada"}),(:organisation{id:5038,type:"university",name:"Escuela_Normal_Miguel_F._Martínez",url:"http://dbpedia.org/resource/Escuela_Normal_Miguel_F._Martínez"}),(:organisation{id:5043,type:"university",name:"Chihuahua_Institute_of_Technology",url:"http://dbpedia.org/resource/Chihuahua_Institute_of_Technology"}),(:organisation{id:968,type:"company",name:"Spirit_of_Manila_Airlines",url:"http://dbpedia.org/resource/Spirit_of_Manila_Airlines"}),(:organisation{id:800,type:"company",name:"Republicair",url:"http://dbpedia.org/resource/Republicair"}),(:organisation{id:956,type:"company",name:"South_East_Asian_Airlines",url:"http://dbpedia.org/resource/South_East_Asian_Airlines"}),(:organisation{id:984,type:"company",name:"Aerocondor",url:"http://dbpedia.org/resource/Aerocondor"}),(:organisation{id:781,type:"company",name:"Aero_California",url:"http://dbpedia.org/resource/Aero_California"}),(:organisation{id:298,type:"company",name:"Aerogaviota",url:"http://dbpedia.org/resource/Aerogaviota"}),(:organisation{id:2435,type:"university",name:"University_of_Cienfuegos",url:"http://dbpedia.org/resource/University_of_Cienfuegos"}),(:organisation{id:265,type:"company",name:"AeroSucre",url:"http://dbpedia.org/resource/AeroSucre"}),(:organisation{id:1011,type:"company",name:"Avioimpex",url:"http://dbpedia.org/resource/Avioimpex"}),(:organisation{id:185,type:"company",name:"Platinum_Air_Linhas_Aéreas",url:"http://dbpedia.org/resource/Platinum_Air_Linhas_Aéreas"}),(:organisation{id:145,type:"company",name:"Meta_Transportes_Aéreos",url:"http://dbpedia.org/resource/Meta_Transportes_Aéreos"}),(:organisation{id:960,type:"company",name:"Tair_Airways",url:"http://dbpedia.org/resource/Tair_Airways"});
INSERT (:person{id:17592186045864,firstName:"Hoang Yen",lastName:"Pham",gender:"female",birthday:"1986-05-12",locationIP:"118.107.125.235",browserUsed:"Chrome",creationDate:"2011-05-09T15:29:41.136+0000"}),(:person{id:13194139534451,firstName:"Jose",lastName:"Martinez",gender:"male",birthday:"1989-09-27",locationIP:"46.227.42.4",browserUsed:"Chrome",creationDate:"2011-03-03T12:20:15.028+0000"}),(:person{id:26388279067669,firstName:"Emperor of Brazil",lastName:"Oliveira",gender:"female",birthday:"1983-05-05",locationIP:"200.0.68.105",browserUsed:"Safari",creationDate:"2012-01-20T13:34:47.928+0000"}),(:person{id:6597069767300,firstName:"Jose",lastName:"Salvador",gender:"female",birthday:"1987-10-26",locationIP:"110.5.68.234",browserUsed:"Opera",creationDate:"2010-08-11T16:43:46.957+0000"}),(:person{id:1050,firstName:"Rafael",lastName:"Magomaev",gender:"female",birthday:"1983-11-11",locationIP:"88.151.199.140",browserUsed:"Firefox",creationDate:"2010-01-06T23:09:42.096+0000"}),(:person{id:32985348834937,firstName:"Juan",lastName:"Perez",gender:"male",birthday:"1983-05-13",locationIP:"46.18.46.21",browserUsed:"Firefox",creationDate:"2012-08-09T11:18:39.502+0000"}),(:person{id:4398046512440,firstName:"Arnold",lastName:"Laur",gender:"female",birthday:"1983-05-06",locationIP:"94.246.200.242",browserUsed:"Chrome",creationDate:"2010-07-01T18:23:44.540+0000"}),(:person{id:407,firstName:"Gregorio",lastName:"Manalo",gender:"male",birthday:"1982-10-28",locationIP:"27.126.153.181",browserUsed:"Chrome",creationDate:"2010-01-17T12:49:53.860+0000"}),(:person{id:32985348834794,firstName:"Cesar",lastName:"Diaz",gender:"male",birthday:"1981-07-19",locationIP:"103.4.20.110",browserUsed:"Internet Explorer",creationDate:"2012-09-04T13:00:12.333+0000"}),(:person{id:10995116278291,firstName:"Karl",lastName:"Muller",gender:"female",birthday:"1985-11-03",locationIP:"46.16.217.105",browserUsed:"Chrome",creationDate:"2010-11-07T12:02:35.341+0000"}),(:person{id:32985348833679,firstName:"Min-Jung",lastName:"Park",gender:"female",birthday:"1988-05-13",locationIP:"42.18.171.166",browserUsed:"Internet Explorer",creationDate:"2012-08-24T16:31:48.405+0000",language:'["en"]',email:'["Min-Jung32985348833679@gmail.com"]'}),(:person{id:19791209301471,firstName:"James",lastName:"Smith",gender:"male",birthday:"1984-01-03",locationIP:"31.220.194.54",browserUsed:"Chrome",creationDate:"2011-08-21T21:11:05.557+0000"}),(:person{id:13194139533618,firstName:"Yang",lastName:"Zhang",gender:"male",birthday:"1980-05-19",locationIP:"14.192.79.60",browserUsed:"Internet Explorer",creationDate:"2011-01-30T21:29:35.343+0000"}),(:person{id:32985348834375,firstName:"Alfred",lastName:"Hoffmann",gender:"female",birthday:"1989-01-19",locationIP:"46.29.29.10",browserUsed:"Internet Explorer",creationDate:"2012-07-24T09:18:29.279+0000"}),(:person{id:30786325578029,firstName:"Jose",lastName:"Santos",gender:"male",birthday:"1985-09-30",locationIP:"150.165.53.206",browserUsed:"Internet Explorer",creationDate:"2012-05-23T12:58:18.546+0000"}),(:person{id:2199023256816,firstName:"K.",lastName:"Bose",gender:"female",birthday:"1981-04-13",locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2010-04-27T04:53:03.650+0000"}),(:person{id:2199023256862,firstName:"Takeshi",lastName:"Yamada",gender:"female",birthday:"1982-11-08",locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2010-04-14T08:18:31.766+0000",language:'["ja","en"]',email:'["Takeshi2199023256862@gmail.com"]'}),(:person{id:17592186044865,firstName:"Jose",lastName:"Garcia",gender:"female",birthday:"1980-06-16",locationIP:"27.106.218.141",browserUsed:"Chrome",creationDate:"2011-06-19T01:04:45.869+0000"}),(:person{id:2199023256530,firstName:"Pol",lastName:"Dara",gender:"female",birthday:"1986-04-25",locationIP:"27.109.114.212",browserUsed:"Chrome",creationDate:"2010-04-01T05:28:18.772+0000"}),(:person{id:19791209300405,firstName:"Robert",lastName:"Boulanger",gender:"female",birthday:"1982-04-26",locationIP:"81.12.208.222",browserUsed:"Internet Explorer",creationDate:"2011-08-17T11:14:47.042+0000"});
INSERT (:place{id:979,type:"city",name:"San_Miguel_de_Tucumán",url:"http://dbpedia.org/resource/San_Miguel_de_Tucumán"}),(:place{id:810,type:"city",name:"Silang",url:"http://dbpedia.org/resource/Silang"}),(:place{id:55,type:"country",name:"Philippines",url:"http://dbpedia.org/resource/Philippines"}),(:place{id:1417,type:"city",name:"Lviv",url:"http://dbpedia.org/resource/Lviv"}),(:place{id:61,type:"country",name:"Argentina",url:"http://dbpedia.org/resource/Argentina"}),(:place{id:724,type:"city",name:"Tlalpan",url:"http://dbpedia.org/resource/Tlalpan"}),(:place{id:831,type:"city",name:"Naga",url:"http://dbpedia.org/resource/Naga"}),(:place{id:38,type:"country",name:"Republic_of_Macedonia",url:"http://dbpedia.org/resource/Republic_of_Macedonia"}),(:place{id:821,type:"city",name:"Cagayan_de_Oro",url:"http://dbpedia.org/resource/Cagayan_de_Oro"}),(:place{id:559,type:"city",name:"Rio_de_Janeiro",url:"http://dbpedia.org/resource/Rio_de_Janeiro"}),(:place{id:976,type:"city",name:"Corrientes",url:"http://dbpedia.org/resource/Corrientes"}),(:place{id:705,type:"city",name:"Sapporo",url:"http://dbpedia.org/resource/Sapporo"}),(:place{id:1077,type:"city",name:"Ciego_de_Ávila",url:"http://dbpedia.org/resource/Ciego_de_Ávila"}),(:place{id:1295,type:"city",name:"Mesa",url:"http://dbpedia.org/resource/Mesa"}),(:place{id:716,type:"city",name:"Chihuahua",url:"http://dbpedia.org/resource/Chihuahua"}),(:place{id:519,type:"city",name:"Tallinn",url:"http://dbpedia.org/resource/Tallinn"}),(:place{id:99,type:"country",name:"Spain",url:"http://dbpedia.org/resource/Spain"}),(:place{id:845,type:"city",name:"Moscow",url:"http://dbpedia.org/resource/Moscow"}),(:place{id:820,type:"city",name:"Tacloban",url:"http://dbpedia.org/resource/Tacloban"}),(:place{id:572,type:"city",name:"Campinas",url:"http://dbpedia.org/resource/Campinas"}),(:person{id:1242,firstName:"Hans",lastName:"Johansson",gender:"female",birthday:"1987-05-02",locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2010-01-13T12:07:46.523+0000"}),(:person{id:21990232556982,firstName:"Jose",lastName:"Bernal",gender:"female",birthday:"1984-01-02",locationIP:"186.64.1.11",browserUsed:"Firefox",creationDate:"2011-09-26T21:07:01.291+0000"}),(:person{id:17592186045168,firstName:"Albert",lastName:"Buysse",gender:"female",birthday:"1981-05-30",locationIP:"46.182.194.26",browserUsed:"Firefox",creationDate:"2011-05-26T16:38:33.614+0000"}),(:person{id:28587302322537,firstName:"Anh",lastName:"Nguyen",gender:"male",birthday:"1980-11-20",locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-03-30T05:33:05.154+0000"}),(:person{id:15393162790472,firstName:"Jose",lastName:"Fernandez",gender:"female",birthday:"1989-03-23",locationIP:"190.15.146.147",browserUsed:"Firefox",creationDate:"2011-04-11T22:27:34.838+0000"}),(:person{id:15393162789569,firstName:"Bechir",lastName:"Cardinale",gender:"male",birthday:"1988-09-06",locationIP:"196.203.234.56",browserUsed:"Firefox",creationDate:"2011-04-30T05:09:16.986+0000"}),(:person{id:28587302322741,firstName:"Jose",lastName:"Silva",gender:"male",birthday:"1980-04-16",locationIP:"157.86.206.70",browserUsed:"Chrome",creationDate:"2012-04-30T15:11:16.502+0000"}),(:person{id:21990232556900,firstName:"Jose",lastName:"Carvalho",gender:"male",birthday:"1981-06-29",locationIP:"94.126.172.0",browserUsed:"Firefox",creationDate:"2011-09-20T17:55:27.629+0000"}),(:person{id:933,firstName:"Mahinda",lastName:"Perera",gender:"male",birthday:"1989-12-03",locationIP:"119.235.7.103",browserUsed:"Firefox",creationDate:"2010-02-14T15:32:10.447+0000"}),(:person{id:32985348834174,firstName:"Maria",lastName:"Onopka",gender:"female",birthday:"1989-05-15",locationIP:"62.16.17.125",browserUsed:"Chrome",creationDate:"2012-07-12T14:27:43.364+0000"}),(:person{id:4398046512201,firstName:"Jorge",lastName:"Arango",gender:"female",birthday:"1980-05-04",locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2010-05-06T02:18:16.064+0000"}),(:person{id:2199023255987,firstName:"Hao",lastName:"Chen",gender:"male",birthday:"1988-09-20",locationIP:"27.54.75.46",browserUsed:"Firefox",creationDate:"2010-03-22T10:10:42.261+0000"}),(:person{id:987,firstName:"Ali",lastName:"Diori",gender:"male",birthday:"1983-08-31",locationIP:"41.138.47.146",browserUsed:"Chrome",creationDate:"2010-01-21T15:34:48.534+0000"}),(:person{id:15393162789076,firstName:"John",lastName:"Kobzon",gender:"male",birthday:"1983-11-05",locationIP:"2.56.239.37",browserUsed:"Internet Explorer",creationDate:"2011-04-25T18:49:59.034+0000"}),(:person{id:21990232556833,firstName:"Jose",lastName:"Aquino",gender:"female",birthday:"1989-07-09",locationIP:"115.85.60.103",browserUsed:"Chrome",creationDate:"2011-09-30T08:59:37.607+0000"}),(:person{id:4398046512194,firstName:"Jesus",lastName:"Mendez",gender:"female",birthday:"1987-06-02",locationIP:"148.250.218.116",browserUsed:"Firefox",creationDate:"2010-06-28T12:12:07.592+0000"}),(:person{id:24189255811398,firstName:"Jose",lastName:"Escobar",gender:"female",birthday:"1986-06-10",locationIP:"66.231.75.230",browserUsed:"Firefox",creationDate:"2012-01-04T23:52:52.608+0000"}),(:person{id:26388279067426,firstName:"Mikhail",lastName:"Popov",gender:"male",birthday:"1988-04-25",locationIP:"31.40.10.147",browserUsed:"Chrome",creationDate:"2012-03-05T23:23:36.692+0000"}),(:person{id:24189255812662,firstName:"Koji",lastName:"Nakamura",gender:"female",birthday:"1988-04-21",locationIP:"14.0.11.110",browserUsed:"Internet Explorer",creationDate:"2011-12-22T16:53:44.055+0000"}),(:person{id:939,firstName:"Alejandro",lastName:"Sumac",gender:"female",birthday:"1989-04-27",locationIP:"190.113.215.24",browserUsed:"Chrome",creationDate:"2010-02-19T09:36:20.940+0000"}),(:place{id:426,type:"city",name:"Kunming",url:"http://dbpedia.org/resource/Kunming"}),(:place{id:1062,type:"city",name:"Pamplona",url:"http://dbpedia.org/resource/Pamplona"}),(:place{id:940,type:"city",name:"Cần_Thơ",url:"http://dbpedia.org/resource/Cần_Thơ"}),(:place{id:1350,type:"city",name:"San_Sebastián",url:"http://dbpedia.org/resource/San_Sebastián"}),(:place{id:1064,type:"city",name:"Armenia",url:"http://dbpedia.org/resource/Armenia"}),(:place{id:726,type:"city",name:"San_Pedro_Garza_García",url:"http://dbpedia.org/resource/San_Pedro_Garza_García"}),(:place{id:70,type:"country",name:"Colombia",url:"http://dbpedia.org/resource/Colombia"}),(:place{id:568,type:"city",name:"Feira_de_Santana",url:"http://dbpedia.org/resource/Feira_de_Santana"}),(:place{id:745,type:"city",name:"San_Luis_Potosí",url:"http://dbpedia.org/resource/San_Luis_Potosí"}),(:place{id:588,type:"city",name:"Brasília",url:"http://dbpedia.org/resource/Brasília"}),(:place{id:828,type:"city",name:"San_Miguel",url:"http://dbpedia.org/resource/San_Miguel"}),(:place{id:1267,type:"city",name:"Trujillo",url:"http://dbpedia.org/resource/Trujillo"}),(:place{id:714,type:"city",name:"Monterrey",url:"http://dbpedia.org/resource/Monterrey"}),(:place{id:1294,type:"city",name:"Évora",url:"http://dbpedia.org/resource/Évora"}),(:place{id:1314,type:"city",name:"Timișoara",url:"http://dbpedia.org/resource/Timișoara"}),(:place{id:1343,type:"city",name:"Salamanca",url:"http://dbpedia.org/resource/Salamanca"}),(:place{id:53,type:"country",name:"Mexico",url:"http://dbpedia.org/resource/Mexico"}),(:place{id:586,type:"city",name:"Belo_Horizonte",url:"http://dbpedia.org/resource/Belo_Horizonte"}),(:place{id:49,type:"country",name:"Brazil",url:"http://dbpedia.org/resource/Brazil"}),(:place{id:1073,type:"city",name:"Jagüey_Grande",url:"http://dbpedia.org/resource/Jagüey_Grande"}),(:person{id:15393162790400,firstName:"Jose",lastName:"Costa",gender:"male",birthday:"1984-08-19",locationIP:"198.50.19.91",browserUsed:"Opera",creationDate:"2011-03-19T01:38:26.475+0000"}),(:person{id:28587302322565,firstName:"Jose",lastName:"Gonzalez",gender:"male",birthday:"1985-07-14",locationIP:"148.240.49.231",browserUsed:"Firefox",creationDate:"2012-04-10T07:24:17.371+0000"}),(:person{id:30786325578525,firstName:"Wei",lastName:"Zhang",gender:"female",birthday:"1989-06-12",locationIP:"27.109.38.233",browserUsed:"Firefox",creationDate:"2012-05-24T22:59:24.226+0000"}),(:person{id:6597069767242,firstName:"Salim Ahmed",lastName:"Binalshibh",gender:"female",birthday:"1987-03-30",locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2010-08-02T20:11:10.199+0000",language:'["ar","en"]',email:'["Salim.Ahmed6597069767242@gmail.com","Salim.Ahmed6597069767242@gmx.com"]'}),(:person{id:24189255811254,firstName:"Abdullah",lastName:"Koksal",gender:"male",birthday:"1989-03-09",locationIP:"46.31.114.181",browserUsed:"Chrome",creationDate:"2011-12-06T14:48:36.934+0000"}),(:person{id:26388279066636,firstName:"Jose",lastName:"Alonso",gender:"female",birthday:"1987-09-18",locationIP:"196.1.135.241",browserUsed:"Internet Explorer",creationDate:"2012-02-15T13:41:01.645+0000"}),(:person{id:8796093023000,firstName:"Peng",lastName:"Zhang",gender:"female",birthday:"1989-05-29",locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2010-09-20T10:50:36.454+0000",language:'["zh","en"]',email:'["Peng8796093023000@gmail.com","Peng8796093023000@gmx.com"]'}),(:person{id:13194139533391,firstName:"Jose",lastName:"Pereira",gender:"male",birthday:"1980-08-18",locationIP:"193.136.95.244",browserUsed:"Firefox",creationDate:"2011-01-28T14:46:36.060+0000"}),(:person{id:19791209300852,firstName:"Ge",lastName:"Wang",gender:"female",birthday:"1989-11-08",locationIP:"27.131.223.231",browserUsed:"Firefox",creationDate:"2011-07-13T16:31:50.558+0000",language:'["zh","en"]',email:'["Ge19791209300852@gmail.com","Ge19791209300852@pop3.ru"]'}),(:person{id:30786325577859,firstName:"Kenji",lastName:"Matsudaira",gender:"male",birthday:"1982-03-24",locationIP:"1.113.8.81",browserUsed:"Firefox",creationDate:"2012-06-01T16:32:00.161+0000"}),(:person{id:26388279067534,firstName:"Emperor of Brazil",lastName:"Dom Pedro II",gender:"female",birthday:"1989-10-01",locationIP:"192.160.111.235",browserUsed:"Internet Explorer",creationDate:"2012-01-11T14:36:26.465+0000"}),(:person{id:1355,firstName:"Peter",lastName:"Taylor",gender:"male",birthday:"1988-08-18",locationIP:"49.194.208.50",browserUsed:"Internet Explorer",creationDate:"2010-01-29T08:05:57.021+0000"}),(:person{id:17592186045594,firstName:"John",lastName:"Irani",gender:"male",birthday:"1985-04-26",locationIP:"49.156.135.191",browserUsed:"Chrome",creationDate:"2011-07-07T02:44:58.949+0000"}),(:person{id:19791209301112,firstName:"Jose",lastName:"Gonzalez",gender:"male",birthday:"1988-08-19",locationIP:"189.225.78.97",browserUsed:"Internet Explorer",creationDate:"2011-07-07T10:05:07.366+0000"}),(:person{id:2199023256077,firstName:"Ibrahim Bare",lastName:"Ousmane",gender:"female",birthday:"1988-07-28",locationIP:"41.138.46.206",browserUsed:"Firefox",creationDate:"2010-04-07T22:36:34.078+0000"}),(:person{id:26388279068177,firstName:"Jose",lastName:"Garcia",gender:"male",birthday:"1989-07-15",locationIP:"148.230.139.205",browserUsed:"Internet Explorer",creationDate:"2012-03-05T21:05:03.813+0000"}),(:person{id:1274,firstName:"Roberto",lastName:"Fernandez",gender:"male",birthday:"1989-01-02",locationIP:"200.0.27.84",browserUsed:"Firefox",creationDate:"2010-01-22T13:05:49.036+0000"}),(:person{id:2199023256403,firstName:"Nikhil",lastName:"Sharma",gender:"female",birthday:"1984-04-15",locationIP:"27.250.19.130",browserUsed:"Chrome",creationDate:"2010-03-14T20:00:27.645+0000"});
INSERT (:post{id:412317198066,language:"uz",content:"About Humayun, his father in India in 1530, while his half-brother Kamran Mirza, who was to become a rather ",length:109,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-03-04T23:44:32.370+0000"}),(:post{id:824633891449,language:"uz",content:"About Saddam Hussein, s control, leaving the system eventually insolvent mostly due to the Iran–Iraq War, the Gulf War, and",length:123,locationIP:"27.109.114.212",browserUsed:"Chrome",creationDate:"2012-02-23T21:30:50.561+0000"}),(:post{id:481036662981,language:"tk",content:"About Julia Gillard, e House of Representatives seaAbout Pahlavi dynasty, i (reg. 1925–1941) and MohammaAbout British",length:117,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-03-29T12:48:56.666+0000"}),(:post{id:1030792312480,language:"tk",content:"About Ehud Olmert, an and lawyer. He served as Prime MiAbout West Pakistan, rent provisional borders of fou",length:107,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-04T12:12:50.871+0000"}),(:post{id:687194975658,language:"uz",content:"About Napoleon, ns have seen the triumph of France. About Dimitri Tiomkin, ns, where his expansive, muscul",length:106,locationIP:"190.113.215.24",browserUsed:"Chrome",creationDate:"2011-10-07T16:20:06.752+0000"});
INSERT (:tag{id:2057,name:"Jonathan_Swift",url:"http://dbpedia.org/resource/Jonathan_Swift"}),(:tag{id:2780,name:"Ronald_Reagan",url:"http://dbpedia.org/resource/Ronald_Reagan"}),(:tag{id:2803,name:"Martin_Luther_King,_Jr.",url:"http://dbpedia.org/resource/Martin_Luther_King,_Jr."}),(:tag{id:5163,name:"Ralph_Vaughan_Williams",url:"http://dbpedia.org/resource/Ralph_Vaughan_Williams"}),(:tag{id:7032,name:"Vincent_Price",url:"http://dbpedia.org/resource/Vincent_Price"}),(:tag{id:6962,name:"Saddam_Hussein",url:"http://dbpedia.org/resource/Saddam_Hussein"}),(:tag{id:2778,name:"Barack_Obama",url:"http://dbpedia.org/resource/Barack_Obama"}),(:tag{id:1764,name:"Rafael_Nadal",url:"http://dbpedia.org/resource/Rafael_Nadal"}),(:tag{id:1985,name:"Elizabeth_II",url:"http://dbpedia.org/resource/Elizabeth_II"}),(:tag{id:779,name:"George_Frideric_Handel",url:"http://dbpedia.org/resource/George_Frideric_Handel"}),(:tag{id:5159,name:"Georges_Bizet",url:"http://dbpedia.org/resource/Georges_Bizet"}),(:tag{id:565,name:"Napoleon",url:"http://dbpedia.org/resource/Napoleon"}),(:tag{id:2975,name:"Nicole_Kidman",url:"http://dbpedia.org/resource/Nicole_Kidman"}),(:place{id:1060,type:"city",name:"Bogotá",url:"http://dbpedia.org/resource/Bogotá"}),(:place{id:1292,type:"city",name:"Coimbra",url:"http://dbpedia.org/resource/Coimbra"}),(:place{id:93,type:"country",name:"Portugal",url:"http://dbpedia.org/resource/Portugal"}),(:place{id:278,type:"city",name:"Tirupati",url:"http://dbpedia.org/resource/Tirupati"}),(:place{id:71,type:"country",name:"Cuba",url:"http://dbpedia.org/resource/Cuba"}),(:place{id:1039,type:"city",name:"Pursat",url:"http://dbpedia.org/resource/Pursat"}),(:place{id:1074,type:"city",name:"Cienfuegos",url:"http://dbpedia.org/resource/Cienfuegos"}),(:place{id:1363,type:"city",name:"Rovaniemi",url:"http://dbpedia.org/resource/Rovaniemi"}),(:post{id:549755875671,language:"ar",content:"About Bruce Willis, at North American box offiAbout David Hockney, (born 9 July 1937) is an EAbout Ron",length:104,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2011-06-14T03:03:05.095+0000"}),(:post{id:1030792198178,language:"tk",content:"About Augustine of Hippo, tegrate, Augustine developed the conAbout Confucius, olars are cautious of attri",length:106,locationIP:"14.192.79.60",browserUsed:"Internet Explorer",creationDate:"2012-08-04T12:22:02.643+0000"}),(:post{id:687194814306,language:"tk",content:"About Augustine of Hippo, his memorial is celebrated 28 AAbout Napoleon, renewed declaration of war betAbout John Calvin, ",length:123,locationIP:"14.192.79.60",browserUsed:"Internet Explorer",creationDate:"2011-11-04T12:56:11.624+0000"}),(:post{id:687195092166,language:"tk",content:"About Charles V, Holy Roman Emperor, Holy Roman Emperor and Archduke of Austria. From that point forwa",length:103,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-10-22T04:35:07.969+0000"}),(:post{id:893353367816,language:"uz",content:"About Saddam Hussein, ter Tony Blair accused him of possessing weapons of mass destruction and having ties to al-Qaeda. Saddam's Ba'",length:132,locationIP:"49.156.135.191",browserUsed:"Chrome",creationDate:"2012-03-23T23:52:27.219+0000"}),(:post{id:1030792311999,language:"tk",content:"About Ehud Olmert, ations with the Fatah-ledAbout T.I., ommercial market. He has About Frank Sinatr",length:99,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-04T21:36:50.871+0000"}),(:post{id:343597708046,language:"tk",content:"About Charles V, Holy Roman Emperor, s I, and his heir, king Henry II, which althAbout ",length:87,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2010-11-23T06:53:08.237+0000"}),(:post{id:618475627812,language:"uz",content:"About Humayun, ascended the throne at the age of 22 and was somewhat inexperienced when he came to power. Humayun lost Mughal territories to the Pashtun noble, Sher Shah Suri, and, with Persian aid, regained them 15 year",length:221,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-08-05T18:23:23.880+0000"}),(:post{id:893353367667,language:"uz",content:"About Saddam Hussein, ddam's rule. Whereas some venerated him for his aggressive stance against Israel, i",length:105,locationIP:"84.43.159.32",browserUsed:"Chrome",creationDate:"2012-04-13T16:25:01.125+0000"}),(:post{id:962072941169,language:"ar",content:"About Mstislav Rostropovich, ano Galina Vishnevskaya. He is widely considered to have been the greatest cellist of the second half of the 20th century, and one of the greatest of all time. In addition to his outstanding i",length:221,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-06-22T15:09:17.423+0000"}),(:post{id:137439289996,language:"uz",content:"About Humayun, is father, Babur, he lost his kingdom early, but with Persian aid, he eventually regained an e",length:109,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2010-06-06T08:23:38.242+0000"}),(:post{id:962072999303,language:"tk",content:"About Charles V, Holy Roman Emperor, ance was halted after they failed to capture Vienna",length:88,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2012-05-29T09:42:03.639+0000"}),(:post{id:549756126404,language:"uz",content:"About Freddie Mercury, een, including Bohemian Rhapsody, Killer Queen, Somebody to Love, Don't Stop Me Now, Crazy LAbout Hammer to Fall, popular music video directed by David Mallet,",length:182,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-05-07T04:16:13.638+0000"}),(:post{id:137439289868,language:"uz",content:"About Humayun, ained the sovereignty of Kabul and Lahore, the more northern parts of their father's empire. He originally ascended the throne at the age of 22 and was somewhat inexperienced when he came to power. Humayun lost Mug",length:229,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2010-05-06T21:54:00.847+0000"}),(:post{id:687195079880,language:"uz",content:"About Sammy Sosa, been the suAbout Stevie Wonder, as SuperstiAbout Orson Welles, ctor, directAbout Egy",length:104,locationIP:"27.98.181.96",browserUsed:"Chrome",creationDate:"2011-10-06T22:35:24.735+0000"}),(:post{id:1030792312423,language:"tk",content:"About Ehud Olmert, d as Mayor of JerusaleAbout Ovid, ea. Ovid was also the About Donald Duck, written and il",length:108,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-05T11:51:50.871+0000"}),(:post{id:1030792312200,language:"tk",content:"About Ehud Olmert, in September of that year. However, Livni'About Samuel Beckett, our. Beckett is widely regarded as among tAbout The Notorious B.I.G., nds to chart success through his protégé gAbout Waylon",length:207,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-04T10:19:35.871+0000"}),(:post{id:412317197736,language:"uz",content:"About Humayun, , signaled an important change in Mughal court culture, as the Central Asian origins of the ",length:107,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-02-12T04:45:33.643+0000"}),(:post{id:1030792312136,language:"tk",content:"About Ehud Olmert, second stints as a cabinet member,About Stephen Fry, ded the late Humphrey Lyttel",length:100,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-05T04:33:05.871+0000"}),(:post{id:824633787301,language:"tk",content:"About Lleyton Hewitt, 40 greatest tennis playeAbout Aisam-ul-Haq Qureshi, he first time in 2",length:92,locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2012-01-10T10:42:59.749+0000"}),(:post{id:687195027604,language:"ar",content:"About Joe Strummer, shed the Strummerville FoundAbout Nicole Kidman, d first Academy Award nominaAbout I Drove ",length:111,locationIP:"118.107.125.235",browserUsed:"Chrome",creationDate:"2011-10-22T10:32:24.382+0000"}),(:post{id:1030792320509,language:"uz",content:"About Saddam Hussein, f War, and UN sanctions. Through the 1970s, Saddam cemented his authority over the apparatuses of government as oil mone",length:142,locationIP:"46.18.46.21",browserUsed:"Firefox",creationDate:"2012-08-25T11:06:37.065+0000"}),(:post{id:481036384058,language:"tk",content:"About Augustine of Hippo, ace of Christ was About Charlemagne, es the Great (LatiAbout El",length:89,locationIP:"14.192.79.60",browserUsed:"Internet Explorer",creationDate:"2011-05-06T15:44:16.070+0000"}),(:post{id:687195027474,language:"ar",content:"About Rafael Nadal, nch Open titleAbout Joe Strummer, eros and The PAbout Margaret Thatcher, tr",length:95,locationIP:"118.107.125.235",browserUsed:"Chrome",creationDate:"2011-10-22T08:05:24.382+0000"}),(:post{id:1030792312609,language:"tk",content:"About Ehud Olmert, r, he served as Mayor of JerusaAbout Terry Pratchett, cworld book, Snuff is the thirdAbout Dwight D. E",length:121,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-05T08:06:50.871+0000"}),(:post{id:1030792285833,language:"ar",content:"About Paul Keres, ampionship match on five occasions. He won the 1938 AVRO tournament, ",length:87,locationIP:"27.250.19.130",browserUsed:"Chrome",creationDate:"2012-09-06T01:19:08.167+0000"}),(:post{id:687195027492,language:"ar",content:"About René Descartes, In the opening secAbout Joe Strummer, e Strummerville FoAbout Bar",length:87,locationIP:"118.107.125.235",browserUsed:"Chrome",creationDate:"2011-10-22T12:27:54.382+0000"}),(:post{id:1030792322077,language:"uz",content:"About Saddam Hussein, erim government. On 5 November 2006, Saddam was convicted of cha",length:86,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2012-08-16T21:07:04.237+0000"}),(:post{id:824633767796,language:"tk",content:"About Augustine of Hippo, r. When the WesternAbout George Frideric Handel, ngly influenced",length:90,locationIP:"14.192.79.60",browserUsed:"Internet Explorer",creationDate:"2012-02-04T23:54:06.808+0000"}),(:post{id:1030792312629,language:"tk",content:"About Ehud Olmert, te 2008, a ceasefire between Hamas and Israel ended, whiAbout Colonel Bogey March, t, and de",length:111,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-04T13:37:35.871+0000"}),(:post{id:1030792312593,language:"tk",content:"About George Orwell, His work is markAbout Ehud Olmert, e Minister and aAbout Jerry Lewis, ar",length:93,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-04T23:02:20.871+0000"}),(:post{id:893353429186,language:"uz",content:"About Aung San Suu Kyi, w, the lower house of the Burmese parliament, representing the constituency of KawhAbout Rafael Nadal, regard him as the greatest clay cour",length:164,locationIP:"94.246.200.242",browserUsed:"Chrome",creationDate:"2012-03-31T11:44:12.027+0000"}),(:post{id:1099511761479,language:"ar",content:"About Paul Keres, ampionship match against champion Alexander Alekhine, but the match never took place due to World War II. Then after the war he was runner-up in the Candidates' Tournament on four consec",length:204,locationIP:"2.56.239.37",browserUsed:"Internet Explorer",creationDate:"2012-09-10T03:53:27.600+0000"}),(:post{id:824633782740,language:"ar",content:"About Alexander Downer, lia from March 1996 to DecemberAbout Leonard Cohen, ilm by Lian Lunson about the liAbout Pope Pius IX, n Mary, meaning that Mary was cAbout Robert Plant, mporaries and later singers sucAbout Martin Luther King, Jr., ",length:240,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2012-01-29T17:13:22.584+0000"}),(:post{id:893353535995,language:"uz",content:"About Humayun, housands of Persian manuscript in India. Subsequently, in a very short time, Humayun",length:99,locationIP:"81.186.135.203",browserUsed:"Safari",creationDate:"2012-05-03T18:17:35.696+0000"}),(:post{id:1099511762295,language:"ar",content:"About Paul Keres, nd a renowned chess writer. He was among the world's top players from the mid-1930s to the mid-1960s. Kere",length:124,locationIP:"103.4.20.110",browserUsed:"Internet Explorer",creationDate:"2012-09-10T00:36:19.779+0000"}),(:post{id:61882,language:"ar",content:"About Katarina Srebotnik, ust 7, 2006. SAbout Dwight D. Eisenhower, recession in 1About Jack Kirby, which spa",length:110,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2010-02-24T19:30:12.494+0000"}),(:post{id:1030792311832,language:"tk",content:"About Ehud Olmert, d of corruptioAbout Arthur Wellesley, 1st Duke of Wellington, ainst the FrenAbout Welcome to the Jungle,",length:123,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2012-08-05T23:57:05.871+0000"}),(:post{id:137439019620,language:"tk",content:"About Lleyton Hewitt, ranked no. 1 at the age of 20. His career achievements include winning the 2000 US Open men's About Barack Obama, taught constitutional law at the University of Chica",length:189,locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2010-05-11T18:49:03.802+0000"}),(:post{id:206158661798,language:"uz",content:"About Aung San Suu Kyi, he was elected to the Pyithu Hluttaw, the lower hAbout Rafael Nadal, Op",length:96,locationIP:"94.246.200.242",browserUsed:"Chrome",creationDate:"2010-07-21T09:09:13.055+0000"}),(:post{id:755914580588,language:"uz",content:"About Humayun, a substantial legacy for his son, Akbar. His peaceful personality, patience and non-provocative methods of speech earned him the title ’Insān",length:157,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-12-05T07:37:12.230+0000"}),(:post{id:755914310693,language:"tk",content:"About Lleyton Hewitt, f 176. Hewitt is the youngestAbout Barack Obama, would hold t",length:84,locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2011-11-25T20:42:01.355+0000"}),(:post{id:481036673594,language:"uz",content:"About Humayun, umayun lost Mughal territories to the Pashtun noble, Sher Shah Suri, and, with Persian aid",length:105,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-04-07T15:55:31.979+0000"}),(:post{id:962072844939,language:"uz",content:"About Saddam Hussein, Israeli targets, he was widely condemned for the brutality of his dictatorship",length:100,locationIP:"27.109.114.212",browserUsed:"Chrome",creationDate:"2012-06-17T09:20:19.785+0000"}),(:post{id:481036663271,language:"tk",content:"About Steve Martin, national tours. In 2004, CAbout Julia Gillard, ralian Labor Party. FollowiAbout Midnig",length:107,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-03-29T22:20:26.666+0000"}),(:post{id:343597720492,language:"uz",content:"About Humayun, e and also there are many stone carved and Persian language In India from the time of Humayun also tho",length:117,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2010-12-18T09:50:52.097+0000"}),(:post{id:481036663559,language:"tk",content:"About Julia Gillard, er family to Adelaide, AustraAbout Georges Bizet, d published versions of his wAbout Sean Co",length:113,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-03-30T09:06:11.666+0000"}),(:post{id:893353464874,language:"ar",content:"About Alejandro Falla, on in 2007, beating players such as the 5About Philip II of Spain, rom 1556 until 1581, holding v",length:120,locationIP:"117.6.98.6",browserUsed:"Internet Explorer",creationDate:"2012-05-02T20:33:02.420+0000"}),(:post{id:274877973475,language:"tk",content:"About Lleyton Hewitt, include winning the 2000 US Open men's doubles, the 2001 US OAbout Barack Obama, As president, Oba",length:121,locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2010-10-12T00:17:10.545+0000"}),(:post{id:893353536607,language:"uz",content:"About Samuel Taylor Coleridge, childhood ilAbout Sarah Palin, irst episode,About John Rhys-Davies, ded the v",length:109,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-04-20T03:31:28.597+0000"}),(:post{id:206158755514,language:"tk",content:"About Charles V, Holy Roman Emperor, Empire, several German prinAbout Clint Eastwood, is two most commercial",length:109,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2010-08-16T07:17:02.591+0000"}),(:post{id:824634045417,language:"tk",content:"About Charles V, Holy Roman Emperor, force. Unwilling to allow the samAbout Bette Midler, became ",length:98,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2012-02-21T17:16:23.902+0000"}),(:post{id:687195027635,language:"ar",content:"About Joe Strummer, to celebrate his memoAbout Georges Bizet, was instantly populaAbout In the Ghetto, us by Elvis Presle",length:122,locationIP:"118.107.125.235",browserUsed:"Chrome",creationDate:"2011-10-22T12:30:54.382+0000"}),(:post{id:481036497882,language:"tk",content:"About Jacques Brel, inatra, Scott Walker, and Andy Williams. In French-speaking countries, Brel was also a successf",length:115,locationIP:"1.202.204.190",browserUsed:"Chrome",creationDate:"2011-04-22T14:54:15.927+0000"}),(:post{id:481036663370,language:"tk",content:"About Joss Whedon, can screenwriter, executive pAbout Julia Gillard, sentatives seat of Lalor, VicAbout Killing M",length:113,locationIP:"109.200.162.181",browserUsed:"Internet Explorer",creationDate:"2011-03-29T12:29:26.666+0000"}),(:post{id:962073011265,language:"uz",content:"About Humayun, the more northern parts of their father's empire. He originally ascended the throne at the age of 22 and was somewhat inexperienced when he came",length:159,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2012-05-23T08:50:05.343+0000"}),(:post{id:412317198520,language:"uz",content:"About Humayun, he lost his kingdom early, but with Persian aid, he eventually regained an even large",length:101,locationIP:"61.17.197.42",browserUsed:"Safari",creationDate:"2011-01-07T20:40:19.590+0000"}),(:post{id:687194829032,language:"ar",content:"About Sammy Sosa, season in whichAbout William Penn, r 1670) was an About Emmylou Harris, sts includin",length:102,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2011-10-07T03:39:54.735+0000"}),(:post{id:687194829119,language:"ar",content:"About Sammy Sosa, . He is also the all-time home runAbout Jonathan Swift, Drapier's Letters, The Ba",length:99,locationIP:"31.130.237.152",browserUsed:"Internet Explorer",creationDate:"2011-10-06T14:40:39.735+0000"}),(:post{id:412316926503,language:"tk",content:"About Lleyton Hewitt, -back Tennis Masters Cup titles (About Maria Theresa, ldren, including Quee",length:97,locationIP:"186.169.83.109",browserUsed:"Firefox",creationDate:"2011-02-02T06:12:43.989+0000"});
INSERT (:comment{id:962072999307})-[:replyOf]->(:post{id:962072999303}),(:comment{id:687195079891})-[:replyOf]->(:post{id:687195079880}),(:comment{id:206158755519})-[:replyOf]->(:post{id:206158755514}),(:comment{id:687195079881})-[:replyOf]->(:post{id:687195079880}),(:comment{id:343597708049})-[:replyOf]->(:post{id:343597708046}),(:comment{id:1030792312481})-[:replyOf]->(:post{id:1030792312480}),(:comment{id:755914580593})-[:replyOf]->(:post{id:755914580588}),(:comment{id:1030792312004})-[:replyOf]->(:post{id:1030792311999}),(:comment{id:1030792311835})-[:replyOf]->(:post{id:1030792311832}),(:comment{id:1030792312616})-[:replyOf]->(:post{id:1030792312609}),(:comment{id:687195092171})-[:replyOf]->(:post{id:687195092166}),(:comment{id:481036497897})-[:replyOf]->(:post{id:481036497882}),(:comment{id:893353536615})-[:replyOf]->(:post{id:893353536607}),(:comment{id:412317198072})-[:replyOf]->(:post{id:412317198066}),(:comment{id:618475627816})-[:replyOf]->(:post{id:618475627812}),(:comment{id:1030792312141})-[:replyOf]->(:post{id:1030792312136}),(:comment{id:481036673597})-[:replyOf]->(:post{id:481036673594}),(:comment{id:893353464876})-[:replyOf]->(:post{id:893353464874}),(:comment{id:549756126405})-[:replyOf]->(:post{id:549756126404}),(:comment{id:687195079885})-[:replyOf]->(:post{id:687195079880}),(:comment{id:343597720504})-[:replyOf]->(:post{id:343597720492}),(:comment{id:687195079886})-[:replyOf]->(:post{id:687195079880}),(:comment{id:962072941171})-[:replyOf]->(:post{id:962072941169}),(:comment{id:962073011270})-[:replyOf]->(:post{id:962073011265}),(:comment{id:1030792312598})-[:replyOf]->(:post{id:1030792312593}),(:comment{id:481036663573})-[:replyOf]->(:post{id:481036663559}),(:comment{id:481036663378})-[:replyOf]->(:post{id:481036663370}),(:comment{id:687195079882})-[:replyOf]->(:post{id:687195079880}),(:comment{id:1030792312641})-[:replyOf]->(:post{id:1030792312629}),(:comment{id:687195079884})-[:replyOf]->(:post{id:687195079880}),(:comment{id:824634045418})-[:replyOf]->(:post{id:824634045417}),(:comment{id:687195079894})-[:replyOf]->(:post{id:687195079880}),(:comment{id:412317198521})-[:replyOf]->(:post{id:412317198520}),(:comment{id:1099511761482})-[:replyOf]->(:post{id:1099511761479}),(:comment{id:1030792312428})-[:replyOf]->(:post{id:1030792312423}),(:comment{id:481036662991})-[:replyOf]->(:post{id:481036662981}),(:comment{id:137439290004})-[:replyOf]->(:post{id:137439289996}),(:comment{id:412317197738})-[:replyOf]->(:post{id:412317197736}),(:comment{id:1030792285836})-[:replyOf]->(:post{id:1030792285833}),(:comment{id:687195079888})-[:replyOf]->(:post{id:687195079880}),(:comment{id:893353536001})-[:replyOf]->(:post{id:893353535995}),(:comment{id:137439289870})-[:replyOf]->(:post{id:137439289868}),(:comment{id:481036663273})-[:replyOf]->(:post{id:481036663271}),(:comment{id:412317197742})-[:replyOf]->(:post{id:412317197736}),(:comment{id:549756126406})-[:replyOf]->(:post{id:549756126404}),(:comment{id:549756126407})-[:replyOf]->(:post{id:549756126404}),(:comment{id:1030792312202})-[:replyOf]->(:post{id:1030792312200}),(:post{id:824633787301})-[:hasTag]->(:tag{id:2778}),(:post{id:687194829032})-[:hasTag]->(:tag{id:5163}),(:post{id:962072844939})-[:hasTag]->(:tag{id:6962}),(:post{id:481036384058})-[:hasTag]->(:tag{id:1985}),(:post{id:687194814306})-[:hasTag]->(:tag{id:565}),(:post{id:1030792198178})-[:hasTag]->(:tag{id:565}),(:post{id:687195027492})-[:hasTag]->(:tag{id:2778}),(:post{id:1030792322077})-[:hasTag]->(:tag{id:6962}),(:post{id:687194829119})-[:hasTag]->(:tag{id:2057}),(:post{id:687194975658})-[:hasTag]->(:tag{id:565}),(:post{id:412316926503})-[:hasTag]->(:tag{id:2778}),(:post{id:274877973475})-[:hasTag]->(:tag{id:2778}),(:post{id:824633767796})-[:hasTag]->(:tag{id:779}),(:post{id:893353367816})-[:hasTag]->(:tag{id:6962}),(:post{id:549755875671})-[:hasTag]->(:tag{id:2780}),(:post{id:687195027635})-[:hasTag]->(:tag{id:5159}),(:post{id:893353429186})-[:hasTag]->(:tag{id:1764}),(:post{id:137439019620})-[:hasTag]->(:tag{id:2778}),(:post{id:824633782740})-[:hasTag]->(:tag{id:2803}),(:post{id:61882})-[:hasTag]->(:tag{id:7032}),(:post{id:1030792320509})-[:hasTag]->(:tag{id:6962}),(:post{id:687195027474})-[:hasTag]->(:tag{id:1764}),(:post{id:824633891449})-[:hasTag]->(:tag{id:6962}),(:post{id:687195027604})-[:hasTag]->(:tag{id:2975}),(:post{id:755914310693})-[:hasTag]->(:tag{id:2778}),(:post{id:206158661798})-[:hasTag]->(:tag{id:1764}),(:post{id:893353367667})-[:hasTag]->(:tag{id:6962});
INSERT (:comment{id:68719620861})-[:replyOf]->(:comment{id:68719620859}),(:comment{id:68719620864})-[:replyOf]->(:comment{id:68719620859}),(:comment{id:962072761050})-[:replyOf]->(:comment{id:962072761041}),(:comment{id:1030792475467})-[:replyOf]->(:comment{id:1030792475457}),(:comment{id:893353237446})-[:replyOf]->(:comment{id:893353237444}),(:comment{id:893353421361})-[:replyOf]->(:comment{id:893353421359}),(:comment{id:893353494752})-[:replyOf]->(:comment{id:893353494749}),(:comment{id:68719620866})-[:replyOf]->(:comment{id:68719620859}),(:comment{id:824634014661})-[:replyOf]->(:comment{id:824634014655}),(:comment{id:68719620860})-[:replyOf]->(:comment{id:68719620859}),(:comment{id:824633877031})-[:replyOf]->(:comment{id:824633877018}),(:comment{id:206158767051})-[:replyOf]->(:comment{id:206158767047}),(:comment{id:1099511761487})-[:replyOf]->(:comment{id:1099511761484}),(:comment{id:1030792162212})-[:replyOf]->(:comment{id:1030792162208}),(:comment{id:962072693254})-[:replyOf]->(:comment{id:962072693253}),(:comment{id:1030792191618})-[:replyOf]->(:comment{id:1030792191617}),(:comment{id:824634014656})-[:replyOf]->(:comment{id:824634014655}),(:comment{id:962072934715})-[:replyOf]->(:comment{id:962072934712}),(:comment{id:824634014664})-[:replyOf]->(:comment{id:824634014655}),(:comment{id:824633996217})-[:replyOf]->(:comment{id:824633996216}),(:comment{id:1099511761484})-[:replyOf]->(:comment{id:1099511761482}),(:comment{id:893353223107})-[:replyOf]->(:comment{id:893353223100}),(:comment{id:824633996220})-[:replyOf]->(:comment{id:824633996211}),(:comment{id:1030792285837})-[:replyOf]->(:comment{id:1030792285836}),(:comment{id:893353490443})-[:replyOf]->(:comment{id:893353490440}),(:comment{id:962072693255})-[:replyOf]->(:comment{id:962072693245});
INSERT (:person{id:2199023256816})-[:knows{creationDate:"2011-07-24T09:50:59.207+0000"}]->(:person{id:19791209300852}),(:person{id:15393162790400})-[:knows{creationDate:"2012-03-06T08:58:06.246+0000"}]->(:person{id:26388279068177}),(:person{id:15393162790400})-[:knows{creationDate:"2011-06-22T06:36:38.448+0000"}]->(:person{id:17592186045168}),(:person{id:15393162790400})-[:knows{creationDate:"2012-01-25T16:32:59.971+0000"}]->(:person{id:26388279067534}),(:person{id:30786325577859})-[:knows{creationDate:"2012-08-03T00:43:00.240+0000"}]->(:person{id:32985348834375}),(:person{id:19791209301471})-[:knows{creationDate:"2012-01-19T00:14:46.238+0000"}]->(:person{id:26388279067534}),(:person{id:17592186044865})-[:knows{creationDate:"2012-04-14T16:08:35.809+0000"}]->(:person{id:28587302322537}),(:person{id:2199023256862})-[:knows{creationDate:"2010-08-13T09:33:03.459+0000"}]->(:person{id:6597069767242}),(:person{id:2199023256862})-[:knows{creationDate:"2011-07-26T00:05:25.240+0000"}]->(:person{id:19791209300852}),(:person{id:2199023256862})-[:knows{creationDate:"2010-10-18T11:36:33.287+0000"}]->(:person{id:8796093023000}),(:person{id:8796093023000})-[:knows{creationDate:"2012-04-05T05:54:11.174+0000"}]->(:person{id:28587302322537}),(:person{id:19791209300852})-[:knows{creationDate:"2012-04-15T03:14:34.341+0000"}]->(:person{id:28587302322537}),(:person{id:939})-[:knows{creationDate:"2011-02-02T11:30:49.485+0000"}]->(:person{id:13194139533618}),(:person{id:939})-[:knows{creationDate:"2011-12-12T03:23:53.843+0000"}]->(:person{id:24189255811254}),(:person{id:6597069767242})-[:knows{creationDate:"2012-04-14T14:38:17.782+0000"}]->(:person{id:28587302322537}),(:person{id:6597069767242})-[:knows{creationDate:"2011-07-17T06:19:52.541+0000"}]->(:person{id:19791209300852}),(:person{id:17592186045594})-[:knows{creationDate:"2011-12-08T11:49:30.342+0000"}]->(:person{id:24189255811254}),(:person{id:15393162790472})-[:knows{creationDate:"2012-08-06T11:50:18.872+0000"}]->(:person{id:32985348834375}),(:person{id:1242})-[:knows{creationDate:"2010-11-18T07:09:54.852+0000"}]->(:person{id:10995116278291}),(:person{id:1242})-[:knows{creationDate:"2011-08-25T22:24:53.389+0000"}]->(:person{id:19791209300405}),(:person{id:26388279067534})-[:knows{creationDate:"2012-03-27T23:12:22.241+0000"}]->(:person{id:26388279068177}),(:person{id:26388279067534})-[:knows{creationDate:"2012-06-03T06:29:00.899+0000"}]->(:person{id:30786325577859}),(:person{id:26388279067534})-[:knows{creationDate:"2012-08-21T14:18:00.521+0000"}]->(:person{id:32985348834375}),(:person{id:26388279067534})-[:knows{creationDate:"2012-08-26T06:34:52.810+0000"}]->(:person{id:32985348833679}),(:person{id:17592186045168})-[:knows{creationDate:"2012-04-04T06:11:18.357+0000"}]->(:person{id:28587302322537}),(:person{id:17592186045168})-[:knows{creationDate:"2012-06-15T15:09:40.111+0000"}]->(:person{id:30786325577859}),(:person{id:17592186045168})-[:knows{creationDate:"2012-06-06T01:53:52.977+0000"}]->(:person{id:30786325578525}),(:person{id:17592186045168})-[:knows{creationDate:"2011-09-09T16:32:21.325+0000"}]->(:person{id:19791209301471}),(:person{id:17592186045168})-[:knows{creationDate:"2012-01-16T19:49:07.721+0000"}]->(:person{id:26388279067534}),(:person{id:13194139533618})-[:knows{creationDate:"2011-12-28T11:02:49.798+0000"}]->(:person{id:24189255811254}),(:person{id:13194139533618})-[:knows{creationDate:"2012-01-18T01:41:52.713+0000"}]->(:person{id:24189255812662}),(:person{id:21990232556982})-[:knows{creationDate:"2012-04-11T00:29:05.648+0000"}]->(:person{id:28587302322537}),(:person{id:21990232556982})-[:knows{creationDate:"2012-06-30T18:34:46.014+0000"}]->(:person{id:30786325577859}),(:person{id:24189255811254})-[:knows{creationDate:"2012-03-28T22:44:56.055+0000"}]->(:person{id:26388279067426}),(:person{id:24189255811254})-[:knows{creationDate:"2012-07-15T06:58:11.950+0000"}]->(:person{id:32985348834174}),(:person{id:6597069767300})-[:knows{creationDate:"2012-04-25T09:12:10.318+0000"}]->(:person{id:28587302322537}),(:person{id:28587302322565})-[:knows{creationDate:"2012-07-31T22:01:19.502+0000"}]->(:person{id:32985348834375}),(:person{id:4398046512440})-[:knows{creationDate:"2010-11-16T11:43:24.616+0000"}]->(:person{id:10995116278291}),(:person{id:1274})-[:knows{creationDate:"2012-03-20T06:41:35.145+0000"}]->(:person{id:26388279068177}),(:person{id:1274})-[:knows{creationDate:"2012-06-12T22:03:29.897+0000"}]->(:person{id:30786325577859}),(:person{id:28587302322537})-[:knows{creationDate:"2012-09-09T16:11:55.393+0000"}]->(:person{id:32985348833679}),(:person{id:2199023256077})-[:knows{creationDate:"2010-04-22T05:26:20.072+0000"}]->(:person{id:2199023256530}),(:person{id:2199023256077})-[:knows{creationDate:"2011-06-02T21:47:34.608+0000"}]->(:person{id:17592186045864}),(:person{id:2199023256077})-[:knows{creationDate:"2012-01-06T08:23:33.324+0000"}]->(:person{id:24189255812662}),(:person{id:2199023256077})-[:knows{creationDate:"2012-01-21T21:23:14.691+0000"}]->(:person{id:26388279067669}),(:person{id:2199023256077})-[:knows{creationDate:"2012-08-15T02:20:37.420+0000"}]->(:person{id:32985348834937}),(:person{id:30786325578525})-[:knows{creationDate:"2012-08-06T18:41:49.423+0000"}]->(:person{id:32985348834375}),(:person{id:13194139534451})-[:knows{creationDate:"2011-05-07T18:35:30.124+0000"}]->(:person{id:15393162789569}),(:person{id:13194139534451})-[:knows{creationDate:"2011-08-31T10:45:19.282+0000"}]->(:person{id:19791209301471}),(:person{id:2199023256816})-[:knows{creationDate:"2012-04-19T16:47:07.243+0000"}]->(:person{id:28587302322537}),(:person{id:2199023256816})-[:knows{creationDate:"2012-04-23T11:50:46.811+0000"}]->(:person{id:28587302322565}),(:person{id:2199023256816})-[:knows{creationDate:"2012-06-06T05:53:50.889+0000"}]->(:person{id:30786325578525}),(:person{id:2199023256816})-[:knows{creationDate:"2012-08-16T10:19:06.326+0000"}]->(:person{id:32985348834375}),(:person{id:2199023256816})-[:knows{creationDate:"2010-07-01T09:09:15.566+0000"}]->(:person{id:4398046512194}),(:person{id:2199023256816})-[:knows{creationDate:"2011-05-09T09:01:44.338+0000"}]->(:person{id:15393162790472}),(:person{id:2199023256816})-[:knows{creationDate:"2011-06-25T07:42:42.647+0000"}]->(:person{id:17592186045168}),(:person{id:2199023256816})-[:knows{creationDate:"2011-10-01T11:20:22.470+0000"}]->(:person{id:21990232556900}),(:person{id:2199023256816})-[:knows{creationDate:"2012-02-04T14:57:54.021+0000"}]->(:person{id:26388279067534}),(:person{id:2199023256816})-[:knows{creationDate:"2010-08-09T22:07:38.878+0000"}]->(:person{id:6597069767242}),(:person{id:2199023256816})-[:knows{creationDate:"2010-05-06T06:25:27.061+0000"}]->(:person{id:2199023256862});
INSERT (:person{id:13194139533618})-[:hasInterest]->(:tag{id:1985}),(:person{id:13194139533618})-[:hasInterest]->(:tag{id:565}),(:person{id:13194139533618})-[:hasInterest]->(:tag{id:779}),(:person{id:17592186045864})-[:hasInterest]->(:tag{id:2778}),(:person{id:933})-[:hasInterest]->(:tag{id:2778}),(:person{id:933})-[:hasInterest]->(:tag{id:2057}),(:person{id:933})-[:hasInterest]->(:tag{id:2975}),(:person{id:933})-[:hasInterest]->(:tag{id:6962}),(:person{id:933})-[:hasInterest]->(:tag{id:7032}),(:person{id:933})-[:hasInterest]->(:tag{id:5163}),(:person{id:933})-[:hasInterest]->(:tag{id:2780}),(:person{id:933})-[:hasInterest]->(:tag{id:1985}),(:person{id:933})-[:hasInterest]->(:tag{id:565}),(:person{id:933})-[:hasInterest]->(:tag{id:2803}),(:person{id:933})-[:hasInterest]->(:tag{id:1764}),(:person{id:933})-[:hasInterest]->(:tag{id:5159}),(:person{id:933})-[:hasInterest]->(:tag{id:779}),(:person{id:4398046512440})-[:hasInterest]->(:tag{id:1764}),(:person{id:10995116278291})-[:hasInterest]->(:tag{id:2780}),(:person{id:4398046512201})-[:hasInterest]->(:tag{id:2778}),(:person{id:1274})-[:knows{creationDate:"2010-07-14T14:16:17.141+0000"}]->(:person{id:4398046512194}),(:person{id:1274})-[:knows{creationDate:"2011-03-22T23:07:05.567+0000"}]->(:person{id:13194139534451}),(:person{id:1274})-[:knows{creationDate:"2011-04-12T03:16:50.317+0000"}]->(:person{id:15393162790400}),(:person{id:1274})-[:knows{creationDate:"2011-06-18T02:43:56.450+0000"}]->(:person{id:17592186045168}),(:person{id:1274})-[:knows{creationDate:"2011-09-04T20:56:10.726+0000"}]->(:person{id:19791209301471}),(:person{id:1274})-[:knows{creationDate:"2012-01-28T07:05:20.099+0000"}]->(:person{id:26388279067534}),(:person{id:26388279066636})-[:knows{creationDate:"2012-07-29T07:13:28.855+0000"}]->(:person{id:32985348834375}),(:person{id:987})-[:knows{creationDate:"2012-08-05T02:41:35.065+0000"}]->(:person{id:32985348834375}),(:person{id:987})-[:knows{creationDate:"2010-02-02T23:06:39.721+0000"}]->(:person{id:1274}),(:person{id:987})-[:knows{creationDate:"2011-03-24T21:26:06.027+0000"}]->(:person{id:15393162790400}),(:person{id:987})-[:knows{creationDate:"2011-06-23T15:11:46.786+0000"}]->(:person{id:17592186045168}),(:person{id:987})-[:knows{creationDate:"2012-01-24T19:55:54.290+0000"}]->(:person{id:26388279067534}),(:person{id:4398046512194})-[:knows{creationDate:"2012-06-18T04:46:11.747+0000"}]->(:person{id:30786325577859}),(:person{id:4398046512194})-[:knows{creationDate:"2012-06-21T15:37:10.048+0000"}]->(:person{id:30786325578525}),(:person{id:4398046512194})-[:knows{creationDate:"2011-06-20T08:16:35.587+0000"}]->(:person{id:17592186044865}),(:person{id:4398046512194})-[:knows{creationDate:"2012-03-06T13:11:28.380+0000"}]->(:person{id:26388279066636}),(:person{id:4398046512194})-[:knows{creationDate:"2012-01-14T12:44:42.617+0000"}]->(:person{id:26388279067534}),(:person{id:933})-[:knows{creationDate:"2010-04-22T12:30:57.947+0000"}]->(:person{id:2199023256077}),(:person{id:933})-[:knows{creationDate:"2010-11-15T07:23:49.104+0000"}]->(:person{id:10995116278291}),(:person{id:933})-[:knows{creationDate:"2011-12-15T02:34:43.085+0000"}]->(:person{id:24189255811254}),(:person{id:15393162789569})-[:knows{creationDate:"2012-08-16T18:38:50.009+0000"}]->(:person{id:32985348834375}),(:person{id:15393162789569})-[:knows{creationDate:"2011-05-28T05:34:02.349+0000"}]->(:person{id:15393162790400}),(:person{id:15393162789569})-[:knows{creationDate:"2011-06-21T11:45:03.495+0000"}]->(:person{id:17592186045168}),(:person{id:10995116278291})-[:knows{creationDate:"2011-02-06T11:17:53.881+0000"}]->(:person{id:13194139533618}),(:person{id:10995116278291})-[:knows{creationDate:"2011-08-30T22:46:28.483+0000"}]->(:person{id:19791209300405}),(:person{id:4398046512201})-[:knows{creationDate:"2010-11-21T10:32:55.431+0000"}]->(:person{id:10995116278291});
INSERT (:person{id:13194139533391})-[:isLocatedIn]->(:place{id:1292}),(:person{id:19791209301112})-[:isLocatedIn]->(:place{id:724}),(:person{id:4398046512201})-[:isLocatedIn]->(:place{id:1062}),(:person{id:939})-[:isLocatedIn]->(:place{id:1267}),(:person{id:28587302322741})-[:isLocatedIn]->(:place{id:568}),(:person{id:17592186045864})-[:isLocatedIn]->(:place{id:940}),(:person{id:21990232556900})-[:isLocatedIn]->(:place{id:1295}),(:person{id:19791209300405})-[:isLocatedIn]->(:place{id:1314}),(:person{id:1242})-[:isLocatedIn]->(:place{id:1363}),(:person{id:30786325578029})-[:isLocatedIn]->(:place{id:586}),(:person{id:13194139534451})-[:isLocatedIn]->(:place{id:1343}),(:person{id:26388279067426})-[:isLocatedIn]->(:place{id:845}),(:person{id:2199023256530})-[:isLocatedIn]->(:place{id:1039}),(:person{id:17592186044865})-[:isLocatedIn]->(:place{id:821}),(:person{id:17592186045594})-[:isLocatedIn]->(:place{id:278}),(:person{id:13194139533618})-[:isLocatedIn]->(:place{id:426}),(:person{id:6597069767300})-[:isLocatedIn]->(:place{id:831}),(:person{id:26388279067669})-[:isLocatedIn]->(:place{id:588}),(:person{id:26388279068177})-[:isLocatedIn]->(:place{id:726}),(:person{id:24189255811398})-[:isLocatedIn]->(:place{id:1064}),(:person{id:21990232556982})-[:isLocatedIn]->(:place{id:976}),(:person{id:15393162790400})-[:isLocatedIn]->(:place{id:572}),(:person{id:28587302322565})-[:isLocatedIn]->(:place{id:745}),(:person{id:15393162790472})-[:isLocatedIn]->(:place{id:1074}),(:person{id:32985348834937})-[:isLocatedIn]->(:place{id:1350}),(:person{id:26388279066636})-[:isLocatedIn]->(:place{id:1073}),(:person{id:24189255812662})-[:isLocatedIn]->(:place{id:705}),(:person{id:4398046512440})-[:isLocatedIn]->(:place{id:519}),(:person{id:32985348834174})-[:isLocatedIn]->(:place{id:1417}),(:person{id:21990232556833})-[:isLocatedIn]->(:place{id:820}),(:organisation{id:959})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:955})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:950})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:169})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:185})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:781})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:5866})-[:isLocatedIn]->(:place{id:1294}),(:organisation{id:184})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:2438})-[:isLocatedIn]->(:place{id:1077}),(:organisation{id:1011})-[:isLocatedIn]->(:place{id:38}),(:organisation{id:961})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:265})-[:isLocatedIn]->(:place{id:70}),(:organisation{id:984})-[:isLocatedIn]->(:place{id:93}),(:organisation{id:296})-[:isLocatedIn]->(:place{id:71}),(:organisation{id:965})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:27})-[:isLocatedIn]->(:place{id:61}),(:organisation{id:298})-[:isLocatedIn]->(:place{id:71}),(:organisation{id:1857})-[:isLocatedIn]->(:place{id:559}),(:organisation{id:2407})-[:isLocatedIn]->(:place{id:1060}),(:organisation{id:985})-[:isLocatedIn]->(:place{id:93}),(:organisation{id:968})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:963})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:5529})-[:isLocatedIn]->(:place{id:810}),(:organisation{id:800})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:182})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:136})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:956})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:5038})-[:isLocatedIn]->(:place{id:714}),(:organisation{id:964})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:5043})-[:isLocatedIn]->(:place{id:716}),(:organisation{id:989})-[:isLocatedIn]->(:place{id:93}),(:organisation{id:2435})-[:isLocatedIn]->(:place{id:1074}),(:organisation{id:1609})-[:isLocatedIn]->(:place{id:979}),(:organisation{id:145})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:168})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:805})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:176})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:801})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:271})-[:isLocatedIn]->(:place{id:70}),(:organisation{id:792})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:135})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:5686})-[:isLocatedIn]->(:place{id:810}),(:organisation{id:1211})-[:isLocatedIn]->(:place{id:99}),(:organisation{id:297})-[:isLocatedIn]->(:place{id:71}),(:organisation{id:141})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:960})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:778})-[:isLocatedIn]->(:place{id:53}),(:organisation{id:286})-[:isLocatedIn]->(:place{id:70}),(:organisation{id:951})-[:isLocatedIn]->(:place{id:55}),(:organisation{id:137})-[:isLocatedIn]->(:place{id:49}),(:organisation{id:5526})-[:isLocatedIn]->(:place{id:828});
INSERT (:comment{id:824633996217})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:962072693253})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:412317198521})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:962072693254})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:1030792191617})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:893353494749})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:68719620861})-[:hasCreator]->(:person{id:1355}),(:comment{id:137439290004})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:412317197742})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:687195079881})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:962072999307})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:1030792312481})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:549756126405})-[:hasCreator]->(:person{id:6597069767242}),(:comment{id:893353421361})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:481036662991})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:687195079888})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:1030792312004})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:962072761050})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:1030792475457})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:1030792312141})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:1030792285837})-[:hasCreator]->(:person{id:32985348834794}),(:comment{id:1099511761487})-[:hasCreator]->(:person{id:32985348834794}),(:comment{id:68719620860})-[:hasCreator]->(:person{id:407}),(:comment{id:962072941171})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:412317197738})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:1030792312641})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:824634045418})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:962072693245})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:893353237446})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:962072761041})-[:hasCreator]->(:person{id:8796093023000}),(:comment{id:1030792312598})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:962072934712})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:1030792475467})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:824633996211})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:893353490443})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:755914580593})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:893353494752})-[:hasCreator]->(:person{id:6597069767242}),(:comment{id:1030792312428})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:824633996220})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:343597720504})-[:hasCreator]->(:person{id:2199023256862});
INSERT (:person{id:13194139534451})-[:workAt{workFrom:2010}]->(:organisation{id:1211}),(:comment{id:824634014664})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:893353536615})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:687195079884})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:481036663573})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:1030792312202})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:549756126406})-[:hasCreator]->(:person{id:8796093023000}),(:comment{id:824634014656})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:481036497897})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:893353223100})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:481036673597})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:824633996216})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:481036663378})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:962072693255})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:1030792191618})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:1030792311835})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:206158755519})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:824634014655})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:893353490440})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:824633877031})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:1030792312616})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:1030792162212})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:68719620864})-[:hasCreator]->(:person{id:1050}),(:comment{id:687195079894})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:893353237444})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:824634014661})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:206158767047})-[:hasCreator]->(:person{id:6597069767242}),(:comment{id:618475627816})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:68719620866})-[:hasCreator]->(:person{id:2199023255987}),(:comment{id:687195079886})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:549756126407})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:1030792162208})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:687195079885})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:412317198072})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:962073011270})-[:hasCreator]->(:person{id:26388279067534}),(:comment{id:893353421359})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:687195079882})-[:hasCreator]->(:person{id:6597069767242}),(:comment{id:893353536001})-[:hasCreator]->(:person{id:28587302322537}),(:comment{id:137439289870})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:824633877018})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:687195079891})-[:hasCreator]->(:person{id:19791209300852}),(:comment{id:206158767051})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:687195092171})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:893353464876})-[:hasCreator]->(:person{id:6597069767242}),(:comment{id:962072934715})-[:hasCreator]->(:person{id:2199023256816}),(:comment{id:343597708049})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:481036663273})-[:hasCreator]->(:person{id:2199023256862}),(:comment{id:893353223107})-[:hasCreator]->(:person{id:2199023256816});
INSERT (:person{id:13194139533391})-[:studyAt{classYear:2000}]->(:organisation{id:5866}),(:person{id:21990232556833})-[:studyAt{classYear:2008}]->(:organisation{id:5529}),(:person{id:26388279066636})-[:studyAt{classYear:2008}]->(:organisation{id:2435}),(:person{id:24189255811398})-[:studyAt{classYear:2004}]->(:organisation{id:2407}),(:person{id:17592186044865})-[:studyAt{classYear:1998}]->(:organisation{id:5686}),(:person{id:28587302322565})-[:studyAt{classYear:2006}]->(:organisation{id:5043}),(:person{id:6597069767300})-[:studyAt{classYear:2008}]->(:organisation{id:5526}),(:person{id:19791209301112})-[:studyAt{classYear:2010}]->(:organisation{id:5038}),(:person{id:28587302322741})-[:studyAt{classYear:1998}]->(:organisation{id:1857}),(:person{id:21990232556982})-[:studyAt{classYear:2005}]->(:organisation{id:1609}),(:person{id:15393162790472})-[:studyAt{classYear:2010}]->(:organisation{id:2438});
INSERT (:person{id:26388279068177})-[:workAt{workFrom:2012}]->(:organisation{id:792}),(:person{id:26388279068177})-[:workAt{workFrom:2012}]->(:organisation{id:805}),(:person{id:13194139533391})-[:workAt{workFrom:2000}]->(:organisation{id:984}),(:person{id:13194139533391})-[:workAt{workFrom:2001}]->(:organisation{id:985}),(:person{id:28587302322565})-[:workAt{workFrom:2008}]->(:organisation{id:778}),(:person{id:28587302322565})-[:workAt{workFrom:2007}]->(:organisation{id:781}),(:person{id:28587302322565})-[:workAt{workFrom:2008}]->(:organisation{id:801}),(:person{id:21990232556833})-[:workAt{workFrom:2009}]->(:organisation{id:950}),(:person{id:21990232556833})-[:workAt{workFrom:2008}]->(:organisation{id:956}),(:person{id:21990232556833})-[:workAt{workFrom:2008}]->(:organisation{id:961}),(:person{id:21990232556833})-[:workAt{workFrom:2009}]->(:organisation{id:965}),(:person{id:24189255811398})-[:workAt{workFrom:2004}]->(:organisation{id:265}),(:person{id:24189255811398})-[:workAt{workFrom:2006}]->(:organisation{id:271}),(:person{id:24189255811398})-[:workAt{workFrom:2005}]->(:organisation{id:286}),(:person{id:24189255811398})-[:workAt{workFrom:2005}]->(:organisation{id:1011}),(:person{id:26388279066636})-[:workAt{workFrom:2009}]->(:organisation{id:296}),(:person{id:26388279066636})-[:workAt{workFrom:2010}]->(:organisation{id:298}),(:person{id:15393162790400})-[:workAt{workFrom:2005}]->(:organisation{id:136}),(:person{id:15393162790400})-[:workAt{workFrom:2011}]->(:organisation{id:169}),(:person{id:15393162790400})-[:workAt{workFrom:2008}]->(:organisation{id:176}),(:post{id:61882})-[:hasCreator]->(:person{id:1242}),(:post{id:1030792312609})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:1030792312480})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:412317197736})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:687195079880})-[:hasCreator]->(:person{id:2199023256862}),(:post{id:549756126404})-[:hasCreator]->(:person{id:2199023256862}),(:post{id:1030792322077})-[:hasCreator]->(:person{id:1242}),(:post{id:1099511762295})-[:hasCreator]->(:person{id:32985348834794}),(:post{id:1030792312593})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:687195092166})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:687194975658})-[:hasCreator]->(:person{id:939}),(:post{id:274877973475})-[:hasCreator]->(:person{id:4398046512201}),(:post{id:824633787301})-[:hasCreator]->(:person{id:4398046512201}),(:post{id:962072941169})-[:hasCreator]->(:person{id:28587302322537}),(:post{id:687194814306})-[:hasCreator]->(:person{id:13194139533618}),(:post{id:824633767796})-[:hasCreator]->(:person{id:13194139533618}),(:post{id:962072999303})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:137439289996})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:893353367667})-[:hasCreator]->(:person{id:17592186045864}),(:post{id:893353367816})-[:hasCreator]->(:person{id:17592186045594}),(:person{id:15393162790400})-[:workAt{workFrom:2011}]->(:organisation{id:184}),(:person{id:21990232556900})-[:workAt{workFrom:2010}]->(:organisation{id:989}),(:person{id:21990232556982})-[:workAt{workFrom:2006}]->(:organisation{id:27}),(:person{id:19791209301112})-[:workAt{workFrom:2012}]->(:organisation{id:800}),(:person{id:15393162790472})-[:workAt{workFrom:2011}]->(:organisation{id:296}),(:person{id:15393162790472})-[:workAt{workFrom:2010}]->(:organisation{id:297}),(:person{id:28587302322741})-[:workAt{workFrom:1999}]->(:organisation{id:135}),(:person{id:28587302322741})-[:workAt{workFrom:1998}]->(:organisation{id:145}),(:person{id:28587302322741})-[:workAt{workFrom:1999}]->(:organisation{id:182}),(:person{id:28587302322741})-[:workAt{workFrom:2000}]->(:organisation{id:185}),(:person{id:30786325578029})-[:workAt{workFrom:2005}]->(:organisation{id:137}),(:person{id:30786325578029})-[:workAt{workFrom:2010}]->(:organisation{id:141}),(:person{id:30786325578029})-[:workAt{workFrom:2005}]->(:organisation{id:168}),(:person{id:17592186044865})-[:workAt{workFrom:1998}]->(:organisation{id:951}),(:person{id:17592186044865})-[:workAt{workFrom:2000}]->(:organisation{id:955}),(:person{id:6597069767300})-[:workAt{workFrom:2009}]->(:organisation{id:959}),(:person{id:6597069767300})-[:workAt{workFrom:2009}]->(:organisation{id:960}),(:person{id:6597069767300})-[:workAt{workFrom:2010}]->(:organisation{id:963}),(:person{id:6597069767300})-[:workAt{workFrom:2008}]->(:organisation{id:964}),(:person{id:6597069767300})-[:workAt{workFrom:2009}]->(:organisation{id:968}),(:post{id:481036497882})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:1030792312423})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:481036673594})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:1099511761479})-[:hasCreator]->(:person{id:15393162789076}),(:post{id:687195027604})-[:hasCreator]->(:person{id:17592186045864}),(:post{id:687195027492})-[:hasCreator]->(:person{id:17592186045864}),(:post{id:1030792285833})-[:hasCreator]->(:person{id:2199023256403}),(:post{id:618475627812})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:206158661798})-[:hasCreator]->(:person{id:4398046512440}),(:post{id:687195027474})-[:hasCreator]->(:person{id:17592186045864}),(:post{id:137439019620})-[:hasCreator]->(:person{id:4398046512201}),(:post{id:343597720492})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:824633891449})-[:hasCreator]->(:person{id:2199023256530}),(:post{id:343597708046})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:206158755514})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:824634045417})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:755914310693})-[:hasCreator]->(:person{id:4398046512201}),(:post{id:137439289868})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:687194829032})-[:hasCreator]->(:person{id:1242}),(:post{id:687194829119})-[:hasCreator]->(:person{id:1242}),(:post{id:1030792312136})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:893353536607})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:481036384058})-[:hasCreator]->(:person{id:13194139533618}),(:post{id:893353429186})-[:hasCreator]->(:person{id:4398046512440}),(:post{id:481036663370})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:412317198066})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:1030792312200})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:1030792320509})-[:hasCreator]->(:person{id:32985348834937}),(:post{id:412317198520})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:1030792198178})-[:hasCreator]->(:person{id:13194139533618}),(:post{id:1030792311999})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:893353464874})-[:hasCreator]->(:person{id:28587302322537}),(:post{id:687195027635})-[:hasCreator]->(:person{id:17592186045864}),(:post{id:481036663559})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:893353535995})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:549755875671})-[:hasCreator]->(:person{id:1242}),(:post{id:755914580588})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:412316926503})-[:hasCreator]->(:person{id:4398046512201}),(:post{id:481036663271})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:824633782740})-[:hasCreator]->(:person{id:1242}),(:post{id:962073011265})-[:hasCreator]->(:person{id:2199023256816}),(:post{id:1030792312629})-[:hasCreator]->(:person{id:8796093023000}),(:post{id:481036662981})-[:hasCreator]->(:person{id:6597069767242}),(:post{id:962072844939})-[:hasCreator]->(:person{id:2199023256530}),(:post{id:1030792311832})-[:hasCreator]->(:person{id:8796093023000});

复杂查询

多 MATCH 查询

在构建涉及多个关联关系和复杂查询逻辑的图数据库查询时,使用多个 MATCH 子句可以显著提高查询的灵活性和可读性。

示例
在社交媒体或论坛应用中,若用户希望查看特定用户发布的最新消息以展示其最新动态或进行个性化内容推荐。使用多 Match 查询策略可以实现这一目标,例如:在“ARC_GRAPH_TEST”图中查找特定用户(id 为“32985348834794”,别名为 person)发布的最新十条消息(帖子 post 或评论 comment,别名 message)以及这些消息所回复的原始帖子(别名 post)和原始发帖人(别名 originalPoster)的详细信息。并将返回结果按照消息创建日期(messageCreationDate)降序和消息 ID(messageId)升序排列。

查询示意图:

query-example-1.png

查询语句示例如下:

USE ARC_GRAPH_TEST;
MATCH
(:person {id: 32985348834794})<-[:hasCreator]-(message:post|comment)
WITH
message,
message.id AS messageId,
message.creationDate AS messageCreationDate
ORDER BY
messageCreationDate DESC, messageId ASC
LIMIT 10
MATCH
(message:post|comment)-[:replyOf*0..]->(post:post)-[a:hasCreator]->(originalPoster:person)
RETURN
messageId,
coalesce(message.imageFile, message.content) AS messageContent,
messageCreationDate,
post.id AS postId,
originalPoster.id AS personId,
originalPoster.firstName AS personFirstName,
originalPoster.lastName AS personLastName
ORDER BY
messageCreationDate DESC, messageId ASC;

返回结果示例如下:

+---------------+------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------+-----------------+----------------+
| messageId | messageContent | messageCreationDate | postId | personId | personFirstName | personLastName |
+===============+==============================================================================================================================+==============================+===============+================+=================+================+
| 1099511761487 | yes | 2012-09-11T07:59:35.930+0000 | 1099511761479 | 15393162789076 | John | Kobzon |
+---------------+------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------+-----------------+----------------+
| 1099511762295 | About Paul Keres, nd a renowned chess writer. He was among the world's top players from the mid-1930s to the mid-1960s. Kere | 2012-09-10T00:36:19.779+0000 | 1099511762295 | 32985348834794 | Cesar | Diaz |
+---------------+------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------+-----------------+----------------+
| 1030792285837 | no way! | 2012-09-06T09:29:34.041+0000 | 1030792285833 | 2199023256403 | Nikhil | Sharma |
+---------------+------------------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------+-----------------+----------------+

Optional Match 查询

在 ArcGraph 图数据库的查询语句中,OPTIONAL MATCH 子句用于执行非强制性的模式匹配。如果 OPTIONAL MATCH 未找到匹配项,整个查询也不会因此而中断,而是会继续执行查询的其余部分操作,并将缺失部分在返回结果中以 null 表示。这种查询方式特别适用于需要关联多个模式,但其中一些关联可能不存在的情况。

示例
在社交媒体或论坛应用中,若用户希望深入了解某条特定消息下的讨论动态和社交互动情况。使用 Optional Match 查询策略可以实现这一目标,例如:在“ARC_GRAPH_TEST”图中,查询回复特定帖子或评论(id 为“68719620859”的 postcomment,别名 m)的评论(comment,别名 c)及其创建者(person,别名 p)信息,同时查询回复者(别名 p)是否认识原始消息的创建者(person,别名 a),返回结果按回复的创建日期(commentCreationDate)降序和回复者 ID(replyAuthorId)升序排列。

查询示意图:

query-example-2.png

查询语句示例如下:

USE ARC_GRAPH_TEST;
MATCH
(m:post|comment {id: 68719620859 })<-[:replyOf]-(c:comment)-[:hasCreator]->(p:person)
OPTIONAL MATCH
(m)-[:hasCreator]->(a:person)-[r:knows]-(p)
RETURN c.id AS commentId,
c.content AS commentContent,
c.creationDate AS commentCreationDate,
p.id AS replyAuthorId,
p.firstName AS replyAuthorFirstName,
p.lastName AS replyAuthorLastName,
CASE r
WHEN null THEN false
ELSE true
END AS replyAuthorKnowsOriginalMessageAuthor
ORDER BY commentCreationDate DESC, replyAuthorId;

返回结果示例如下:

+-------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------------+---------------------+---------------------------------------+
| commentId | commentContent | commentCreationDate | replyAuthorId | replyAuthorFirstName | replyAuthorLastName | replyAuthorKnowsOriginalMessageAuthor |
+=============+=======================================================================================================================+==============================+===============+======================+=====================+=======================================+
| 68719620861 | About Robin Williams, obin McLaurin Williams (born July 21, 1951) is an American a | 2010-04-26T22:18:49.591+0000 | 1355 | Peter | Taylor | false |
+-------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------------+---------------------+---------------------------------------+
| 68719620860 | About Otto von Bismarck, rman Empire had universal male suffrage, the elected officials did not have real control of | 2010-04-26T09:33:28.949+0000 | 407 | Gregorio | Manalo | false |
+-------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------------+---------------------+---------------------------------------+
| 68719620866 | thx | 2010-04-26T05:00:12.835+0000 | 2199023255987 | Hao | Chen | false |
+-------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------------+---------------------+---------------------------------------+
| 68719620864 | fine | 2010-04-26T04:01:19.734+0000 | 1050 | Rafael | Magomaev | false |
+-------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------+---------------+----------------------+---------------------+---------------------------------------+

最短路径查询

在图数据库中,最短路径查询旨在确定两个点之间边数最少的路径。在 ArcGraph 图数据库中,可以通过调用 ShortestPath() 函数查询最短路径。

示例
在社交媒体或论坛应用中,若用户希望快速找到二度或多度朋友,以识别共同好友并推荐潜在联系人。使用最短路径查询策略可以实现这一目标,例如:在“ARC_GRAPH_TEST”图中,查询与特定用户(id 为“17592186045168”的 person,别名 person1)最多三层关系内且名为“Jose”的朋友(firstName 为“Jose”的 person,别名 friend)的详细信息,并按距离、姓氏和 ID 升序排序返回前 5 个结果。

查询示意图:

query-example-3.png

查询语句示例如下:

USE ARC_GRAPH_TEST;

MATCH
(person1:person {id: 17592186045168}), (friend:person {firstName: "Jose"})
WHERE NOT person1.id=friend.id

WITH person1, friend, shortestPath((person1)-[:knows*1..3]-(friend)) AS path
WITH min(length(path)) AS distance, friend
ORDER BY
distance ASC,
friend.lastName ASC,
toInteger(friend.id) ASC
LIMIT 5

MATCH (friend)-[:isLocatedIn]->(friendCity:place)
OPTIONAL MATCH
(friend)-[studyAt:studyAt]->
(uni:organisation)-[:isLocatedIn]->
(uniCity:place)

WITH friend,
collect(
CASE uni.name
WHEN null THEN null
ELSE [uni.name, studyAt.classYear, uniCity.name]
END
) AS unis,
friendCity,
distance

OPTIONAL MATCH (friend:person)-[workAt:workAt]->
(company:organisation)-[:isLocatedIn]->(companyCountry:place)
WITH friend, collect(
CASE company.name
WHEN null THEN null
ELSE [company.name, workAt.workFrom, companyCountry.name]
END) AS companies, unis, friendCity, distance

RETURN
friend.id AS friendId,
friend.lastName AS friendLastName,
distance AS distanceFromPerson,
friend.birthday AS friendBirthday,
friend.creationDate AS friendCreationDate,
friend.gender AS friendGender,
friend.browserUsed AS friendBrowserUsed,
friend.email AS friendEmails,
friend.language AS friendLanguages,
friendCity.name AS friendCityName,
unis AS friendUniversities,
companies AS friendCompanies
ORDER BY
distanceFromPerson ASC,
friendLastName ASC,
toInteger(friendId) ASC
LIMIT 5;

返回结果示例如下:

+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
| friendId | friendLastName | distanceFromPerson | friendBirthday | friendCreationDate | friendGender | friendBrowserUsed | friendEmails | friendLanguages | friendCityName | friendUniversities | friendCompanies |
+================+================+====================+================+==============================+==============+===================+==============+=================+================+===============================================================================+==================================================================================================================================================+
| 15393162790400 | Costa | 1 | 1984-08-19 | 2011-03-19T01:38:26.475+0000 | male | Opera | null | null | Campinas | [] | [[Companhia_Itaú_de_Transportes_Aéreos, 2011, Brazil], [Aeronorte, 2008, Brazil], [Aerovias_Brasil, 2011, Brazil], [TAM_Airlines, 2005, Brazil]] |
+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
| 21990232556982 | Bernal | 2 | 1984-01-02 | 2011-09-26T21:07:01.291+0000 | female | Firefox | null | null | Corrientes | [[Saint_Thomas_Aquinas_University_of_the_North, 2005, San_Miguel_de_Tucumán]] | [[Líneas_Aéreas_Federales, 2006, Argentina]] |
+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
| 21990232556900 | Carvalho | 2 | 1981-06-29 | 2011-09-20T17:55:27.629+0000 | male | Firefox | null | null | Mesa | [] | [[White_Airways, 2010, Portugal]] |
+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
| 15393162790472 | Fernandez | 2 | 1989-03-23 | 2011-04-11T22:27:34.838+0000 | female | Firefox | null | null | Cienfuegos | [[University_of_Ciego_de_Ávila, 2010, Ciego_de_Ávila]] | [[Aero_Caribbean, 2010, Cuba], [Cubana_de_Aviación, 2011, Cuba]] |
+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+
| 17592186044865 | Garcia | 2 | 1980-06-16 | 2011-06-19T01:04:45.869+0000 | female | Chrome | null | null | Cagayan_de_Oro | [[Infant_Jesus_Academy_of_Silang, 1998, Silang]] | [[Pacificair, 2000, Philippines], [Airphil_Express, 1998, Philippines]] |
+----------------+----------------+--------------------+----------------+------------------------------+--------------+-------------------+--------------+-----------------+----------------+-------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+

存在性计算

关系存在性查询是图数据库中常见的操作之一,用于验证两个点之间是否存在特定的关系,进而支持后续的过滤与计算操作。

示例
在社交媒体或论坛应用中,若需要基于共同好友和兴趣爱好等信息,为用户推荐潜在的新朋友。使用存在性计算查询策略可以实现这一目标,例如:在“ARC_GRAPH_TEST”图中,查询与特定用户(id 为“933”的 person,别名 person1)有二级朋友关系(非直接好友,即朋友的朋友关系)且生日在 4 月 21 日或之后的人员(别名为 friendperson)。对于每位这样的朋友,计算他们与 person1 的共同兴趣得分(基于共同发布的帖子 post 和标签 tag),并返回共同兴趣得分最高的前 10 名用户及其相关信息。

查询示意图:

query-example-4.png

查询语句示例如下:

USE ARC_GRAPH_TEST;
MATCH (person1:person {id: 933})-[:knows*2..2]-(friend:person),
(friend:person)-[:isLocatedIn]->(city:place)
WHERE NOT friend.id=person1.id AND NOT (friend)-[:knows]-(person1)

WITH person1, city, friend, friend.birthday AS birthday
WHERE (month(birthday)=4 AND day(birthday)>=21)
OR
(month(birthday)=(4%12)+1 AND day(birthday)<22)

WITH DISTINCT friend, city, person1
OPTIONAL MATCH (friend:person)<-[:hasCreator]-(post:post)
WITH friend, city, post, person1
OPTIONAL MATCH (person1:person)-[:hasInterest]->(tag:tag)<-[:hasTag]-(post:post)
WITH friend, city, post, count(tag) AS tag_cnt
WITH friend, city, post, (CASE WHEN tag_cnt > tointeger(0) THEN 1 ELSE 0 END) as tag_cnt1
WITH friend, city, count(post) AS postCount, sum(tag_cnt1) AS commonPostCount
RETURN friend.id AS personId,
friend.firstName AS personFirstName,
friend.lastName AS personLastName,
tointeger(commonPostCount) - (tointeger(postCount) - tointeger(commonPostCount)) AS commonInterestScore,
friend.gender AS personGender,
city.name AS personCityName
ORDER BY commonInterestScore DESC, personId ASC
LIMIT 10;

返回结果示例如下:

+----------------+-----------------+----------------+---------------------+--------------+----------------+
| personId | personFirstName | personLastName | commonInterestScore | personGender | personCityName |
+================+=================+================+=====================+==============+================+
| 1242 | Hans | Johansson | 6 | female | Rovaniemi |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 4398046512201 | Jorge | Arango | 5 | female | Pamplona |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 17592186045864 | Hoang Yen | Pham | 5 | female | Cần_Thơ |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 13194139533618 | Yang | Zhang | 4 | male | Kunming |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 2199023256530 | Pol | Dara | 2 | female | Pursat |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 4398046512440 | Arnold | Laur | 2 | female | Tallinn |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 939 | Alejandro | Sumac | 1 | female | Trujillo |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 17592186045594 | John | Irani | 1 | male | Tirupati |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 32985348834937 | Juan | Perez | 1 | male | San_Sebastián |
+----------------+-----------------+----------------+---------------------+--------------+----------------+
| 19791209300405 | Robert | Boulanger | 0 | female | Timișoara |
+----------------+-----------------+----------------+---------------------+--------------+----------------+

复杂权重计算

在复杂网络分析中,经常需要根据各点间路径上的属性来计算权重。在 ArcGraph 图数据库中,通常使用 UNWIND 语法和 REDUCE 函数进行复杂的权重计算操作。

示例
在社交媒体或论坛应用中,若需要查询两用户间的信任路径,用于安全通信、社交推荐或关系评估。使用复杂权重计算查询策略可以实现这一目标,例如:在“ARC_GRAPH_TEST”图中,查询两个特定人员(id 为“32985348833679”的 person,别名 person1id 为“2199023256862”的 person,别名 person2)之间的所有最短路径,并根据这些路径上评论和帖子的权重(帖子权重为 1.0,评论权重为 0.5)计算每条路径的总权重(pathWeight)。返回按权重降序排列的路径权重及人员 ID 列表。

查询示意图:

query-example-5.png

查询语句示例如下:

USE ARC_GRAPH_TEST;
MATCH (person1:person {id: 32985348833679}), (person2:person {id: 2199023256862})
WITH allShortestPaths(
(person1:person)-[:knows*0..]-(person2:person)
) AS path
WITH
[n in nodes(path) | id(n) ] AS personIdsInPath,
relationships(path) AS rels_in_path
UNWIND rels_in_path AS r
WITH personIdsInPath, startNode(r) AS start_node, endNode(r) AS end_node
WITH personIdsInPath, id(start_node) AS start_id, id(end_node) AS end_id
WITH personIdsInPath, start_id, end_id
OPTIONAL MATCH
(a2:person)<-[:hasCreator]-(:comment)-[:replyOf]->(post2:post|comment)-[:hasCreator]->(b2:person)
WHERE (id(a2) = start_id and id(b2)= end_id) OR (id(a2) = end_id and id(b2)= start_id)
WITH personIdsInPath, start_id, end_id, (CASE type(post2) WHEN 'post'