/****** Script for SelectTopNRows command from SSMS  ******/
SELECT [isDeleted]
      ,[deletionDate]
      ,[MerchID]
      ,[MerchTitle]
      ,[MerchSize]
      ,[MerchDesc]
      ,[MerchIdentifier]
      ,[MerchMaxQty]
      ,[lowInventoryLevel]
      ,[lowInvAlertEmailRecps]
      ,[SortRank]
      ,[MerchImage]
      ,[PublishDate]
      ,[UnPublishDate]
      ,[bwVisi]
      ,[outofstock]
      ,[PDFOnlyNotInStock]
      ,[PrivateYesNo]
      ,[FullMemberAccess]
      ,[Keywords]
      ,[InternalNotes]
      ,[CustomFld_1]
      ,[CustomFld_2]
      ,[CustomFld_3]
      ,[CustomFld_4]
      ,[CustomFld_5]
      ,[CustomFld_6]
	  , c.imgname
	  , c.imgExt
  FROM tbl_POS_Items i
	left outer join qryImageLookup c ON i.MerchImage = c.imageid
  where ownerid = 54
  and fsl_tableCode = 'MFR'

  

	SELECT	d.MerchID, d.MerchTitle, c.filterlabel AS Category, fv.attrDescription as CategoryDescription
	FROM	tbl_POS_Items d, tbl_ORG_AttributeLinks k, tbl_ORG_AttributeLinks k2,
			tbl_CMM_Filters c, tbl_ORG_Attributes fv
	WHERE	d.MerchID = k.child_attrID
	AND		k.child_attrTypeID = 44
	AND		k.mstr_attrTypeID = 29
	AND		k.mstr_attrID = fv.attrID
	AND		k.mstr_attrID = k2.child_attrID
	AND		k2.child_attrTypeID = 29
	AND		k2.mstr_attrTypeID = 28
	AND		k2.mstr_attrID = c.filterid
	AND		c.OwnerID = 54
	AND		c.FSL_TableCode = 'MFR'
	ORDER	BY d.MerchID, d.MerchTitle, c.filterlabel, fv.attrDescription



	SELECT	merchid, merchtitle, attribute
	FROM	tbl_POS_CustAttrbLnks link
		INNER JOIN tbl_POS_CustAttrbs attrbs ON (link.attributeid = attrbs.attributeid)
		INNER JOIN tbl_POS_CustCats cc ON (cc.categoryid = attrbs.categoryid)
		INNER JOIN tbl_POS_Items i ON (posid = merchid)
	WHERE attrbs.ownerid = 54
	and   attrbs.fsl_tableCode = 'MFR'
	order by merchtitle, attribute



	SELECT	 p.merchid, p.merchtitle, c.res_category, res_attribute
	FROM	tblResourceCategories c
		INNER JOIN  tblResourceAssignments a ON (c.Res_Category_ID = a.Res_Category_ID)
		INNER JOIN  tblResourceAttributes ra ON (a.res_category_id = ra.res_category_id)
		INNER JOIN  tbl_POS_Attributes pa ON (pa.res_attribute_id = ra.res_attribute_id)
		INNER JOIN  tbl_POS_Items p ON (p.merchid = pa.merchid)
	WHERE	p.ownerid = 54
	and     p.fsl_tableCode = 'MFR'
	and    a.Res_Assignment = 'POS'
	ORDER	by  p.merchtitle, c.res_category, res_attribute