SELECT id,data_message,data_link,data_type,data_likes_summary_total_count as data_like_count,DATE_FORMAT(`data_created_time`, '%Y-%m-%d %H:%i:%S') as post_date,data_object_id,'Facebook' as platform FROM `compubrain` where data_message LIKE '%Wishes%' HAVING (post_date < '2100-12-31' AND post_date > '1970-01-01') UNION ALL SELECT id,data_message,data_link,data_type,data_likes as data_like_count,STR_TO_DATE(REPLACE(`data_created_time`,' +0000','') , '%a %b %d %k:%i:%S %Y') as post_date,data_object_id,'Twitter' as platform FROM `Compubrain` where data_message LIKE '%Wishes%' HAVING post_date > ('1970-01-01' AND post_date < '2100-12-31') UNION ALL SELECT id,data_message,data_link,data_type,data_like_count,REPLACE(from_unixtime(`data_created_time`),'.000000','') as post_date,data_post_id as data_object_id,'Instagram' as platform FROM `CompuBrain` where data_message LIKE '%Wishes%' HAVING (post_date < '2100-12-31' AND post_date > '1970-01-01') ORDER BY `post_date` DESC LIMIT 0,12