<select id="ibatorgenerated_selectByPrimaryKey" resultMap="ibatorgenerated_BaseResultMap"
parameterClass="java.util.Map">
select ROWNUM,t.* from (select
m.procuct_name,m.cost_price,i.img_path,s.product_sku_id,s.product_id
from
kmproduct.product_sku s,
kmproduct.productmain m,...