Tag Filter - (Html)

Apr 13, 2008
12:04

Common special HTML and ASCII character codes

A list of common special HTML codes used for displaying ASCII character symbols on webpages...

Filed under: Design Tags: Html

(default) 9 queries took 82 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `posts`	17	17	9
2	DESCRIBE `comments`	11	11	4
3	DESCRIBE `tags`	2	2	4
4	DESCRIBE `categories`	2	2	2
5	DESCRIBE `posts_tags`	2	2	20
6	DESCRIBE `categories_posts`	2	2	23
7	SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Html') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	1	1	4
8	SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category	15	15	9
9	SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag	49	49	7

(default) 9 queries took 82 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `posts`

DESCRIBE `comments`

DESCRIBE `tags`

DESCRIBE `categories`

DESCRIBE `posts_tags`

DESCRIBE `categories_posts`

SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Html') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC

SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category

SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag

Tag Filter - (Html)

Common special HTML and ASCII character codes

Categories

Tags

Site Sections

Blog Categories

Latest

Popular