AX modelElements in models between build versions

MEcount.sql

SELECT mf.name,
       mf.VersionMajor,
       mf.VersionMinor,
       mf.VersionBuildNo,
       mf.VersionRevision,
       COUNT(*) AS 'Element count'
FROM modelelementdata med
     JOIN modelmanifest mf ON mf.modelid = med.modelid
WHERE mf.VersionBuildNo BETWEEN 1000 AND 3999
GROUP BY mf.name,
         mf.VersionMajor,
         mf.VersionMinor,
         mf.VersionBuildNo,
         mf.VersionRevision;