<?php
    if ($currentLang && strtoupper($currentLang) != 'EN') {
          $langSelect = ", `niches_languages`.`name` AS `langName`";
        $langJoin = " LEFT JOIN `niches_languages` ON `niches_languages`.`niche` = `niches`.`record_num` AND `niches_languages`.`language` = '$currentLang'";
        $langWhere = " ";
    }

    $max_results = $results_per_page;
    if (!isset($_GET['page']) || $_GET['page'] == '' || !is_numeric($_GET['page'])) {
        $page = 1;
    } else {
        $page = $_GET['page'];
    }
    $from = (($page * $max_results) - $max_results);
    
    $results = dbQuery("SELECT `niches`.* $langSelect FROM `niches` $langJoin WHERE 1=1 $langWhere ORDER BY `name`", true);
    $total_pages = ceil($total_results / $max_results);
?>