% On Error Resume Next set ObjConn=Open_Conn() strSQL="" strSQL=strSQL+"SELECT A.[SID],A.[OnClick],A.[Name],A.[Subject],A.[PostDate],ISNULL(B.[ViewCount],0) AS [ViewCount],B.[RePostDate],B.[Name] AS [ReName] " strSQL=strSQL+"FROM " strSQL=strSQL+" ( " strSQL=strSQL+" SELECT TalkReply.*, M.[ViewCount] " strSQL=strSQL+" FROM [TalkReply], " strSQL=strSQL+" ( " strSQL=strSQL+" SELECT [SID], COUNT(1) AS [ViewCount], MAX([RePostDate]) AS [RePostDate] " strSQL=strSQL+" FROM [TalkReply] " strSQL=strSQL+" GROUP BY [SID] " strSQL=strSQL+" ) M " strSQL=strSQL+" WHERE 1=1 AND TalkReply.[RePostDate]=M.[RePostDate] AND TalkReply.[SID]=M.[SID] " strSQL=strSQL+" ) B RIGHT JOIN [TalkSubject] A ON A.[SID]=B.[SID] " strSQL=strSQL+"WHERE [CodeName]='S131120030816P' " strSQL=strSQL+"ORDER BY A.[LastPostDate] DESC" 'response.write strSQL set ObjRs=Open_Rs(ObjConn,strSQL) %>
亞洲新人歌唱大賽放寬比賽年齡限制公告、報名辦法 |
|
|
|
| 年齡資格調整如下 | |
| 報名資格: 14歲
~ 38歲 節目評分標準:音色40%、技巧40%、台風20% |
|
| 詳細報名辦法 | |
|