[pLog-svn] r2340 - plog/branches/plog-1.0.2/class/dao
oscar at devel.plogworld.net
oscar at devel.plogworld.net
Fri Jul 15 19:58:20 GMT 2005
Author: oscar
Date: 2005-07-15 19:58:20 +0000 (Fri, 15 Jul 2005)
New Revision: 2340
Modified:
plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
Log:
added matt's optimizations to the queries to load blog categories, see http://bugs.plogworld.net/view.php?id=614
Modified: plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
===================================================================
--- plog/branches/plog-1.0.2/class/dao/articlecategories.class.php 2005-07-15 06:22:07 UTC (rev 2339)
+++ plog/branches/plog-1.0.2/class/dao/articlecategories.class.php 2005-07-15 19:58:20 UTC (rev 2340)
@@ -167,8 +167,9 @@
c.last_modification AS last_modification, c.in_main_page AS in_main_page,
c.parent_id AS parent_id, c.description AS description, c.properties AS properties,
c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update
- FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
- ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id
+ FROM {$prefix}articles a
+ LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+ LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id
WHERE c.blog_id = '".Db::qstr($blogId)."'";
if( $onlyInMainPage )
@@ -210,8 +211,9 @@
c.last_modification AS last_modification, c.in_main_page AS in_main_page,
c.parent_id AS parent_id, c.properties AS properties, c.description AS description,
c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update
- FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
- ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id
+ FROM {$prefix}articles a
+ LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+ LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id
WHERE c.blog_id = $blogId";
if( $onlyInMainPage )
@@ -478,9 +480,10 @@
$query = "SELECT a.id as article_id, c.id AS id, c.name AS name, c.url AS url, c.blog_id AS blog_id,
c.last_modification AS last_modification, c.in_main_page AS in_main_page,
c.parent_id AS parent_id, c.properties AS properties, c.description AS description,
- c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update
- FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
- ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id
+ c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update
+ FROM {$prefix}articles a
+ LEFT JOIN {$prefix}articles_categories c ON c.id = l.category_id
+ LEFT JOIN {$prefix}article_categories_link l ON a.id = l.article_id
WHERE a.id IN (".$articleIds.") ";
if( $blogId > -1 ) {
$query .= " AND a.blog_id = '".Db::qstr( $blogId )."' AND c.blog_id = '".Db::qstr( $blogId )."'";
More information about the pLog-svn
mailing list