function splitPageResults($query, $max_rows, $count_key = '*', $page_holder = 'page', $number_of_rows = '')
 {
     global $HTTP_GET_VARS, $HTTP_POST_VARS;
     $this->sql_query = $query;
     $this->page_name = $page_holder;
     if (isset($HTTP_GET_VARS[$page_holder])) {
         $page = $HTTP_GET_VARS[$page_holder];
     } elseif (isset($HTTP_POST_VARS[$page_holder])) {
         $page = $HTTP_POST_VARS[$page_holder];
     } else {
         $page = '';
     }
     if (empty($page) || (int) $page == 0) {
         $page = 1;
     }
     $this->current_page_number = $page;
     if (strlen($number_of_rows) > 0) {
         $this->number_of_rows = $number_of_rows;
     } else {
         $pos_to = mb_strlen($this->sql_query, 'CP1251');
         $pos_from = mb_strpos($this->sql_query, ' from', 0, 'CP1251');
         $pos_group_by = mb_strpos($this->sql_query, ' group by', $pos_from, 'CP1251');
         if ($pos_group_by < $pos_to && $pos_group_by != false) {
             $pos_to = $pos_group_by;
         }
         if ($pos_group_by != false) {
             if (preg_match('/group by ([^\\s|,]+)/i', $this->sql_query, $regs)) {
                 $count_key = trim($regs[1]);
             }
         }
         $pos_having = mb_strpos($this->sql_query, ' having', $pos_from, 'CP1251');
         if ($pos_having < $pos_to && $pos_having != false) {
             $pos_to = $pos_having;
         }
         $pos_order_by = mb_strpos($this->sql_query, ' order by', $pos_from, 'CP1251');
         if ($pos_order_by < $pos_to && $pos_order_by != false) {
             $pos_to = $pos_order_by;
         }
         if (mb_strpos($this->sql_query, 'distinct', 0, 'CP1251') || mb_strpos($this->sql_query, 'group by', 0, 'CP1251')) {
             $count_string = 'distinct ' . tep_db_input($count_key);
         } else {
             $count_string = tep_db_input($count_key);
         }
         $count_query = tep_db_unbuffered_query("select count(" . $count_string . ") as total " . mb_substr($this->sql_query, $pos_from, $pos_to - $pos_from, 'CP1251'));
         $count = tep_db_fetch_array($count_query);
         $this->number_of_rows = $count['total'];
     }
     $this->number_of_rows_per_page = $max_rows > 0 ? $max_rows : $this->number_of_rows;
     $this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);
     if ($this->current_page_number > $this->number_of_pages) {
         $this->current_page_number = $this->number_of_pages;
     }
     $offset = $this->number_of_rows_per_page * ($this->current_page_number - 1);
     $this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;
 }
 } else {
     $form_link = $form_link . '?action=[form_action]';
 }
 while (strpos($form_link, '?&')) {
     $form_link = str_replace('?&', '?', $form_link);
 }
 while (strpos($form_link, '&&')) {
     $form_link = str_replace('&&', '&', $form_link);
 }
 $cur_row = 0;
 //	if ($customer_id==2) echo $listing_sql;
 $listing = array();
 if ($show_listing_string == false) {
     $listing_query = tep_db_unbuffered_query($listing_sql);
 } else {
     $listing_query = tep_db_unbuffered_query($listing_split->sql_query);
 }
 while ($row = tep_db_fetch_row($listing_query)) {
     $listing[] = $row[0];
 }
 reset($listing);
 while (list($rows, $product_id) = each($listing)) {
     $product_info_query = tep_db_query("select " . $select_column_list . " p.* from " . TABLE_PRODUCTS . " p where p.products_id = '" . (int) $product_id . "'");
     $product_info = tep_db_fetch_array($product_info_query);
     $product_info['final_price'] = $product_info['products_price'];
     $product_info['specials_new_products_price'] = 0;
     $product_info['specials_name'] = '';
     $product_info['specials_description'] = '';
     $special_info_query = tep_db_query("select specials_name, specials_description, specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int) $product_id . "' and status > '0' and specials_new_products_price > '0' and specials_new_products_price < '" . $product_info['products_price'] . "' and language_id = '" . (int) $languages_id . "' order by specials_date_added desc limit 1");
     if (tep_db_num_rows($special_info_query) > 0) {
         $special_info = tep_db_fetch_array($special_info_query);