View source for User:WikiSysop/Sandbox/Badquery

==Query Problems==


===Character set conversion problems===

====Incorrect====
Incorrect character encoding: AeromÃ©xic Flight 498

====Correct====
Correct character encoding: Aeroméxico Flight 498

===Ask query syntax===
The query used Fatalities (deaths) as the search term. 

====Original Query:====

=====query=====
<nowiki>[[Fatalities::>0]][[Fatalities::<1001]]</nowiki>

=====result=====
{{#ask: [[Fatalities::>0]][[Fatalities::<1001]]
|
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}

====Good Query:====

=====query=====
<nowiki>[[Fatalities::>0]]</nowiki>

=====result=====
{{#ask: [[Fatalities::>0]]
|
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}

===Page not shown as a link===
The page/article name table doesn't contain a clickable link back to that page. The first line in the return result is the name of the first column field which should also be, in this case, the page name. 

=====query=====
<nowiki>[[Fatalities::>0]][[Fatalities::<1001]]</nowiki>

=====result=====
{{#ask: [[Fatalities::>0]][[Fatalities::<1001]]
| 
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}

====Good Query:====

=====query=====
<nowiki>[[Fatalities::>0]]</nowiki>

=====result=====
{{#ask: [[Fatalities::>0]]
|
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}

===Correct category===

Best choice (category set to : <nowiki>[[Category:Accidents and incidents on commercial airliners in the United States]]</nowiki>
Query set to :  <nowiki>[[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]</nowiki>

{{#ask: [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]
|
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}


===Linkable result for page in the first result column===

{{#ask: [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]
| mainlabel=Airline/Flight
| link=subject
| ?Date=Date
| ?Accident_Cause=Cause
| ?Aircraft_Type=Aircraft
| ?Airline=Airline
| ?Airport_Code=Airport involved
| ?Miles_Traveled=Miles Traveled
| ?State_Code=State of incident
| ?Survivors=Survivors
| ?Fatalities=Deaths
}}