Non-Square Product Images

Custom SQL query returning 185 rows (hide)

SELECT p.id, p.name,
       '{"href": "/images/' || p.id || '.jpg", "img_src": "/images/' || p.id || '.jpg"}' as image,
       pi.width, pi.height,
       ROUND(CAST(pi.width AS FLOAT) / pi.height, 3) as ratio,
       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
JOIN product_images pi ON p.id = pi.product_id
LEFT JOIN product_backend_data b ON p.id = b.product_id
WHERE ABS(CAST(pi.width AS FLOAT) / pi.height - 1.0) >= 0.005
ORDER BY ABS(CAST(pi.width AS FLOAT) / pi.height - 1.0) DESC

Edit SQL