SELECT ROUND(COUNT(*)/86, 1) AS `rank`, t.`tag`, COUNT(*) as `cnt`
				FROM `bokeh_pixelpost` AS p
					INNER JOIN `bokeh_tags` AS t ON t.`img_id` = p.`id`
				WHERE t.`tag` IS NOT NULL
				  AND LTRIM(RTRIM(t.`tag`)) != ''
				  AND p.`datetime` <= '2014-10-22 12:27:49'
				GROUP BY t.`tag`
				ORDER BY t.`tag`