openside("Straipsniai ir komentarai");
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta
INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id
WHERE ".groupaccess('article_cat_access')." ORDER BY article_datestamp DESC LIMIT 0,5"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['article_subject'], 23);
echo " $itemsubject (".dbcount("(comment_id)","comments","comment_type = 'A' AND comment_item_id = '".$data['article_id']."'").$locale['043'].")
\n";
}
} else {
echo "".$locale['004']."\n";
}
closeside();