多条件组合查询SQL语句

//根据组合条件查询新闻列表
    @Select("<script>"+"select N_ID AS id,N_indexNum AS indexNum,N_fileNum AS fileNum,N_Title AS title,N_Content AS content,N_aID AS aId,N_mID AS mId,N_pic AS pic,N_file AS newsFile,N_url AS url,N_from AS newsFrom,N_author AS author,N_addTime AS addTime,N_isTop AS isTop,N_topic AS topic,N_hitCount AS hitCount,N_keyWords AS keyWords,N_isPublish AS isPublish,N_rejectReason AS rejectReason,N_CheckName AS checkName,N_CName AS cName,N_CPosition AS cPosition,N_valid AS valid,N_isHeadlineNews AS isHeadlineNews from Article_News where 1=1" +
            " <if test='N_author != null and N_author.trim() != &quot;&quot;'>" +
//            " AND N_author LIKE CONCAT('%',#{N_author},'%')" +
            "AND N_author LIKE '%'+#{N_author}+'%'"+
            " </if>" +
            " <if test='N_Title != null and N_Title.trim() != &quot;&quot;'>" +
//            " AND N_Title LIKE CONCAT('%',#{N_Title},'%')" +
            " AND N_Title LIKE '%'+#{N_Title}+'%'" +
            " </if>"+
            " <if test='N_mID != null '>" +
            " AND N_mID=#{N_mID} " +
            " </if>" +"ORDER BY  N_isPublish asc, N_addTime DESC"+"</script>")
    List<ArticleNewsVO> selectZuHe(Page<ArticleNewsVO> page, ZuHeNews zuHeNews);

@Select("<script>"+"select N_ID AS id, N_indexNum AS indexNum,N_fileNum AS fileNum,N_Title AS title,N_Content AS content,N_aID AS aId,N_mID AS mId,N_pic AS pic,N_file AS newsFile,N_url AS url,N_from AS newsFrom,N_author AS author,N_addTime AS addTime,N_isTop AS isTop,N_topic AS topic,N_hitCount AS hitCount,N_keyWords AS keyWords,N_isPublish AS isPublish,N_rejectReason AS rejectReason,N_CheckName AS checkName,N_CName AS cName,N_CPosition AS cPosition,N_valid AS valid,N_isHeadlineNews AS isHeadlineNews from Article_News where 1=1" +
            " <if test='zuHeNews.N_author != null and zuHeNews.N_author.trim() != &quot;&quot;'>" +
//            " AND N_author LIKE CONCAT('%',#{N_author},'%')" +
            "AND N_author LIKE '%'+#{N_author}+'%'"+
            "AND N_author LIKE '%'+#{zuHeNews.N_author}+'%'"+
            " </if>" +
            " <if test='N_Title != null and N_Title.trim() != &quot;&quot;'>" +
            " <if test='zuHeNews.N_Title != null and zuHeNews.N_Title.trim() != &quot;&quot;'>" +
//            " AND N_Title LIKE CONCAT('%',#{N_Title},'%')" +
            " AND N_Title LIKE '%'+#{N_Title}+'%'" +
            " AND N_Title LIKE '%'+#{zuHeNews.N_Title}+'%'" +
            " </if>"+
            " <if test='N_mID != null '>" +
            " AND N_mID=#{N_mID} " +
            " </if>" +"ORDER BY  N_isPublish asc, N_addTime DESC"+"</script>")
    List<ArticleNewsVO> selectZuHeByCommon(Page<ArticleNewsVO> page, ZuHeNews zuHeNews, Integer aId);
            " <if test='zuHeNews.N_mID != null '>" +
            " AND N_mID=#{zuHeNews.N_mID} " +
            " </if>" +" and N_aID = #{adminId} ORDER BY  N_isPublish asc, N_addTime DESC"+"</script>")
    List<ArticleNewsVO> selectZuHeByCommon(Page<ArticleNewsVO> page,
                                           @Param("zuHeNews") ZuHeNews zuHeNews,
                                           Integer adminId);