Friendpaste

--- Revision 363133363464
+++ Revision 396632613535
@@ -1,21 +1,1 @@
-Midgard.QueryStorage storage = new Midgard.QueryStorage ("midgard_page");
-Midgard.QuerySelect select = new Midgard.QuerySelect (cnc, storage);
-
-Midgard.QueryProperty prop1 = new Midgard.QueryProperty ("metadata.created", null);
-Midgard.QueryValue val1 = new Midgard.QueryValue ("2000-01-01 10:10:10");
-Midgard.QueryConstraint cnstr1 = new Midgard.QueryConstraint (prop1, ">", val1, null);
-
-Midgard.QueryProperty prop2 = new Midgard.QueryProperty ("name", null);
-Midgard.QueryValue val2 = new Midgard.QueryValue ("");
-Midgard.QueryConstraint cnstr2 = new Midgard.QueryConstraint (prop2, "<>", val2, null);
-
-Midgard.QueryGroupConstraint group_constraint = new Midgard.QueryGroupConstraint ("AND", cnstr1, cnstr2);
-
-elect.set_constraint (group_constraint);
-select.set_limit (1);
-select.execute();
-
-Executed query so far:
-
-SELECT page.guid AS guid, page.id AS id, page.name AS name, page.info AS info, page.style AS style, page.up AS up, page.component AS component, page.title AS title, page.content AS content, page.metadata_creator AS creator, page.metadata_created AS created, page.metadata_revisor AS revisor, page.metadata_revised AS revised, page.metadata_revision AS revision, page.metadata_locker AS locker, page.metadata_locked AS locked, page.metadata_approver AS approver, page.metadata_approved AS approved, page.metadata_authors AS authors, page.metadata_owner AS owner, page.metadata_schedule_start AS schedulestart, page.metadata_schedule_end AS scheduleend, page.metadata_hidden AS hidden, page.metadata_nav_noentry AS navnoentry, page.metadata_size AS size, page.metadata_published AS published, page.metadata_score AS score, page.metadata_imported AS imported, page.metadata_exported AS exported, page.metadata_deleted AS deleted, page.metadata_isapproved AS isapproved, page.metadata_islocked AS islocked FROM `page` WHERE metadata_deleted = 0
-
+qRyhQZ  <a href="http://pvbvmnmujcpk.com/">pvbvmnmujcpk</a>, [url=http://ckiouznxcgee.com/]ckiouznxcgee[/url], [link=http://tafrdybcjemj.com/]tafrdybcjemj[/link], http://dhtnnjbpbkfw.com/
a	b
0		-	Midgard.QueryStorage storage = new Midgard.QueryStorage ("midgard_page");
0		-	Midgard.QuerySelect select = new Midgard.QuerySelect (cnc, storage);
0		-
0		-	Midgard.QueryProperty prop1 = new Midgard.QueryProperty ("metadata.created", null);
0		-	Midgard.QueryValue val1 = new Midgard.QueryValue ("2000-01-01 10:10:10");
0		-	Midgard.QueryConstraint cnstr1 = new Midgard.QueryConstraint (prop1, ">", val1, null);
0		-
0		-	Midgard.QueryProperty prop2 = new Midgard.QueryProperty ("name", null);
0		-	Midgard.QueryValue val2 = new Midgard.QueryValue ("");
0		-	Midgard.QueryConstraint cnstr2 = new Midgard.QueryConstraint (prop2, "<>", val2, null);
0		-
0		-	Midgard.QueryGroupConstraint group_constraint = new Midgard.QueryGroupConstraint ("AND", cnstr1, cnstr2);
0		-
0		-	elect.set_constraint (group_constraint);
0		-	select.set_limit (1);
0		-	select.execute();
0		-
0		-	Executed query so far:
0		-
0		-	SELECT page.guid AS guid, page.id AS id, page.name AS name, page.info AS info, page.style AS style, page.up AS up, page.component AS component, page.title AS title, page.content AS content, page.metadata_creator AS creator, page.metadata_created AS created, page.metadata_revisor AS revisor, page.metadata_revised AS revised, page.metadata_revision AS revision, page.metadata_locker AS locker, page.metadata_locked AS locked, page.metadata_approver AS approver, page.metadata_approved AS approved, page.metadata_authors AS authors, page.metadata_owner AS owner, page.metadata_schedule_start AS schedulestart, page.metadata_schedule_end AS scheduleend, page.metadata_hidden AS hidden, page.metadata_nav_noentry AS navnoentry, page.metadata_size AS size, page.metadata_published AS published, page.metadata_score AS score, page.metadata_imported AS imported, page.metadata_exported AS exported, page.metadata_deleted AS deleted, page.metadata_isapproved AS isapproved, page.metadata_islocked AS islocked FROM `page` WHERE metadata_deleted = 0
0		-
	0	+	qRyhQZ <a href="http://pvbvmnmujcpk.com/">pvbvmnmujcpk</a>, [url=http://ckiouznxcgee.com/]ckiouznxcgee[/url], [link=http://tafrdybcjemj.com/]tafrdybcjemj[/link], http://dhtnnjbpbkfw.com/
...