Products In Stock

Custom SQL query returning 271 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,
       b.inventory
FROM products p
JOIN product_backend_data b ON p.id = b.product_id
WHERE b.instock = 1
ORDER BY p.name

Edit SQL