SELECT COM_News.New_ID, COM_News.New_Date, COM_News.New_Active, COM_News.New_Category, COM_News.migration, COM_News.New_image_small, COM_News.New_image_large, COM_New_Captions.NewCaption_ID, COM_New_Captions.NewCaption_New_ID, COM_New_Captions.NewCaption_Language_ID, COM_New_Captions.NewCaption_Title, COM_New_Captions.NewCaption_SmallDescription, COM_New_Captions.NewCaption_Description FROM COM_News INNER JOIN COM_New_Captions ON COM_News.New_ID = COM_New_Captions.NewCaption_New_ID WHERE New_Active = 1 and New_Category = 'Συναυλίες' and NewCaption_Language_ID = 1 and New_Date between '9/1/2006' and '8/30/2007' order by New_Date ASC