CTEs - Common Table Expressions

'a CTE can only be used once in your query' (by the query the immediately follows it).

source :
http://www.singingeels.com/Articles/Understanding_SQL_Complex_Queries.aspx