(Re)formule du jour : La Guerre Fratricide

Dans ce numéro de (Re)formule du jour, on va s'intéresser à quelques formulations intéressantes que j'ai pu trouver dans l'extension Guerre Fratricide.

Warning: A non-numeric value encountered in /home/clients/32fa8d9de35b75e5bcdbe40212113964/web/include/php/classes/dataObject.class.php on line 914
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, listWithPicture, 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 52