[wp-meta] [Making WordPress.org] #5544: The mySQL query / lookup for the lesson plans on Learn is wrong.

[Making WordPress.org]

#5544: The mySQL query / lookup for the lesson plans on Learn is wrong.
---------------------------------+---------------------
 Reporter:  carike               |       Owner:  (none)
     Type:  defect               |      Status:  new
 Priority:  highest omg bbq      |   Milestone:
Component:  learn.wordpress.org  |  Resolution:
 Keywords:                       |
---------------------------------+---------------------
Changes (by carike):

 * priority:  normal => highest omg bbq


Comment:

 Changing the priority on this ticket because of the significant impact.
 https://learn.wordpress.org/lesson-plans/ is currently the only place
 where front end users can discover / explore lesson plans.
 If this was simple duplication, it would be one thing, but the duplicates
 are substituting published content that is supposed to be there.

 When I performed this test, the following lesson plans are duplicated on
 the list:
 Child Themes Twenty Sixteen TWICE
 Customizer Taglines THRICE
 Customizer: Static Vs. Content Front Page THRICE
 Dashboard Icons THRICE
 Dashboard Overview TWICE
 Managing Comments TWICE
 Theme Troubleshooting TWICE
 Web Fonts TWICE
 What Is A Theme TWICE
 Widget Areas TWICE
 What is Open Source? TWICE
 What You Can Do With WordPress TWICE

 This means that 15 published lesson plans that should be discoverable to
 Learn users are not.
 That is 25.8% of currently published courses that are not seen if a new
 user browses through courses.

 Here is the raw data, in the order that the lesson plans appeared:
 Line breaks separate pages.

 {{{
 Speaker Training Workshop
 Creating a WordPress.org Account
 Child Themes Twenty Sixteen
 Enqueueing Scripts And Styles
 Keeping WordPress Sites Secure
 Managing Spam On A Site
 Improving Site Performance
 How To Install WordPress On A Server
 Child Themes Twenty Seventeen

 Choosing And Installing Themes
 Child Themes Twenty Sixteen
 Post Formats (Theme)
 Template Heirarchy
 Theme Troubleshooting
 Theme Accessibility
 The Loop
 Settings
 Template Tour

 Managing Comments
 Theme Troubleshooting
 Web Fonts
 What Is A Theme
 Widget Areas
 What To Include In functions.php File
 What is Open Source?
 User Management
 What You Can Do With WordPress

 Web Fonts
 What Is A Theme
 What is Open Source?
 What You Can Do With WordPress
 Widget Areas
 How To Find Theme Specific Documentation
 Introduction To CSS
 Local Install
 Managing Comments

 Managing Updates
 Managing Widgets
 Pages Vs. Posts
 Conditional Tags
 Choosing And Installing Plugins
 Customizer: Static Vs. Content Front Page
 Customizer Taglines
 Dashboard Icons
 Dashboard Overview

 Customizer: Site Icons And Logo
 Customizer: Static Vs. Content Front Page
 Customizer Taglines
 Dashboard Icons
 Dashboard Overview
 General History Of WordPress
 Help Regenerate Thumbnails
 High-Level Overview
 How To Find Help With WordPress

 Dashboard Icons
 Customizer Taglines
 Customizer: Static Vs. Content Front Page
 Anatomy Of A Theme
 }}}

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/5544#comment:1>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org