products

All products from the webshop

5 rows where categories_raw = "Norwegian National Day" 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

  • Norwegian National Day · 5 ✖
id name ▲ colour description page_title url_slug categories_raw language created_at updated_at
gch4ky1554 Sweet Celebration   A sweet and simplistic gesture for someone who enjoys the celebration of Norwegians National Day and wants to brighten up the day a little more   sweet-celebration Norwegian National Day en 2026-02-03 21:08:40 2026-02-03 21:08:40
rhpnkscpzx National pride   The perfect combination to celebrate the wonderful norwegian national day on 17th of may. We use our prestigous red roses with a vivid blend in national colours   national_pride Norwegian National Day en 2026-02-03 21:08:40 2026-02-03 21:08:40
qs2wo196e0 Exclusive National Day   An exclusive bouquet design, composed of long stemmed colombian roses, mixed with blues and tropical palm leaves for a special look   exclusive-national-day Norwegian National Day en 2026-02-03 21:08:40 2026-02-03 21:08:40
o93yjjs5sr Deluxe Celebration   The delightful festivity bouquet with top quality roses serves as an excellent decoration for themed occasions such as Norwegians National day on May 17th   deluxe-celebration Norwegian National Day en 2026-02-03 21:08:40 2026-02-03 21:08:40
1i412son83 Bright National Day   This lovely piece is a bright combination of large white roses and light blue carnations, directly imported from Colombia   bright-national-day Norwegian National Day 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
);
CREATE INDEX idx_products_language ON products(language);
CREATE INDEX idx_products_name ON products(name);