SELECT DISTINCT o.operatorid, o.companyname, o.address, o.address2, o.city, o.customFld_6, o.lrwSpecial, o.lrwMaterial, o.lrwPricePoint, attr10.attributeid as Participant10x, nysra.attributeId as nysramember, newpart.attributeId as newparticipant
FROM tbl_OPR_CLientOperators o
LEFT OUTER JOIN tbl_MVU_KitchenHours kh ON kh.operatorId = o.operatorId
INNER JOIN tbl_OPR_CustAttrbLnks k ON (o.OperatorID = k.Opr_id)
LEFT OUTER JOIN tbl_OPR_CustAttrbLnks ma ON ( o.operatorId = ma.opr_id AND ma.attributeId = 482 )
LEFT OUTER JOIN tbl_OPR_CustAttrbLnks attr10 ON (attr10.opr_id = o.operatorid AND attr10.attributeid = 422)
LEFT OUTER JOIN tbl_OPR_CustAttrbLnks nysra ON (nysra.opr_id = o.operatorid AND nysra.attributeid = 263)
LEFT OUTER JOIN tbl_OPR_CustAttrbLnks newpart ON ( newpart.opr_id = o.operatorid and newpart.attributeId = 487 )
INNER JOIN tbl_OPR_CustAttrbLnks attr ON (attr.opr_id = o.operatorid)
WHERE o.OwneRID = 99
AND o.FSLTableCode = 'MSC'
AND o.Territoryid= 1044
AND k.attributeid = 488
| Restaurant | Table Tent | Poster |
| #companyName# | None |
| #companyName# | #_tValue# | #_pValue# |