Mybatis - 仅作学习与使用记录，若违规立删

1.xml中 写 sql 时的注意事项；冯管干啥用的，注意格式就行。
注：xml中写sql时不能带注释，sql语句会被压缩成一整行，So...

	SELECT
		i.id AS itemId,
		i.item_name AS itemName,
		i.sell_counts AS sellCounts,
		ii.url AS imgUrl,
		spec.price_discount AS price
	FROM
		items i
	LEFT JOIN items_img ii ON i.id = ii.item_id
	LEFT JOIN ( SELECT item_id, min( price_discount ) AS price_discount FROM items_spec GROUP BY item_id ) spec ON spec.item_id = i.id
	WHERE
		ii.is_main = 1
		
		
			
			
			and i.item_name like "%${mapParam.keyword}%"	
			
		
	order by
	
		
		
		
			i.sell_counts desc
		
		
			spec.price_discount asc
		
		
			i.item_name desc