GEOLOGICAL SURVEY OF IRAN | WWW.GSI.IR
 
فارسی  |     
Home |  Contact Us |  Help 
type title:   
State name: 
 
SELECT SUBSTRING(`LastModifiedDate`,1,7) AS `LastModifiedDate` FROM `news_data` WHERE SUBSTRING(`LastModifiedDate`,1,7) != '0000-00' AND `LastModifiedDate` IS NOT NULL AND `TypeId` LIKE '7' AND `GroupId` LIKE '%%' GROUP BY SUBSTRING(`LastModifiedDate`,1,7 ) ORDER BY `LastModifiedDate` DESC;
Presentation news archive for special day
Months list that their news archive is available
 February 2008  January 2008  December 2006  November 2006
 October 2006  May 2006  February 2006  January 2006
 December 2005  November 2005  October 2005  September 2005
 August 2005  July 2005  June 2005