products
4 rows where categories_raw = "Christmas" 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 | deleted_at |
|---|---|---|---|---|---|---|---|---|---|---|
| gfja8nuyn8 | The Pine Crown | The season for pine wreaths has begun and we are now decorating our doors with this fresh, winter scent tuning into the season ahead. | the-pine-crown | Christmas | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| l2k2y935j0 | The Blue Door | This lovely piece is not only timeless in style but also in durability. A simple masterpiece to match every kind of home. | the-blue-door | Christmas | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| gu0mhsvuty | Red-Bow Wreath | Our seasonal Red-Bow Wreath is a Christmas door wreath with white, red and gold round Christmas ornaments and bright red bows | red-bow-wreath- | Christmas | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | |||
| sao43a8skg | Christmas Rose Delight | This stunning decoration is the ideal christmas mood setter. Deep red roses, white pine branches and a bit of snow white make the perfect, classic combination. | christmas-rose-delight | Christmas | 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
, deleted_at TIMESTAMP);
CREATE INDEX idx_products_language ON products(language);
CREATE INDEX idx_products_name ON products(name);