products

All products from the webshop

5 rows where categories_raw = "Groom and Best Man:Weddings:Knappehulsblomster" sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

language 1

categories_raw 1

  • Groom and Best Man:Weddings:Knappehulsblomster · 5 ✖
id name ▲ colour description page_title url_slug categories_raw language created_at updated_at deleted_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  
8c2ishkyts Tropical and Rose corsage   Tropical and Rose corsage, white rose and leather leaves plus other greenery   tropical-rose-corsage Groom and Best Man:Weddings:Knappehulsblomster   2026-02-03 21:08:40 2026-06-12 11:17:38.697972  
5xeb21vm0v Pastel Rustique Corsage   Pastel Rustique corsage is the perfect companion of the Pastel Rustique bridal bouquet   pastel-rustique-corsage Groom and Best Man:Weddings:Knappehulsblomster   2026-02-03 21:08:40 2026-06-12 11:17:38.697972  
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  

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);