Query Error: Table 'dhr.b_rezlist' doesn't exist
SQL: SELECT u.*, IF(special.ratecode IS NULL,br.ratecode, special.ratecode) as ratecode, IF(special.features IS NULL,br.features, special.features) as features, IF(special.shortdesc IS NULL,br.shortdesc, special.shortdesc) as shortdesc, IF(special.minlos IS NULL,br.minlos, special.minlos) as minlos, IF(special.maxlos IS NULL,br.maxlos, special.maxlos) as maxlos, (SELECT GROUP_CONCAT(images.file_name ORDER BY images.order_id ASC SEPARATOR ',') FROM images WHERE images.unit=u.id and images.is_active=1 and images.image_type=0 GROUP BY images.unit) as images, IF(u.rating!='',u.rating,'zzzz') as ratingorder, ROUND(AVG(IF(spr.onenight IS NULL, r.onenight, spr.onenight)),2) AS onenightavg, ROUND(AVG(IF(spr.multinight IS NULL, r.multinight, spr.multinight)),2) AS multinightavg FROM units u LEFT JOIN b_ratecodes br ON (br.property=39 AND (br.unittype=u.springer_type AND br.is_unique=0 AND br.features=u.springer_diamonds) AND br.startdate<'2015-08-31' AND br.enddate>'2015-09-01') LEFT JOIN b_ratecodes special ON (special.property=39 AND (special.unittype=u.springer_id and special.is_unique=1 AND special.features='C') AND special.startdate<'2015-08-31' AND special.enddate>'2015-09-01') LEFT JOIN b_rates r ON ( r.thedate>='2015-08-31' AND r.thedate<'2015-09-01' AND r.ratecode=br.id AND r.property=39) LEFT JOIN b_rates spr ON ( spr.thedate>='2015-08-31' AND spr.thedate<'2015-09-01' AND spr.ratecode=special.id AND spr.property=39) LEFT JOIN b_rezlist a ON ((a.arrival<'2015-09-01' and a.departure>'2015-08-31') AND a.unitnumber=u.springer_id) WHERE !(ISNULL(r.thedate) AND ISNULL(spr.thedate)) AND u.is_active=1 AND FIND_IN_SET(u.building,'108,110,109,105,104,107,74,57,87') AND u.rental_program=1 AND u.springer_id!='' AND u.springer_type!='' AND a.unitnumber IS NULL AND u.springer_id='H11129' GROUP BY u.id ORDER BY ratingorder ASC, u.rating ASC, u.unit_usage ASCAn error has been encountered while accessing the database. Please try again later.