[thesite] add: LOTTD

[Dean Mah]

Ummm.... where did you get this from?  I do not seem to have access to
the production Web server.

Dean


Warden, Matt writes:

> >How many is it supposed to return?  Should it be limited to 10?  Or is
> >it limited by date?  Inquiring minds want to know.
> 
> Lazy inquiring minds?  =)
> 
> select
>         content.contentid, content.contentname, content.body,
>         content.datemod, users.userid, users.who,
>         categorys.category, categorys.categoryid
> from content,users,categorys
> where content.signoff=1
> and content.userid=users.userid
> and content.datemod > '#dateformat(lastweek, "dd-MMM-yyyy")#'
> and content.categoryid=categorys.categoryid
> and content.categoryid <> 26
> order by content.datemod desc
> 
> the line you wanna look at is:
> 
> and content.datemod > '#dateformat(lastweek, "dd-MMM-yyyy")#'
> 
> 
> So, it's the articles with a datemod within the last week... I suppose.