Summary
We give Indian rural retail shops access to technologies that improve their customers’ lives.
Categories
Videos:
Quick Links
PROBLEM
Many organizations design solar lanterns, water filters, and other life-improving essential technologies for homes in developing countries. However, these products rarely benefit end users at scale because the rural last mile lacks effective distribution, marketing, and service.
Meanwhile, 90% of the $260B annual retail spending in India takes place in 14M small, low-margin, family-run retail shops. Retail shops don’t sell essential technologies because they don’t know about them, where to find them, or how to service them.
Essmart offers a solution. Essmart delivers the goods.
SOLUTION
Essmart is an essential technology distributor with an embedded retail presence. We address three problems that local retail shops face:
TRACTION
After founding in October 2011, Essmart surveyed over 200 retailers in southern India during January 2012. In our pilot, two retail shops sold 17 Essmart products in one week in Pollachi, Tamil Nadu. In Summer 2012, Essmart will begin year one of operations, with the goal of establishing distribution channels to 65 rural shops by year end.
Get 2,000+ technologies into rural areas in the first year; 4.5 million by five years.
Diana Jue (co-founder) is a second year Master’s student studying international development in MIT’s Department of Urban Studies and Planning. She is studying technology dissemination for her thesis and has traveled extensively in southern India. Having obtained bachelor’s degrees in economics and urban studies and planning from MIT in 2009, Diana will be working on overall idea and business model development in addition to supply chain logistics and operations management.
Jackie Stenson (co-founder) studied engineering at Harvard, graduating in 2008, and completed her Master’s degree in Engineering for Sustainable Development from the University of Cambridge, graduating in 2012. Jackie has extensive experience both designing essential technologies and studying dissemination models for low-income communities in Africa, having traveled and worked there for over two years in 11 countries. Jackie will be working on overall idea and business model development in addition to technology sourcing.
Prashanth Venkataramana has a background in mechanical engineering and studied Engineering for Sustainable Development at the University of Cambridge. He is from Pollachi, Tamil Nadu, India, lives in Chennai, and works in sales and marketing in the glass industry. Prashanth has numerous contacts in Chennai and in Bangalore and speaks Tamil, Hindi, Telugu, and English. Prashanth works on technology evaluation, securing local connections, creating customer value propositions, and relaying local conditions to the rest of the team.
Taylor Matthews is a first-year MBA student at the MIT Sloan School of Management. He focuses his studies on the intersection of technology and finance with a particular interest in how both can be applied in the developing world. With a background in investment banking, management consulting, and venture finance, Taylor will focus on the financial aspects of the business and provide input into the overall idea and business model development.
Robert Weiss is a Masters candidate at Harvard Kennedy School. His academic background is in clean tech policy and economics. He focused on deployment of renewable energy in China, where he lived for one year and is fluent in Mandarin. Rob has also worked in Cameroon and Timor-Leste, the latter spent assessing the impact of a solar lantern distribution project in off-grid rural villages. Rob focuses on supplier relations and business strategy.
Jaya Movva studies International Business at the Tufts University Fletcher School of Law and Diplomacy. She has worked as a design engineer at Motorola in the past and then worked for a major financial services firm in Dubai. She has done development work in Tanzania and Haiti and plans to work in initiatives that promote private sector development in emerging markets. She will help out with business plan development and market analysis.
Ben Younkman studies International Business at the Tufts University Fletcher School of Law and Diplomacy, focusing on community development and social enterprises in emerging markets. He is experienced with community development, documentary work, and logistics from nearly seven years working in Latin America, the Caribbean and China. Ben focuses on Essmart’s distribution logistics and produces media content and marketing materials.
Jen Zhu is a joint degree candidate in Government and Sociology at Harvard University. She has prior experience with two other social enterprises, and worked with Dalberg Global Development Advisors to analyze 80+ social enterprises’ challenges and success factors. She also researches the dissemination of public health interventions through social networks in developing countries. Jen works on market analysis, social media, and U.S. marketing.
Aubrey Colter is a third year undergraduate in MIT’s Department of Electrical Engineering and Computer Science. When she took the Media Lab's Building Mobile Applications class, she began prototyping mobile technologies for Essmart's future use. Aubrey will be developing back-end applications for Essmart's field agents so that they can more conveniently collect survey information about the product after it is purchased and put to use.
Sri Siddhanta Foundation
Chennai, Tamil Nadu, India
SSF is a Chennai-based nonprofit organization that focuses on village development. Its recent initiative, Gramothan, includes chapters in Bangalore, Delhi, Calcutta, and Mumbai. Gramothan Resource Centers are located throughout India, in the states of Tamil Nadu, Jharkhand, Maharashtra, Orissa, West Bengal, and Uttar Pradesh. Contacts within SSF are presently very interested in bringing essential technologies to villages, which is why SSF serves as a potential collaborator. Essmart would work with SSF to run product demonstrations and to train youngsters that would work in the service and demonstration centers.
Location:
External Blog Feed
Diana and I recently got back from Austin, Texas, where we attended our second Dell Social Innovation Challenge finalist weekend. Although this time, we were sitting on the other side of the fence. DSIC has a tradition of bringing back the previous year’s winner as a judge, [...] More »
We’re excited to launch our first crowd funding campaign on Indiegogo! We’ve been excited about how our model has been working in Pollachi, Tamil Nadu, and we’re ready to take on the challenge of scaling to a new, nearby region. Our crowd funding campaign allows us to engage [...] More »
We’ve recently been setting up a new accounting software – Xero. As we’ve gone through this process, we’ve received a fair amount of push back in India. People are used to using a software called Tally, and we’ve had to justify why we want to use a [...] More »
Yesterday, we took everyone based in our Pollachi office out to lunch at nice place outside of Pollachi. This was our first retreat for our sales executives. It was mostly a chance to get everyone together, to treat our employees to a nice meal, and to say [...] More »
While reading a Jalopnik article reflecting on the Indian car market, it struck me that the Indian car market is really not that different from the market for essential technologies. The author, Jason Torchinsky, a car blogger and first-time visitor to India, hit on a number of [...] More »
You can’t completely understand the problem until you learn about it from the people who know it best. This has been a personal philosophy that has grown stronger over the past couple of years. It’s been reinforced even more this winter. I’m Jen, and I’ve been working [...] More »
As we approach the end of 2012, we’ve taken some time to reflect on this past year. It has truly been a whirlwind. At this time last year, Diana was preparing to travel to India for our first pilot. We had a grand vision, a ridiculous amount [...] More »
Warning (2): strip_tags() expects parameter 1 to be string, array given [CORE/cake/libs/sanitize.php, line 91]
$string = array() $remove = true
}echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);
Debugger::handleError() - CORE/cake/libs/debugger.php, line 213 strip_tags - [internal], line ?? Sanitize::html() - CORE/cake/libs/sanitize.php, line 91 include - APP/views/elements/teams/blogger.ctp, line 50 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/teams/view.ctp, line 341 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::render() - CORE/cake/libs/view/view.php, line 377 DebugView::render() - APP/plugins/debug_kit/views/debug.php, line 74 Controller::render() - CORE/cake/libs/controller/controller.php, line 808 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 90
From our monthly(ish) newsletter, which you can subscribe to here: Greetings from India! Essmart has been on the ground in Pollachi, Tamil Nadu, India for about two months now. Much has happened since our last email update. Selvan, our Director of Field Operations, has hired two sales [...] More »
A few months back, Selvan met a Dasra representative at a conference held at the Tata Institute of Social Sciences in Mumbai. She told him about the Dasra Social Impact Program, an executive education program that trains decision makers of leading nonprofits and social enterprises across India. [...] More »
Comments and Support
Leave a message
* indicates a required field.
Top Liked Comments
"This sounds a great and very promisin...", 1 people liked this.
"This sounds sweet and I'd love to get...", 1 people liked this.
"Just skimming your promo materials, i...", 1 people liked this.
"Good job mzungu Jackie, and to the re...", 1 people liked this.
"Hi Team Essmart,
Welcome to the IDEA...", 1 people liked this.
Promote This Team
Notice (8): Undefined index: Rss [APP/controllers/teams_controller.php, line 88]
$media_url = "http://twitter.com/statuses/user_timeline/EssmartGlobal.rss?count=5" $type = null $HttpSocket = HttpSocket HttpSocket::$description = "HTTP-based DataSource Interface" HttpSocket::$quirksMode = false HttpSocket::$request = array HttpSocket::$response = array HttpSocket::$config = array HttpSocket::$lineBreak = "" HttpSocket::$_baseConfig = array HttpSocket::$connection = NULL HttpSocket::$connected = false HttpSocket::$lastError = array HttpSocket::$_log = NULL $results = null $parsed_xml = array()
}echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);
Debugger::handleError() - CORE/cake/libs/debugger.php, line 213 TeamsController::fetchMedia() - APP/controllers/teams_controller.php, line 88 TeamsController::fetchTwitter() - APP/controllers/teams_controller.php, line 55 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 Object::requestAction() - CORE/cake/libs/object.php, line 100 include - APP/views/elements/teams/twitter.ctp, line 2 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/teams/view.ctp, line 673 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::render() - CORE/cake/libs/view/view.php, line 377 DebugView::render() - APP/plugins/debug_kit/views/debug.php, line 74 Controller::render() - CORE/cake/libs/controller/controller.php, line 808 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229
Follow on Twitter
Warning (2): Invalid argument supplied for foreach() [APP/views/elements/teams/twitter.ctp, line 12]
$___viewFn = "/var/www/html/globalchallenge/app/views/elements/teams/twitter.ctp"
$___dataForView = array(
"comp_year" => "2013",
"team_comp_year" => "2013",
"allow_initial_proposals" => "1",
"allow_final_proposals" => "0",
"allow_voting" => "0",
"allow_cert_registration" => "1",
"allow_cert_login" => "1",
"allow_grants" => "0",
"enable_optin" => "1",
"show_explore_problems" => "1",
"show_discover_teams" => "1",
"show_join_support" => "1",
"show_create_team" => "1",
"show_offer_help" => "1",
"show_volunteer_for" => "1",
"show_browse_help" => "1",
"show_counting_votes" => "0",
"show_microsite" => "0",
"microsite_state" => "post",
"roles" => array(
"member" => "Participant",
"admin" => "Team Admin",
"mentor" => "Mentor",
"partner" => "Community Partner"
),
"invite_roles" => array(
"member" => "Participant",
"mentor" => "Mentor",
"partner" => "Community Partner"
),
"categories_images" => array(
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array()
),
"team" => array(
"Team" => array(),
"Problem" => array(),
"Challenge" => array(),
"Image" => array(),
"TeamsPartner" => array(),
"Help" => array(),
"Video" => array(),
"Vote" => array(),
"TeamFollower" => array(),
"Comment" => array(),
"Category" => array(),
"User" => array()
),
"is_member" => false,
"debugToolbarPanels" => array(
"history" => array(),
"session" => array(),
"request" => array(),
"sql_log" => array(),
"timer" => array(),
"log" => array(),
"variables" => array()
),
"debugToolbarJavascript" => array(
"behavior" => "/debug_kit/js/js_debug_toolbar"
),
"cache" => array(
"key" => "twitter_240",
"time" => "+1 hour"
),
"time" => TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/teams/view/240"
TimeHelper::$params = array
TimeHelper::$action = "view"
TimeHelper::$plugin = NULL
TimeHelper::$data = array
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL,
"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/teams/view/240"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = array
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/teams/view/240"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = array
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
"text" => TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/teams/view/240"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = array
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL,
"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/teams/view/240"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = array
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
"mitgc" => MitgcHelper
MitgcHelper::$helpers = array
MitgcHelper::$base = ""
MitgcHelper::$webroot = "/"
MitgcHelper::$themeWeb = NULL
MitgcHelper::$here = "/teams/view/240"
MitgcHelper::$params = array
MitgcHelper::$action = "view"
MitgcHelper::$plugin = NULL
MitgcHelper::$data = array
MitgcHelper::$namedArgs = NULL
MitgcHelper::$argSeparator = NULL
MitgcHelper::$validationErrors = NULL
MitgcHelper::$tags = array
MitgcHelper::$__tainted = NULL
MitgcHelper::$__cleaned = NULL
MitgcHelper::$_log = NULL
MitgcHelper::$Html = HtmlHelper object,
"toolbar" => ToolbarHelper
ToolbarHelper::$settings = array
ToolbarHelper::$_cacheEnabled = true
ToolbarHelper::$helpers = array
ToolbarHelper::$base = ""
ToolbarHelper::$webroot = "/"
ToolbarHelper::$themeWeb = NULL
ToolbarHelper::$here = "/teams/view/240"
ToolbarHelper::$params = array
ToolbarHelper::$action = "view"
ToolbarHelper::$plugin = NULL
ToolbarHelper::$data = array
ToolbarHelper::$namedArgs = NULL
ToolbarHelper::$argSeparator = NULL
ToolbarHelper::$validationErrors = NULL
ToolbarHelper::$tags = array
ToolbarHelper::$__tainted = NULL
ToolbarHelper::$__cleaned = NULL
ToolbarHelper::$_log = NULL
ToolbarHelper::$_myName = "toolbarhelper"
ToolbarHelper::$_backEndClassName = "HtmlToolbar"
ToolbarHelper::$_cacheKey = "toolbar_cache3c1b71f40148752f58a1ff2ea6e2c2b7"
ToolbarHelper::$_cacheConfig = "debug_kit"
ToolbarHelper::$HtmlToolbar = HtmlToolbarHelper object,
"htmlToolbar" => HtmlToolbarHelper
HtmlToolbarHelper::$helpers = array
HtmlToolbarHelper::$settings = array
HtmlToolbarHelper::$_cacheEnabled = false
HtmlToolbarHelper::$base = ""
HtmlToolbarHelper::$webroot = "/"
HtmlToolbarHelper::$themeWeb = NULL
HtmlToolbarHelper::$here = "/teams/view/240"
HtmlToolbarHelper::$params = array
HtmlToolbarHelper::$action = "view"
HtmlToolbarHelper::$plugin = NULL
HtmlToolbarHelper::$data = array
HtmlToolbarHelper::$namedArgs = NULL
HtmlToolbarHelper::$argSeparator = NULL
HtmlToolbarHelper::$validationErrors = NULL
HtmlToolbarHelper::$tags = array
HtmlToolbarHelper::$__tainted = NULL
HtmlToolbarHelper::$__cleaned = NULL
HtmlToolbarHelper::$_log = NULL
HtmlToolbarHelper::$_myName = "htmltoolbarhelper"
HtmlToolbarHelper::$Html = HtmlHelper object
HtmlToolbarHelper::$Javascript = JavascriptHelper object,
"number" => NumberHelper
NumberHelper::$helpers = NULL
NumberHelper::$base = ""
NumberHelper::$webroot = "/"
NumberHelper::$themeWeb = NULL
NumberHelper::$here = "/teams/view/240"
NumberHelper::$params = array
NumberHelper::$action = "view"
NumberHelper::$plugin = NULL
NumberHelper::$data = array
NumberHelper::$namedArgs = NULL
NumberHelper::$argSeparator = NULL
NumberHelper::$validationErrors = NULL
NumberHelper::$tags = array
NumberHelper::$__tainted = NULL
NumberHelper::$__cleaned = NULL
NumberHelper::$_log = NULL,
"simpleGraph" => SimpleGraphHelper
SimpleGraphHelper::$helpers = array
SimpleGraphHelper::$__defaultSettings = array
SimpleGraphHelper::$base = ""
SimpleGraphHelper::$webroot = "/"
SimpleGraphHelper::$themeWeb = NULL
SimpleGraphHelper::$here = "/teams/view/240"
SimpleGraphHelper::$params = array
SimpleGraphHelper::$action = "view"
SimpleGraphHelper::$plugin = NULL
SimpleGraphHelper::$data = array
SimpleGraphHelper::$namedArgs = NULL
SimpleGraphHelper::$argSeparator = NULL
SimpleGraphHelper::$validationErrors = NULL
SimpleGraphHelper::$tags = array
SimpleGraphHelper::$__tainted = NULL
SimpleGraphHelper::$__cleaned = NULL
SimpleGraphHelper::$_log = NULL
SimpleGraphHelper::$Html = HtmlHelper object,
"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = array
SessionHelper::$_userAgent = "3c1b71f40148752f58a1ff2ea6e2c2b7"
SessionHelper::$path = "/"
SessionHelper::$lastError = 2
SessionHelper::$security = "low"
SessionHelper::$time = 1369510418
SessionHelper::$sessionTime = 1369546418
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 788940000
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/teams/view/240"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = array
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers = false
$cached = false
$loadedHelpers = array()
$comp_year = "2013"
$team_comp_year = "2013"
$allow_initial_proposals = "1"
$allow_final_proposals = "0"
$allow_voting = "0"
$allow_cert_registration = "1"
$allow_cert_login = "1"
$allow_grants = "0"
$enable_optin = "1"
$show_explore_problems = "1"
$show_discover_teams = "1"
$show_join_support = "1"
$show_create_team = "1"
$show_offer_help = "1"
$show_volunteer_for = "1"
$show_browse_help = "1"
$show_counting_votes = "0"
$show_microsite = "0"
$microsite_state = "post"
$roles = array(
"member" => "Participant",
"admin" => "Team Admin",
"mentor" => "Mentor",
"partner" => "Community Partner"
)
$invite_roles = array(
"member" => "Participant",
"mentor" => "Mentor",
"partner" => "Community Partner"
)
$categories_images = array(
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
),
array(
"Category" => array(),
"Image" => array()
)
)
$team = array(
"Team" => array(
"id" => "240",
"contestyear" => "2012-01-01",
"name" => "Essmart",
"created" => "2011-10-28 12:18:55",
"modified" => "2012-05-08 13:32:29",
"email" => "hello@essmart-global.com",
"inglobalchallenge" => "1",
"pitch" => "**PROBLEM**
Many organizations design solar lanterns, water filters, and other life-improving essential technologies for homes in developing countries. However, these products rarely benefit end users at scale because the rural last mile lacks effective distribution, marketing, and service.
Meanwhile, 90% of the $260B annual retail spending in India takes place in 14M small, low-margin, family-run retail shops. Retail shops don’t sell essential technologies because they don’t know about them, where to find them, or how to service them.
_Essmart offers a solution. Essmart delivers the goods._
**SOLUTION**
Essmart is an essential technology distributor with an embedded retail presence. We address three problems that local retail shops face:
1. Knowledge Gap: We amplify demand for “essential technologies” via a paper and mobile catalogue and appealing marketing campaigns.
2. Distribution Gap: We supply essential technologies to Essmart sections in retail stores.
3. After-Sales Service Gap: We provide training, warranties, and maintenance service on essential technologies to ensure long-term benefits.
**TRACTION**
After founding in October 2011, Essmart surveyed over 200 retailers in southern India during January 2012. In our pilot, two retail shops sold 17 Essmart products in one week in Pollachi, Tamil Nadu. In Summer 2012, Essmart will begin year one of operations, with the goal of establishing distribution channels to 65 rural shops by year end.",
"intent" => "",
"impact" => "Get 2,000+ technologies into rural areas in the first year; 4.5 million by five years.",
"rawlocation" => "Pollachi, India",
"lat" => "10.6573",
"lon" => "77.0107",
"glocation" => "Palakkad- Koduvayur - Thathamangalam - Meenakshipuram Hwy, Pollachi, Tamil Nadu, India",
"category_other" => "",
"whoweare" => "**Diana Jue** (co-founder) is a second year Master’s student studying international development in MIT’s Department of Urban Studies and Planning. She is studying technology dissemination for her thesis and has traveled extensively in southern India. Having obtained bachelor’s degrees in economics and urban studies and planning from MIT in 2009, Diana will be working on overall idea and business model development in addition to supply chain logistics and operations management.
**Jackie Stenson** (co-founder) studied engineering at Harvard, graduating in 2008, and completed her Master’s degree in Engineering for Sustainable Development from the University of Cambridge, graduating in 2012. Jackie has extensive experience both designing essential technologies and studying dissemination models for low-income communities in Africa, having traveled and worked there for over two years in 11 countries. Jackie will be working on overall idea and business model development in addition to technology sourcing.
**Prashanth Venkataramana** has a background in mechanical engineering and studied Engineering for Sustainable Development at the University of Cambridge. He is from Pollachi, Tamil Nadu, India, lives in Chennai, and works in sales and marketing in the glass industry. Prashanth has numerous contacts in Chennai and in Bangalore and speaks Tamil, Hindi, Telugu, and English. Prashanth works on technology evaluation, securing local connections, creating customer value propositions, and relaying local conditions to the rest of the team.
**Taylor Matthews** is a first-year MBA student at the MIT Sloan School of Management. He focuses his studies on the intersection of technology and finance with a particular interest in how both can be applied in the developing world. With a background in investment banking, management consulting, and venture finance, Taylor will focus on the financial aspects of the business and provide input into the overall idea and business model development.
**Robert Weiss** is a Masters candidate at Harvard Kennedy School. His academic background is in clean tech policy and economics. He focused on deployment of renewable energy in China, where he lived for one year and is fluent in Mandarin. Rob has also worked in Cameroon and Timor-Leste, the latter spent assessing the impact of a solar lantern distribution project in off-grid rural villages. Rob focuses on supplier relations and business strategy.
**Jaya Movva** studies International Business at the Tufts University Fletcher School of Law and Diplomacy. She has worked as a design engineer at Motorola in the past and then worked for a major financial services firm in Dubai. She has done development work in Tanzania and Haiti and plans to work in initiatives that promote private sector development in emerging markets. She will help out with business plan development and market analysis.
**Ben Younkman** studies International Business at the Tufts University Fletcher School of Law and Diplomacy, focusing on community development and social enterprises in emerging markets. He is experienced with community development, documentary work, and logistics from nearly seven years working in Latin America, the Caribbean and China. Ben focuses on Essmart’s distribution logistics and produces media content and marketing materials.
**Jen Zhu** is a joint degree candidate in Government and Sociology at Harvard University. She has prior experience with two other social enterprises, and worked with Dalberg Global Development Advisors to analyze 80+ social enterprises’ challenges and success factors. She also researches the dissemination of public health interventions through social networks in developing countries. Jen works on market analysis, social media, and U.S. marketing.
**Aubrey Colter** is a third year undergraduate in MIT’s Department of Electrical Engineering and Computer Science. When she took the Media Lab's Building Mobile Applications class, she began prototyping mobile technologies for Essmart's future use. Aubrey will be developing back-end applications for Essmart's field agents so that they can more conveniently collect survey information about the product after it is purchased and put to use. ",
"url" => "http://www.essmart-global.com/",
"blog" => "http://www.essmart-global.com/feed/",
"twitter" => "EssmartGlobal",
"twitter_import" => "1",
"facebook" => " FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init(" FB.init("http://www.facebook.com/EssmartGlobal"); "); "); ",
"problem_id" => "0",
"challenge_id" => "32",
"winner" => "1",
"winnertype" => "",
"shortpitch" => "We give Indian rural retail shops access to technologies that improve their customers’ lives.",
"vote_count" => "418",
"active" => "1",
"facebook_page_id" => "",
"follower_count" => "110",
"comment_count" => "16",
"in_the_field" => "0"
),
"Problem" => array(
"id" => null,
"description" => null,
"created" => null,
"modified" => null,
"contestyear" => null,
"user_id" => null,
"title" => null,
"published" => null,
"agree" => null,
"category_suggestion" => null,
"follower_count" => null,
"comment_count" => null
),
"Challenge" => array(
"id" => "32",
"description" => "<p>To promote forward thinking in social and environmental responsibility In alignment with Dow Chemical’s 2015 Sustainability Goals, the <a href="http://www.dow.com/sustainability/studentchallenge/">Sustainability Innovation Student Challenge Award</a> (SISCA) program was launched in 2009 in order to promote forward thinking in social and environmental responsibility. Dow Chemical is sponsoring the SISCA program through the MIT IDEAS Global Challenge.</p>
<p>Participating students are rewarded for their work in sustainability and recognized for innovations that address global sustainability challenges. <br /><br />Student projects will be evaluated based on:</p>
<ul>
<li>Potential for solving world challenges</li>
<li>Interdisciplinary nature of work, for example, applied sciences, engineering, economics, public policy, social studies, business, etc.</li>
</ul>
<p>Innovative thinking and excellence in research <br /><br />MIT IDEAS Global Challenge teams can enter this Challenge as a way to increase the chances of winning an award. A special award pool of up to $10,000 will support teams working on projects encouraging and furthering sustainability. To take up this challenge, go to your Team Profile and select "Edit Profile" and then choose the associated challenge. </p>
<p>Questions? Email globalchallenge@mit.edu</p>",
"created" => "2012-04-06 11:51:57",
"modified" => "2012-04-06 11:51:00",
"user_id" => "2075",
"title" => "2012 Dow Sustainability Innovation Student Challenge Award",
"published" => "1",
"category_suggestion" => null
),
"Image" => array(
"id" => "628",
"filename" => "Logo_v_3_square.png",
"dir" => "uploads/image/teams",
"mimetype" => "image/png",
"filesize" => "12040",
"created" => "2011-11-28 18:34:10",
"modified" => "2011-11-28 18:34:10",
"page_id" => "0",
"entity_id" => "0",
"element_id" => "0",
"team_id" => "240",
"problem_id" => "0",
"category_id" => "0",
"challenge_id" => "0"
),
"TeamsPartner" => array(
"id" => "125",
"team_id" => "240",
"orgname" => "Sri Siddhanta Foundation",
"contactname" => "Dr. Bhavana Upadhyaya",
"location" => "Chennai, Tamil Nadu, India",
"description" => "SSF is a Chennai-based nonprofit organization that focuses on village development. Its recent initiative, Gramothan, includes chapters in Bangalore, Delhi, Calcutta, and Mumbai. Gramothan Resource Centers are located throughout India, in the states of Tamil Nadu, Jharkhand, Maharashtra, Orissa, West Bengal, and Uttar Pradesh. Contacts within SSF are presently very interested in bringing essential technologies to villages, which is why SSF serves as a potential collaborator. Essmart would work with SSF to run product demonstrations and to train youngsters that would work in the service and demonstration centers.",
"projectrole" => "Education and training",
"phone" => "+91-44-2857-7100",
"email" => "bhavana@ssfglobal.org",
"website" => "http://www.ssfglobal.org/",
"info" => ""
),
"Help" => array(),
"Video" => array(
array()
),
"Vote" => array(),
"TeamFollower" => array(),
"Comment" => array(
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array()
),
"Category" => array(
array(),
array(),
array(),
array(),
array()
),
"User" => array(
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array(),
array()
)
)
$is_member = false
$debugToolbarPanels = array(
"history" => array(
"content" => array(),
"elementName" => "history_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"session" => array(
"content" => array(),
"elementName" => "session_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"request" => array(
"content" => array(),
"elementName" => "request_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"sql_log" => array(
"content" => array(),
"elementName" => "sql_log_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"timer" => array(
"content" => null,
"elementName" => "timer_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"log" => array(
"content" => array(),
"elementName" => "log_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
),
"variables" => array(
"content" => array(),
"elementName" => "variables_panel",
"plugin" => "debug_kit",
"title" => null,
"disableTimer" => true
)
)
$debugToolbarJavascript = array(
"behavior" => "/debug_kit/js/js_debug_toolbar"
)
$cache = array(
"key" => "twitter_240",
"time" => "+1 hour"
)
$time = TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/teams/view/240"
TimeHelper::$params = array
TimeHelper::$action = "view"
TimeHelper::$plugin = NULL
TimeHelper::$data = array
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL
$javascript = JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/teams/view/240"
JavascriptHelper::$params = array
JavascriptHelper::$action = "view"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = array
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/teams/view/240"
HtmlHelper::$params = array
HtmlHelper::$action = "view"
HtmlHelper::$data = array
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$text = TextHelper
TextHelper::$helpers = NULL
TextHelper::$base = ""
TextHelper::$webroot = "/"
TextHelper::$themeWeb = NULL
TextHelper::$here = "/teams/view/240"
TextHelper::$params = array
TextHelper::$action = "view"
TextHelper::$plugin = NULL
TextHelper::$data = array
TextHelper::$namedArgs = NULL
TextHelper::$argSeparator = NULL
TextHelper::$validationErrors = NULL
TextHelper::$tags = array
TextHelper::$__tainted = NULL
TextHelper::$__cleaned = NULL
TextHelper::$_log = NULL
$form = FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/teams/view/240"
FormHelper::$params = array
FormHelper::$action = "view"
FormHelper::$plugin = NULL
FormHelper::$data = array
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$mitgc = MitgcHelper
MitgcHelper::$helpers = array
MitgcHelper::$base = ""
MitgcHelper::$webroot = "/"
MitgcHelper::$themeWeb = NULL
MitgcHelper::$here = "/teams/view/240"
MitgcHelper::$params = array
MitgcHelper::$action = "view"
MitgcHelper::$plugin = NULL
MitgcHelper::$data = array
MitgcHelper::$namedArgs = NULL
MitgcHelper::$argSeparator = NULL
MitgcHelper::$validationErrors = NULL
MitgcHelper::$tags = array
MitgcHelper::$__tainted = NULL
MitgcHelper::$__cleaned = NULL
MitgcHelper::$_log = NULL
MitgcHelper::$Html = HtmlHelper object
$toolbar = ToolbarHelper
ToolbarHelper::$settings = array
ToolbarHelper::$_cacheEnabled = true
ToolbarHelper::$helpers = array
ToolbarHelper::$base = ""
ToolbarHelper::$webroot = "/"
ToolbarHelper::$themeWeb = NULL
ToolbarHelper::$here = "/teams/view/240"
ToolbarHelper::$params = array
ToolbarHelper::$action = "view"
ToolbarHelper::$plugin = NULL
ToolbarHelper::$data = array
ToolbarHelper::$namedArgs = NULL
ToolbarHelper::$argSeparator = NULL
ToolbarHelper::$validationErrors = NULL
ToolbarHelper::$tags = array
ToolbarHelper::$__tainted = NULL
ToolbarHelper::$__cleaned = NULL
ToolbarHelper::$_log = NULL
ToolbarHelper::$_myName = "toolbarhelper"
ToolbarHelper::$_backEndClassName = "HtmlToolbar"
ToolbarHelper::$_cacheKey = "toolbar_cache3c1b71f40148752f58a1ff2ea6e2c2b7"
ToolbarHelper::$_cacheConfig = "debug_kit"
ToolbarHelper::$HtmlToolbar = HtmlToolbarHelper object
$htmlToolbar = HtmlToolbarHelper
HtmlToolbarHelper::$helpers = array
HtmlToolbarHelper::$settings = array
HtmlToolbarHelper::$_cacheEnabled = false
HtmlToolbarHelper::$base = ""
HtmlToolbarHelper::$webroot = "/"
HtmlToolbarHelper::$themeWeb = NULL
HtmlToolbarHelper::$here = "/teams/view/240"
HtmlToolbarHelper::$params = array
HtmlToolbarHelper::$action = "view"
HtmlToolbarHelper::$plugin = NULL
HtmlToolbarHelper::$data = array
HtmlToolbarHelper::$namedArgs = NULL
HtmlToolbarHelper::$argSeparator = NULL
HtmlToolbarHelper::$validationErrors = NULL
HtmlToolbarHelper::$tags = array
HtmlToolbarHelper::$__tainted = NULL
HtmlToolbarHelper::$__cleaned = NULL
HtmlToolbarHelper::$_log = NULL
HtmlToolbarHelper::$_myName = "htmltoolbarhelper"
HtmlToolbarHelper::$Html = HtmlHelper object
HtmlToolbarHelper::$Javascript = JavascriptHelper object
$number = NumberHelper
NumberHelper::$helpers = NULL
NumberHelper::$base = ""
NumberHelper::$webroot = "/"
NumberHelper::$themeWeb = NULL
NumberHelper::$here = "/teams/view/240"
NumberHelper::$params = array
NumberHelper::$action = "view"
NumberHelper::$plugin = NULL
NumberHelper::$data = array
NumberHelper::$namedArgs = NULL
NumberHelper::$argSeparator = NULL
NumberHelper::$validationErrors = NULL
NumberHelper::$tags = array
NumberHelper::$__tainted = NULL
NumberHelper::$__cleaned = NULL
NumberHelper::$_log = NULL
$simpleGraph = SimpleGraphHelper
SimpleGraphHelper::$helpers = array
SimpleGraphHelper::$__defaultSettings = array
SimpleGraphHelper::$base = ""
SimpleGraphHelper::$webroot = "/"
SimpleGraphHelper::$themeWeb = NULL
SimpleGraphHelper::$here = "/teams/view/240"
SimpleGraphHelper::$params = array
SimpleGraphHelper::$action = "view"
SimpleGraphHelper::$plugin = NULL
SimpleGraphHelper::$data = array
SimpleGraphHelper::$namedArgs = NULL
SimpleGraphHelper::$argSeparator = NULL
SimpleGraphHelper::$validationErrors = NULL
SimpleGraphHelper::$tags = array
SimpleGraphHelper::$__tainted = NULL
SimpleGraphHelper::$__cleaned = NULL
SimpleGraphHelper::$_log = NULL
SimpleGraphHelper::$Html = HtmlHelper object
$session = SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = array
SessionHelper::$_userAgent = "3c1b71f40148752f58a1ff2ea6e2c2b7"
SessionHelper::$path = "/"
SessionHelper::$lastError = 2
SessionHelper::$security = "low"
SessionHelper::$time = 1369510418
SessionHelper::$sessionTime = 1369546418
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 788940000
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/teams/view/240"
SessionHelper::$params = array
SessionHelper::$action = "view"
SessionHelper::$data = array
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$twitter = null
$i = 0}echo $_this->_output($level, $error, $code, $helpCode, $description, $file, $line, $context);
Debugger::handleError() - CORE/cake/libs/debugger.php, line 213 include - APP/views/elements/teams/twitter.ctp, line 12 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/teams/view.ctp, line 673 View::_render() - CORE/cake/libs/view/view.php, line 665 DebugView::_render() - APP/plugins/debug_kit/views/debug.php, line 54 View::render() - CORE/cake/libs/view/view.php, line 377 DebugView::render() - APP/plugins/debug_kit/views/debug.php, line 74 Controller::render() - CORE/cake/libs/controller/controller.php, line 808 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 90
Essmart On the web
Other Teams You May Like
Aasadeep Projects
aasadeep projects is established to solve the...
976 votes
458 followers
21 comments
Agua Clara
In the Corn Islands, two islands off the...
63 votes
9 followers
2 comments
Hope in Flight
Problem According to a 2010 UN report, 80% of...
230 votes
38 followers
4 comments
ReFresh Water
MIT students get reusable bottles for free at...
56 votes
13 followers
3 comments
AutoPump
Domestic water management in urban Nepal is...
11 votes
3 followers
0 comments
SUPPORTED BY: See all 
Support MIT IDEAS Global Challenge:
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Competition`.`id`, `Competition`.`allow_initial_proposals`, `Competition`.`allow_final_proposals`, `Competition`.`allow_voting`, `Competition`.`show_create_team_cta`, `Competition`.`comp_year`, `Competition`.`team_comp_year`, `Competition`.`allow_cert_registration`, `Competition`.`allow_cert_login`, `Competition`.`allow_grants`, `Competition`.`enable_optin`, `Competition`.`show_explore_problems`, `Competition`.`show_discover_teams`, `Competition`.`show_join_support`, `Competition`.`show_create_team`, `Competition`.`show_offer_help`, `Competition`.`show_volunteer_for`, `Competition`.`show_browse_help`, `Competition`.`show_counting_votes`, `Competition`.`show_microsite`, `Competition`.`microsite_state` FROM `competitions` AS `Competition` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'rinqs02tv3r22bogmq9q0fbe64' | 0 | 0 | 0 | |
| 3 | SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE 1 = 1 | 10 | 10 | 0 | |
| 4 | SELECT `Image`.`category_id`, `Image`.`dir`, `Image`.`filename` FROM `images` AS `Image` WHERE `Image`.`category_id` IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11) | 20 | 20 | 0 | |
| 5 | SELECT `Team`.`id`, `Team`.`contestyear`, `Team`.`name`, `Team`.`created`, `Team`.`modified`, `Team`.`email`, `Team`.`inglobalchallenge`, `Team`.`pitch`, `Team`.`intent`, `Team`.`impact`, `Team`.`rawlocation`, `Team`.`lat`, `Team`.`lon`, `Team`.`glocation`, `Team`.`category_other`, `Team`.`whoweare`, `Team`.`url`, `Team`.`blog`, `Team`.`twitter`, `Team`.`twitter_import`, `Team`.`facebook`, `Team`.`problem_id`, `Team`.`challenge_id`, `Team`.`winner`, `Team`.`winnertype`, `Team`.`shortpitch`, `Team`.`vote_count`, `Team`.`active`, `Team`.`facebook_page_id`, `Team`.`follower_count`, `Team`.`comment_count`, `Team`.`in_the_field`, `Problem`.`id`, `Problem`.`description`, `Problem`.`created`, `Problem`.`modified`, `Problem`.`contestyear`, `Problem`.`user_id`, `Problem`.`title`, `Problem`.`published`, `Problem`.`agree`, `Problem`.`category_suggestion`, `Problem`.`follower_count`, `Problem`.`comment_count`, `Challenge`.`id`, `Challenge`.`description`, `Challenge`.`created`, `Challenge`.`modified`, `Challenge`.`user_id`, `Challenge`.`title`, `Challenge`.`published`, `Challenge`.`category_suggestion`, `Image`.`id`, `Image`.`filename`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified`, `Image`.`page_id`, `Image`.`entity_id`, `Image`.`element_id`, `Image`.`team_id`, `Image`.`problem_id`, `Image`.`category_id`, `Image`.`challenge_id`, `TeamsPartner`.`id`, `TeamsPartner`.`team_id`, `TeamsPartner`.`orgname`, `TeamsPartner`.`contactname`, `TeamsPartner`.`location`, `TeamsPartner`.`description`, `TeamsPartner`.`projectrole`, `TeamsPartner`.`phone`, `TeamsPartner`.`email`, `TeamsPartner`.`website`, `TeamsPartner`.`info` FROM `teams` AS `Team` LEFT JOIN `problems` AS `Problem` ON (`Team`.`problem_id` = `Problem`.`id`) LEFT JOIN `challenges` AS `Challenge` ON (`Team`.`challenge_id` = `Challenge`.`id`) LEFT JOIN `images` AS `Image` ON (`Image`.`team_id` = `Team`.`id`) LEFT JOIN `teams_partners` AS `TeamsPartner` ON (`TeamsPartner`.`team_id` = `Team`.`id`) WHERE `Team`.`id` = 240 LIMIT 1 | 1 | 1 | 0 | |
| 6 | SELECT `Problem`.`id`, `Problem`.`description`, `Problem`.`created`, `Problem`.`modified`, `Problem`.`contestyear`, `Problem`.`user_id`, `Problem`.`title`, `Problem`.`published`, `Problem`.`agree`, `Problem`.`category_suggestion`, `Problem`.`follower_count`, `Problem`.`comment_count` FROM `problems` AS `Problem` WHERE `Problem`.`id` = 0 | 0 | 0 | 0 | |
| 7 | SELECT `Challenge`.`id`, `Challenge`.`description`, `Challenge`.`created`, `Challenge`.`modified`, `Challenge`.`user_id`, `Challenge`.`title`, `Challenge`.`published`, `Challenge`.`category_suggestion` FROM `challenges` AS `Challenge` WHERE `Challenge`.`id` = 32 | 1 | 1 | 0 | |
| 8 | SELECT `Image`.`id`, `Image`.`filename`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified`, `Image`.`page_id`, `Image`.`entity_id`, `Image`.`element_id`, `Image`.`team_id`, `Image`.`problem_id`, `Image`.`category_id`, `Image`.`challenge_id` FROM `images` AS `Image` WHERE `Image`.`team_id` = 240 | 1 | 1 | 0 | |
| 9 | SELECT `TeamsPartner`.`id`, `TeamsPartner`.`team_id`, `TeamsPartner`.`orgname`, `TeamsPartner`.`contactname`, `TeamsPartner`.`location`, `TeamsPartner`.`description`, `TeamsPartner`.`projectrole`, `TeamsPartner`.`phone`, `TeamsPartner`.`email`, `TeamsPartner`.`website`, `TeamsPartner`.`info` FROM `teams_partners` AS `TeamsPartner` WHERE `TeamsPartner`.`team_id` = 240 | 1 | 1 | 0 | |
| 10 | SELECT `Help`.`id`, `Help`.`title`, `Help`.`helptype_id`, `Help`.`offer_want`, `Help`.`description`, `Help`.`category_suggestion`, `Help`.`deleted`, `Help`.`closed`, `Help`.`created`, `Help`.`modified`, `Help`.`team_id`, `Help`.`user_id` FROM `help` AS `Help` WHERE `closed` = 0 AND `deleted` = 0 AND `Help`.`team_id` = (240) | 0 | 0 | 0 | |
| 11 | SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`url`, `Video`.`created`, `Video`.`modified`, `Video`.`team_id`, `Video`.`type`, `Video`.`thumbnail_name`, `Video`.`thumbnail_path`, `Video`.`thumbnail_size` FROM `videos` AS `Video` WHERE `Video`.`team_id` = (240) ORDER BY `Video`.`created` DESC | 1 | 1 | 0 | |
| 12 | SELECT `Vote`.`id`, `Vote`.`user_id`, `Vote`.`team_id`, `Vote`.`contestyear`, `Vote`.`created`, `Vote`.`ipaddress` FROM `votes` AS `Vote` WHERE `user_id` IS NULL AND `Vote`.`team_id` = (240) | 0 | 0 | 0 | |
| 13 | SELECT `TeamFollower`.`id`, `TeamFollower`.`user_id`, `TeamFollower`.`team_id`, `TeamFollower`.`created`, `TeamFollower`.`modified` FROM `team_followers` AS `TeamFollower` WHERE `user_id` IS NULL AND `TeamFollower`.`team_id` = (240) | 0 | 0 | 0 | |
| 14 | SELECT `Comment`.`id`, `Comment`.`team_id`, `Comment`.`user_id`, `Comment`.`problem_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`comment`, `Comment`.`is_spam`, `Comment`.`flagged`, `Comment`.`moderated`, `Comment`.`like_count`, `Comment`.`created`, `Comment`.`approved`, `Comment`.`ip_address` FROM `comments` AS `Comment` WHERE ((`is_spam` = 0) AND (`moderated` = 0)) AND `Comment`.`team_id` = (240) ORDER BY created DESC | 14 | 14 | 0 | |
| 15 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 24060 | 1 | 1 | 0 | |
| 16 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 24060 | 1 | 1 | 0 | |
| 17 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 23096 | 1 | 1 | 0 | |
| 18 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 23096 | 1 | 1 | 0 | |
| 19 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 22618 | 1 | 1 | 0 | |
| 20 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 22618 | 1 | 1 | 0 | |
| 21 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 2120 | 1 | 1 | 0 | |
| 22 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 2120 | 1 | 1 | 0 | |
| 23 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 21264 | 1 | 1 | 0 | |
| 24 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 21264 | 1 | 1 | 0 | |
| 25 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 21072 | 1 | 1 | 0 | |
| 26 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 21072 | 1 | 1 | 0 | |
| 27 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 20460 | 1 | 1 | 0 | |
| 28 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 20460 | 1 | 1 | 0 | |
| 29 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 20038 | 1 | 1 | 0 | |
| 30 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 20038 | 1 | 1 | 0 | |
| 31 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 0 | 0 | 0 | 0 | |
| 32 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 0 | 0 | 0 | 0 | |
| 33 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 0 | 0 | 0 | 0 | |
| 34 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 0 | 0 | 0 | 0 | |
| 35 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 12664 | 1 | 1 | 0 | |
| 36 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 12664 | 1 | 1 | 0 | |
| 37 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 18606 | 1 | 1 | 0 | |
| 38 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 18606 | 1 | 1 | 0 | |
| 39 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`comment_id`, `Like`.`created` FROM `likes` AS `Like` WHERE `user_id` IS NULL AND `Like`.`comment_id` IN (1666, 1609, 1579, 1517, 1490, 1488, 1459, 1438, 1404, 1398, 1397, 1396, 1153, 1136) | 0 | 0 | 0 | |
| 40 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified`, `CategoriesTeam`.`id`, `CategoriesTeam`.`team_id`, `CategoriesTeam`.`category_id` FROM `categories` AS `Category` JOIN `categories_teams` AS `CategoriesTeam` ON (`CategoriesTeam`.`team_id` = 240 AND `CategoriesTeam`.`category_id` = `Category`.`id`) ORDER BY `Category`.`id` ASC | 5 | 5 | 0 | |
| 41 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country`, `TeamsUser`.`id`, `TeamsUser`.`user_id`, `TeamsUser`.`team_id`, `TeamsUser`.`role`, `TeamsUser`.`inviteaccepted` FROM `users` AS `User` JOIN `teams_users` AS `TeamsUser` ON (`TeamsUser`.`team_id` = 240 AND `TeamsUser`.`user_id` = `User`.`id`) WHERE `User`.`active` = 1 | 9 | 9 | 0 | |
| 42 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 37 | 1 | 1 | 0 | |
| 43 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 18660 | 1 | 1 | 0 | |
| 44 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 11284 | 1 | 1 | 0 | |
| 45 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19097 | 1 | 1 | 0 | |
| 46 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19099 | 1 | 1 | 0 | |
| 47 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 18606 | 1 | 1 | 0 | |
| 48 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 20431 | 1 | 1 | 0 | |
| 49 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 17817 | 1 | 1 | 0 | |
| 50 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 20214 | 1 | 1 | 0 | |
| 51 | SELECT `Team`.`id`, `Team`.`name`, `Team`.`inglobalchallenge`, `Team`.`active` FROM `teams` AS `Team` WHERE `Team`.`id` = 240 LIMIT 1 | 1 | 1 | 0 | |
| 52 | SELECT `User`.`id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`type`, `TeamsUser`.`id`, `TeamsUser`.`user_id`, `TeamsUser`.`team_id`, `TeamsUser`.`role`, `TeamsUser`.`inviteaccepted` FROM `users` AS `User` JOIN `teams_users` AS `TeamsUser` ON (`TeamsUser`.`team_id` = 240 AND `TeamsUser`.`user_id` = `User`.`id`) | 9 | 9 | 0 |
Warning No slow queries!, or your database does not support EXPLAIN
Peak Memory Use 11.33 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.18 MB |
| Controller action start | 6.22 MB |
| Controller render start | 7.97 MB |
| Component intitailization #2 | 9.34 MB |
| Controller action start #2 | 9.34 MB |
| Component intitailization #3 | 10.23 MB |
| Controller action start #3 | 10.24 MB |
| Component intitailization #4 | 10.42 MB |
| Controller action start #4 | 10.42 MB |
| Component intitailization #5 | 10.63 MB |
| Controller action start #5 | 10.63 MB |
| View render complete | 10.68 MB |
Total Request Time: 1736 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 46.30 | |
| Component initialization and startup | 3.01 | |
| Controller action | 96.83 | |
| Render Controller Action | 1476.59 | |
| » Rendering View | 1475.44 | |
| » » Rendering APP/views/teams/view.ctp | 1445.30 | |
| » » » Rendering APP/views/elements/teams/blogger.ctp | 991.26 | |
| » » » » Component initialization and startup #2 | 18.28 | |
| Controller action #2 | 0.00 | |
| » » » » Rendering APP/views/elements/mostLikedComments.ctp | 24.95 | |
| » » » » » Component initialization and startup #3 | 5.72 | |
| Controller action #3 | 0.00 | |
| » » » » » Rendering APP/views/elements/teams/twitter.ctp | 186.82 | |
| » » » » » » Component initialization and startup #4 | 5.36 | |
| Controller action #4 | 0.00 | |
| » » » » » » Rendering APP/views/elements/teams/cta_team_page.ctp | 5.94 | |
| » » » » » » Rendering APP/views/elements/teams/similar.ctp | 107.61 | |
| » » » » » » » Component initialization and startup #5 | 5.93 | |
| Controller action #5 | 0.00 | |
| » » » » » » Rendering APP/views/layouts/default.ctp | 29.34 | |
| » » » » » » » Rendering APP/views/elements/signedout.ctp | 6.73 |
There were no log entries made this request
There were no log entries made this request

Back To All Teams
Good luck, Stenson!
Posted by M. Badgley on Wed, May 2nd 2012, 12:31 Report Abuse
0 likes
Keep it up jackie,and all the best
Posted by L. Gitinywa on Tue, Apr 24th 2012, 04:57 Report Abuse
0 likes
This sounds a great and very promising idea. I am sure you will do great with this idea if you can stick to it for a while. Best of luck and keep in touch!
Posted by Y. Chen on Fri, Apr 20th 2012, 15:11 Report Abuse
1 likes
Good luck guys!
Posted by H. Sahal on Tue, Apr 17th 2012, 01:15 Report Abuse
1 likes
Good luck Diana!!!
Posted by D. Handal on Sun, Apr 15th 2012, 23:28 Report Abuse
1 likes
All the best, Team ESSMART!
Posted by K. Manohar on Sun, Apr 15th 2012, 12:56 Report Abuse
1 likes
Good luck, Diana and the Essmart Team!!!
Posted by A. Jue on Sat, Apr 14th 2012, 01:10 Report Abuse
1 likes
Good luck guys! Michael Keogh
Posted by M. Keogh on Fri, Apr 13th 2012, 00:22 Report Abuse
1 likes
Good job mzungu Jackie, and to the rest of the team as well. Good luck with the project.
Posted by Nemo on Tue, Apr 10th 2012, 15:59 Report Abuse
1 likes
Just skimming your promo materials, it looks like you may have an interesting approach for reducing the risk to shopowners distributing such items and increasing the liquidity of the distribution and support markets. Could you elaborate on the economics behind this endeavor?
Posted by Ken Arnold on Tue, Apr 10th 2012, 00:19 Report Abuse
1 likes
Just skimming your promo materials, it looks like you may have an interesting approach for reducing the risk to shopowners distributing such items and increasing the liquidity of the distribution and support markets. Could you elaborate on the economics behind this endeavor?
Posted by Ken Arnold on Tue, Apr 10th 2012, 00:18 Report Abuse
0 likes
Just skimming your promo materials, it looks like you may have an interesting approach for reducing the risk to shopowners distributing such items and increasing the liquidity of the distribution and support markets. Could you elaborate on the economics behind this endeavor?
Posted by Ken Arnold on Tue, Apr 10th 2012, 00:18 Report Abuse
0 likes
Hi Team Essmart, Welcome to the IDEAS Competition and MIT Global Challenge! And all the best. Looking forward to you're work. Let me know if you have any questions. Here to help.--Sneha Chitte(Community Manager, MIT Global Challenge)
Posted by S. Chitte on Sat, Dec 24th 2011, 16:13 Report Abuse
1 likes
This sounds sweet and I'd love to get involved; I'm over at Harvard Kennedy School. Over winter break, I'm planning to go to work with an organization, Kopernik (http://kopernik.info), that also focuses on appropriate technology dissemination. They might have some relevant insights. Please reach me at robert.m.weiss09@gmail.com if you think it'd be useful to touch base. I'd love to learn how I could support your team. Thanks!
Posted by R. Weiss on Tue, Dec 13th 2011, 23:14 Report Abuse
1 likes