-- Find and unflag non-sneaker items (hats, bags, accessories)
UPDATE products SET is_sneaker = false
WHERE is_sneaker = true AND (
  LOWER(name) LIKE '%vissershoedje%'
  OR LOWER(name) LIKE '%bucket hat%'
  OR LOWER(name) LIKE '%pet %'
  OR LOWER(name) LIKE '%cap %'
  OR LOWER(name) LIKE '%muts%'
  OR LOWER(name) LIKE '%beanie%'
  OR LOWER(name) LIKE '%tas %'
  OR LOWER(name) LIKE '%rugzak%'
  OR LOWER(name) LIKE '%backpack%'
  OR LOWER(name) LIKE '%sokken%'
  OR LOWER(name) LIKE '%socks%'
  OR LOWER(name) LIKE '%slippers%'
  OR LOWER(name) LIKE '%slides%'
  OR LOWER(name) LIKE '%sandal%'
  OR LOWER(name) LIKE '%flip flop%'
  OR LOWER(name) LIKE '%pantoffel%'
  OR LOWER(name) LIKE '%t-shirt%'
  OR LOWER(name) LIKE '%hoodie%'
  OR LOWER(name) LIKE '%jacket%'
  OR LOWER(name) LIKE '%broek%'
  OR LOWER(name) LIKE '%pants%'
  OR LOWER(name) LIKE '%short %'
  OR LOWER(name) LIKE '%hoedje%'
  OR LOWER(name) LIKE '% hat %'
  OR LOWER(name) LIKE '%zonnebril%'
  OR LOWER(name) LIKE '%riem%'
  OR LOWER(name) LIKE '%belt%'
  OR LOWER(name) LIKE '%portemonnee%'
  OR LOWER(name) LIKE '%wallet%'
  OR LOWER(name) LIKE '%horloge%'
  OR LOWER(name) LIKE '%watch %'
)
RETURNING id, name;
