WordPress database error: [Table 'testidxmap_bk.listings_rets_active' doesn't exist]
SELECT ( select COUNT(id) FROM listings_rets_active where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental = 1 ) as total_rent, ( select AVG(list_price) FROM listings_rets_active where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental = 1 ) as prom_price_rent, ( select AVG(list_price) FROM listings_rets_sold where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental IS NULL AND list_date >= "2018-02-20" ) as prom_price_sold, COUNT(id) AS total_sale, min(square_feet) AS min_sf, max(square_feet) AS max_sf, min(list_price) AS price_min, max(list_price) AS price_max, AVG(square_feet) AS pro_sf, AVG(list_price) AS prom_price, min( list_date ) AS min_date , max( list_date ) AS max_date FROM listings_rets_active where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental IS NULL /* From [www.euadoromiami.com.br/condo-building/aqua-gorlin/] in [/nas/content/live/euadoromiami/wp-content/plugins/idx-real-estate-post-type/admin/generate_information.php:85] */

WordPress database error: [Table 'testidxmap_bk.listings_rets_sold' doesn't exist]
select (select count(id) FROM listings_rets_sold where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental IS NULL AND list_date >= "2018-02-20" ) as tot_12, (select count(id) FROM listings_rets_sold where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental IS NULL AND list_date >= "2017-02-20" ) as tot_24, (select count(id) FROM listings_rets_sold where ( (street_number IN (6101) and street_name regexp "Aqua") ) and zip regexp "33141" AND rental IS NULL AND list_date >= "2016-02-20" ) as tot_36 /* From [www.euadoromiami.com.br/condo-building/aqua-gorlin/] in [/nas/content/live/euadoromiami/wp-content/plugins/idx-real-estate-post-type/admin/generate_information.php:116] */