Routine~11min
The Invisible Category
The product team is puzzled — 31 products exist in the database and are marked active, but they never show up in any category browse page. A migration last month deleted four legacy categories without first null-ing the category_id on their products. Those products are now effectively invisible to shoppers.
Tables you'll query
categoriesproducts
What you'll learn
JOINsSELECT & Filtering