MENU

catsort = catName
MySQL server version: 5.0.67.d7-ourdelta-log
CATEGORY QUERY: 
 SELECT wp_term_taxonomy.count as 'count',
    wp_terms.term_id, wp_terms.name, wp_terms.slug,
    wp_term_taxonomy.parent, wp_term_taxonomy.description FROM
    wp_terms, wp_term_taxonomy WHERE wp_terms.term_id =
    wp_term_taxonomy.term_id  AND
    wp_term_taxonomy.taxonomy = 'link_category' 
    ORDER BY wp_terms.name ASC

CATEGORY QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [count] => 1
            [term_id] => 6
            [name] => Car rental
            [slug] => car-rental
            [parent] => 0
            [description] => 
        )

    [1] => stdClass Object
        (
            [count] => 1
            [term_id] => 9
            [name] => Contact Us
            [slug] => contact-us
            [parent] => 0
            [description] => 
        )

    [2] => stdClass Object
        (
            [count] => 3
            [term_id] => 3
            [name] => Flights
            [slug] => flights
            [parent] => 0
            [description] => 
        )

    [3] => stdClass Object
        (
            [count] => 10
            [term_id] => 5
            [name] => Lodging
            [slug] => lodging
            [parent] => 0
            [description] => 
        )

    [4] => stdClass Object
        (
            [count] => 4
            [term_id] => 2
            [name] => Manuel Antonio
            [slug] => manuel-antonio
            [parent] => 0
            [description] => 
        )

    [5] => stdClass Object
        (
            [count] => 0
            [term_id] => 7
            [name] => Packages CR
            [slug] => packages-cr
            [parent] => 0
            [description] => 
        )

    [6] => stdClass Object
        (
            [count] => 1
            [term_id] => 11
            [name] => Partners
            [slug] => partners
            [parent] => 0
            [description] => 
        )

    [7] => stdClass Object
        (
            [count] => 1
            [term_id] => 8
            [name] => Special Offers
            [slug] => special-offers
            [parent] => 0
            [description] => 
        )

    [8] => stdClass Object
        (
            [count] => 2
            [term_id] => 4
            [name] => Transportation
            [slug] => transportation
            [parent] => 0
            [description] => 
        )

)
LINK QUERY:
 SELECT * FROM wp_links l
      inner join wp_term_relationships tr on l.link_id = tr.object_id
      inner join wp_term_taxonomy tt on 
      tt.term_taxonomy_id = tr.term_taxonomy_id 
      inner join wp_terms t on t.term_id = tt.term_id 
      WHERE tt.taxonomy='link_category' AND l.link_visible='Y' 
      ORDER BY l.link_rating ASC

