products

All products from the webshop

3 rows where categories_raw = "Brides Maid:Weddings:Bridal Bouquets:Brudebuketter:Brudepikene" sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

language 1

categories_raw 1

  • Brides Maid:Weddings:Bridal Bouquets:Brudebuketter:Brudepikene · 3 ✖
id name ▲ colour description page_title url_slug categories_raw language created_at updated_at deleted_at
hvxyw7bfn5 The Purple Brides Maid   Purple, blue and pink rose shades for the ultimate combination of creative passion and warm, floral wedding decorations made to perfection   the-purple-brides-maid Brides Maid:Weddings:Bridal Bouquets:Brudebuketter:Brudepikene en 2026-02-03 21:08:40 2026-02-03 21:08:40  
b32ptqzbh7 Silky Rose   An elegant pink floral combination to match the cream white dress and rose gold wedding theme made of roses and silk ribbon details   satin-silky-rose Brides Maid:Weddings:Bridal Bouquets:Brudebuketter:Brudepikene en 2026-02-03 21:08:40 2026-02-03 21:08:40  
svgzmdrczd Peony Brides Maid   Sweet, soft pink peonies and cream white rose creation for brides and brides maids wedding bouquets of the late spring and summer season   peony-brides-maid Brides Maid:Weddings:Bridal Bouquets:Brudebuketter:Brudepikene en 2026-02-03 21:08:40 2026-02-03 21:08:40  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);