Browse Top 100 Fonts

SELECT DISTINCT, vendorname, vendorurl, name, fullname, ttf, license, folder, pc, mac, vendor, exception, rating, rate_count, comments, SUM( `downloads` ) AS Total, externaldownload FROM fonts INNER JOIN font_categories ON font_categories.font_id = INNER JOIN font_downloads ON = font_downloads.font_id WHERE donotshow IS NULL AND remove IS NULL AND bad IS NULL AND revise IS NULL AND fonts.pc LIKE '' AND DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= font_downloads.download_date GROUP BY fonts.pc ORDER BY Total DESC
Popular fonts