<resultMap id="LayoutVo_ResultMap" extends="com.yuedu.ihome.yuegou.dao.LayoutModelMapper.BaseResultMap" type="com.yuedu.ihome.layout.vo.LayoutVo" >
<id column="rowNo" property="rowNo" jdbcType="INTEGER" />  
</resultMap>

<!-- 示范性分页查询 -->
<select id="selectByExampleListPage" resultMap="LayoutVo_ResultMap" parameterType="com.yuedu.ihome.yuegou.dao.base.Page">
select
    (@rowNum :=@rowNum + 1) AS rowNo,
    data_layout.*
from
    (
        select
        uname.user_name AS createUserName,
        <include refid="com.yuedu.ihome.yuegou.dao.LayoutModelMapper.Base_Column_List" />
        from layout
        LEFT JOIN (
        SELECT DISTINCT
                u.user_id,
                u.user_name
            FROM
                `user` u
            LEFT JOIN layout l ON u.user_id = l.create_user_id
        ) uname ON uname.user_id = layout.create_user_id
        <if test="_parameter != null">
            <include refid="com.yuedu.ihome.yuegou.dao.LayoutModelMapper.Update_By_Example_Where_Clause" />
        </if>
        <if test="sort != null">
            order by ${sort} ${order}
        </if>
        <if test="limit != null">
            limit ${start} , ${limit}
        </if>
    ) data_layout,
    (SELECT(@rowNum := ${start})) b
</select>