Product Gallery (with images)

Custom SQL query returning 50 rows (hide)

SELECT p.id, p.name,
       '{"href": "/images/' || p.id || '.jpg", "img_src": "/images/' || p.id || '.jpg"}' as image,
       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
LIMIT 50

Edit SQL