A Database Error Occurred

Error Number: 1064

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 'group by hotel_details_common.data_id, hotel_details_common.hotel_url, hotel_...' at line 14

SELECT hotel_details_common.data_id, hotel_details_common.hotel_url, hotel_details_common.star_category, hotel_details_common.hotel_location_data_id, hotel_details_common.hotel_logo_img_id, hotel_details_common.hotel_image_id, hotel_details_common.distance, hotel_details_lang.data_id, hotel_details_lang.hotel_name, hotel_details_lang.hotel_description, hotel_details_lang.hotel_address /*hotel_details_lang.*, hotel_rooms_common.*, hotel_rooms_lang.**/ FROM hotel_details_common INNER JOIN hotel_details_lang ON hotel_details_lang.data_id = hotel_details_common.data_id INNER JOIN hotel_rooms_common ON hotel_rooms_common.hotel_id = hotel_details_lang.data_id INNER JOIN hotel_rooms_lang ON hotel_rooms_lang.hotel_id = hotel_rooms_common.hotel_id WHERE group by hotel_details_common.data_id, hotel_details_common.hotel_url, hotel_details_common.star_category, hotel_details_common.hotel_location_data_id, hotel_details_common.hotel_logo_img_id, hotel_details_common.hotel_image_id, hotel_details_common.distance, hotel_details_lang.data_id, hotel_details_lang.hotel_name, hotel_details_lang.hotel_description, hotel_details_lang.hotel_address

Filename: /home/islamnts/public_html/models/search_model.php

Line Number: 89