Category Filter - (Silverstripe)

May 28, 2015
05:05

How to Enable a temporary administrator account in SilverStripe CMS

To enable a temporary administrator account in SilverStripe add the following...

Filed under: Silverstripe Tags: Ss

May 28, 2015
05:05

To enable a temporary administrator account in SilverStripe add the following...

Filed under: Silverstripe Tags: Ss

(default) 9 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `posts`	17	17	1
2	DESCRIBE `comments`	11	11	1
3	DESCRIBE `tags`	2	2	1
4	DESCRIBE `categories`	2	2	1
5	DESCRIBE `posts_tags`	2	2	1
6	DESCRIBE `categories_posts`	2	2	1
7	SELECT Post.* FROM posts Post, categories_posts pc, categories c WHERE c.category = ('Silverstripe') AND c.id = pc.category_id AND pc.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	2	2	1
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	1
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	1