[dev] [commit] r938 - phplib/models

[automailer at dexonline.ro]

Author: alinu
Date: Sun Aug 18 23:09:45 2013
New Revision: 938

Log:


Modified:
   phplib/models/CrawledPage.php

Modified: phplib/models/CrawledPage.php
==============================================================================
--- phplib/models/CrawledPage.php	Sun Aug 18 22:48:13 2013	(r937)
+++ phplib/models/CrawledPage.php	Sun Aug 18 23:09:45 2013	(r938)
@@ -32,7 +32,9 @@
 	//intoarce o lista cu domeniile parsate
 	public static function getListOfDomains() {
 
-		return Model::factory(self::$_table)->raw_query("select id, substr(substring_index(url, '/', 3),8) as domain from CrawledPage group by domain order by id asc;")->find_many();
+		//return Model::factory(self::$_table)->raw_query("select id, substr(substring_index(url, '/', 3),8) as domain from CrawledPage group by domain order by id asc;")->find_many();
+		return Model::factory(self::$_table)->raw_query("select id, domain from
+			 (select id, substr(substring_index(url, '/', 3),8) as domain from CrawledPage order by id desc) alias1 group by domain order by id asc;")->find_many();
 	}