SELECT COUNT(compteur) AS total FROM (select COUNT(*) AS compteur  WHERE 1   AND dataPublicationDate <= now()  AND dtRel.relationTypeId != 361  AND dataListId = 24  AND dataDataId = '0'  AND dataIsValidated = '1'  AND dataIsTerminated = '1'  AND dataIsMyOwn = '0'  GROUP BY dataId HAVING COUNT(dataId) >= 0 ) AS subquery <br />Unknown column 'dtRel.relationTypeId' in 'WHERE'