![](\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2011\/02\/wpid-dworkblogimage20110201_06org.jpg\")
<\/a><\/p>\n- \n
- terms: \u30ab\u30c6\u30b4\u30ea\u540d\u306a\u3069\u306e\u540d\u79f0<\/li>\n
- term_taxonomy: terms \u306e\u5206\u985e(category, link_category \u306a\u3069)<\/li>\n
- term_relationships: \u30ab\u30c6\u30b4\u30ea\u3068\u306e\u89aa\u5b50\u95a2\u4fc2<\/li>\n
- posts: \u8a18\u4e8b\u81ea\u4f53<\/li>\n<\/ul>\n
\u3068\u3044\u3046 4 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u95a2\u308f\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n
\u3044\u304d\u306a\u308a\u306f\u3084\u3084\u3053\u3057\u3044\u306e\u3067\u3001\u307e\u305a\u306f\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7\u3002<\/p>\n
\u25a0\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7\u306e\u30d3\u30e5\u30fc(views\/categories\/index.ctp)<\/p>\n
[code lang=”php”]
\n<h2>\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7<\/h2>
\n<table>
\n\t<tr>
\n\t\t<th>term_id<\/th>
\n\t\t<th>term_taxonomy_id<\/th>
\n\t\t<th>name<\/th>
\n\t\t<th>slug<\/th>
\n\t<\/tr>
\n\t<?php foreach($Categories as $item) : ?>
\n\t<tr>
\n\t\t<td><?php echo $item[‘Term’][‘term_id’]; ?>
\n\t\t<td><?php echo $item[‘TermTaxonomy’][‘term_taxonomy_id’]; ?>
\n\t\t<td><?php echo $item[‘Term’][‘name’]; ?>
\n\t\t<td><?php echo $item[‘Term’][‘slug’]; ?>
\n\t<\/tr>
\n\t<?php endforeach ; ?>
\n<\/table>
\n<h2>\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7(\u30ea\u30f3\u30af\u7248)<\/h2>
\n<ul>
\n\t<?php foreach($Categories as $item) : ?>
\n\t<li>
\n\t\t<a href="http:\/\/localhost\/cake_wp\/categories\/item\/<?php echo $item[‘Term’][‘slug’]; ?>"><?php echo $item[‘Term’][‘name’]; ?><\/a>
\n\t<\/li>
\n\t<?php endforeach ; ?>
\n<\/ul>
\n[\/code]<\/p>\n\u30ab\u30c6\u30b4\u30ea\u3060\u3051\u3092\u8868\u793a\u3057\u305f\u3044\u306e\u3067\u3001Term \u3068 TermTaxonomy \u30e2\u30c7\u30eb\u3060\u3051\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n
\u25a0\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc(controllers\/categories_controller.php)<\/p>\n
[code lang=”php”]
\n<?php
\nclass CategoriesController extends AppController {<\/p>\n\tvar $name = ‘Categories’;
\n\tvar $uses = array(‘Category’);
\n\tfunction index() {
\n\t\t$this->set(‘Categories’,$this->Category->findCategories());
\n\t}
\n\tfunction item($slug=”) {
\n\t\t$this->set(‘Categories’,$this->Category->findPosts($slug));
\n\t\t$this->set(‘ViewData’,array(
\n\t\t\t‘slug’=>$slug,
\n\t\t\t‘name’=> $this->Category->getCategoryName($slug)
\n\t\t\t\t));
\n\t}
\n}
\n?>
\n[\/code]<\/p>\n\uff08\u8ffd\u8a18 2014\/06\/22 item function \u3092\u8ffd\u52a0\uff09
\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306f CategoriesController \u306b\u3057\u307e\u3057\u305f\u30024 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3046\u306e\u3067\u3001\u3069\u308c\u306e\u540d\u524d\u3082\u9069\u5207\u3067\u306f\u306a\u3044\u3093\u3067\u3059\u3088\u306d\u3002\u305d\u3057\u3066\u3001\u4e00\u89a7\u8868\u3092\u53d6\u308b\u6642\u306b\u306f index \u30e1\u30bd\u30c3\u30c9\u3092\u4f5c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\u3055\u3066\u3001\u30e2\u30c7\u30eb\u306f\u3069\u3046\u3059\u308b\u304b\u3068\u3044\u3046\u3068\u3001Term \u30e2\u30c7\u30eb\u3001TermTaxonomy \u30e2\u30c7\u30eb\u3092\u76f4\u63a5\u5229\u7528\u3059\u308b\u3053\u3068\u306f\u907f\u3051\u307e\u3057\u305f\u3002\u5148\u306b\u3082\u66f8\u304d\u307e\u3057\u305f\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e0a\u306f\u6b63\u898f\u5316\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5e38\u306a\u8a33\u3067\u3001\u305d\u306e\u307e\u307e O\/R \u30de\u30c3\u30d4\u30f3\u30b0\u3092\u3057\u3066\u3057\u307e\u3046\u3068\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411\u306e\u4e16\u754c\u3067\u306f\u300c\u73fe\u5b9f\u96e2\u308c\u300d\u306a\u30af\u30e9\u30b9\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u306a\u306e\u3067\u3001\u3088\u308a\u81ea\u7136\u306a\u5f62\u306b\u623b\u3059(\u672c\u6765\u306e\u5f62\u306b\u623b\u3059)\u305f\u3081\u306b\u3001Category \u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u3092\u4f5c\u308a\u307e\u3059\u3002
\n\u3053\u3053\u3067\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306b\u3001findPosts \u3068\u3044\u3046\u30e1\u30bd\u30c3\u30c9\u3092\u65b0\u305f\u306b\u4f5c\u3063\u3066\u3044\u307e\u3059\u3002
\n# find(‘all’) \u3068\u304b find(‘first’) \u3068\u304b\u5408\u308f\u305b\u305f\u307b\u3046\u304c\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u3072\u3068\u307e\u305a\u3002<\/p>\n\u25a0\u30e2\u30c7\u30eb(models\/category.php)<\/p>\n
\u3055\u3066\u3001Category \u30e2\u30c7\u30eb\u306f\u5b9f\u30c6\u30fc\u30d6\u30eb\u3068\u306f\u9023\u7d50\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u3001$useTable = false \u306b\u3057\u307e\u3059\u3002\u3067\u3001\u554f\u984c\u306a\u306e\u306f\u3001\u3069\u3046\u3084\u3063\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u3063\u3066\u304f\u308b\u306e\u304b\uff1f\u3067\u3059\u306d\u3002<\/p>\n
\u5148\u306b Term \u3068 TermTaxonomy \u30e2\u30c7\u30eb\u306e\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n
[code lang=”php”]
\n<!– models\/term.php –>
\n<?php
\nclass Term extends AppModel
\n{
\n\tvar $name = ‘Term’;
\n\tvar $primaryKey = ‘term_id’;
\n\tvar $hasOne = array(
\n\t\t‘TermTaxonomy’ => array(
\n\t\t\t‘className’ => ‘TermTaxonomy’,
\n\t\t\t‘foreignKey’ => ‘term_taxonomy_id’ ));
\n}
\n?>
\n[\/code]<\/p>\nTerm.term_taxonomy_id (1)-(1) TermTaxonomy.term_taxonomy_id \u306e\u95a2\u4fc2\u306b\u306a\u308b\u306e\u3067 Model::$hasOne \u3092\u6307\u5b9a\u3002<\/p>\n
[code lang=”php”]
\n<!– models\/term_taxonomy.php –>
\n<?php
\nclass TermTaxonomy extends AppModel
\n{
\n\tvar $name = ‘TermTaxonomy’;
\n\tvar $useTable = ‘term_taxonomy’;
\n\tvar $primaryKey = ‘term_taxonomy_id’;
\n\tvar $hasOne = array(
\n\t ‘Term’ => array(
\n\t\t\t‘className’ => ‘Term’,
\n\t\t\t‘foreignKey’ => ‘term_id’ ));
\n}
\n?>
\n[\/code]<\/p>\n\u9006\u5411\u304d\u3082\u540c\u3058\u3067 Model::$hasOne \u3092\u6307\u5b9a\u3002<\/p>\n
\u3053\u3046\u3057\u3066\u304a\u304f\u3068\u3001\u6b21\u306e\u3088\u3046\u306b findCategories \u304c\u66f8\u3051\u307e\u3059\u3002<\/p>\n
[code lang=”php”]
\n<!– models\/category.php –>
\n<?php
\nclass Category extends AppModel
\n{
\n\tvar $name = ‘Category’;
\n\tvar $useTable = false ;
\n\tfunction findCategories() {
\n\t\tif (0) {
\n\t\t\t$TermTaxonomy = ClassRegistry::init(‘TermTaxonomy’);
\n\t\t\t$items = $TermTaxonomy->find(‘all’,array(
\n\t\t\t\t‘conditions’=>"taxonomy = ‘category’"));
\n\t\t\treturn $items ;
\n\t\t} else {
\n\t\t\t$Term = ClassRegistry::init(‘Term’);
\n\t\t\t$items = $Term->find(‘all’, array(
\n\t\t\t\t‘conditions’=>"TermTaxonomy.taxonomy = ‘category’"));
\n\t\t\treturn $items ;
\n\t\t}
\n\t}
\n}
\n[\/code]<\/p>\nif \u6587\u3067\u5206\u3051\u3066\u3044\u307e\u3059\u304c\u3001\u3069\u3061\u3089\u3082\u540c\u3058\u8a18\u8ff0\u3067\u3059\u3002
\n\u30c6\u30fc\u30d6\u30eb\u306b\u9023\u7d50\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001ClassRegistry::init \u30e1\u30bd\u30c3\u30c9\u3067\u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u3092\u8aad\u307f\u8fbc\u307f\u307e\u3059\u3002\u3053\u306e\u5f8c\u306f\u3001\u666e\u901a\u306b\u691c\u7d22\u3092\u3057\u3066 OK \u3067\u3059\u3002
\nTermTaxonomy \u30e2\u30c7\u30eb\u3092\u4e2d\u5fc3\u306b\u3057\u305f\u5834\u5408\u306f\u3001’category’ \u3092\u76f4\u63a5\u691c\u7d22\u3067\u304d\u307e\u3059\u304c\u3001Term \u30e2\u30c7\u30eb\u3092\u4e2d\u5fc3\u306b\u3057\u305f\u5834\u5408\u306f\u3001TermTaxonomy.taxonomy \u306a\u5f62\u3067 conditions \u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\u3053\u308c\u306f\u3069\u3061\u3089\u3082\u7d50\u679c\u304c\u540c\u3058\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
[img 20110201_07.jpg]<\/p>\n
\u4eca\u5ea6\u306f\u3001\u30ab\u30c6\u30b4\u30ea\u5185\u306e\u8a18\u4e8b\u4e00\u89a7\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n
\u25a0\u30ab\u30c6\u30b4\u30ea\u5185\u8a18\u4e8b\u306e\u30d3\u30e5\u30fc(views\/categories\/item.ctp)<\/p>\n
[code lang=”php”]
\n<h2>\u30ab\u30c6\u30b4\u30ea\u5185\u306e\u8a18\u4e8b\u4e00\u89a7<\/h2>
\n<?php echo $ViewData[‘slug’]; ?> \/
\n<?php echo $ViewData[‘name’]; ?>
\n<table>
\n\t<tr>
\n\t\t<th>Post.ID<\/th>
\n\t\t<th>Post.post_title<\/th>
\n\t\t<th>Post.post_date<\/th>
\n\t\t<th>Post.guid<\/th>
\n\t<\/tr>
\n\t<?php foreach($Categories as $item) : ?>
\n\t<tr>
\n\t\t<td><?php echo $item[‘Post’][‘ID’]; ?>
\n\t\t<td><?php echo $item[‘Post’][‘post_title’]; ?>
\n\t\t<td><?php echo $item[‘Post’][‘post_date’]; ?>
\n\t\t<td><?php echo $item[‘Post’][‘guid’]; ?>
\n\t<\/tr>
\n\t<?php endforeach ; ?>
\n<\/table>
\n[\/code]<\/p>\n\u306a\u611f\u3058\u3067\u3001Post \u30e2\u30c7\u30eb\u304b\u3089\u60c5\u5831\u3092\u53d6\u3063\u3066\u304d\u307e\u3059\u3002\u30ab\u30c6\u30b4\u30ea\u306e\u30b9\u30e9\u30c3\u30b0(\u540d\u524d)\u3068\u65e5\u672c\u8a9e\u540d\u79f0\u306f\u3001$ViewData \u3068\u3044\u3046\u5909\u6570\u306b\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n
\u25a0\u307e\u305a\u306f\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u30af\u30a8\u30ea\u3067\u66f8\u3044\u3066\u3057\u307e\u3046\u3002<\/p>\n
\u9762\u5012\u306a\u306e\u3067\u3001Category::findPosts \u30e1\u30bd\u30c3\u30c9\u306e\u4e2d\u8eab\u3092\u30af\u30a8\u30ea\u3067\u66f8\u3044\u3066\u3057\u307e\u3063\u305f\u306e\u304c\u3053\u308c\u3067\u3059\u3002<\/p>\n
[code lang=”php”]
\n<!– models\/category.php –>
\n<?php
\nclass Category extends AppModel
\n{
\n\tvar $name = ‘Category’;
\n\tvar $useTable = false ;
\n\tfunction findCategories() {
\n\t\tif (0) {
\n\t\t$TermTaxonomy = ClassRegistry::init(‘TermTaxonomy’);
\n\t\t$items = $TermTaxonomy->find(‘all’,array(
\n\t\t\t‘conditions’=>"taxonomy = ‘category’"));
\n\t\treturn $items ;
\n\t\t} else {
\n\t\t$Term = ClassRegistry::init(‘Term’);
\n\t\t$items = $Term->find(‘all’, array(
\n\t\t\t‘conditions’=>"TermTaxonomy.taxonomy = ‘category’"));
\n\t\treturn $items ;
\n\t\t}
\n\t}<\/p>\n\t\/\/ \u30ab\u30c6\u30b4\u30ea\u5185\u306e\u8a18\u4e8b\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b
\n\tfunction findPosts($slug,$max=10) {
\n\tif(0) {<\/p>\n\t\t$sql = <<< HERE
\nselect *
\nfrom wp_term_taxonomy as TermTaxonomy
\n inner join wp_term_relationships as TermRelationship
\n on TermTaxonomy.term_taxonomy_id = TermRelationship.term_taxonomy_id
\n inner join wp_terms as Term
\n on ( Term.term_id = TermTaxonomy.term_id )
\n inner join wp_posts as Post
\n on ( TermRelationship.object_id = Post.ID )
\n where TermTaxonomy.taxonomy = ‘category’
\n and Term.slug = ‘$slug’
\n order by Post.post_date desc
\n limit $max
\n ;
\nHERE;
\n\treturn $this->query($sql);
\n\t} else {
\n\t\t$Post = ClassRegistry::init(‘Post’);
\n\t\t$items = $Post->find(‘all’,array(
\n\t\t\t‘conditions’=>"TermTaxonomy.taxonomy = ‘category’"));
\n\t\treturn $items ;
\n\t}<\/p>\n\t}<\/p>\n
\tfunction getCategoryName($slug) {
\n\t\t$Term = ClassRegistry::init(‘Term’);
\n\t\t$item = $Term->find(‘first’,array(
\n\t\t\t‘conditions’=>"slug = ‘$slug’"));
\n\t\treturn $item[‘Term’][‘name’];
\n\t}
\n}
\n?>
\n[\/code]<\/p>\n\u3053\u308c\u3067\u3082\u7528\u306f\u8db3\u308a\u308b\u306e\u3067\u3059\u304c\u3001\u30d7\u30ec\u30d5\u30a3\u30af\u30b9\u300cwp_\u300d\u304c\u3001\u305d\u306e\u307e\u307e\u51fa\u3066\u304d\u3066\u3057\u307e\u3046\u306e\u3067\u96e3\u70b9\u304c\u591a\u3044\u3067\u3059\u3088\u306d\u3002\u305f\u3060\u3001\u8907\u96d1\u306a\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\uff08\u5916\u90e8\u30ad\u30fc\uff09\u3067\u60a9\u3080\u3088\u308a\u306f\u3001\u3053\u306e\u307b\u3046\u304c\u5b89\u5168\u3060\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
![](\"http:\/\/www.moonmile.net\/blog\/wp-content\/uploads\/2011\/02\/wpid-dworkblogimage20110201_08thum3.jpg\")
<\/a><\/p>\n\u25a0\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u3067\u8a2d\u5b9a\u3057\u3066\u307f\u308b\u3002<\/p>\n
\u304c\u3001CakePHP \u306a\u306e\u3067\u30a2\u30bd\u30b7\u30a8\u30fc\u30b7\u30e7\u30f3\u3067\u9811\u5f35\u3063\u3066\u307f\u3088\u3046\u3068\u30e2\u30c7\u30eb\u3092\u4f5c\u308a\u307e\u3059\u3002\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u30014 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u9023\u643a\u3055\u305b\u3066\u52d5\u304b\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093…\u679c\u305f\u3057\u3066\u52d5\u304f\u306e\u304b\u52d5\u304b\u306a\u3044\u306e\u304b\u5206\u304b\u3089\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u4e00\u5fdc\u3001\u30bd\u30fc\u30b9\u3092\u6652\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n
TermRelationship \u30e2\u30c7\u30eb\u30af\u30e9\u30b9\u306f\u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u30922\u3064\u6301\u3064\u306e\u3067\u3001$primaryKey \u306b\u5bfe\u3057\u3066 array \u3067\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u3053\u308c\u3067\u3044\u3044\u3093\u3067\u3057\u3087\u3046\u304b\u306d\u3047\uff1f<\/p>\n
[code lang=”php”]
\n<!– models\/term_relationship.php –>
\n<?php
\nclass TermRelationship extends AppModel
\n{
\n\tvar $name = ‘TermRelationship’;
\n\tvar $primaryKey = array(‘object_id’,’term_taxonomy_id’);
\n\tvar $belongsTo = array(
\n\t\t‘TermTaxonomy’ => array(
\n\t\t\t‘className’ => ‘TermTaxonomy’,
\n\t\t\t‘conditions’ => ‘TermTaxonomy.term_taxonomy_id = TermRelationship.term_taxonomy_id’));
\n\tvar $hasOne = array(
\n\t\t‘Post’ => array(
\n\t\t\t‘className’ => ‘Post’,
\n\t\t\t‘conditions’ => ‘Post.ID = TermRelationship.object_id’));
\n}
\n?>
\n[\/code]<\/p>\nPost \u30e2\u30c7\u30eb\u306b\u5bfe\u3057\u3066\u306f\u3001Model::$hasOne \u3092\u4f7f\u3044\u3001TermTaxonomy \u30e2\u30c7\u30eb\u306b\u5bfe\u3057\u3066\u306f Model::$belongsTo \u306a\u3093\u3067\u3059\u304c\u3002
\nPost \u30e2\u30c7\u30eb\u306b\u95a2\u3057\u3066\u306f\u3001TermRelationship \u3078\u306e\u9023\u643a\u3092 Model::$hasOne \u3067\u6307\u5b9a\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n[code lang=”php”]
\n<!– models\/post.php –>
\n<?php
\nclass Post extends AppModel
\n{
\n\tvar $name = ‘Post’;<\/p>\n\tvar $belongsTo = array(
\n\t ‘User’ => array(
\n\t\t\t‘className’ => ‘User’,
\n\t\t\t‘foreignKey’ => ‘post_author’ ));
\n\tvar $hasOne = array(
\n\t\t‘TermRelationship’ => array(
\n\t\t\t‘className’ => ‘TermRelationship’,
\n\t\t\t‘foreignKey’ => ‘object_id’));
\n}
\n[\/code]<\/p>\n\u3053\u308c\u3092\u6709\u52b9\u306b\u3057\u3066\u3001Category::findPosts \u30e1\u30bd\u30c3\u30c9\u3092\u66f8\u304d\u63db\u3048\u307e\u3059\u3002<\/p>\n
[code lang=”php”]
\n\t\/\/ \u30ab\u30c6\u30b4\u30ea\u5185\u306e\u8a18\u4e8b\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b
\n\tfunction findPosts($slug,$max=10) {
\n\t\t$TermTaxonomy = ClassRegistry::init(‘TermTaxonomy’);
\n\t\t$items = $TermTaxonomy->find(‘all’,array(
\n\t\t\t‘conditions’=> array(
\n\t\t\t\t‘TermTaxonomy.taxonomy’ => ‘category’,
\n\t\t\t\t‘Post.post_status’ => ‘publish’ )));
\n\t\treturn $items ;
\n\t}
\n[\/code]<\/p>\n\u3053\u308c\u3092\u52d5\u304b\u3057\u3066\u307f\u308b\u306e\u3067\u3059\u304c\u3001SQL\u6587\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u3059\u3002<\/p>\n
[code lang=”sql”]
\nSELECT
\n `TermTaxonomy`.`term_taxonomy_id`,
\n `TermTaxonomy`.`term_id`,
\n `TermTaxonomy`.`taxonomy`,
\n `TermTaxonomy`.`description`,
\n `TermTaxonomy`.`parent`,
\n `TermTaxonomy`.`count`,
\n `Post`.`ID`,
\n `Post`.`post_author`,
\n `Post`.`post_date`,
\n `Post`.`post_date_gmt`,
\n `Post`.`post_content`,
\n `Post`.`post_title`,
\n `Post`.`post_excerpt`,
\n `Post`.`post_status`,
\n `Post`.`comment_status`,
\n `Post`.`ping_status`,
\n `Post`.`post_password`,
\n `Post`.`post_name`,
\n `Post`.`to_ping`,
\n `Post`.`pinged`,
\n `Post`.`post_modified`,
\n `Post`.`post_modified_gmt`,
\n `Post`.`post_content_filtered`,
\n `Post`.`post_parent`,
\n `Post`.`guid`,
\n `Post`.`menu_order`,
\n `Post`.`post_type`,
\n `Post`.`post_mime_type`,
\n `Post`.`comment_count`,
\n `Term`.`term_id`,
\n `Term`.`name`,
\n `Term`.`slug`,
\n `Term`.`term_group`
\nFROM
\n `wp_term_taxonomy` AS `TermTaxonomy`
\n LEFT JOIN `wp_posts` AS `Post`
\n ON (`TermRelationship`.`object_id` = `Post`.`ID` AND `TermTaxonomy`.`post_id` = `Post`.`id`)
\n LEFT JOIN `wp_terms` AS `Term`
\n ON (`Term`.`term_id` = `TermTaxonomy`.`term_taxonomy_id`)
\nWHERE
\n `TermTaxonomy`.`taxonomy` = ‘category’
\nAND `Post`.`post_status` = ‘publish’
\n[\/code]<\/p>\n`TermRelationship`.`object_id` \u304c\u7121\u3044\u3068\u306e\u3053\u3068\u306a\u306e\u3067\u3001TermRelationship \u306e\u5b9a\u7fa9\u304c\u60aa\u3044\u306e\u3067\u3059\u304c\u3001\u3061\u3087\u3063\u3068\u3088\u304f\u308f\u304b\u308a\u307e\u305b\u3093\u3002TermRelationship \u30e2\u30c7\u30eb\u81ea\u4f53\u306f\u3001\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u304c object_id \u3068 term_taxonomy_id \u306e 2 \u3064\u306b\u306a\u308b\u306e\u3067\u3001\u3053\u308c\u304c\u539f\u56e0\u3067\u3057\u3087\u3046\u3002<\/p>\n
\u5f8c\u3067\u3082\u3046\u5c11\u3057\u8abf\u3079\u3066\u307f\u307e\u3059\u304c\u3001\u3053\u306e\u624b\u306e\u8907\u96d1\u306a\u30c6\u30fc\u30d6\u30eb\u306e\u5834\u5408\u306f\u30af\u30a8\u30ea\u6587\u304c\u697d\u304b\u306a\u3068\u601d\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u307e\u3042\u3001\u4f5c\u696d\u91cf\u3092\u8003\u3048\u308b\u3068\u3001CakePHP \u306b\u6e96\u62e0\u3057\u3066\u306a\u3044\u30c6\u30fc\u30d6\u30eb\u3092\u6271\u3046\u6642\u306f(wordpress \u306f\u3001\u6e96\u62e0\u3057\u3066\u3044\u308b\u3068\u601d\u3046\u306e\u3060\u3051\u3069)\u30af\u30a8\u30ea\u306e\u307b\u3046\u304c\u4f5c\u6210\u304c\u901f\u3044\u3063\u3066\u306e\u304c\u3042\u308a\u307e\u3059\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4eca\u5ea6\u306f wordpress \u306e\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7\u3001\u3068\u6307\u5b9a\u3057\u305f\u30ab\u30c6\u30b4\u30ea\u5185\u306e\u8a18\u4e8b\u3092\u62fe\u3063\u3066\u307f\u307e\u3059\u3002 wordpress \u306f\u30ab\u30c6\u30b4\u30ea\u306e\u6271\u3044\u304c\u3084\u3084\u3053\u3057\u304f\u3066\u3001\u30ab\u30c6\u30b4\u30ea\u306e\u540d\u524d\u81ea\u4f53\u306f wp_terms \u306b\u5165\u3063\u3066\u3044\u308b\u306e\u3067\u3059\u304c…\u305d\u306e\u5f8c … \u7d9a\u304d\u3092\u8aad\u3080