Posts Tagged Revelation

Links 鏈接

catsort = catId
MySQL server version: 5.1.68-cll
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] => 10
            [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] => Our Bookstore 網絡書店
            [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] => 23
            [link_url] => https://www.amazon.com/author/taichuantongs
            [link_name] => Amazon author page for Taichuan Tongs
            [link_image] => 
            [link_target] => _blank
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 9
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 23
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 外聯 External Links
            [parent] => 0
            [count] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

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

    [3] => stdClass Object
        (
            [link_id] => 17
            [link_url] => http://1459919.net
            [link_name] => Reader Feedbacks 讀者回應
            [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
        )

    [4] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [5] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [6] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [7] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [8] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [9] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [10] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [term_group] => 0
        )

    [11] => 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] => 10
            [name] => External Links
            [slug] => links2other-sites
            [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
        )

    [13] => stdClass Object
        (
            [link_id] => 21
            [link_url] => http://rockoftruthministry.org/
            [link_name] => Excerpts from End Time Series
            [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
        )

    [14] => stdClass Object
        (
            [link_id] => 19
            [link_url] => https://plus.google.com/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
        )

)

collapsLink options:

• ▼內联 Internal Links (5)
  • Our Bookstore 網絡書店
  • Reader Feedbacks 讀者回應
  • 中文末日信息叢書選摘
  • Excerpts from End Time Series
  • Our Google+ Page
• ► 外聯 External Links (10)
  • Amazon author page for Taichuan Tongs
  • BibleCodes.ca
  • AngelFall.com
  • TheoMatics.com
  • BibleWheel.com
  • Voice of Elijah
  • 聖經查詢閱讀系統
  • Hebrew/Greek Interlinear Bible
  • Hebrew/Greek Bible Gematria
  • Concordant Publishing Concern