home / shop

products

All products from the webshop

3 rows where categories_raw = "Fresh Cut Flowers:White:Hvit:Snittblomster" sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

categories_raw 1

  • Fresh Cut Flowers:White:Hvit:Snittblomster · 3 ✖

language 0

id name ▲ colour description page_title url_slug categories_raw language created_at updated_at deleted_at
03jg0t4szy White double Eustoma   The Lisianthus Flowers is unique in design and style, resembling the classic white rose in some features, with a refreshed twist   double-eustoma Fresh Cut Flowers:White:Hvit:Snittblomster   2026-02-03 21:08:40 2026-02-03 21:08:40  
fjfzqnt6r3 White Gerbera Snowfall   White Gerbera, in perfect shape and form for simplicity and absolute minimalism, yet so incredibly detailed - it`s pure beauty.   white-gerbera-snowfall Fresh Cut Flowers:White:Hvit:Snittblomster   2026-02-03 21:08:40 2026-02-03 21:08:40  
fcml7nevxg Martha Lily   The martha lily is often used for formal events as the simple and prestigious look conveys pure elegance in minimalistic style.   martha-lily Fresh Cut Flowers:White:Hvit:Snittblomster   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);
Powered by Datasette · Queries took 26.511ms