MySQL Query : SELECT COUNT(*) as count FROM (select * from bc_shejishi AS z LEFT JOIN bc_shejishi_data AS f ON z.id=f.id where 1 and scfg like"%田园%" AND catid IN (8,18,161,338)) T MySQL Error : Duplicate column name 'id' MySQL Errno : 1060 Message : Duplicate column name 'id' Need Help?