LINK QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [link_id] => 27
            [link_url] => http://lynchtravel.com/packages-costa-rica.html
            [link_name] => Packages CR
            [link_image] => 
            [link_target] => 
            [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] => 27
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 4
            [name] => Manuel Antonio
            [slug] => manuel-antonio
            [term_group] => 0
        )

    [1] => stdClass Object
        (
            [link_id] => 35
            [link_url] => http://lynchtravel.com/partners.html
            [link_name] => Partners
            [link_image] => 
            [link_target] => 
            [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] => 35
            [term_taxonomy_id] => 11
            [term_order] => 0
            [term_id] => 11
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 1
            [name] => Partners
            [slug] => partners
            [term_group] => 0
        )

    [2] => stdClass Object
        (
            [link_id] => 34
            [link_url] => http://lynchtravel.com/special-offers.html
            [link_name] => Special Offers
            [link_image] => 
            [link_target] => 
            [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] => 34
            [term_taxonomy_id] => 8
            [term_order] => 0
            [term_id] => 8
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 1
            [name] => Special Offers
            [slug] => special-offers
            [term_group] => 0
        )

    [3] => stdClass Object
        (
            [link_id] => 14
            [link_url] => http://lynchtravel.com/interbus.html
            [link_name] => Interbus
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 1
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 14
            [term_taxonomy_id] => 4
            [term_order] => 0
            [term_id] => 4
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Transportation
            [slug] => transportation
            [term_group] => 0
        )

    [4] => stdClass Object
        (
            [link_id] => 11
            [link_url] => http://lynchtravel.com/sansa.html
            [link_name] => Sansa
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 1
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 11
            [term_taxonomy_id] => 3
            [term_order] => 0
            [term_id] => 3
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => Flights
            [slug] => flights
            [term_group] => 0
        )

    [5] => stdClass Object
        (
            [link_id] => 8
            [link_url] => http://lynchtravel.com/hotels.html
            [link_name] => Hotels
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 1
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 8
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 4
            [name] => Manuel Antonio
            [slug] => manuel-antonio
            [term_group] => 0
        )

    [6] => stdClass Object
        (
            [link_id] => 16
            [link_url] => http://lynchtravel.com/san-jose.html
            [link_name] => San José
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 1
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 16
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [7] => stdClass Object
        (
            [link_id] => 15
            [link_url] => http://lynchtravel.com/transfer.html
            [link_name] => Transfer
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [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] => 15
            [term_taxonomy_id] => 4
            [term_order] => 0
            [term_id] => 4
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 2
            [name] => Transportation
            [slug] => transportation
            [term_group] => 0
        )

    [8] => stdClass Object
        (
            [link_id] => 12
            [link_url] => http://lynchtravel.com/nature-air.html
            [link_name] => Nature Air
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [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] => 12
            [term_taxonomy_id] => 3
            [term_order] => 0
            [term_id] => 3
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => Flights
            [slug] => flights
            [term_group] => 0
        )

    [9] => stdClass Object
        (
            [link_id] => 9
            [link_url] => http://lynchtravel.com/villas.html
            [link_name] => Villas
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [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] => 9
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 4
            [name] => Manuel Antonio
            [slug] => manuel-antonio
            [term_group] => 0
        )

    [10] => stdClass Object
        (
            [link_id] => 17
            [link_url] => http://lynchtravel.com/liberia.html
            [link_name] => Liberia
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [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] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [11] => stdClass Object
        (
            [link_id] => 13
            [link_url] => http://lynchtravel.com/charter.html
            [link_name] => Charter
            [link_image] => 
            [link_target] => 
            [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] => 13
            [term_taxonomy_id] => 3
            [term_order] => 0
            [term_id] => 3
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 3
            [name] => Flights
            [slug] => flights
            [term_group] => 0
        )

    [12] => stdClass Object
        (
            [link_id] => 10
            [link_url] => http://lynchtravel.com/tours.html
            [link_name] => Tours
            [link_image] => 
            [link_target] => 
            [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] => 10
            [term_taxonomy_id] => 2
            [term_order] => 0
            [term_id] => 2
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 4
            [name] => Manuel Antonio
            [slug] => manuel-antonio
            [term_group] => 0
        )

    [13] => stdClass Object
        (
            [link_id] => 18
            [link_url] => http://lynchtravel.com/arenal.html
            [link_name] => Arenal
            [link_image] => 
            [link_target] => 
            [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] => 18
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [14] => stdClass Object
        (
            [link_id] => 19
            [link_url] => http://lynchtravel.com/monteverde.html
            [link_name] => Monteverde
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 4
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 19
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [15] => stdClass Object
        (
            [link_id] => 20
            [link_url] => http://lynchtravel.com/corcovado.html
            [link_name] => Corcovado
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 5
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 20
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [16] => stdClass Object
        (
            [link_id] => 21
            [link_url] => http://lynchtravel.com/uvita.html
            [link_name] => Uvita
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 6
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 21
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [17] => stdClass Object
        (
            [link_id] => 22
            [link_url] => http://lynchtravel.com/tamarindo.html
            [link_name] => Tamarindo
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 6
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 22
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [18] => stdClass Object
        (
            [link_id] => 23
            [link_url] => http://lynchtravel.com/montezuma.html
            [link_name] => Montezuma
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 7
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 23
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [19] => stdClass Object
        (
            [link_id] => 24
            [link_url] => http://lynchtravel.com/tortuguero.html
            [link_name] => Tortuguero
            [link_image] => 
            [link_target] => 
            [link_description] => 
            [link_visible] => Y
            [link_owner] => 1
            [link_rating] => 8
            [link_updated] => 0000-00-00 00:00:00
            [link_rel] => 
            [link_notes] => 
            [link_rss] => 
            [object_id] => 24
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [20] => stdClass Object
        (
            [link_id] => 25
            [link_url] => http://lynchtravel.com/samara.html
            [link_name] => Samara
            [link_image] => 
            [link_target] => 
            [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] => 25
            [term_taxonomy_id] => 5
            [term_order] => 0
            [term_id] => 5
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 10
            [name] => Lodging
            [slug] => lodging
            [term_group] => 0
        )

    [21] => stdClass Object
        (
            [link_id] => 26
            [link_url] => http://lynchtravel.com/car-rental.html
            [link_name] => Car Rental
            [link_image] => 
            [link_target] => 
            [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] => 26
            [term_taxonomy_id] => 6
            [term_order] => 0
            [term_id] => 6
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 1
            [name] => Car rental
            [slug] => car-rental
            [term_group] => 0
        )

    [22] => stdClass Object
        (
            [link_id] => 33
            [link_url] => http://lynchtravel.com/contact-us.html
            [link_name] => Contact Us
            [link_image] => 
            [link_target] => 
            [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] => 33
            [term_taxonomy_id] => 9
            [term_order] => 0
            [term_id] => 9
            [taxonomy] => link_category
            [description] => 
            [parent] => 0
            [count] => 1
            [name] => Contact Us
            [slug] => contact-us
            [term_group] => 0
        )

)

collapsLink options:

• ► Car rental
  • Car Rental
• ► Contact Us
  • Contact Us
• ► Flights
  • Sansa
  • Nature Air
  • Charter
• ► Lodging
  • San José
  • Liberia
  • Arenal
  • Monteverde
  • Corcovado
  • Uvita
  • Tamarindo
  • Montezuma
  • Tortuguero
  • Samara
• ► Manuel Antonio
  • Packages CR
  • Hotels
  • Villas
  • Tours
• ► Partners
  • Partners
• ► Special Offers
  • Special Offers
• ► Transportation
  • Interbus
  • Transfer