models.php
->add_subquery('(SELECT character_name FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter')
->add_subquery('(SELECT character_detail_id FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter_id')
->add_subquery('(SELECT character_icon FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter_icon')
以上是我用来从表中获取character_name
、character_detail_id
和character_icon
的三个子查询zid_character_details
并从表中引用zid_guild_feeds
。
谁能告诉我如何将这三个查询优化为单个或简单的查询。
谢谢
看看 Kohana Query Builder Joins 和 Kohana Query Builder 子查询
当您需要探索各种ORM时,我建议您查看Leap ORM