MySQL Query : SELECT COUNT(*) as count FROM (SELECT g.*, m.vip, d.* FROM v9_member m, v9_yp_goods_price g, v9_yp_goods_price_data d WHERE m.userid = g.userid and g.id=d.id ORDER BY g.inputtime DESC, m.vip DESC) T MySQL Error : Duplicate column name 'id' MySQL Errno : 1060 Message : Duplicate column name 'id' Need Help?