WordPress database error: [Unknown column 'p.post_author' in 'on clause']
SELECT
p.id as id,
post_title,
post_excerpt,
DATE_FORMAT(start,'%Y%m%dT%H%i%sZ') AS dt_start,
HOUR(end-start) AS duration,
user_nicename
FROM wp_posts p, wp_ec3_schedule s
LEFT JOIN wp_users u
ON u.ID=p.post_author
WHERE post_status = 'publish'
AND p.id = s.post_id
ORDER BY start