GUYS I NEED YOUR SUPERIOR SQL SKILLZ.
So I'm busy working on the website for the Greek's band De Profundis
(isn't it sexy?), but I keep getting the following error message on blog posts / gig pages:
WordPress database error: [Unknown column 'p.ID' in 'IN/ALL/ANY subquery']
SELECT ID, post_title FROM wp_posts WHERE post_date < '2008-02-21 21:29:06' AND post_type = 'post' AND post_status = 'publish' AND p.ID NOT IN (SELECT postID FROM wp_gigs_gig) ORDER BY post_date DESC LIMIT 1
I've tried the Wordpress support forum, but no one's replied yet, and I have NO IDEA how to interpret that error message.