Le Webzine délicieusement insensé de Magic the Gathering

Analyse du coffret Signature Spellbook: Jace

Le premier Signature Spellbook sort ce vendredi (15 juin 2018). Appelés à remplacer les coffrets From the Vault, les Signature Spellbooks seront des produits promotionnels ayant chacun pour thème un arpenteur de l'histoire. Et c'est Jace, le mage de l'esprit, qui essuie les plâtres.

Erreur select `dataId`, `dataListId`, `dataDataId`, `dataTitle`, `dataTitleUS`, `dataTeaser`, `dataTeaserHTML`, dataViewFR AS dataView, `dataEvaluation`, `dataLike`, `dataNotLike`, `dataIsValidated`, `dataIsTerminated`, `dataCreatedBy`, `dataModifiedBy`, `dataValidatedBy`, `dataCreationDate`, `dataModificationDate`, `dataValidationDate`, `dataNbrEdit`, `dataLanguage`, `dataIsFirstPage`, `dataCreationName`, `dataCreationEmail`, `dataValidationNotes`, `dataValidationComment`, `dataComments`, `dataDim1`, `dataDim2`, `dataDim3`, `dataVarchar1`, `dataInt1`, `dataIsHTML`, dataIsCarrousel, GROUP_CONCAT(tm.termId,'|',tm.termLabelFR SEPARATOR ';') as dataAttributes, listUrlName, listFullName, listWithComments, listWithLike, listNumberByPage, listDisplay, listMiniatureSize, id, login, grade, last_forum_visit FROM allDataText dText INNER JOIN allData dt ON dt.dataId = dText.dataRefId AND dText.dataLanguage = 'FR' INNER JOIN allLists ls ON dt.dataListId = ls.listId INNER JOIN users u1 ON u1.id = dt.dataCreatedby LEFT OUTER JOIN allDataRelationship dtRel ON dtRel.parentId = dt.dataId LEFT OUTER JOIN termStore tm ON tm.termId = dtRel.childId WHERE 1 AND dataLanguage = 'FR' AND listIsForAdmin = 0 AND dataIsValidated = '1' AND dataIsFirstPage = '1' AND dataIsCarrousel = '0' group by dataId having count(dataId) >= 0 order by dataValidationDate desc LIMIT -4, 4
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 '-4, 4' at line 57