Archive for December, 2011

Links 鏈接

catsort = catId
MySQL server version: 5.0.95-community-log
CATEGORY QUERY: 
 SELECT wp5_term_taxonomy.count as 'count',
    wp5_terms.term_id, wp5_terms.name, wp5_terms.slug,
    wp5_term_taxonomy.parent, wp5_term_taxonomy.description FROM
    wp5_terms, wp5_term_taxonomy WHERE wp5_terms.term_id =
    wp5_term_taxonomy.term_id  AND
    wp5_term_taxonomy.taxonomy = 'link_category' 
    ORDER BY wp5_terms.term_id DESC

CATEGORY QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [count] => 5
            [term_id] => 24
            [name] => Internal Links
            [slug] => internal-links
            [parent] => 0
            [description] => 內联 Internal Links
        )

    [1] => stdClass Object
        (
            [count] => 8
            [term_id] => 2
            [name] => External Links
            [slug] => links2other-sites
            [parent] => 0
            [description] => 外聯 External Links
        )

)
LINK QUERY:
 SELECT * FROM wp5_links l
      inner join wp5_term_relationships tr on l.link_id = tr.object_id
      inner join wp5_term_taxonomy tt on 
      tt.term_taxonomy_id = tr.term_taxonomy_id 
      inner join wp5_terms t on t.term_id = tt.term_id 
      WHERE tt.taxonomy='link_category' AND l.link_visible='Y' 
      ORDER BY l.link_rating DESC

LINK QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [link_id] => 8
            [link_url] => http://theologos.net/ebooks
            [link_name] => eBookstore 網絡書店
            [link_image] => 
            [link_target] => _blank
            [link_description] => This is our own online ebook store where you can find all ebooks we publish. 這是我們自己的網絡書店。
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 10
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 8
            [term_taxonomy_id] => 24
            [term_order] => 0
            [term_id] => 24
            [taxonomy] => link_category
            [description] => 內联 Internal Links
            [parent] => 0
            [count] => 5
            [name] => Internal Links
            [slug] => internal-links
            [term_group] => 0
        )

    [1] => stdClass Object
        (
            [link_id] => 17
            [link_url] => http://1459919.info
            [link_name] => Number Our Days 數算自己的日子
            [link_image] => 
            [link_target] => _blank
            [link_description] => Short articles related to End Times books 六本末日信息叢書讀後心得、真實見證和更新探解
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 2
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 17
            [term_taxonomy_id] => 24
            [term_order] => 0
            [term_id] => 24
            [taxonomy] => link_category
            [description] => 內联 Internal Links
            [parent] => 0
            [count] => 5
            [name] => Internal Links
            [slug] => internal-links
            [term_group] => 0
        )

    [2] => stdClass Object
        (
            [link_id] => 9
            [link_url] => http://angelfall.com/map.php?mapexpand=1
            [link_name] => AngelFall.com
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 9
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [3] => stdClass Object
        (
            [link_id] => 10
            [link_url] => http://theomatics.com/
            [link_name] => TheoMatics.com
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 10
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [4] => stdClass Object
        (
            [link_id] => 11
            [link_url] => http://www.biblewheel.com
            [link_name] => BibleWheel.com
            [link_image] => 
            [link_target] => _blank
            [link_description] => The Bible Wheel is a view of the Bible that displays its sixty-six books as a circular matrix of three wheels within a wheel. The increase from the traditional one-dimensional list of books to the two-dimensional Bible Wheel reveals otherwise hidden patte
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 11
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [5] => stdClass Object
        (
            [link_id] => 12
            [link_url] => http://www.biblewheel.com/GR/GR_Identities.asp
            [link_name] => Hebrew/Greek Bible Gematria
            [link_image] => 
            [link_target] => _blank
            [link_description] => This tool will allow you to analyse the alphanumeric structure of every verse of the Holy Bible. It displays the numerical equivalent of every word of the Old and New Testaments and automatically calculates the sum of any combination of words in the origi
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 12
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [6] => stdClass Object
        (
            [link_id] => 13
            [link_url] => http://voiceofelijah.org/reading.html
            [link_name] => Voice of Elijah
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 13
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [7] => stdClass Object
        (
            [link_id] => 14
            [link_url] => http://www.concordant.org/
            [link_name] => Concordant Publishing Concern
            [link_image] => 
            [link_target] => _blank
            [link_description] => The Concordant Publishing Concern is a nondenominational, nonprofit association founded in 1909 for the purpose of disseminating the facts and truths of the ancient manuscripts of the Scriptures.
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 14
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [8] => stdClass Object
        (
            [link_id] => 15
            [link_url] => http://interlinearbible.org/genesis/1-1.htm
            [link_name] => Hebrew/Greek Interlinear Bible
            [link_image] => 
            [link_target] => _blank
            [link_description] => Hebrew Text: Westminster Leningrad Codex; Greek Text Based on the Westcott-Hort Edition of 1881
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 15
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [9] => stdClass Object
        (
            [link_id] => 16
            [link_url] => http://springbible.fhl.net/Bible2/cgic201/index.html
            [link_name] => 聖經查詢閱讀系統
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 16
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 8
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [10] => stdClass Object
        (
            [link_id] => 19
            [link_url] => https://plus.google.com/b/108491637909231098487/
            [link_name] => Our Google+ Page
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 19
            [term_taxonomy_id] => 24
            [term_order] => 0
            [term_id] => 24
            [taxonomy] => link_category
            [description] => 內联 Internal Links
            [parent] => 0
            [count] => 5
            [name] => Internal Links
            [slug] => internal-links
            [term_group] => 0
        )

    [11] => stdClass Object
        (
            [link_id] => 21
            [link_url] => http://rockoftruthministry.org/
            [link_name] => Rock of Ages Ministry
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 21
            [term_taxonomy_id] => 24
            [term_order] => 0
            [term_id] => 24
            [taxonomy] => link_category
            [description] => 內联 Internal Links
            [parent] => 0
            [count] => 5
            [name] => Internal Links
            [slug] => internal-links
            [term_group] => 0
        )

    [12] => stdClass Object
        (
            [link_id] => 22
            [link_url] => http://therockministry.org/
            [link_name] => 永久磐石真理事工
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 0
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 22
            [term_taxonomy_id] => 24
            [term_order] => 0
            [term_id] => 24
            [taxonomy] => link_category
            [description] => 內联 Internal Links
            [parent] => 0
            [count] => 5
            [name] => Internal Links
            [slug] => internal-links
            [term_group] => 0
        )

)

collapsLink options:

• ▼內联 Internal Links (5)
  • eBookstore 網絡書店
  • Number Our Days 數算自己的日子
  • Our Google+ Page
  • Rock of Ages Ministry
  • 永久磐石真理事工
• ► 外聯 External Links (8)
  • AngelFall.com
  • TheoMatics.com
  • BibleWheel.com
  • Hebrew/Greek Bible Gematria
  • Voice of Elijah
  • Concordant Publishing Concern
  • Hebrew/Greek Interlinear Bible
  • 聖經查詢閱讀系統