products
3 rows where categories_raw = "Autumn Plants:Plants:Autumn:Host:Planter" sorted by name descending
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
categories_raw 1
- Autumn Plants:Plants:Autumn:Host:Planter · 3 ✖
language 0
| id | name ▲ | colour | description | page_title | url_slug | categories_raw | language | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|
| 01f0ptmkt5 | Erica mix | A lovely, refreshing and stylish plant for the dark and cold season, Ericas last up to out the norwegian winter, not many flowers do, so this one is perfect | erica-mix | Autumn Plants:Plants:Autumn:Host:Planter | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| 1bn5juwpl5 | Chrysanthemum Plant | This lovely round pot plant is perfect for the autumn season, it blossoms fully and becomes one beautiful ball like plant | chrysanthemum-plant | Autumn Plants:Plants:Autumn:Host:Planter | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| nccywwqwru | Autumn Hybrid Dark | The autumn hybrid plants are the last source of bright and fresh green colours to surround ourselves with when the cold, grey season approaches | autumn-hybrid-dark | Autumn Plants:Plants:Autumn:Host:Planter | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);