Apple Valley-Rosemount
Burnsville-Eagan
Farmington-Lakeville
Dakota County Tribune
catsort = catName
MySQL server version: 5.0.77
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] => 0
[term_id] => 2
[name] => Blogroll
[slug] => blogroll
[parent] => 0
[description] =>
)
[1] => stdClass Object
(
[count] => 6
[term_id] => 8
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[parent] => 0
[description] =>
)
[2] => stdClass Object
(
[count] => 0
[term_id] => 6
[name] => Charter Schools
[slug] => charter-schools
[parent] => 0
[description] =>
)
[3] => stdClass Object
(
[count] => 7
[term_id] => 3
[name] => Cities
[slug] => cities
[parent] => 0
[description] =>
)
[4] => stdClass Object
(
[count] => 5
[term_id] => 9
[name] => Community Events
[slug] => community-events
[parent] => 0
[description] =>
)
[5] => stdClass Object
(
[count] => 3
[term_id] => 39
[name] => Community Guides
[slug] => community-guides
[parent] => 0
[description] =>
)
[6] => stdClass Object
(
[count] => 4
[term_id] => 5
[name] => Counties
[slug] => counties
[parent] => 0
[description] =>
)
[7] => stdClass Object
(
[count] => 4
[term_id] => 7
[name] => School Districts
[slug] => school-districts
[parent] => 0
[description] =>
)
[8] => stdClass Object
(
[count] => 3
[term_id] => 4
[name] => State
[slug] => state
[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_name ASC
LINK QUERY RESULTS
Array
(
[0] => stdClass Object
(
[link_id] => 13
[link_url] => http://www.avmnchamber.org/
[link_name] => Apple Valley Chamber of Commerce
[link_image] =>
[link_target] => _blank
[link_description] => Apple Valley Chamber of Commerce
[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] => 8
[term_order] => 0
[term_id] => 8
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 6
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[term_group] => 0
)
[1] => stdClass Object
(
[link_id] => 9
[link_url] => http://www.avfreedomdays.com/
[link_name] => Apple Valley Freedom Days
[link_image] =>
[link_target] => _blank
[link_description] => Apple Valley Freedom Days
[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] => 9
[term_order] => 0
[term_id] => 9
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 5
[name] => Community Events
[slug] => community-events
[term_group] => 0
)
[2] => stdClass Object
(
[link_id] => 36
[link_url] => http://www.thisweeklive.com/community-guide-apple-valley-rosemount/
[link_name] => Apple Valley/Rosemount
[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] => 36
[term_taxonomy_id] => 41
[term_order] => 0
[term_id] => 39
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => Community Guides
[slug] => community-guides
[term_group] => 0
)
[3] => stdClass Object
(
[link_id] => 14
[link_url] => http://www.burnsvillechamber.com/
[link_name] => Burnsville Chamber of Commmerce
[link_image] =>
[link_target] => _blank
[link_description] => Burnsville Chamber of Commmerce
[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] => 8
[term_order] => 0
[term_id] => 8
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 6
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[term_group] => 0
)
[4] => stdClass Object
(
[link_id] => 10
[link_url] => http://www.burnsvillefiremuster.com
[link_name] => Burnsville Firemuster
[link_image] =>
[link_target] => _blank
[link_description] => Burnsville Firemuster
[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] => 9
[term_order] => 0
[term_id] => 9
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 5
[name] => Community Events
[slug] => community-events
[term_group] => 0
)
[5] => stdClass Object
(
[link_id] => 38
[link_url] => http://thisweeklive.com/community-guide-burnsville-eagan
[link_name] => Burnsville/Eagan
[link_image] =>
[link_target] =>
[link_description] => Community Guide: Burnsville/Eagan
[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] => 38
[term_taxonomy_id] => 41
[term_order] => 0
[term_id] => 39
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => Community Guides
[slug] => community-guides
[term_group] => 0
)
[6] => stdClass Object
(
[link_id] => 18
[link_url] => http://www.ci.apple-valley.mn.us/
[link_name] => City of Apple Valley
[link_image] =>
[link_target] => _blank
[link_description] => City of Apple Valley
[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] => 18
[term_taxonomy_id] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[7] => stdClass Object
(
[link_id] => 19
[link_url] => http://www.ci.burnsville.mn.us/
[link_name] => City of Burnsville
[link_image] =>
[link_target] => _blank
[link_description] => City of Burnsville
[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] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[8] => stdClass Object
(
[link_id] => 20
[link_url] => http://www.ci.eagan.mn.us/
[link_name] => City of Eagan
[link_image] =>
[link_target] => _blank
[link_description] => City of Eagan
[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] => 20
[term_taxonomy_id] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[9] => stdClass Object
(
[link_id] => 21
[link_url] => http://www.ci.farmington.mn.us/
[link_name] => City of Farmington
[link_image] =>
[link_target] => _blank
[link_description] => City of Farmington
[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] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[10] => stdClass Object
(
[link_id] => 22
[link_url] => http://www.ci.lakeville.mn.us/
[link_name] => City of Lakeville
[link_image] =>
[link_target] => _blank
[link_description] => City of Lakeville
[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] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[11] => stdClass Object
(
[link_id] => 23
[link_url] => http://www.ci.rosemount.mn.us/
[link_name] => City of Rosemount
[link_image] =>
[link_target] => _blank
[link_description] => City of Rosemount
[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] => 23
[term_taxonomy_id] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[12] => stdClass Object
(
[link_id] => 24
[link_url] => http://www.cityofsavage.com
[link_name] => City of Savage
[link_image] =>
[link_target] => _blank
[link_description] => City of Savage
[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] => 24
[term_taxonomy_id] => 3
[term_order] => 0
[term_id] => 3
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 7
[name] => Cities
[slug] => cities
[term_group] => 0
)
[13] => stdClass Object
(
[link_id] => 25
[link_url] => http://www.co.dakota.mn.us/
[link_name] => Dakota County
[link_image] =>
[link_target] => _blank
[link_description] => Dakota County
[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] => 25
[term_taxonomy_id] => 5
[term_order] => 0
[term_id] => 5
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => Counties
[slug] => counties
[term_group] => 0
)
[14] => stdClass Object
(
[link_id] => 11
[link_url] => http://www.dakotacountyfair.org
[link_name] => Dakota County Fair
[link_image] =>
[link_target] => _blank
[link_description] => Dakota County Fair
[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] => 9
[term_order] => 0
[term_id] => 9
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 5
[name] => Community Events
[slug] => community-events
[term_group] => 0
)
[15] => stdClass Object
(
[link_id] => 15
[link_url] => http://dcrchamber.com
[link_name] => Dakota County Regional Chamber of Commerce
[link_image] =>
[link_target] => _blank
[link_description] => Dakota County Regional
[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] => 8
[term_order] => 0
[term_id] => 8
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 6
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[term_group] => 0
)
[16] => stdClass Object
(
[link_id] => 31
[link_url] => http://exploreminnesota.com/
[link_name] => Explore Minnesota
[link_image] =>
[link_target] => _blank
[link_description] => Explore Minnesota - Tourism
[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] => 31
[term_taxonomy_id] => 4
[term_order] => 0
[term_id] => 4
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => State
[slug] => state
[term_group] => 0
)
[17] => stdClass Object
(
[link_id] => 37
[link_url] => http://www.thisweeklive.com/community-guide-farmingtonlakeville/
[link_name] => Farmington/Lakeville
[link_image] =>
[link_target] =>
[link_description] => Community Guide: Farmington/Lakeville
[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] => 37
[term_taxonomy_id] => 41
[term_order] => 0
[term_id] => 39
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => Community Guides
[slug] => community-guides
[term_group] => 0
)
[18] => stdClass Object
(
[link_id] => 26
[link_url] => http://www.co.dakota.mn.us/
[link_name] => Hennepin County
[link_image] =>
[link_target] => _blank
[link_description] => Hennepin County
[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] => 26
[term_taxonomy_id] => 5
[term_order] => 0
[term_id] => 5
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => Counties
[slug] => counties
[term_group] => 0
)
[19] => stdClass Object
(
[link_id] => 32
[link_url] => http://www.isd191.org/
[link_name] => ISD 191 - Burnsville Eagan Savage
[link_image] =>
[link_target] => _blank
[link_description] => ISD 191 - Burnsville Eagan Savage
[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] => 32
[term_taxonomy_id] => 7
[term_order] => 0
[term_id] => 7
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => School Districts
[slug] => school-districts
[term_group] => 0
)
[20] => stdClass Object
(
[link_id] => 33
[link_url] => http://www.farmington.k12.mn.us/
[link_name] => ISD 192 - Farmington
[link_image] =>
[link_target] => _blank
[link_description] => ISD 192 - Farmington
[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] => 33
[term_taxonomy_id] => 7
[term_order] => 0
[term_id] => 7
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => School Districts
[slug] => school-districts
[term_group] => 0
)
[21] => stdClass Object
(
[link_id] => 34
[link_url] => http://www.isd194.k12.mn.us/
[link_name] => ISD 194 - Lakeville
[link_image] =>
[link_target] => _blank
[link_description] => ISD 194 - Lakeville
[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] => 7
[term_order] => 0
[term_id] => 7
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => School Districts
[slug] => school-districts
[term_group] => 0
)
[22] => stdClass Object
(
[link_id] => 35
[link_url] => http://www.district196.org
[link_name] => ISD 196 - Rosemount, Apple Valley, Eagan
[link_image] =>
[link_target] => _blank
[link_description] => ISD 196 - Rosemount, Apple Valley, Eagan
[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] => 7
[term_order] => 0
[term_id] => 7
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => School Districts
[slug] => school-districts
[term_group] => 0
)
[23] => stdClass Object
(
[link_id] => 16
[link_url] => http://www.lakevillechambercvb.org/
[link_name] => Lakeville Chamber of Commerce
[link_image] =>
[link_target] => _blank
[link_description] => Lakeville Chamber of Commerce
[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] => 8
[term_order] => 0
[term_id] => 8
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 6
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[term_group] => 0
)
[24] => stdClass Object
(
[link_id] => 8
[link_url] => http://www.panoprog.org
[link_name] => Lakeville Pan-O-Prog
[link_image] =>
[link_target] => _blank
[link_description] => Lakeville Pan-O-Prog
[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] => 8
[term_taxonomy_id] => 9
[term_order] => 0
[term_id] => 9
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 5
[name] => Community Events
[slug] => community-events
[term_group] => 0
)
[25] => stdClass Object
(
[link_id] => 30
[link_url] => http://www.state.mn.us
[link_name] => Official State of MN Site
[link_image] =>
[link_target] => _blank
[link_description] => Official State of MN Site
[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] => 30
[term_taxonomy_id] => 4
[term_order] => 0
[term_id] => 4
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => State
[slug] => state
[term_group] => 0
)
[26] => stdClass Object
(
[link_id] => 29
[link_url] => http://pollfinder.sos.state.mn.us/
[link_name] => Pollfinder Application - Secretary of State
[link_image] =>
[link_target] => _blank
[link_description] => Pollfinder Application - Secretary of State
[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] => 29
[term_taxonomy_id] => 4
[term_order] => 0
[term_id] => 4
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 3
[name] => State
[slug] => state
[term_group] => 0
)
[27] => stdClass Object
(
[link_id] => 27
[link_url] => http://www.co.ramsey.mn.us/
[link_name] => Ramsey County
[link_image] =>
[link_target] => _blank
[link_description] => Ramsey County
[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] => 5
[term_order] => 0
[term_id] => 5
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => Counties
[slug] => counties
[term_group] => 0
)
[28] => stdClass Object
(
[link_id] => 39
[link_url] => http://www.riverheights.com
[link_name] => River Heights Chamber of Commerce
[link_image] =>
[link_target] => _blank
[link_description] => River Heights Chamber of Commerce
[link_visible] => Y
[link_owner] => 20
[link_rating] => 0
[link_updated] => 0000-00-00 00:00:00
[link_rel] =>
[link_notes] =>
[link_rss] =>
[object_id] => 39
[term_taxonomy_id] => 8
[term_order] => 0
[term_id] => 8
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 6
[name] => Chambers of Commerce
[slug] => chambers-of-commerce
[term_group] => 0
)
[29] => stdClass Object
(
[link_id] => 12
[link_url] => http://www.rosemountevents.com/Leprechaun.html
[link_name] => Rosemount Leprechaun Days
[link_image] =>
[link_target] => _blank
[link_description] => Rosemount Leprechaun Days
[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] => 9
[term_order] => 0
[term_id] => 9
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 5
[name] => Community Events
[slug] => community-events
[term_group] => 0
)
[30] => stdClass Object
(
[link_id] => 28
[link_url] => http://www.co.scott.mn.us/
[link_name] => Scott County
[link_image] =>
[link_target] => _blank
[link_description] => Scott County
[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] => 28
[term_taxonomy_id] => 5
[term_order] => 0
[term_id] => 5
[taxonomy] => link_category
[description] =>
[parent] => 0
[count] => 4
[name] => Counties
[slug] => counties
[term_group] => 0
)
)
collapsLink options:
