!Please ask for our special prices for long term rents and green season
specials!
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
- ► Contact Us
- ► Flights
- ► Lodging
- ► Manuel Antonio
- ► Partners
- ► Special Offers
- ► Transportation
Copyright © 2009 Lynchtravel
Web By Credipaginas
Articulos de Guanacaste - Articulos de Costa Rica - Articulos de Negocios - Articulos de Manuel Antonio
top
Articulos de Guanacaste - Articulos de Costa Rica - Articulos de Negocios - Articulos de Manuel Antonio
top
Comments