Play/The Ember of Yellow Turban
| The Ember of Yellow Turban |
|---|
Play Information
The Ember of Yellow Turban (黄天ノ種火) is the Winter Troupe's twelfth play.
Related Event: The Ember of Yellow Turban
Related Story: [[Play/The Ember of Yellow Turban/Episode 1|]]
Type: Troupe
Introduction
Cast
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Homare" AND `mw_cargo__Card_Chibis`.`chibi1`="199" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Homare Arisugawa' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Azuma" AND `mw_cargo__Card_Chibis`.`chibi1`="197" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Azuma Yukishiro' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Guy" AND `mw_cargo__Card_Chibis`.`chibi1`="182" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Guy' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Tasuku" AND `mw_cargo__Card_Chibis`.`chibi1`="211" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Tasuku Takato' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Tsumugi" AND `mw_cargo__Card_Chibis`.`chibi1`="217" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Tsumugi Tsukioka' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT('50px') AS `Image` FROM `mw_cargo__Charas` LEFT OUTER JOIN `mw_cargo__Card_Chibis` ON ((`mw_cargo__Charas`.`firstname`=`mw_cargo__Card_Chibis`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) LEFT OUTER JOIN `mw_cargo__Card_Files` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Card_Files`.`number`)) WHERE `mw_cargo__Charas`.`firstname`="Hisoka" AND `mw_cargo__Card_Chibis`.`chibi1`="208" ORDER BY CONCAT('50px') LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageID` AS `cargo_backlink_page_id_Cards`,`mw_cargo__Charas`.`_pageID` AS `cargo_backlink_page_id_Charas`,`mw_cargo__Card_Chibis`.`_pageID` AS `cargo_backlink_page_id_Card_Chibis`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') AS `Image` FROM `mw_cargo__Card_Chibis` LEFT OUTER JOIN `mw_cargo__Charas` ON ((`mw_cargo__Card_Chibis`.`firstname`=`mw_cargo__Charas`.`firstname`)) LEFT OUTER JOIN `mw_cargo__Cards` ON ((`mw_cargo__Card_Chibis`.`number`=`mw_cargo__Cards`.`number`)) WHERE `mw_cargo__Charas`.`_pageName`='Hisoka Mikage' AND `mw_cargo__Cards`.`cardname` LIKE "%The Ember of Yellow Turban%" ORDER BY `mw_cargo__Cards`.`_pageID`,`mw_cargo__Charas`.`_pageID`,`mw_cargo__Card_Chibis`.`_pageID`,CONCAT('File:',`mw cargo Card Chibis`.`firstname`,' ',`mw cargo Card Chibis`.`chibi1`,' Chibi.png') LIMIT 100
Gallery
File:The Ember of Yellow Turban Poster B.png
