fixed it with:

Code:
$page_query = $db->Execute("SELECT e.*, et.pages_title
                             FROM  " . TABLE_EZPAGES . " e 
                               LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
                             WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
                                 AND e.status_footer = 1
                                 AND e.footer_sort_order > 0
                             ORDER BY e.header_sort_order, et.pages_title");