Product Details (with backend data)

Custom SQL query returning 535 rows (hide)

SELECT p.id, p.name,
       '{"href": "/images/' || p.id || '.jpg", "img_src": "/images/' || p.id || '.jpg"}' as image,
       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.inventory,
       b.useinventory,
       b.autostock,
       pi.width || 'x' || pi.height as image_size,
       ROUND(CAST(pi.width AS FLOAT) / pi.height, 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
ORDER BY p.name

Edit SQL