SELECT ROUND(COUNT(*)/5014, 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` <= '2026-04-09 06:40:46'
				GROUP BY t.`tag`
				ORDER BY t.`tag`