products
4 rows where categories_raw = "Groom and Best Man:Weddings:Knappehulsblomster" 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 |
|---|---|---|---|---|---|---|---|---|---|
| g8tu6e1dvt | corsage classic large | Corsage Classic Large from Bonita Blomster in Oslo. Same day delivery if ordered as displayed. | corsage-classic-large | Groom and Best Man:Weddings:Knappehulsblomster | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| 3kz45er2au | Corsage Violet Bliss | The beautiful large violet coloured corsage theme makes an excellent combination to the purple floral bridal bouquet theme | corsage-violet-bliss | Groom and Best Man:Weddings:Knappehulsblomster | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| eyy15kun33 | Corsage Pink | Men can wear pink too - specially if the colour of the corsage blends in so smoothly with the bridal bouquet as it does here. | corsage-pink | Groom and Best Man:Weddings:Knappehulsblomster | en | 2026-02-03 21:08:40 | 2026-02-03 21:08:40 | ||
| vm24ahlry1 | Corsage Orchid | corsage-orchid | Groom and Best Man:Weddings:Knappehulsblomster | 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);