</verbs>
<body>
<Set key="whichnewswire" value="Open Publishing News" />
- <List key="newswire" table="content" limit="20"
+ <List key="newswire" table="content" limit="50"
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
<Language>
<List key="mostcomments"
table="content c"
extratables="comment cm"
- selection="c.webdb_create > NOW()-'2 weeks'::interval and c.is_published=true and cm.is_published=true and c.id=cm.to_media group by c.id,c.title,
+ selection="c.webdb_create > NOW()-'1 week'::interval and c.is_published=true and cm.is_published=true and c.id=cm.to_media group by c.id,c.title,
c.subtitle,c.edittitle,c.date,c.creator,c.creator_main_url,c.creator_email,c.creator_address,c.creator_phone,c.description,
c.comment,c.source,c.is_published,c.is_produced,c.to_publisher,c.to_language,c.to_rights,c.webdb_create,c.webdb_lastchange,
c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
<Define key="topicfile" value="${category.filename}" />
<List key="randomarticles" table="content"
- selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
+ selection ="id in (select content_id from content_x_topic where topic_id = ${category.id}) AND is_published=true" order="date DESC"
limit="3" />
<Language>
<Generate
projects / nyc.indymedia.org.git / commitdiff