ERROR 1054 (42S22): Unknown column 'SearchWord' in 'field list'

[rpnew]

select `SearchWord` as 'Search Word', `SearchEngine` as 'Search Engine', `DomainName` as 'Domain Name', `Pos` as Position , `Link` as URL, `date` as 'Date Time'  UNION  select SearchWord,SearchEngine,DomainName,Pos,Link,date into outfile '/root/Desktop/data.csv' fields terminated by ',' from tempsearch; 
 

Well i hope title explains the problem.
Tell me what is the problem in this query. Here i'm trying to export mysql data into csv file with header. I've done this before as well, but cant find what is problem in this query. :(

Regards,
RP

[rpnew]

Hi,
Found the solution.

 select 'SearchWord' as 'Search Word', 'SearchEngine' as 'Search Engine', 'DomainName' as 'Domain Name', 'Pos' as 'Position' , 'Link' as 'URL', 'date' as 'Date Time'  UNION  select SearchWord,SearchEngine,DomainName,Pos,Link,date from tempsearch into outfile '/root/Desktop/data.csv' fields terminated by ',';