Routine~13min

The Promo Exclusion Breach

Finance found that last week's FLASH20 promotion was applied to some product categories that were explicitly excluded from it. The frontend showed the promo as valid for all categories — the backend never re-checked the exclusion list. Find the violations.

Tables you'll query

promotionsorder_discounts

What you'll learn

JOINs
Investigate this case →