SELECT
count(1)
FROM
tb_shop s,
tb_area a,
tb_shop_category sc


and s.shop_category_id=
#{shopCondition.shopCategory.shopCategoryId}


and s.shop_category_id in (select shop_category_id from
tb_shop_category
WHERE parent_id =
#{shopCondition.shopCategory.parent.shopCategoryId})


and s.area_id=
#{shopCondition.area.areaId}

		<if
			test="shopCondition.shopName!=null">
			and s.shop_name like '%#{shopCondition.shopName}%'
			</if>
			
		<if
			test="shopCondition.enableStatus!=null">
			and s.enable_status =#{shopCondition.enableStatus}
			</if>
		
		<if
			test="shopCondition.owner!=null and shopCondition.owner.userId!=null">
			and s.owner_id = #{shopCondition.owner.userId}		
			</if>
			AND 
			s.area_id=a.area_id
			AND
			s.shop_category_id=sc.shop_category_id
	</where>
</select>

查询结果