(SELECT a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.cs_status,a.category_type,a.image11,b.boxno,a.source3,a.vp_comp_name,a.person_name,a.person_designation,a.person_company,'' as company_name_url,'' as visited_company,'' as section_img,a.new_url_flag,a.crawl FROM news_data a JOIN box_layout_content b ON a.news_id = b.news_id WHERE b.category_id = 166 AND b.boxno = '4' AND b.box_position = 1) union all (SELECT a.companyid AS news_id,trim(SUBSTRING_INDEX(a.companytitle, ':', -1)) as headline,a.management_name AS source,'' AS description,a.image2 AS image1,10 AS news_type,a.management_name2 AS source2,'' AS cs_status,'' AS category_type,'' AS image11,b.boxno,'' AS source3,'' AS vp_comp_name,person_name AS person_name,person_designation AS person_designation,trim(SUBSTRING_INDEX(a.companytitle,':', 1)) as person_company,company_name_url,'' as visited_company, a.section_img,'' as new_url_flag,'' as crawl FROM companies a join box_layout_content b ON a.companyid = b.comp_id WHERE b.category_id = 166 AND b.boxno = '4' AND b.box_position = 1)

(SELECT a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.cs_status,a.category_type,a.image11,b.boxno,a.source3,a.vp_comp_name,a.person_name,a.person_designation,a.person_company,'' as company_name_url,'' as visited_company,'' as section_img,a.new_url_flag,a.crawl FROM news_data a JOIN box_layout_content b ON a.news_id = b.news_id WHERE b.category_id = 166 AND b.boxno = '2' AND b.box_position = 2) union all (SELECT a.companyid AS news_id,trim(SUBSTRING_INDEX(a.companytitle, ':', -1)) as headline,a.management_name AS source,'' AS description,a.image2 AS image1,10 AS news_type,a.management_name2 AS source2,'' AS cs_status,'' AS category_type,'' AS image11,b.boxno,'' AS source3,'' AS vp_comp_name,person_name AS person_name,person_designation AS person_designation,trim(SUBSTRING_INDEX(a.companytitle,':', 1)) as person_company,company_name_url,'' as visited_company, a.section_img,'' as new_url_flag,'' as crawl FROM companies a join box_layout_content b ON a.companyid = b.comp_id WHERE b.category_id = 166 AND b.boxno = '2' AND b.box_position = 2)

(SELECT a.news_id,a.headline,a.source,a.description,a.image1,a.news_type,a.source2,a.cs_status,a.category_type,a.image11,b.boxno,a.source3,a.vp_comp_name,a.person_name,a.person_designation,a.person_company,'' as company_name_url,'' as visited_company,'' as section_img,a.new_url_flag,a.crawl FROM news_data a JOIN box_layout_content b ON a.news_id = b.news_id WHERE b.category_id = 166 AND b.boxno = '3' AND b.box_position = 3) union all (SELECT a.companyid AS news_id,trim(SUBSTRING_INDEX(a.companytitle, ':', -1)) as headline,a.management_name AS source,'' AS description,a.image2 AS image1,10 AS news_type,a.management_name2 AS source2,'' AS cs_status,'' AS category_type,'' AS image11,b.boxno,'' AS source3,'' AS vp_comp_name,person_name AS person_name,person_designation AS person_designation,trim(SUBSTRING_INDEX(a.companytitle,':', 1)) as person_company,company_name_url,'' as visited_company, a.section_img,'' as new_url_flag,'' as crawl FROM companies a join box_layout_content b ON a.companyid = b.comp_id WHERE b.category_id = 166 AND b.boxno = '3' AND b.box_position = 3)