A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 36

select listings.listing_id, listing_name, listings.island_id, listings.bedrooms, listings.bathrooms, listings.listing_uri, island_uri, island_name, -- concat(substr(listings.description, 1, 500), '...') summary, listings.summary, listings.description, listings.latitude, listings.longitude, islands.latitude island_latitude, islands.longitude island_longitude, owner_people_id, has_availability_calendar, availability_link, owner_info_link, location, listings.is_featured, is_homepage, -- is_active, listings.status_type_id, status_types.status_type_description, (select attribute_value from listing_attributes inner join attributes on listing_attributes.attribute_id = attributes.attribute_id and attributes.attribute_name = 'Pool' where listing_attributes.listing_id = listings.listing_id) has_pool, (select attribute_value from listing_attributes inner join attributes on listing_attributes.attribute_id = attributes.attribute_id and attributes.attribute_name = 'Beachfront' where listing_attributes.listing_id = listings.listing_id) has_beach, (select attribute_value from listing_attributes inner join attributes on listing_attributes.attribute_id = attributes.attribute_id and attributes.attribute_name = 'Internet' where listing_attributes.listing_id = listings.listing_id) has_internet from listings inner join islands on listings.island_id = islands.island_id inner join status_types on listings.status_type_id = status_types.status_type_id and status_types.status_type != 'onhold' where listings.listing_id = -- and listings.is_active = 1