SELECT RECIPENAME, CATEGORY, SUBMITTEDBY, MODIFYDATE, ID,INTRO FROM RECIPE WHERE ID IN (#SEARCHRESULTS#) ORDER BY MODIFYDATE DESC SELECT RECIPENAME, CATEGORY, SUBMITTEDBY, MODIFYDATE, ID, INTRO FROM RECIPE WHERE STATUS <> 0 AND CATEGORY LIKE '%#lcase(form.catagory)#%' AND ETHNICORIGIN LIKE '%#lcase(form.ethnic)#%' AND TUMMYINDEX LIKE '%#form.tummy#%' AND MODIFYDATE between convert(datetime,'#startdate#') and convert(datetime,'#enddate#') ORDER BY MODIFYDATE DESC SELECT RECIPENAME, CATEGORY, SUBMITTEDBY, MODIFYDATE, ID, INTRO,STATUS FROM RECIPE WHERE STATUS > 0 and RECIPENAME LIKE '%#FORM.KEYWORD#%' OR INTRO LIKE '%#FORM.KEYWORD#%' OR CATEGORY LIKE '%#FORM.KEYWORD#%' OR ETHNICORIGIN LIKE '%#FORM.KEYWORD#%' ORDER BY MODIFYDATE DESC SELECT RecipeName, Category, Submittedby, ModifyDate, ID, intro FROM Recipe Where Status = 2 ORDER BY ModifyDate DESC SELECT RECIPENAME, CATEGORY, SUBMITTEDBY, MODIFYDATE, ID, INTRO,STATUS FROM RECIPE WHERE STATUS > 0 and RECIPENAME LIKE '#letter#%' ORDER BY RECIPENAME ASC