products
7 rows where categories_raw = "Bonita Coffee:Obsolete" sorted by name descending
This data as json, CSV (advanced)
Suggested facets: description, created_at (date), updated_at (date)
categories_raw 1
- Bonita Coffee:Obsolete · 7 ✖
language 0
| id | name ▲ | colour | description | page_title | url_slug | categories_raw | language | created_at | updated_at | deleted_at |
|---|---|---|---|---|---|---|---|---|---|---|
| q5b7zmpzbc | Ginger Bread | Gluten , Wheat and Dairy free HEALTHY snacks. Ideal for a gift basket | ginger-bread | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| vpiqiicyb2 | Clipper Peppermint | Our Peppermint infusion provides a light, highly refreshing drink with a crisp, clean and cool taste. Naturally caffeine free. | clipper-peppermint | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| bbqc91qbfo | Clipper OrangeandCoconut | Taking Fruit Infusions to a new flavour intensity, our delicious, fragrant, Orange and Coconut Infusion delivers a sharp tang of orange and the rounded creaminess of coconut. Naturally caffeine free | clipper-orangecoconut | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| 0yynvkds3d | Clipper Liquorice | <link href="/system/vista/css/bootstrap.css" rel="stylesheet" type="text/css" class="form-control">Our lovely Liquorice has a distinctive flavour providing a full and naturally sweet drink; popular in the office as a distraction from the mid afternoon sugar craving! Naturally caffeine free."> <link href="/system/vista/css/bootstrap.css" rel="stylesheet" type="text/css | clipper-liquorice | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| xf38p0sulx | Clipper Blackcurrent and Acai | A deeply fruity and refreshing infusion superbly blended with hibiscus, rosehip, acai berry and the delicious and distinctive taste of blackcurrant. Naturally caffeine free. (includes 20 tea bags | clipper-blackcurrent-acai | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| z6on3ilaiy | Cashew Cookie Bar | Gluten , Wheat and Dairy free HEALTHY snacks. Ideal for a gift basket | cashew-cookie-bar | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 | ||||
| 4zbfb1pyb8 | Cafe Mocha | Gluten , Wheat and Dairy free HEALTHY snacks. Ideal for a gift basket | cafe-mocha | Bonita Coffee:Obsolete | 2026-02-03 21:08:40 | 2026-07-06 14:20:26.215374 |
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);