(SELECT n.news_id AS id, n.headline, n.source, n.description, n.image1, n.news_type, n.source2, n.source3, n.category_type, n.image2, 0 AS boxno, 0 AS type, n.short_desc, n.news_id AS box_news_id, n.new_url_flag, n.person_name, n.person_designation, n.person_company, n.crawl, n.writer_name, n.source AS source_name, n.source2 AS source2_name, '' AS companytitle, '' AS companyname, '' AS company_name_url, '' AS companyurl, '' AS management_name, '' AS management_name2, '' AS companydesc, 0 AS magazine_id, 0 AS vendorview_status, 0 AS visited_company, '' AS special_cover_image, cat.category_name, cat.shorturl, cat.category_id, 'news' AS data_type FROM news_data n JOIN category cat ON cat.category_id = n.category_type AND cat.web_id = n.web_id WHERE n.web_id = 63 AND cat.category_id = 10 AND n.news_type IN (1,2,5) AND NOT EXISTS (SELECT 1 FROM box_layout_content WHERE news_id = n.news_id AND type=0 AND web_id=63)) UNION ALL (SELECT c.companyid AS id, TRIM(SUBSTRING_INDEX(c.companytitle, ':', -1)) AS headline, '' AS source, '' AS description, c.image AS image1, '' AS news_type, '' AS source2, '' AS source3, '' AS category_type, '' AS image2, 0 AS boxno, 1 AS type, '' AS short_desc, c.companyid AS box_news_id, '' AS new_url_flag, c.person_name, c.person_designation, c.companyname AS person_company, '' AS crawl, '' AS writer_name, '' AS source_name, '' AS source2_name, c.companytitle, c.companyname, c.company_name_url, c.companyurl, c.management_name, c.management_name2, c.companydesc, c.magazine_id, c.vendorview_status, c.visited_company, c.special_cover_image, '' AS category_name, '' AS shorturl, 0 AS category_id, 'company' AS data_type FROM companies c JOIN magazine_details md ON md.sno = c.magazine_id AND md.web_id = c.web_id JOIN category cat ON cat.category_id = md.cat_id AND md.cat_id = 10 AND cat.web_id = c.web_id WHERE cat.status = 1 AND c.web_id = 63 AND cat.category_id = 10 AND ((c.companydesc !='' AND c.companydesc IS NOT NULL) OR (c.column1 !='' AND c.column1 IS NOT NULL)) AND NOT EXISTS (SELECT 1 FROM box_layout_content WHERE news_id = c.companyid AND type=1 AND web_id=63)) ORDER BY data_type ASC, id ASC