SELECT YEAR(bu_regdate) regdate_year, FLOOR(bu_price / 10000 / 100) * 100 price_about, bu_rooms , count(bu_id) FROM bukkened_sub WHERE ( (1) and ((bu_type1 = '2' and bu_type2 = '2')) and (concat(bu_address1, bu_address2) like '渶迷%') and ( ( (1) and (bu_type1 = '2' and bu_type2 = '2') ) ) ) GROUP BY regdate_year, price_about, bu_rooms UNION ALL SELECT YEAR(bu_regdate) regdate_year, FLOOR(bu_price / 10000 / 100) * 100 price_about, bu_rooms , count(bu_id) FROM bukken_sub WHERE ( (1) and ((bu_type1 = '2' and bu_type2 = '2')) and (concat(bu_address1, bu_address2) like '渶迷%') and ( ( (1) and (bu_type1 = '2' and bu_type2 = '2') ) ) ) GROUP BY regdate_year, price_about, bu_rooms-noTable 'ci5-12062101.bukkened_sub' doesn't exist