SELECT max(uploaded) AS uploaded FROM recipes SELECT recipes.id, title AS rsstitle, tags AS rsstags, uploaded, whattype, description, username, security.id as userid FROM recipes, security WHERE recipes.user=security.id AND recipes.approved='y' AND uploaded>#checkdate# ORDER BY uploaded DESC LIMIT #numberOfFeedItems# tz=gettimezoneinfo(); tz=tz.isDSTon ? "+0100" : "+0000"; now=now(); now="#dateformat(now, 'ddd, dd mmm yyyy')# #timeformat(now, 'HH:mm:ss')# #tz#"; 120 the latest from Nibblous.com http://www.nibblous.com/ http://www.nibblous.com/resources/nibblousicon2007.png the latest from Nibblous.com http://www.nibblous.com/ latest Nibblous nibblings en copyright Nibblous.com #now#

posted by #username#

#getContent.description# SELECT tag FROM recipetags WHERE recipe=#id# select name from rtagnames, recipetags where recipe=#id# and tag=rtagnames.id order by name SELECT recipes.id, recipes.title, count(recipetags.recipe) AS quality FROM recipetags, recipes WHERE recipetags.recipe!=#id# AND recipetags.tag IN (#valuelist(keywords.tag)#) AND recipes.id=recipetags.recipe GROUP BY recipetags.recipe ORDER BY quality DESC, rand() DESC LIMIT 6 tagged with: #name# 

You might also like:

#title#
 title=server.entity(lcase(rereplace(rsstitle, "<[^>]*>", "", "ALL"))); summary=server.entity(rereplace(description, "<[^>]*>", "", "ALL")); content=server.entity(rereplacenocase(description, "]*>", "", "ALL")); date=dateformat(uploaded, "ddd, dd mmm yyyy"); time=timeformat(uploaded, "HH:mm:ss"); pubDate=date & " " & time & " " & tz; link="http://www.nibblous.com/recipe/#id#"; #title# #summary# #link# #pubDate# #thexml#