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
Investigate this case →