FloodRecords: Difference between revisions

From DFO – Flood Observatory
No edit summary
No edit summary
Line 2: Line 2:
tables=FloodReports
tables=FloodReports
|fields=
|fields=
    CONCAT_WS('','[[',_pageName, '|', ReportNumber, ']]',
     ReportNumber=﹟,
     ReportNumber=﹟,
     GlideNumber=Glide ﹟,
     GlideNumber=Glide ﹟,

Revision as of 13:24, 12 December 2025

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\xEF\xB9\x9F,\x0A GlideNumber=Glide \xEF\xB9\x9F,\x0A BeginDate=Start Date' at line 2

Function: CargoSQLQuery::run Query: SELECT `FloodReports`.`_pageID` AS `cargo_backlink_page_id_FloodReports`,CONCAT_WS(,'', ReportNumber, '',

   ReportNumber=﹟,
   GlideNumber=Glide ﹟,
   BeginDate=Start Date,
   EndDate=End Date,
   Country=Country,
   OtherCountry=Additional Countries,
   Source=Source,
   MainCause=Main Cause,
   NumberOfFatalities=Fatalities,
   NumberOfDisplaced=Displaced,
   Severity=Severity AS `CONCAT WS(  ,  , ReportNumber,   ,
   ReportNumber=﹟,
   GlideNumber=Glide ﹟,
   BeginDate=Start Date,
   EndDate=End Date,
   Country=Country,
   OtherCountry=Additional Countries,
   Source=Source,
   MainCause=Main Cause,
   NumberOfFatalities=Fatalities,
   NumberOfDisplaced=Displaced,
   Severity=Severity`  FROM `cargo__FloodReports` `FloodReports`     ORDER BY `Start Date` DESC LIMIT 100