Committer: gprochaev
LJSUP-7052.U trunk/bin/worker/category-recent-posts U trunk/htdocs/admin/browse/recent_posts.bml
Modified: trunk/bin/worker/category-recent-posts =================================================================== --- trunk/bin/worker/category-recent-posts 2010-11-23 10:44:55 UTC (rev 17756) +++ trunk/bin/worker/category-recent-posts 2010-11-23 11:08:56 UTC (rev 17757) @@ -50,7 +50,7 @@ my $dbh = LJ::get_db_writer(); - my $journals = $dbh->selectall_arrayref ("SELECT catid, journalid FROM categoryjournals", { Slice => {} }); + my $journals = $dbh->selectall_arrayref ("SELECT cj.catid, cj.journalid FROM categoryjournals cj, category c WHERE cj.catid = c.catid AND c.vert_id <> 0", { Slice => {} }); foreach my $rec (@$journals) { my $journalid = $rec->{journalid}; my @last_jitemid = $dbh->selectrow_array ("SELECT max(jitemid) FROM category_recent_posts WHERE journalid = ?", undef, $journalid); Modified: trunk/htdocs/admin/browse/recent_posts.bml =================================================================== --- trunk/htdocs/admin/browse/recent_posts.bml 2010-11-23 10:44:55 UTC (rev 17756) +++ trunk/htdocs/admin/browse/recent_posts.bml 2010-11-23 11:08:56 UTC (rev 17757) @@ -65,7 +65,7 @@ my $skip = ($page-1) * $page_size; my $last = $skip + $page_size; - my @posts = LJ::Browse->search_posts(\@communities, "$skip,$page_size"); + my @posts = LJ::Browse->search_posts( comms => \@communities, page_size => "$skip,$page_size", vertical => $vertical ); foreach (@posts) { my $url = $_->url;