Media for social change

SELECT t.term_id, t.name, t.slug, t.term_group, tt.taxonomy, tt.description, tt.term_taxonomy_id, tt.count, cm.blog_id, wb.domain, wb.path FROM wp_1_cat_mapping AS cm LEFT JOIN wp_1_term_taxonomy AS tt ON tt.term_id = cm.top_cat_id LEFT JOIN wp_1_terms AS t ON t.term_id = tt.term_id LEFT JOIN wp_blogs AS wb ON wb.blog_id = cm.blog_id WHERE t.name IS NOT NULLArray ( [Featured] => Array ( [1288405709] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 71 [domain] => citizenshift.org [path] => /blogs/remix-to-rio/ [blogname] => REMIX-TO-RIO [dateLastPost] => 1288405709 ) [1317556804] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 69 [domain] => citizenshift.org [path] => /blogs/mtl-womens-conf/ [blogname] => Montreal International Womens Conference [dateLastPost] => 1317556804 ) [1342115057] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 19 [domain] => citizenshift.org [path] => /blogs/burundi-film-center/ [blogname] => Burundi Film Center [dateLastPost] => 1342115057 ) [1300473663] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 10 [domain] => citizenshift.org [path] => /blogs/citizenshift/ [blogname] => CitizenShift [dateLastPost] => 1300473663 ) [1299937136] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 72 [domain] => citizenshift.org [path] => /blogs/WSF2011/ [blogname] => Alternatives delegation - FSM 2011 [dateLastPost] => 1299937136 ) [1352415444] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 9 [domain] => citizenshift.org [path] => /blogs/women-boxers-in-india/ [blogname] => Women Boxers In India: With This Ring [dateLastPost] => 1352415444 ) [1355964461] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 52 [domain] => citizenshift.org [path] => /blogs/betweenthelines/ [blogname] => Living Between the Lines [dateLastPost] => 1355964461 ) [1320695057] => stdClass Object ( [term_id] => 6000 [name] => Featured [slug] => featured [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 3 [count] => 1 [blog_id] => 62 [domain] => citizenshift.org [path] => /blogs/civicus/ [blogname] => CIVICUS World Assembly [dateLastPost] => 1320695057 ) ) [Others] => Array ( [1245682341] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 48 [domain] => citizenshift.org [path] => /blogs/live_from_csf/ [blogname] => Canadian Social Forum 2009 [dateLastPost] => 1245682341 ) [1269882819] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 5 [domain] => citizenshift.org [path] => /blogs/haiti/ [blogname] => Haiti: The Damage Done [dateLastPost] => 1269882819 ) [1277307817] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 4 [domain] => citizenshift.org [path] => /blogs/water/ [blogname] => Water [dateLastPost] => 1277307817 ) [1190666496] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 7 [domain] => citizenshift.org [path] => /blogs/trafficking-in-southeast-asia-bleurouge/ [blogname] => Trafficking In Humanity - BleuRouge [dateLastPost] => 1190666496 ) [1207590506] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 8 [domain] => citizenshift.org [path] => /blogs/world-urban-forum/ [blogname] => World Urban Forum [dateLastPost] => 1207590506 ) [1299937136] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 72 [domain] => citizenshift.org [path] => /blogs/WSF2011/ [blogname] => Alternatives delegation - FSM 2011 [dateLastPost] => 1299937136 ) [1183664052] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 11 [domain] => citizenshift.org [path] => /blogs/within-and-without/ [blogname] => Within and Without [dateLastPost] => 1183664052 ) [1184866982] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 12 [domain] => citizenshift.org [path] => /blogs/wal-town/ [blogname] => Wal-Town [dateLastPost] => 1184866982 ) [1198377178] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 14 [domain] => citizenshift.org [path] => /blogs/garbage/ [blogname] => Garbage [dateLastPost] => 1198377178 ) [1241132296] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 15 [domain] => citizenshift.org [path] => /blogs/reel-youth-international/ [blogname] => Reel Youth International [dateLastPost] => 1241132296 ) [1186417859] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 16 [domain] => citizenshift.org [path] => /blogs/velcrow-ripper-on-fierce-light/ [blogname] => Velcrow Ripper on Fierce Light [dateLastPost] => 1186417859 ) [1273413285] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 17 [domain] => citizenshift.org [path] => /blogs/masculinity/ [blogname] => Questioning Masculinity [dateLastPost] => 1273413285 ) [1183572908] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 18 [domain] => citizenshift.org [path] => /blogs/autonomous-media/ [blogname] => Autonomous Media [dateLastPost] => 1183572908 ) [1294676803] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 20 [domain] => citizenshift.org [path] => /blogs/white-water-black-gold/ [blogname] => White Water Black Gold [dateLastPost] => 1294676803 ) [1193416615] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 31 [domain] => citizenshift.org [path] => /blogs/fnc/ [blogname] => Videoblog FNC [dateLastPost] => 1193416615 ) [1193784327] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 22 [domain] => citizenshift.org [path] => /blogs/a-day-in-the-life-of-a-sketchbook/ [blogname] => A Day in the Life of a Sketchbook [dateLastPost] => 1193784327 ) [1246559983] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 33 [domain] => citizenshift.org [path] => /blogs/ask-the-green-queen/ [blogname] => Ask the Green Queen [dateLastPost] => 1246559983 ) [1244148672] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 35 [domain] => citizenshift.org [path] => /blogs/documentary-field-notes-and-flashpoints/ [blogname] => Documentary Field Notes and Flashpoints [dateLastPost] => 1244148672 ) [1213301696] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 36 [domain] => citizenshift.org [path] => /blogs/connexions/ [blogname] => Connexions with Our World [dateLastPost] => 1213301696 ) [1245869943] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 37 [domain] => citizenshift.org [path] => /blogs/charge/ [blogname] => Charge! [dateLastPost] => 1245869943 ) [1228123966] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 34 [domain] => citizenshift.org [path] => /blogs/one-big-hapa-family/ [blogname] => One Big Hapa Family [dateLastPost] => 1228123966 ) [1223388885] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 38 [domain] => citizenshift.org [path] => /blogs/road-to-leh/ [blogname] => Road to Leh [dateLastPost] => 1223388885 ) [1229988977] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 40 [domain] => citizenshift.org [path] => /blogs/building_day_care_peru/ [blogname] => Journey to Peru: The building of a day care centre [dateLastPost] => 1229988977 ) [1225383866] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 41 [domain] => citizenshift.org [path] => /blogs/montreal-matters/ [blogname] => Montreal Matters: Youth [dateLastPost] => 1225383866 ) [1237567902] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 43 [domain] => citizenshift.org [path] => /blogs/ship-for-world-youth/ [blogname] => Ship for World Youth [dateLastPost] => 1237567902 ) [1238018854] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 44 [domain] => citizenshift.org [path] => /blogs/pathways-to-your-plate/ [blogname] => Pathways To Your Plate [dateLastPost] => 1238018854 ) [1256068462] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 45 [domain] => citizenshift.org [path] => /blogs/a-tenuous-peace/ [blogname] => A Tenuous Peace [dateLastPost] => 1256068462 ) [1236755600] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 46 [domain] => citizenshift.org [path] => /blogs/jane-doe-conference/ [blogname] => Jane Doe Conference [dateLastPost] => 1236755600 ) [1242081481] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 47 [domain] => citizenshift.org [path] => /blogs/summit_of_the_americas_trinidad/ [blogname] => Summit of the Americas in Trinidad and Tobago [dateLastPost] => 1242081481 ) [1326781710] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 49 [domain] => citizenshift.org [path] => /blogs/versecity/ [blogname] => The Verse City Workshop: A Career in Journalism? [dateLastPost] => 1326781710 ) [1280697832] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 51 [domain] => citizenshift.org [path] => /blogs/rendezvous/ [blogname] => Citizen Media Rendez-Vous [dateLastPost] => 1280697832 ) [1245364480] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 39 [domain] => citizenshift.org [path] => /blogs/colouringbook/ [blogname] => The Colouring Book [dateLastPost] => 1245364480 ) [1267466965] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 58 [domain] => citizenshift.org [path] => /blogs/good-morning-afghanistan/ [blogname] => Good Morning Afghanistan [dateLastPost] => 1267466965 ) [1270404503] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 59 [domain] => citizenshift.org [path] => /blogs/round-the-world-radio/ [blogname] => Round the World Radio [dateLastPost] => 1270404503 ) [1337919043] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 60 [domain] => citizenshift.org [path] => /blogs/Adventures-in-Outreach/ [blogname] => Adventures in Outreach [dateLastPost] => 1337919043 ) [1260204412] => stdClass Object ( [term_id] => 6001 [name] => Others [slug] => others [term_group] => 0 [taxonomy] => category [description] => [term_taxonomy_id] => 4 [count] => 0 [blog_id] => 3 [domain] => citizenshift.org [path] => /blogs/podcasts/ [blogname] => Podcasts [dateLastPost] => 1260204412 ) ) )