SELECT attrDescription, filterLabel, mstr_attrId FROM qmd_dispLnkdFltrValuesByFltr WHERE filterLabel = 'Audience' SELECT attrDescription, filterLabel, mstr_attrId FROM qmd_dispLnkdFltrValuesByFltr WHERE filterLabel LIKE '%#qmd_audienceLabel.attrDescription#%' #valueList( qmd_dispItemsByLnkdFltrValue.itemId )# SELECT * FROM tbl_CMM_Items i WHERE ( i.itemId IN ( ) ) AND ( keywords NOT LIKE '%video=%' AND ( keywords LIKE or keywords LIKE ) ) AND keywords LIKE ) AND ( between i.publishDate and i.unpublishDate ) AND exists ( select * from tbl_ORG_AttributeLinks oal2 inner join tbl_ORG_Attributes oa2 on oa2.attrId = oal2.mstr_attrId and oa2.attrDescription = 'Broker' and oa2.ownerId = and oa2.fsl_tablecode = where oal2.child_attrTypeID = 24 and oal2.mstr_attrTypeID = 26 and oal2.child_attrId = i.itemId ) AND exists ( select * from tbl_ORG_AttributeLinks oal2 inner join tbl_ORG_Attributes oa2 on oa2.attrId = oal2.mstr_attrId and oa2.attrDescription = 'Manufacturer' and oa2.ownerId = and oa2.fsl_tablecode = where oal2.child_attrTypeID = 24 and oal2.mstr_attrTypeID = 26 and oal2.child_attrId = i.itemId ) ORDER BY sortRank, title