products
4 rows where categories_raw = "Christmas:Winter" sorted by name descending
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| id | name ▲ | colour | description | page_title | url_slug | categories_raw | language | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|
| 8an09ir36u | Violet Gold | A Christmas Candle Bloom design for less traditional lovers of this special and magical winter holiday season to spread love and joy | violet-gold | Christmas:Winter | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| uqbhm79udh | Longlasting Xmas | The longlasting Christmas bouquet is composed of beautiful seasonal elements and preserved flowers, creating a stylish, festive arrangement | longlasting-xmas | Christmas:Winter | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| b36y1d6fxw | Golden Violet | Purple haze and golden blaze turn this little floral stunner into the freshest combo of this winters` seasonal decorations | golden-violet- | Christmas:Winter | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| wswf55li4z | Elven Forest Florals | Our Elven Forest decoration is full of fresh cut flowers resembling the a magical place of nature packed into one neat little design | elven-forest-florals | Christmas:Winter | en | 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);