Miva Merchant - Look up PageFinder's Category Pagename
<mvt:assign name="g.select_sql" value="'SELECT name FROM s01_PageFinderCats WHERE cat_id=' $ l.settings:category:id $ ' LIMIT 1'" />
<mvt:item name="ry_toolbelt" param="query|g.select_sql|pagename" />
<mvt:if expr="l.settings:pagename">
<mvt:assign name="l.settings:category:pagelink" value="'http://' $ g.domain:name $ '/' $ l.settings:pagename $ '.html'" />
<mvt:else>
<mvt:assign name="l.settings:category:pagelink" value="'http://' $ g.domain:name $ '/category/' $ l.settings:category:code $ '.html'" />
</mvt:if>