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 = 1and New_Date between CONVERT(varchar, GETDATE(), 1) and '8/30/2013' order by New_Date ASC