[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:  normal               |  Milestone:
Component:  learn.wordpress.org  |   Keywords:
---------------------------------+--------------------
 To replicate:

 1. Open a new browser window;
 2. Go to https://learn.wordpress.org/lesson-plans/
 3. Open each page in a new tab.
 4. Compare and find the duplicates.

 Since it appears that the total number of published lesson plans in /wp-
 admin/ (58) matches the total number of lesson plans available for
 browsing (9 lesson plans x 6 pages + 4 lesson plans on page 7), this means
 that some of the published lesson plans are not available for browsing.
 The order and which lesson plans are duplicated changes from time to time.

 To fix:
 The mySQL query should refer to the published lesson plans on the Learn
 platform.
 To my knowledge, it currently does some sort of lookup to GitHub and this
 is incorrect.

 Examples during my testing:

 The Web Fonts lesson plan appears on page 3 and on page 4.
 Here Theme Troubleshooting appears on page 2 AND on page 3.
 What You Can Do With WordPress appears on page 3 and page 4.

 Will upload screenshots.

 Unfortunately these examples are not exhaustive.

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