SELECT
	(((
			SELECT
				( curdate() - INTERVAL 30 YEAR )) - INTERVAL 1 YEAR	
			) + INTERVAL ( cast( `mysql`.`help_topic`.`help_topic_id` AS signed ) + 1 ) YEAR 
	) AS `current_week` 
FROM
	`mysql`.`help_topic` 
WHERE
	(
		`mysql`.`help_topic`.`help_topic_id` < 30) 
ORDER BY
	`mysql`.`help_topic`.`help_topic_id`

<select id="select" resultMap="Vo">
        select d.date,count(t.id) count
    form 
        (SELECT
	        (((
			SELECT
				( curdate() - INTERVAL #{連續(xù)時間長度} 
                <if test="判斷傳入?yún)?shù)">
                    YEAR
                </if>
             )) - INTERVAL 1 
                <if test="判斷傳入?yún)?shù)">
                    YEAR
                </if>	
			) + INTERVAL ( cast( `mysql`.`help_topic`.`help_topic_id` AS signed ) + 1 ) 
            <if test="判斷傳入?yún)?shù)">
                YEAR
            </if>
        	) AS `current_week` 
        FROM
	        `mysql`.`help_topic` 
        WHERE
    	(
	    	`mysql`.`help_topic`.`help_topic_id` < #{連續(xù)時間長度} ) 
            ORDER BY
	        `mysql`.`help_topic`.`help_topic_id`) d
        left join (
            /** 具體的業(yè)務(wù)表 */
        ）T on T.date = d.date
</select>