SELECT * FROM Production WHERE Production.prodComing <= #CurrentDate# AND #CurrentDate# <= Production.prodEnd ORDER BY prodStart ASC SELECT Production.ProdThumb, Production.prodName, Production.prodEnd FROM Production WHERE Production.ID NOT LIKE '#getCurrentProd.ID#' AND #CurrentDate# <= Production.prodEnd ORDER BY Production.prodStart SELECT * FROM News ORDER BY News.newsDate DESC <cfoutput>#PageTitle#</cfoutput>