On my site, I had created a PHP Article and entered this code to list all articles in nodeid 2. Modify to suit your needs:
PHP Code:
$myquery2 =vB::$vbulletin->db->query_read_slave($myquery = "SELECT cms_nodeinfo.title AS title FROM cms_nodeinfo RIGHT JOIN cms_node ON (cms_node.nodeid=cms_nodeinfo.nodeid) WHERE cms_node.parentnode = 2 AND cms_node.contenttypeid = 18");
while ($myarts = vB::$vbulletin->db->fetch_array($myquery2))
{
$output .= $myarts['title']."<br />";
}