SELECT ROUND(COUNT(*)/4967, 1) AS `rank`, t.`tag`, COUNT(*) as `cnt`
				FROM `pixelpost_pixelpost` AS p
					INNER JOIN `pixelpost_tags` AS t ON t.`img_id` = p.`id`
				WHERE t.`tag` IS NOT NULL
				  AND LTRIM(RTRIM(t.`tag`)) != ''
				  AND p.`datetime` <= '2025-07-19 01:57:37'
				GROUP BY t.`tag`
				ORDER BY t.`tag`