private String SortByExpired(string query)
{
//TODO join item table to get item name and sort by name
string datenow = new LimitC().DatePastMonth();
return("select * from episode where " + query + " and " + EXPIRE + " <= '" + datenow + "' order by " + EXPIRE);
}
private string SortThreeMonths(string qeury)
{
LimitC lim = new LimitC();
return(string.Format("select * from episode where {0} and expire >= '{1}' and expire <= '{2}' order by {3}", qeury, lim.DateNow(), lim.Date3Month(), EXPIRE));
}
