Trying...
select distinct 'mf' as Who, fa.FamilyID, fa.UniqueName, fo.UniqueName, fa.Name as FamilyName, fo.Name, NULL, NULL from Family fa, FamilyCategoryRelations fcr, Foundry fo where fa.FamilyID = fcr.FamilyID and fcr.CategoryID = 1048 and fa.FoundryID = fo.FoundryID order by fa.PopularSortOrder desc limit 2625,25
Fail: Expression #1 of ORDER BY clause is not in SELECT list, references column 'fontpool_live.fa.PopularSortOrder' which is not in SELECT list; this is incompatible with DISTINCT