クエリの送信に失敗しました。<br />SQL2:SELECT property_viewflag,count(*) as cnt FROM m_property a INNER JOIN(SELECT SUBSTR(MIN(CONCAT(CASE WHEN property_imageflag = '1' THEN 0 ELSE 1 END,property_id)),2) as m_propertyid,count(*) as property_cnt FROM m_property WHERE property_situation = 0 and del_flag = 0 and property_type =  and (city_cd = '20215') and property_tradestatus != '3' and property_viewflag != '0' GROUP BY property_land_area,property_address1,property_address2,property_address3) b ON a.property_id = b.m_propertyid  ORDER BY property_ragefee0_kbn DESC,created DESC