Popular Topics on Planet Lean

Receive Articles in your Inbox

SELECT a.id, a.title , a.fake_title, a.show_marquee, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id WHERE a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 08:39:05') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 08:39:05') ORDER BY a.created DESC
  • Latest

  • Trending

SELECT a.fulltext, a.id, a.title, a.fake_title, a.alias, a.introtext, a.state, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.ordering, c.alias AS category_alias, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id WHERE a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 08:39:05') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 08:39:05') ORDER BY a.created DESC
SELECT a.fulltext, a.id, a.title, a.fake_title, a.alias, a.introtext, a.state, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.ordering, c.alias AS category_alias, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id WHERE a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND a.id IN (962,971,973,974,976) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 08:39:05') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 08:39:05') ORDER BY a.hits DESC

Book of the Month

Toyota Engagement Equation book cover  

The Toyota Engagement Equation, by Tracey and Ernie Richardson

Join Tracey and Ernie Richardson on a guided tour of Toyota’s unique learning environment as they look back at their time at the company’s first wholly-owned North American factory and unveil the hidden meaning behind going to see, asking why, and showing respect. Learn about Toyota’s cultural DNA from the authors’ successes and failures and from their interaction with their Japanese trainers. Buy your copy here.

Spotlight - Lean in healthcare

SELECT a.fulltext, a.id, a.title, a.fake_title, a.alias, a.introtext, a.state, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.ordering, c.alias AS category_alias, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id WHERE a.access IN (1,1) AND c.access IN (1,1) AND c.published = 1 AND a.state = 1 AND a.id IN (679,826,858,891) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-24 08:39:05') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-24 08:39:05') ORDER BY a.created DESC