gistfile1.sql

SELECT o,side, o.price, sum(o.volume)
FROM active_order o
WHERE o.side = 0
GROUP BY o.price, o.side
ORDER BY o.price DESC
LIMIT 50
UNION ALL
SELECT o.side, o.price, sum(o.volume)
FROM active_order o
WHERE o.side = 1
GROUP BY o.price, o.side
ORDER BY o.price ASC
LIMIT 50;