Product List (links only)

Custom SQL query returning 535 rows (hide)

SELECT p.id, p.name,
       '{"href": "/images/' || p.id || '.jpg", "label": "View Image"}' as image_link,
       p.language, 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
FROM products p
LEFT JOIN product_backend_data b ON p.id = b.product_id
ORDER BY p.name

Edit SQL