Database Error

A Database Error Occurred

Error Number: 1054

Unknown column 'fi.id' in 'field list'

SELECT `rv`.`LATITUDE`, `rv`.`ex_location`, `rv`.`LONGTITUDE`, `rv`.`ID`, `rv`.`TITLE`, `rv`.`metatitle`, `rv`.`BASE_PRICE_PER_NIGHT` as basprice, `rv`.`BEDROOMS` as bedrooms, `rv`.`GUESTS` as guests, `BEDROOMS` as bedrooms, `BATHROOMS` as bathrooms, `ua`.`FNAME` as fname, `ua`.`LNAME` as lname, `ru`.`PROFILE_PIC` as pic, `ru`.`USERNAME` as uname, `rp`.`PRICE_PER_NIGHT` as baseprice, `rp`.`cutoff_date`, `rp`.`perweek`, `rp`.`permonth`, `rp`.`currency`, `rp`.`CLEANING_FEES` as cleaning_fees, `rp`.`TAX_RATE` as tax_rate, `ra`.`HS_INTERNET` as wifi, `rs`.`SUIT3` as petfriendly, `rv`.`shared_guides`, `rv`.`rating_avg`, `rv`.`tot_reviews`, `cities`.`CITYFULL` as cityname, (SELECT fi.id as fav FROM houfy_favorites_list_items as fi WHERE fi.listing_id = rv.ID AND fi.type = "1" AND fi.user_id = "" LIMIT 1) as fav FROM (`rooffy_vacation` rv) JOIN `rooffmes1_users` ru ON `rv`.`USER_ID` = `ru`.`ID` JOIN `rooffy_users_apilogins` ua ON `rv`.`USER_ID` = `ua`.`USER_ID` AND ua.DEFAULT_LOGIN="Y" JOIN `rooffy_pricing` rp ON `rv`.`ID` = `rp`.`LISTING_ID` LEFT JOIN `rooffy_suitability` rs ON `rv`.`ID` = `rs`.`LISTING_ID` JOIN `rooffy_amenities` ra ON `rv`.`ID` = `ra`.`LISTING_ID` JOIN `rooffy_cities` cities ON `rv`.`CITY_ID` = `cities`.`ID` WHERE `rv`.`active` = 'Y' AND `rv`.`houfy_verified` = 'Y' AND `rv`.`isactive` = 'Y' AND `cities`.`ID` = '83' AND `rv`.`percentage` = 100 AND `rv`.`USER_ID` = 289 LIMIT 20

Filename: /var/www/html/testphp/api/models/getinfo_model.php

Line Number: 3040