<select id="queryTemplateName" resultType="com.qrkjdiy.publish.entity.publish.PublishCategory">
select c.id,c.style_no,c.one_category_id,c.one_category_name,c.two_category_id,
c.two_category_name,c.three_category_id,c.three_category_name,c.excel_template_name,
c.online_platform_id,c.online_platform_name,c.create_time,c.update_time,s.name,
s.english_style_name from pb_publish_category c
join qr_style s on c.style_no=s.style_no
<where>
${ew.SqlSegment} and s.open_status=1</where></select>