{if logged_in}

<title>SEO Ranking Report</title>
<h1>SEO Ranking Report</h1>

	{!--exp:query sql="SELECT * FROM canonical_urls_seo_rank cusr JOIN canonical_urls cu on cu.id = cusr.id WHERE cusr.rank!=0 ORDER BY cu.id ASC "--}
	{!--exp:query sql="SELECT * FROM canonical_urls_seo_rank ORDER BY url ASC "--}
		
		{if count==1}
			<p>**{total_results}**</p>
			<hr />
		{/if}
		
		{switch="<p>|"}{date_start} - {date_end} - {url} (#{rank}){switch="<br />|</p>"}
		
		{if count==total_results}
			<hr />
			<p>**{total_results}**</p>
		{/if}
	
	{!--/exp:query--}


{/if}