products_full (view)

535 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW products_full AS
SELECT 
    p.id,
    p.name,
    p.language,
    p.description,
    p.categories_raw,
    CASE WHEN b.instock = 1 THEN 'In Stock'
         WHEN b.instock = 0 THEN 'Out of Stock'
         ELSE 'Unknown' END as stock_status,
    b.instock,
    b.inventory,
    pi.width as image_width,
    pi.height as image_height,
    ROUND(CAST(pi.width AS FLOAT) / NULLIF(pi.height, 0), 3) as image_ratio
FROM products p
LEFT JOIN product_backend_data b ON p.id = b.product_id
LEFT JOIN product_images pi ON p.id = pi.product_id;