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.catid IN (169,144,153,154,155,156,157,158,159,164,160,162,168) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-12-18 01:06:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-12-18 01:06:33') 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.catid IN (144,153,154,155,156,157,158,159,164,160,162,168) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-12-18 01:06:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-12-18 01:06:33') 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 (692,976,997,998,999) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-12-18 01:06:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-12-18 01:06:33') ORDER BY a.hits DESC

Book of the Month

  

The Lean Bakery, by Juan Antonio Tena and Emi Castro

Removing waste gets you closer to your customers! Learn about the power of experimentation in this entertaining story on a thriving chain of cafés-bakeries in Barcelona.

At 365, lean is applied in both the factory and the shops, with extraordinary results. And it all started by chance, with the CEO being inspired to change the direction of his business after finding the book Lean Thinking at the airport bookstore. Don't miss one of our favorite lean stories! Buy your copy here.

Spotlight - Lean Coaching

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 (650,974,986,989) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-12-18 01:06:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-12-18 01:06:33') ORDER BY a.created DESC