I used some code I found on here to create a ‘most read’ widget, which is meant to display only the top five most read posts.
<ul class="icons">
{exp:query limit="5" sql="select entry_id, view_count_one as cnt, url_title, title from exp_channel_titles
where view_count_one > 0
order by view_count_one desc"}
<li><i class="icon-list-alt"></i><a href="http://{path=blog/view/{url_title}}">{title}</a></li>
{/exp:query}
</ul>However I get the results below:
5 Key Steps in securing Business and Commercial Insurance in the UK
5 Key Steps in securing Business and Commercial Insurance in the UK
Wealth Dynamics Profile Test
Wealth Dynamics Profile Test
Watch This Space - My Book Launch in Sept 2012
7 Common Mistakes Businesses Make - Mistake #6
Watch This Space - My Book Launch in Sept 2012
7 Common Mistakes Businesses Make - Mistake #6
3 Critical Components for Effective KPIs
Help others succeed and you will too
Help others succeed and you will too
3 Critical Components for Effective KPIs
7 Common Mistakes Businesses Make - Mistake #7
7 Common Mistakes Businesses Make - Mistake #7As you can see it’s not limited to five and several entries are repeated. Any ideas why?
I’m using MSM if that affects things at all.