lang09的博客

SELECT * from ( SELECT bwp.pattern_id as patternId ,tp.id as tpId,p.`name` as pname,sum( IF(pi.type = 1, 1, 0) ) as whiteApp ,rt.name as teName, tp.b_time as bTime,tp.e_time as eTime FROM ro_template_pattern as tp ..

SELECT * from ( SELECT t.id, t.name, t.province, p.name AS provinceName, t.city, c.`name` AS cityName, t.area, a.`name` AS areaName, t.street, s.`name` AS streetName, t.address AS address,t.remarks, t.community_type AS communityT..