Browse Top 100 Fonts

SELECT DISTINCT fonts.id, 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 = fonts.id INNER JOIN font_downloads ON fonts.id = font_downloads.font_id WHERE donotshow IS NULL AND remove IS NULL AND bad IS NULL AND revise IS NULL AND fonts.pc LIKE '%.zip' AND DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= font_downloads.download_date GROUP BY fonts.pc ORDER BY Total DESC
Popular fonts