User:Econterms/Patents spike project
- All countries
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
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
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
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
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)