Entry query "DESCLIMIT" invalid SQL

[wolispace]

On the 'Entry Queries' ie this page:
https://putyourlightson.com/articles/introducing-blitz-diagnostics#tracked-element-queries

When we copy the SQL and paste it, we see a sort order has been added to the query without wrapping it with spaces.. so we end up with in invalid SQL: "DESCLIMIT"

SELECT elements.idASelementIdFROM (SELECT elements.idASelementsId, elements_sites.idASelementsSitesId, content.idAScontentIdFROM elements elementsINNER JOIN entries entriesONentries.id=elements.idINNER JOIN elements_sites elements_sitesONelements_sites.elementId=elements.idINNER JOIN content content ON (content.elementId=elements.id) AND (content.siteId=elements_sites.siteId)LEFT JOIN structureelements structureelements ON (structureelements.elementId=elements.id) AND (structureelements.structureId=13)WHERE (entries.sectionId=4) AND (elements_sites.siteId=1) AND (elements.archived=FALSE) AND (elements.dateDeleted IS NULL) AND (elements.draftId IS NULL) AND (elements.revisionIdIS NULL)ORDER BYelements.dateUpdatedDESCLIMIT 1)subqueryINNER JOIN elements elementsONelements.id=subquery.elementsIdINNER JOIN elements_sites elements_sitesONelements_sites.id=subquery.elementsSitesIdINNER JOIN entries entriesONentries.id=subquery.elementsIdINNER JOIN content contentONcontent.id=subquery.contentIdLEFT JOIN structureelements structureelements ON (structureelements.elementId=subquery.elementsId) AND (structureelements.structureId=13)ORDER BY elements.dateUpdated DESC;

Notice there is no space before 'ORDER BY' so its possibly this being added without wrapping in spaces:

"ORDER BY elements.dateUpdated DESC"

[bencroker]

It sounds like perhaps line breaks need to be replaced with spaces before the SQL string is output. Thanks for reporting this, I'll work on a fix for the next release.

[bencroker]

Fixed in 2d8214c for the next release.

[bencroker]

Released in 4.11.0.