<% if (params.~size > 0) {%>
WHERE 1=1
<% if (has("province_name")) {%>
and f1.province_name LIKE @province_name
<% } if (has("province_name")) { %>
and f1.cat_name LIKE @cat_name
<% } %>
GROUP BY f1.commodity_name
<% } %>