Unable to main_tweet query.The used SELECT statements have a different number of columns(SELECT tsid,message,tweetid,pubdate,twitpic,tp_active,source FROM twitstars_tweets WHERE tsid=17089921 ) UNION ALL (SELECT tsid,message,tweetid,pubdate,twitpic,tp_active FROM tweet_archive_3 WHERE tsid=17089921 ) ORDER BY STR_TO_DATE(pubdate,'%a %b %e %T %x %Y') DESC