Unable to main_tweet query.The used SELECT statements have a different number of columns(SELECT tsid,message,tweetid,pubdate,twitpic,tp_active,source,width,height FROM twitstars_tweets WHERE tsid=29590582 ) UNION (SELECT tsid,message,tweetid,pubdate,twitpic,tp_active FROM tweet_archive_3 WHERE tsid=29590582 ) ORDER BY tweetid DESC