if (NQ_WHITELIST_EXISTENTIAL ? count($whitelist) > 0 : true) {
$from_query->whitelist_columns($whitelist);
}
}
# Adding our select columns
$from_query->add_select_columns($G_FROM_TABLE_COLUMNS);
# Where columns
$from_query->add_where_columns($_CGET);
# Order by
if (isset($_CGET['order'])) {
$order_sort = isset($_CGET['ordersort']) ? explode(',', $_CGET['ordersort']) : [];
$from_query->add_order_by(explode(',', $_CGET['order']), $order_sort);
}
# Group by
if (isset($_CGET['group'])) {
$from_query->add_group_by(explode(',', $_CGET['group']));
}
# Where columns
$from_query->add_where_columns($_CGET);
# Overwriting with our global session where values
if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_FROM_TABLE_SETTINGS['alias']})) {
$from_query->add_where_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->global->{$G_FROM_TABLE_SETTINGS['alias']});
}
# Overwriting with our specific fetch where values
if (isset($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->fetch->{$G_FROM_TABLE_SETTINGS['alias']})) {
$from_query->add_where_columns($G_TOKEN_SESSION_DATA->{NQ_SESSION_GROUP}->fetch->{$G_FROM_TABLE_SETTINGS['alias']});
}
}
# Selecting
$from_query->set_table($from_partition_data['table_name'], false, false, $from_partition_data['database']);
$select_query = $from_query->get_select_query($limit, false, false);
$query->whitelist_columns($whitelist);
}
}
# Excluding from the table
if ($G_COLUMNS_EXCLUDED !== false) {
$query->blacklist_columns($G_COLUMNS_EXCLUDED);
}
# Adding our select columns
$query->add_select_columns($G_COLUMNS_SELECTED, false, $G_TABLE_DETAILS['alias']);
# Order by
if ($G_ORDER_BY !== false) {
$query->add_order_by($G_ORDER_BY, $G_ORDER_DESC, false, $G_TABLE_DETAILS['alias']);
}
# Group by
if ($G_GROUP_BY !== false) {
$query->add_group_by($G_GROUP_BY, false, $G_TABLE_DETAILS['alias']);
}
# Where columns
$query->add_where_columns($_CGET, false, $G_TABLE_DETAILS['alias']);
}
}
mysqli_free_result($partition_results);
# We don't want to do our counts (large queries)
$matched_count = 0;
if (!$show_count) {
# Handling our pages
$per_page = isset($_CGET['limit']) ? min((int) $_CGET['limit'], $G_APP_DATA['results_limit']) : $G_APP_DATA['results_limit'];
$page = isset($_CGET['page']) ? abs((int) $_CGET['page']) : 0;
$page_start = $page * $per_page;
$per_page = $per_page + 1;
# We are forcing pagination
