Stuff

-- OrderBookDataSELECT a.stateid,b.name, count(*) FROM orders a, states b WHERE a.stateid=b.id AND traderuserid IN ( SELECT id FROM users WHERE loginname = 'kumarsea') AND active =1 GROUP BY b.name , a.stateid ORDER BY a.stateid;