<?php $output = ''; $result = $modx->db->query( 'SELECT page_id, page_count FROM `nzkj_page_hit_counter` GROUP BY `page_count` ORDER BY page_count DESC LIMIT 3' ); while( $row = $modx->db->getRow( $result ) ) { $input = $modx->getDocument($row["page_id"], 'pagetitle', true); $output .= '<strong><a href="index.php?id=' . $row['page_id'] .'">' . $input['pagetitle'] . ' (' . $row['page_count'] . ' hits)</a></strong><br />'; } return $output; ?>