SQL query: select distinct year(timestamp) as year from weblogs where visible=1 order by timestamp desc
Error message: Expression #1 of ORDER BY clause is not in SELECT list, references column 'texasfootballtalk.weblogs.timestamp' which is not in SELECT list; this is incompatible with DISTINCT
SQL query: select distinct month(timestamp) as month, year(timestamp) as year from weblogs where visible=1 order by timestamp desc
Error message: Expression #1 of ORDER BY clause is not in SELECT list, references column 'texasfootballtalk.weblogs.timestamp' which is not in SELECT list; this is incompatible with DISTINCT