{pboot:sql sql="select pb_content.*, pb_content_sort.name from pb_content_sort,pb_content"}<a href="[sql:id]">[sql:title] [sql:name]</a>{/pboot:sql}

{pboot:sql sql="select ay_content.*, ay_content_sort.<?php echo "mcode";?> from ay_content_sort,ay_content"}<a href="[sql:id]">[sql:title] [sql:<?php echo "mcode";?>]</a>{/pboot:sql}