You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') order by name ASC' at line 1
select page_id, booking_id, acc_type from st_bs_accommodations where (destination_id = ) order by name ASC
Array
(
    [0] => Array
        (
            [file] => /var/www/clients/client67/web193/web/includes/comp_accommodation-map.php
            [line] => 26
            [function] => mysql_query
            [args] => Array
                (
                    [0] => select page_id, booking_id, acc_type from st_bs_accommodations where (destination_id = ) order by name ASC
                )

        )

    [1] => Array
        (
            [file] => /var/www/clients/client67/web193/web/includes/template_page_accommodation-at-destination.php
            [line] => 112
            [args] => Array
                (
                    [0] => /var/www/clients/client67/web193/web/includes/comp_accommodation-map.php
                )

            [function] => include
        )

    [2] => Array
        (
            [file] => /var/www/clients/client67/web193/web/includes/template_site_standard.php
            [line] => 55
            [args] => Array
                (
                    [0] => /var/www/clients/client67/web193/web/includes/template_page_accommodation-at-destination.php
                )

            [function] => include
        )

    [3] => Array
        (
            [file] => /var/www/clients/client67/web193/web/index.php
            [line] => 188
            [args] => Array
                (
                    [0] => /var/www/clients/client67/web193/web/includes/template_site_standard.php
                )

            [function] => include
        )

)