tags:

views:

14

answers:

1

hi,

why does this query work? how am i supposed to write it?

select * from tbl_content order by year desc where visible = '1' limit 0,30;
+3  A: 

WHERE Clauses come before ORDER BY.

Rewrite as:

select * from tbl_content where visible = '1'  order by year desc limit 0,30;
timdev