| tables=acgnEvents;fields=CONCAT('《',_pageName,'》',contents)=name,startDate,endDate,_pageName=link | | tables=acgnEvents;fields=CONCAT('《',_pageName,'》',contents)=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 | + | |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 |