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 '%DiwaliVacation%' 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 '%DiwaliVacation%' 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 '%DiwaliVacation%' HAVING (post_date < '2100-12-31' AND post_date > '1970-01-01') ORDER BY `post_date` DESC LIMIT 0,12 CompuBrain | Social Media 2.0 | Best Social Media Agency | Website Designing Company Ahmedabad | Web Designing Agency Surat | Search Engine Optimization Baroda | Social Media Marketing | Digital Media Agency Rajkot | Technology Consultancy Mumbai | Internet Reputation Management in Gujarat | Hosting Services | India
CompuBrain Social Media 2.0 Best Social Media Agency Website Designing Company Ahmedabad Web Designing Agency Surat Search Engine Optimization Baroda Social Media Marketing Digital Media Agency Rajkot Technology Consultancy Mumbai Internet Reputation Management in Gujarat Hosting Services India