Dakota County Tribune Business Weekly February 16, 2012
ThisweekLive February 17, 2012
Dakota County Tribune Business Weekly February 9, 2012
ThisweekLive February 10, 2012
Dakota County Tribune Business Weekly February 2, 2012
Dakota County Tribune Business Weekly January 26, 2012
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:
