Cutting through the hype.
12 Dec
I’ve got a treat for you readers today! A friend of mine was lucky enough to attend the last Comicon in San Diego and she was nice enough to write a little summary of it to post on the site. I’m green with envy–the pictures make me really wish I could’ve been there. Maybe I’ll have the time and the money when the next one comes around. I certainly plan on trying to get into TGS as soon as finances permit. Major conventions like that are a goldmine of cool stuff no one knows about yet.
Popularity: 31% [?]
Read More >>WordPress database error: [Unknown column 'wp_posts.ID' in 'group statement']
SELECT ID, post_title
FROM wp_posts p
LEFT JOIN wp_term_relationships tr
ON p.ID = tr.object_id
LEFT JOIN wp_term_taxonomy tt
ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN wp_ak_popularity pop
ON p.ID = pop.post_id
WHERE tt.term_id = '6'
AND tt.taxonomy = 'category'
AND post_status = 'publish'
AND post_type = 'post'
AND post_date < NOW()
GROUP BY wp_posts.ID
ORDER BY pop.total DESC
LIMIT 10