Program

Id
31  
Title
Bringing Simplicity To Multi-Cloud Complexity  
Subtitle
Advancing Data Connectivity, Logistics and Value  
Description
<p><strong>Overview</strong></p> <p>The Business Performance Innovation (BPI) Network, in partnership with DBM Cloud Systems and the CMO Council, is undertaking research into the forces, factors, challenges and requirements driving the need for improved data logistics in today&rsquo;s multi-cloud world. Global enterprises are seeking to integrate vast repositories of data across multiple public and private clouds and on-premise systems to extract more value, use and return on these assets. In particular, this relates to decision-support analytics, product and service delivery, customer intelligence and personalized engagement, operational improvement, business compliance, and continuity.</p> <p>While multi-cloud and hybrid cloud environments provide major advantages, they also increase the complexity of managing, translating, processing and moving data. Chief Data Officers, infrastructure IT executives and others in the enterprise are now seeking new and innovative ways to gain greater control, visibility, performance and efficiency in the way they manage data to optimize its value.</p> <p>The program will engage data and IT executives from major companies, as well as leading system integrators, consulting firms and solution providers to understand needs, requirements and best practices in optimizing data economics, protection and logistics in today&rsquo;s multi-cloud, mega-data world.</p> <p><strong>&nbsp;</strong></p> <p><strong>Background</strong></p> <p>The growing importance of the Chief Data Officer underscores widespread recognition of the essential role and value of data and analytics in the modern, agile customer-centric enterprise. This is further compounded by the significant cost, challenge and complexity of unifying, migrating, replicating, protecting, storing and governing data &ldquo;ponds, lakes and dams&rdquo; in today&rsquo;s multi-cloud and hybrid cloud computing environments.</p> <p>Data has become one of the chief engines of value creation. Its role in improving analytical decision making, enhancing our ability to understand, reach and engage customers, and increasing the value of both existing and new products and services has made data a highly valued currency and asset base for enterprises operating digitally across data borders, ramparts and fences.</p> <p>Fueled by an explosive proliferation of new data sources&mdash;from mobile computing, social media and rich media applications and services, to the advent of the Internet of Things, which will generate some 50 million connected sensors by the end of 2020&mdash;the amount and variety of data being stored is growing exponentially.&nbsp; According Seagate Technology, the amount of data generated worldwide will increase to 163 zettabytes by 2025 from 12 zettabytes in 2015.</p> <p>In today&rsquo;s multi-cloud, mega-data world, better Data Logistics and Performance Management (DLPM) has become essential to competing in the Data Economy. According to 451 Research, some 80 percent of companies are now utilizing two or more clouds. Three-quarters of companies say they are pursuing a hybrid/multi-cloud strategy.</p> <p>In this highly distributed compute environment, the requirements to understand where data resides across multiple public clouds and on-premise systems and cost-effectively store, protect and move data to its optimal location becomes critical. With the coming rise of edge computing and micro-data centers designed to bring data and applications closer to users to reduce latency and thereby improve application and workload performance, data management and logistics become even more complex. The edge is creating even more data, with increased data volumes having to be transmitted across networks and between clouds.</p> <p>Object-based data storage is now the dominant storage architecture globally, particularly in the cloud, and will be used to store 85 percent of the world&rsquo;s data by 2025. Developed initially to handle the explosive growth of unstructured data, such as video, images, web pages, log files and IoT data, object storage saves data along with associated metadata in blocks as objects that can contain multiple information formats.</p> <p>It has a variety of advantages over file and block storage, including massive scalability, greater flexibility via metadata for analytics, better governance, faster retrieval, and improved cost efficiencies. In addition, continued technical advances are improving both the performance and the applicability of object storage for new use cases. A major challenge, however, is that the object-based storage systems used my various cloud providers are all different, making data synchronization and translation a challenge.</p> <p>&nbsp;</p> <p><strong>The Data Logistics Mandate</strong></p> <p>In this new world, Chief Data Officers and CIOs must optimize how they manage vast volumes of data across multiple clouds and data environments through better data logistics. There are more data silos, greater distribution of data, vast increases in volume, and a growing demand to understand, protect and exploit data for business growth and optimization while holding down costs.</p> <p>Among those logistical challenges are the need to keep track of where data resides, and cost-effectively synchronize, replicate and move data to optimize value, efficiency, security and governance based on cost differences, processing and analytics capabilities, performance advantages, and regulatory requirements.</p> <p>Organizations need to be able to be able to identify what data needs to be replicated and effectively transmitted and synchronized across different clouds and on-premise locations to improve the availability, security and value of&nbsp;data.</p> <p>For example, organizations increasingly need to move data to specific service providers to conduct analytics or take advantage of specific vendor technologies, lower processing and storage costs, or meet geographic requirements. Particularly when data replication and synchronization is a continuous activity, organizations need to automate this process based on established rules and policies to improve cost efficiency, eliminate errors and reduce management complexity.</p> <p>For object storage data, the capacity to fully utilize metadata to identify location, type and value is now a critical aspect of data logistics, as is the ability to transfer data with a minimum amount of performance degradation and data corruption. New solutions that can handle replication outside of the data path are delivering improved visibility, performance and data quality.</p> <p>Advancing data logistics is a major imperative for today&rsquo;s data-driven organizations and their chief data officers. The mandate to improve data availability, performance, value and cost-efficiency will be a critical competitive differentiator in a multi-cloud, mega-data world.<br /><br /><strong>To get involved in this initiative, please reach out to <a href="mailto:dmurray@bpinetwork.org">Dave Murray</a>.&nbsp;</strong></p>  
Date
2020-08-12  
Created
2020-08-11 21:56:11  
Modified
2020-08-14 18:49:19  
(default) 34 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Menu`.`id`, `Menu`.`slug`, `Menu`.`referrer`, `Menu`.`url`, `Menu`.`report_id`, `Menu`.`other`, `Menu`.`created`, `Menu`.`modified` FROM `bpinorg_dev`.`tracking_routes` AS `Menu` WHERE 1 = 115150
2SELECT `Article`.`id`, `Article`.`date`, `Article`.`title`, `Article`.`author`, `Article`.`publisher`, `Article`.`description`, `Article`.`url`, `Article`.`program_only`, `Article`.`innovator_news`, `Article`.`created`, `Article`.`modified`, `Article`.`modifier` FROM `bpinorg_dev`.`articles` AS `Article` WHERE `Article`.`program_only` = '0' ORDER BY `Article`.`date` DESC LIMIT 8880
3SELECT `Program`.`id`, `Program`.`title`, `Program`.`subtitle`, `Program`.`summary`, `Program`.`description`, `Program`.`image`, `Program`.`thumbnail`, `Program`.`date`, `Program`.`feature`, `Program`.`enable`, `Program`.`created`, `Program`.`modified`, `Program`.`modifier`, `ArticlesProgram`.`id`, `ArticlesProgram`.`program_id`, `ArticlesProgram`.`article_id` FROM `bpinorg_dev`.`programs` AS `Program` JOIN `bpinorg_dev`.`articles_programs` AS `ArticlesProgram` ON (`ArticlesProgram`.`article_id` IN (1365, 1361, 1359, 1360, 1358, 1363, 1354, 1355) AND `ArticlesProgram`.`program_id` = `Program`.`id`) 440
4SELECT `Leader`.`id`, `Leader`.`name`, `Leader`.`job_title`, `Leader`.`company`, `Leader`.`headshot`, `Leader`.`company_logo`, `Leader`.`bio_full`, `Leader`.`summary`, `Leader`.`category`, `Leader`.`featured`, `Leader`.`program_only`, `Leader`.`game_changer_only`, `Leader`.`enable`, `Leader`.`created`, `Leader`.`modified`, `Leader`.`modifier`, `ArticlesLeader`.`id`, `ArticlesLeader`.`article_id`, `ArticlesLeader`.`leader_id` FROM `bpinorg_dev`.`leaders` AS `Leader` JOIN `bpinorg_dev`.`articles_leaders` AS `ArticlesLeader` ON (`ArticlesLeader`.`article_id` IN (1365, 1361, 1359, 1360, 1358, 1363, 1354, 1355) AND `ArticlesLeader`.`leader_id` = `Leader`.`id`) 000
5SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `ArticlesTag`.`id`, `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id` FROM `bpinorg_dev`.`tags` AS `Tag` JOIN `bpinorg_dev`.`articles_tags` AS `ArticlesTag` ON (`ArticlesTag`.`article_id` IN (1365, 1361, 1359, 1360, 1358, 1363, 1354, 1355) AND `ArticlesTag`.`tag_id` = `Tag`.`id`) 000
6SELECT `Article`.`id`, `Article`.`date`, `Article`.`title`, `Article`.`author`, `Article`.`publisher`, `Article`.`description`, `Article`.`url`, `Article`.`program_only`, `Article`.`innovator_news`, `Article`.`created`, `Article`.`modified`, `Article`.`modifier` FROM `bpinorg_dev`.`articles` AS `Article` WHERE `Article`.`innovator_news` = '1' AND `Article`.`program_only` = '0' ORDER BY `Article`.`date` DESC LIMIT 4440
7SELECT `Program`.`id`, `Program`.`title`, `Program`.`subtitle`, `Program`.`summary`, `Program`.`description`, `Program`.`image`, `Program`.`thumbnail`, `Program`.`date`, `Program`.`feature`, `Program`.`enable`, `Program`.`created`, `Program`.`modified`, `Program`.`modifier`, `ArticlesProgram`.`id`, `ArticlesProgram`.`program_id`, `ArticlesProgram`.`article_id` FROM `bpinorg_dev`.`programs` AS `Program` JOIN `bpinorg_dev`.`articles_programs` AS `ArticlesProgram` ON (`ArticlesProgram`.`article_id` IN (1247, 1245, 1244, 1217) AND `ArticlesProgram`.`program_id` = `Program`.`id`) 000
8SELECT `Leader`.`id`, `Leader`.`name`, `Leader`.`job_title`, `Leader`.`company`, `Leader`.`headshot`, `Leader`.`company_logo`, `Leader`.`bio_full`, `Leader`.`summary`, `Leader`.`category`, `Leader`.`featured`, `Leader`.`program_only`, `Leader`.`game_changer_only`, `Leader`.`enable`, `Leader`.`created`, `Leader`.`modified`, `Leader`.`modifier`, `ArticlesLeader`.`id`, `ArticlesLeader`.`article_id`, `ArticlesLeader`.`leader_id` FROM `bpinorg_dev`.`leaders` AS `Leader` JOIN `bpinorg_dev`.`articles_leaders` AS `ArticlesLeader` ON (`ArticlesLeader`.`article_id` IN (1247, 1245, 1244, 1217) AND `ArticlesLeader`.`leader_id` = `Leader`.`id`) 000
9SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `ArticlesTag`.`id`, `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id` FROM `bpinorg_dev`.`tags` AS `Tag` JOIN `bpinorg_dev`.`articles_tags` AS `ArticlesTag` ON (`ArticlesTag`.`article_id` IN (1247, 1245, 1244, 1217) AND `ArticlesTag`.`tag_id` = `Tag`.`id`) 000
10SELECT `Event`.`id`, `Event`.`name`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`date`, `Event`.`not_exact_date`, `Event`.`location`, `Event`.`description`, `Event`.`url`, `Event`.`image`, `Event`.`category`, `Event`.`event_type`, `Event`.`created`, `Event`.`modified`, `Event`.`modifier` FROM `bpinorg_dev`.`events` AS `Event` WHERE `Event`.`category` = 1 ORDER BY `Event`.`date_start` DESC LIMIT 3330
11SELECT `Brainwafe`.`id`, `Brainwafe`.`issue`, `Brainwafe`.`ednote_title`, `Brainwafe`.`ednote_content`, `Brainwafe`.`feature_headshot`, `Brainwafe`.`feature_logo`, `Brainwafe`.`feature_logo_url`, `Brainwafe`.`feature_title`, `Brainwafe`.`feature_subtitle`, `Brainwafe`.`feature_content`, `Brainwafe`.`interview_headshot`, `Brainwafe`.`interview_logo`, `Brainwafe`.`interview_logo_url`, `Brainwafe`.`interview_title`, `Brainwafe`.`interview_subtitle`, `Brainwafe`.`interview_content`, `Brainwafe`.`contributed_title`, `Brainwafe`.`contributed_subtitle`, `Brainwafe`.`contributed_content`, `Brainwafe`.`enable`, `Brainwafe`.`current`, `Brainwafe`.`url_hash`, `Brainwafe`.`modifier`, `BrainwavesEvent`.`id`, `BrainwavesEvent`.`event_id`, `BrainwavesEvent`.`brainwafe_id` FROM `bpinorg_dev`.`brainwaves` AS `Brainwafe` JOIN `bpinorg_dev`.`brainwaves_events` AS `BrainwavesEvent` ON (`BrainwavesEvent`.`event_id` IN (129, 127, 53) AND `BrainwavesEvent`.`brainwafe_id` = `Brainwafe`.`id`) 000
12SELECT `Program`.`id`, `Program`.`title`, `Program`.`subtitle`, `Program`.`summary`, `Program`.`description`, `Program`.`image`, `Program`.`thumbnail`, `Program`.`date`, `Program`.`feature`, `Program`.`enable`, `Program`.`created`, `Program`.`modified`, `Program`.`modifier`, `EventsProgram`.`id`, `EventsProgram`.`event_id`, `EventsProgram`.`program_id` FROM `bpinorg_dev`.`programs` AS `Program` JOIN `bpinorg_dev`.`events_programs` AS `EventsProgram` ON (`EventsProgram`.`event_id` IN (129, 127, 53) AND `EventsProgram`.`program_id` = `Program`.`id`) 110
13SELECT `Event`.`id`, `Event`.`name`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`date`, `Event`.`not_exact_date`, `Event`.`location`, `Event`.`description`, `Event`.`url`, `Event`.`image`, `Event`.`category`, `Event`.`event_type`, `Event`.`created`, `Event`.`modified`, `Event`.`modifier` FROM `bpinorg_dev`.`events` AS `Event` WHERE `Event`.`category` = 0 AND `Event`.`date_end` >= '2025-04-28' ORDER BY `Event`.`date_start` asc LIMIT 3000
14SELECT `Report`.`id`, `Report`.`date`, `Report`.`title`, `Report`.`subtitle`, `Report`.`summary`, `Report`.`author`, `Report`.`body`, `Report`.`upload`, `Report`.`image`, `Report`.`internal`, `Report`.`url`, `Report`.`featured`, `Report`.`program_only`, `Report`.`related`, `Report`.`enable`, `Report`.`created`, `Report`.`modified`, `Report`.`modifier` FROM `bpinorg_dev`.`reports` AS `Report` WHERE `Report`.`id` IN (3, 5)220
15SELECT `Tracking`.`id`, `Tracking`.`referrer`, `Tracking`.`user_id`, `Tracking`.`non_member_id`, `Tracking`.`report_id`, `Tracking`.`report_download`, `Tracking`.`other`, `Tracking`.`date` FROM `bpinorg_dev`.`tracking` AS `Tracking` WHERE `Tracking`.`report_id` IN (3, 5) 000
16SELECT `Download`.`id`, `Download`.`user_id`, `Download`.`non_member_id`, `Download`.`report_id`, `Download`.`tracking_id`, `Download`.`date` FROM `bpinorg_dev`.`reports_download` AS `Download` WHERE `Download`.`report_id` IN (3, 5) 32320
17SELECT `Program`.`id`, `Program`.`title`, `Program`.`subtitle`, `Program`.`summary`, `Program`.`description`, `Program`.`image`, `Program`.`thumbnail`, `Program`.`date`, `Program`.`feature`, `Program`.`enable`, `Program`.`created`, `Program`.`modified`, `Program`.`modifier`, `ProgramsReport`.`id`, `ProgramsReport`.`report_id`, `ProgramsReport`.`program_id` FROM `bpinorg_dev`.`programs` AS `Program` JOIN `bpinorg_dev`.`programs_reports` AS `ProgramsReport` ON (`ProgramsReport`.`report_id` IN (3, 5) AND `ProgramsReport`.`program_id` = `Program`.`id`) 110
18SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `ReportsTag`.`id`, `ReportsTag`.`report_id`, `ReportsTag`.`tag_id` FROM `bpinorg_dev`.`tags` AS `Tag` JOIN `bpinorg_dev`.`reports_tags` AS `ReportsTag` ON (`ReportsTag`.`report_id` IN (3, 5) AND `ReportsTag`.`tag_id` = `Tag`.`id`) 000
19SELECT `MediaCoverage`.`id`, `MediaCoverage`.`date`, `MediaCoverage`.`title`, `MediaCoverage`.`author`, `MediaCoverage`.`summary`, `MediaCoverage`.`publisher`, `MediaCoverage`.`url`, `MediaCoverage`.`created`, `MediaCoverage`.`modified`, `MediaCoverage`.`modifier`, `MediaCoverageReport`.`id`, `MediaCoverageReport`.`media_coverage_id`, `MediaCoverageReport`.`report_id` FROM `bpinorg_dev`.`media_coverage` AS `MediaCoverage` JOIN `bpinorg_dev`.`media_coverage_reports` AS `MediaCoverageReport` ON (`MediaCoverageReport`.`report_id` IN (3, 5) AND `MediaCoverageReport`.`media_coverage_id` = `MediaCoverage`.`id`) 000
20SELECT `Brainwafe`.`id`, `Brainwafe`.`issue`, `Brainwafe`.`ednote_title`, `Brainwafe`.`ednote_content`, `Brainwafe`.`feature_headshot`, `Brainwafe`.`feature_logo`, `Brainwafe`.`feature_logo_url`, `Brainwafe`.`feature_title`, `Brainwafe`.`feature_subtitle`, `Brainwafe`.`feature_content`, `Brainwafe`.`interview_headshot`, `Brainwafe`.`interview_logo`, `Brainwafe`.`interview_logo_url`, `Brainwafe`.`interview_title`, `Brainwafe`.`interview_subtitle`, `Brainwafe`.`interview_content`, `Brainwafe`.`contributed_title`, `Brainwafe`.`contributed_subtitle`, `Brainwafe`.`contributed_content`, `Brainwafe`.`enable`, `Brainwafe`.`current`, `Brainwafe`.`url_hash`, `Brainwafe`.`modifier`, `BrainwavesReport`.`id`, `BrainwavesReport`.`brainwafe_id`, `BrainwavesReport`.`report_id` FROM `bpinorg_dev`.`brainwaves` AS `Brainwafe` JOIN `bpinorg_dev`.`brainwaves_reports` AS `BrainwavesReport` ON (`BrainwavesReport`.`report_id` IN (3, 5) AND `BrainwavesReport`.`brainwafe_id` = `Brainwafe`.`id`) 000
21SELECT COUNT(*) AS `count` FROM `bpinorg_dev`.`programs` AS `Program` WHERE `Program`.`id` = 31110
22SELECT `Program`.`id`, `Program`.`title`, `Program`.`subtitle`, `Program`.`summary`, `Program`.`description`, `Program`.`image`, `Program`.`thumbnail`, `Program`.`date`, `Program`.`feature`, `Program`.`enable`, `Program`.`created`, `Program`.`modified`, `Program`.`modifier` FROM `bpinorg_dev`.`programs` AS `Program` WHERE `Program`.`id` = 31 ORDER BY `date` DESC LIMIT 1110
23SELECT `Article`.`id`, `Article`.`date`, `Article`.`title`, `Article`.`author`, `Article`.`publisher`, `Article`.`description`, `Article`.`url`, `Article`.`program_only`, `Article`.`innovator_news`, `Article`.`created`, `Article`.`modified`, `Article`.`modifier`, `ArticlesProgram`.`id`, `ArticlesProgram`.`program_id`, `ArticlesProgram`.`article_id` FROM `bpinorg_dev`.`articles` AS `Article` JOIN `bpinorg_dev`.`articles_programs` AS `ArticlesProgram` ON (`ArticlesProgram`.`program_id` = 31 AND `ArticlesProgram`.`article_id` = `Article`.`id`) ORDER BY `Article`.`date` DESC 550
24SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`author`, `Blog`.`description`, `Blog`.`url`, `Blog`.`type`, `Blog`.`image`, `Blog`.`program_only`, `Blog`.`featured`, `Blog`.`featured_box1`, `Blog`.`featured_box2`, `Blog`.`feature_image`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`modifier`, `BlogsProgram`.`id`, `BlogsProgram`.`blog_id`, `BlogsProgram`.`program_id` FROM `bpinorg_dev`.`blogs` AS `Blog` JOIN `bpinorg_dev`.`blogs_programs` AS `BlogsProgram` ON (`BlogsProgram`.`program_id` = 31 AND `BlogsProgram`.`blog_id` = `Blog`.`id`) 000
25SELECT `Book`.`id`, `Book`.`date`, `Book`.`title`, `Book`.`author`, `Book`.`publisher`, `Book`.`description`, `Book`.`image`, `Book`.`url`, `Book`.`featured`, `Book`.`program_only`, `Book`.`created`, `Book`.`modified`, `Book`.`modifier`, `BooksProgram`.`id`, `BooksProgram`.`book_id`, `BooksProgram`.`program_id` FROM `bpinorg_dev`.`books` AS `Book` JOIN `bpinorg_dev`.`books_programs` AS `BooksProgram` ON (`BooksProgram`.`program_id` = 31 AND `BooksProgram`.`book_id` = `Book`.`id`) 000
26SELECT `Event`.`id`, `Event`.`name`, `Event`.`date_start`, `Event`.`date_end`, `Event`.`date`, `Event`.`not_exact_date`, `Event`.`location`, `Event`.`description`, `Event`.`url`, `Event`.`image`, `Event`.`category`, `Event`.`event_type`, `Event`.`created`, `Event`.`modified`, `Event`.`modifier`, `EventsProgram`.`id`, `EventsProgram`.`event_id`, `EventsProgram`.`program_id` FROM `bpinorg_dev`.`events` AS `Event` JOIN `bpinorg_dev`.`events_programs` AS `EventsProgram` ON (`EventsProgram`.`program_id` = 31 AND `EventsProgram`.`event_id` = `Event`.`id`) ORDER BY `Event`.`date_start` asc 000
27SELECT `Fact`.`id`, `Fact`.`date`, `Fact`.`title`, `Fact`.`body`, `Fact`.`source`, `Fact`.`url`, `Fact`.`program_only`, `Fact`.`created`, `Fact`.`modified`, `Fact`.`modifier`, `FactsProgram`.`id`, `FactsProgram`.`fact_id`, `FactsProgram`.`program_id` FROM `bpinorg_dev`.`facts` AS `Fact` JOIN `bpinorg_dev`.`facts_programs` AS `FactsProgram` ON (`FactsProgram`.`program_id` = 31 AND `FactsProgram`.`fact_id` = `Fact`.`id`) ORDER BY `Fact`.`date` DESC 550
28SELECT `Leader`.`id`, `Leader`.`name`, `Leader`.`job_title`, `Leader`.`company`, `Leader`.`headshot`, `Leader`.`company_logo`, `Leader`.`bio_full`, `Leader`.`summary`, `Leader`.`category`, `Leader`.`featured`, `Leader`.`program_only`, `Leader`.`game_changer_only`, `Leader`.`enable`, `Leader`.`created`, `Leader`.`modified`, `Leader`.`modifier`, `LeadersProgram`.`id`, `LeadersProgram`.`leader_id`, `LeadersProgram`.`program_id` FROM `bpinorg_dev`.`leaders` AS `Leader` JOIN `bpinorg_dev`.`leaders_programs` AS `LeadersProgram` ON (`LeadersProgram`.`program_id` = 31 AND `LeadersProgram`.`leader_id` = `Leader`.`id`) ORDER BY `Leader`.`company` ASC 000
29SELECT `MediaCoverage`.`id`, `MediaCoverage`.`date`, `MediaCoverage`.`title`, `MediaCoverage`.`author`, `MediaCoverage`.`summary`, `MediaCoverage`.`publisher`, `MediaCoverage`.`url`, `MediaCoverage`.`created`, `MediaCoverage`.`modified`, `MediaCoverage`.`modifier`, `MediaCoverageProgram`.`id`, `MediaCoverageProgram`.`media_coverage_id`, `MediaCoverageProgram`.`program_id` FROM `bpinorg_dev`.`media_coverage` AS `MediaCoverage` JOIN `bpinorg_dev`.`media_coverage_programs` AS `MediaCoverageProgram` ON (`MediaCoverageProgram`.`program_id` = 31 AND `MediaCoverageProgram`.`media_coverage_id` = `MediaCoverage`.`id`) ORDER BY `MediaCoverage`.`date` DESC 000
30SELECT `Report`.`id`, `Report`.`date`, `Report`.`title`, `Report`.`subtitle`, `Report`.`summary`, `Report`.`author`, `Report`.`body`, `Report`.`upload`, `Report`.`image`, `Report`.`internal`, `Report`.`url`, `Report`.`featured`, `Report`.`program_only`, `Report`.`related`, `Report`.`enable`, `Report`.`created`, `Report`.`modified`, `Report`.`modifier`, `ProgramsReport`.`id`, `ProgramsReport`.`report_id`, `ProgramsReport`.`program_id` FROM `bpinorg_dev`.`reports` AS `Report` JOIN `bpinorg_dev`.`programs_reports` AS `ProgramsReport` ON (`ProgramsReport`.`program_id` = 31 AND `ProgramsReport`.`report_id` = `Report`.`id`) 440
31SELECT `Partner`.`id`, `Partner`.`name`, `Partner`.`image`, `Partner`.`description`, `Partner`.`url`, `Partner`.`program_only`, `Partner`.`category`, `Partner`.`created`, `Partner`.`modified`, `Partner`.`modifier`, `PartnersProgram`.`id`, `PartnersProgram`.`program_id`, `PartnersProgram`.`partner_id`, `PartnersProgram`.`postorder` FROM `bpinorg_dev`.`sponsors` AS `Partner` JOIN `bpinorg_dev`.`partners_programs` AS `PartnersProgram` ON (`PartnersProgram`.`program_id` = 31 AND `PartnersProgram`.`partner_id` = `Partner`.`id`) ORDER BY `PartnersProgram`.`postorder` ASC 110
32SELECT `Sponsor`.`id`, `Sponsor`.`name`, `Sponsor`.`image`, `Sponsor`.`description`, `Sponsor`.`url`, `Sponsor`.`program_only`, `Sponsor`.`category`, `Sponsor`.`created`, `Sponsor`.`modified`, `Sponsor`.`modifier`, `ProgramsSponsor`.`id`, `ProgramsSponsor`.`sponsor_id`, `ProgramsSponsor`.`program_id` FROM `bpinorg_dev`.`sponsors` AS `Sponsor` JOIN `bpinorg_dev`.`programs_sponsors` AS `ProgramsSponsor` ON (`ProgramsSponsor`.`program_id` = 31 AND `ProgramsSponsor`.`sponsor_id` = `Sponsor`.`id`) 110
33SELECT `Support`.`id`, `Support`.`name`, `Support`.`image`, `Support`.`description`, `Support`.`url`, `Support`.`program_only`, `Support`.`category`, `Support`.`created`, `Support`.`modified`, `Support`.`modifier`, `ProgramsSponsor`.`id`, `ProgramsSponsor`.`sponsor_id`, `ProgramsSponsor`.`program_id` FROM `bpinorg_dev`.`sponsors` AS `Support` JOIN `bpinorg_dev`.`programs_sponsors` AS `ProgramsSponsor` ON (`ProgramsSponsor`.`program_id` = 31 AND `ProgramsSponsor`.`sponsor_id` = `Support`.`id`) WHERE `category` = '3' 000
34SELECT `Whitepaper`.`id`, `Whitepaper`.`date`, `Whitepaper`.`title`, `Whitepaper`.`publisher`, `Whitepaper`.`description`, `Whitepaper`.`image`, `Whitepaper`.`url`, `Whitepaper`.`program_only`, `Whitepaper`.`created`, `Whitepaper`.`modified`, `Whitepaper`.`modifier`, `WhitepapersProgram`.`id`, `WhitepapersProgram`.`whitepaper_id`, `WhitepapersProgram`.`program_id` FROM `bpinorg_dev`.`whitepapers` AS `Whitepaper` JOIN `bpinorg_dev`.`whitepapers_programs` AS `WhitepapersProgram` ON (`WhitepapersProgram`.`program_id` = 31 AND `WhitepapersProgram`.`whitepaper_id` = `Whitepaper`.`id`) 000