WordPress database error: [Table 'cognitoy_com_blog.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_approved='spam' AND comment_author_IP='38.103.63.16'

WordPress database error: [Table 'cognitoy_com_blog.wp_comments' doesn't exist]
select a.ID as ID, max(b.comment_date_gmt) as LastCommentTime from wp_posts a inner join wp_comments b on a.ID = b.comment_post_id where (a.comment_status = 'open' or a.ping_status = 'open') and b.comment_approved='1' and a.ID >= 30 and a.ID <= 30 group by a.ID

Global Warming Can Be Fun

Saving the planet one game at a time.

Archive for the 'Game marketing' Category


Futures of Entertainment Conference at MIT (updated)

I’m at MIT today (and yesterday) at the Futures of Entertainment Conference.
There are lots of links from that site about what went on. I started to live-blog it, but quickly realized that the rate of idea generation exceeded my ability to type them into coherent form. So all you’re going to get is the […]