select child_attrId from tbl_org_attributelinks where mstr_attrTypeId = 34 and mstr_attrId = and child_attrTypeId = 75 select 'FILE|' + container as type, * from qmd_FoodShowrepositoryContents where FileName not like '%.jpg' order by UploadDate desc