MyBatis SELECT语句失效

Question

使用MyBatis时，有一段SELECT语句出现无法理解的问题。

<select id="getHotelList" resultType="com.genius.travelline.product.entity.Hotel">
    SELECT
    a.id AS "id",
    a.title AS "title",
    a.province AS "province",
    a.city AS "city",
    a.level AS "level",
    b.url AS "imgUrl"
    FROM
    product_hotel_base a
    LEFT JOIN
    product_hotel_img b ON b.hotel_id = a.id
    WHERE
    a.del_flag = 0
    AND a.province = '湖南'
    AND a.city = '长沙'
</select>

上面那段语句是在MyBatis中写的，但是查询结果为空。

SELECT
a.id AS "id",
a.title AS "title",
a.province AS "province",
a.city AS "city",
a.level AS "level",
b.url AS "imgUrl"
FROM
product_hotel_base a
LEFT JOIN
product_hotel_img b ON b.hotel_id = a.id
WHERE
a.del_flag = 0
AND a.province = '湖南'
AND a.city = '长沙'

上面那段语句是在Navicat里面写的，查询结果正常。
两段语句几乎一模一样，但是为什么结果不一样呢？