MySQL Query : SELECT COUNT(*) as count FROM (SELECT * FROM bc_picture as p left join bc_picture_data as p2 on p.id=p2.id where p.catid=18 and p.posids=1) T MySQL Error : Duplicate column name 'id' MySQL Errno : 1060 Message : Duplicate column name 'id' Need Help?