Year wise archive of blog using views Is it possible to generate a year-wise archive of blogs using views?I need years listed like 2001,2002,...2012 and clicking on the year should display list of blogs for that particular year.
I added a contextual Filter Content: Created year also , but it this query only SELECT DISTINCT node.nid AS nid, EXTRACT(YEAR FROM((DATE_ADD('19700101', INTERVAL node.created SECOND) + INTERVAL 0 SECOND))) AS created_year, COUNT(node.nid) AS num_records
FROM 
{node} node
WHERE (( (node.status = '1') AND (node.type IN  ('blog')) ))
GROUP BY created_year, nid
ORDER BY created_year ASC .So this results in duplicate value for years
Check “Archive” view from standard Views install for start.
In your case you need to use contextual filter “Content: Created year” instead of “Content: Created year + month”.