277
个编辑
更改
跳到导航
跳到搜索
第5行：
第5行： − +
无编辑摘要
== '''<big>本月大事件</big>''' ==
== '''<big>本月大事件</big>''' ==
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=acgnEvents;fields=CONCAT('《',_pageName,'》',contents)=name,startDate,endDate,_pageName=link
tables=acgnEvents;fields=CONCAT('《',_pageName,'》',contents,if(remark is null,'',concat('(',remark,')')))=name,startDate,endDate,_pageName=link
|tables=birthdayEvents,birthdayEvents__birthday;join on=birthdayEvents._id=birthdayEvents__birthday._rowid;fields=CONCAT('《',_pageName,'》',birthdayEvents.characterName,if(birthdayEvents__birthday._position=1,'出生','生日'))=name,birthday=start,birthday=end,_pageName=link;color=gray
|tables=birthdayEvents,birthdayEvents__birthday;join on=birthdayEvents._id=birthdayEvents__birthday._rowid;fields=CONCAT('《',_pageName,'》',birthdayEvents.characterName,if(birthdayEvents__birthday._position=1,'出生','生日'))=name,birthday=start,birthday=end,_pageName=link;color=gray
|width=70%
|width=70%
|format=calendar
|format=calendar
}}
}}