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] */