Difference between revisions of "User:Econterms/Patents spike project"

From Inventing aviation
Jump to navigation Jump to search
(many tables, by country, to sketch the issue)
 
(syntax fix)
Line 7: Line 7:
 
|order by=Patents.Year_filed DESC
 
|order by=Patents.Year_filed DESC
 
}}
 
}}
* If want a bar chart, add <nowiki>|format=bar chart<.nowiki> to the end
+
* If want a bar chart, add <nowiki>|format=bar chart</nowiki> to the end
  
 
; Britain
 
; Britain

Revision as of 18:17, 26 August 2018

All countries
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='DE' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

  • If want a bar chart, add |format=bar chart to the end
Britain
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='GB' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

France
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='GB' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

Deutsch
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='DE' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)

United States
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `aero_cargo__Patents`.`Year_filed` AS `Year filed`,COUNT(*),`aero_cargo__Patents`.`Year_filed__precision` AS `Year filed__precision` FROM `aero_cargo__Patents` WHERE `aero_cargo__Patents`.`office`='US' AND `aero_cargo__Patents`.`Year_filed`>'1902' GROUP BY `aero_cargo__Patents`.`Year_filed` ORDER BY `aero_cargo__Patents`.`Year_filed` DESC LIMIT 400 Function: CargoSQLQuery::run Error: 1525 Incorrect DATE value: '1902' (mysql.econterms.net)