STS and extra info_pages

[Guest]

here is what I have

?>
$sts->start_capture();
$page_query = tep_db_query("select 
							   p.pages_id, 
							   p.sort_order,
							   p.status,
							   s.pages_title,
							   s.pages_html_text,
							   s.intorext,
							   s.externallink,
							   s.link_target  
							from 
							   " . TABLE_PAGES . " p LEFT JOIN " .TABLE_PAGES_DESCRIPTION . " s on p.pages_id = s.pages_id
							where 
							   p.pages_id = 8 
							and 
							   p.page_type != 1 
							and 
							   s.language_id = '" . (int)$languages_id . "'
							order by 
							   p.sort_order, s.pages_title");
$page = tep_db_fetch_array($page_query);
echo'<a target="'.$target.'" href="' . $page['externallink'] . '">' . $page['pages_title'] . '</a>';
echo'<a target="'.$target.'" href="' . tep_href_link(FILENAME_PAGES, 'pages_id=' .$page['pages_id'], 'NONSSL') . '">' . $page['pages_title'] . '</a>';
$sts->stop_capture('aboutusp');
?>

I will create a repeat the code for each of the pages but I don't know how to access the database to pull the pages name and id from the datbase using the correct language.

please help