Draft method of retrieving logs from database

logs.php

<?php

/*
 *
 */
public function get_special_logs( $query  ) {

    if (!isset($query['special_id']) || !$query['special_id']) {
        return [];
    }

    global $wpdb;

    $count = 0;

    $table_name = $wpdb->prefix . "special_logs";

    $query = 'SELECT * FROM '.$table_name;

    if (isset($query['special_id']) && $query['special_id'] && ++$count) {
        $query .= (!$count ? ' WHERE ' : ' AND ' ) . ' special_id = "'.$query['special_id'].'" ';
    }

    if (isset($query['begin_date']) && $query['begin_date'] && ++$count) {
        $query .= (!$count ? ' WHERE ' : ' AND ' ) . ' datetime >= "'.$query['begin_date'].'" ';
    }

    if (isset($query['end_date']) && $query['end_date'] && ++$count) {
        $query .= (!$count ? ' WHERE ' : ' AND ' ) .' datetime <= "'.$query['end_date'].'" ';
    }

    return $wpdb->get_results( $query , ARRAY_A );
}