Template/FeaturedContent：修订间差异

2025年5月2日 (五) 18:18的版本

精选人物

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS "\xE4\xB8\xAD\xE6\x96\x87\xE4\xBA\xBA\xE7\x89\xA9" ORDER BY `cargo___page' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo___pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`cargo__FeaturedContent`.`_pageID` AS `cargo_backlink_page_id_FeaturedContent`,`cargo__FeaturedContent`.`Title` AS `Title`,`cargo__FeaturedContent`.`Description` AS `Description`,`cargo__FeaturedContent`.`Author` AS `Author`,`cargo__FeaturedContent`.`Image` AS `Image` FROM `cargo__FeaturedContent` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__FeaturedContent`.`_pageName`=`cargo___pageData`.`_pageName`)) WHERE `cargo__FeaturedContent`.`Type`="人物" AND `cargo__FeaturedContent`.`IsCurrent`="1" AND `cargo___pageData`.`_categories` HOLDS "中文人物" ORDER BY `cargo___pageData`.`_pageID`,`cargo__FeaturedContent`.`_pageID`,`cargo__FeaturedContent`.`Title`,`cargo__FeaturedContent`.`Description`,`cargo__FeaturedContent`.`Author` LIMIT 100

     往期人物精选

精选团体

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS "\xE4\xB8\xAD\xE6\x96\x87\xE5\x9B\xA2\xE4\xBD\x93" ORDER BY `cargo___page' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo___pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`cargo__FeaturedContent`.`_pageID` AS `cargo_backlink_page_id_FeaturedContent`,`cargo__FeaturedContent`.`Title` AS `Title`,`cargo__FeaturedContent`.`Description` AS `Description`,`cargo__FeaturedContent`.`Author` AS `Author`,`cargo__FeaturedContent`.`Image` AS `Image` FROM `cargo__FeaturedContent` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__FeaturedContent`.`_pageName`=`cargo___pageData`.`_pageName`)) WHERE `cargo__FeaturedContent`.`Type`="团体" AND `cargo__FeaturedContent`.`IsCurrent`="1" AND `cargo___pageData`.`_categories` HOLDS "中文团体" ORDER BY `cargo___pageData`.`_pageID`,`cargo__FeaturedContent`.`_pageID`,`cargo__FeaturedContent`.`Title`,`cargo__FeaturedContent`.`Description`,`cargo__FeaturedContent`.`Author` LIMIT 100

     往期团体精选

@@ 第3行： / 第3行： @@
      <div class="section-title">精选人物</div>
      <div class="feature-content">
-      {{#cargo_query:
+     {{#cargo_query:
-      tables=FeaturedContent,Page_Categories
+  tables=FeaturedContent,_pageData
-      |join on=FeaturedContent._pageName=Page_Categories._pageName
+  |join on=FeaturedContent._pageName=_pageData._pageName
-      |fields=FeaturedContent.Title, FeaturedContent.Description, FeaturedContent.Author, FeaturedContent.Image
+  |fields=FeaturedContent.Title, FeaturedContent.Description, FeaturedContent.Author, FeaturedContent.Image
-      |where=FeaturedContent.Type="人物" AND FeaturedContent.IsCurrent="1" AND Page_Categories._categoryName="中文人物"
+  |where=FeaturedContent.Type="人物" AND FeaturedContent.IsCurrent="1" AND _pageData._categories HOLDS "中文人物"
-      |limit=1
+  |limit=1
-      |format=template
+  |format=template
-      |template=FeaturedContent
+  |template=FeaturedContent
-      |named args=yes
+  |named args=yes
 }}
      </div>
@@ 第22行： / 第22行： @@
      <div class="section-title">精选团体</div>
      <div class="feature-content">
-      {{#cargo_query:
+     {{#cargo_query:
-        tables=FeaturedContent
+  tables=FeaturedContent,_pageData
-        |fields=Title, Description, Author, Image
+  |join on=FeaturedContent._pageName=_pageData._pageName
-        |where=Type="团体" AND IsCurrent="1"
+  |fields=FeaturedContent.Title, FeaturedContent.Description, FeaturedContent.Author, FeaturedContent.Image
-        |limit=1
+  |where=FeaturedContent.Type="团体" AND FeaturedContent.IsCurrent="1" AND _pageData._categories HOLDS "中文团体"
-        |format=template
+  |limit=1
-        |template=FeaturedContent
+  |format=template
-        |named args=yes
+  |template=FeaturedContent
-      }}
+  |named args=yes
+}}
      </div>
      <div class="see-more">