Returns the most viewed content of all time, today, or the last-viewed node.
$dbfield: The database field to use, one of:
$dbrows: The number of rows to be returned.
SelectQuery|FALSE A query result containing the node ID, title, user ID that owns the node, and the username for the selected node(s), or FALSE if the query could not be executed correctly.
function statistics_title_list($dbfield, $dbrows) {
if (in_array($dbfield, array(
'totalcount',
'daycount',
'timestamp',
))) {
$query = db_select('node', 'n');
$query
->addTag('node_access');
$query
->join('node_counter', 's', 'n.nid = s.nid');
$query
->join('users', 'u', 'n.uid = u.uid');
return $query
->fields('n', array(
'nid',
'title',
))
->fields('u', array(
'uid',
'name',
))
->condition($dbfield, 0, '<>')
->condition('n.status', 1)
->orderBy($dbfield, 'DESC')
->range(0, $dbrows)
->execute();
}
return FALSE;
}