MySQL Query : SELECT COUNT(*) as count FROM (select * from v9_picture as a left join v9_picture_data as b on a.id=b.id WHERE brandid='3484' AND hx='3367' AND qy='3392' AND catid='70' order by inputtime desc) T MySQL Error : Duplicate column name 'id' MySQL Errno : 1060 Message : Duplicate column name 'id' Need Help?