products

4 rows where categories_raw = "Groom and Best Man:Weddings:Obsolete" sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

CREATE TABLE products (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    colour TEXT,
    description TEXT,
    page_title TEXT,
    url_slug TEXT,
    categories_raw TEXT,  -- Original colon-separated categories from CSV
    language TEXT,  -- 'no', 'en', or NULL if unknown
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
, deleted_at TIMESTAMP);
CREATE INDEX idx_products_language ON products(language);
CREATE INDEX idx_products_name ON products(name);