Program

Id
8  
Title
Predictability Through Planning Agility  
Subtitle
Best Practices in Collaborative Budgeting and Continuous Business Rebalancing  
Description
<p>Improving the accuracy, value and efficiency of financial planning, forecasting and budgeting should be an important goal for any organization.&nbsp; Research shows companies that are adept in these processes outperform their competition. Yet financial processes and systems frequently lack the agility and responsiveness to keep pace with changing business needs and developments.&nbsp; Budgeting is often excessively time-consuming and arduous, while the final product is typically out-of-date on arrival.&nbsp; Financial planning processes should, but often do not, motivate and drive organizational performance. There is a real need for greater timeliness and frequency in budgeting and forecasting with new systems and processes that can improve planning flexibility, speed, and accuracy. Companies need to determine how they can increase collaboration and the value of financial planning across the entire organization.</p> <p><a title="Download Report Now" href="../../../thought-leadership/studies/49/download-report-predictability-through-planning-agility">Download Report Now &raquo;</a></p> <p>Through the &ldquo;Predictability Through Planning Agility&rdquo; program, the Business Performance Innovation Network will investigate how organizations can make financial processes more relevant in driving organizational excellence, efficiency and decision dexterity, while improving forecasting and budgeting accuracy.&nbsp; The program will look at the value and limitations of corporate financial forecasting and budgeting processes and discuss the right practices and approaches for improving the performance management aspects of financial processes.&nbsp;&nbsp;</p>  
Date
2014-04-17  
Created
2014-04-15 11:29:56  
Modified
2014-12-09 10:44:40  

Actions

Related Articles

Id Date Title Publisher Url Created Modified Actions
670 2015-07-04 9 Money Lessons in Baseball CNN Money http://time.com/money/3944899/money-lessons-baseball/ 2015-07-09 10:48:05 2015-07-09 10:48:05 View Edit Delete
671 2015-07-02 31 Ways Financial Planners Can Make You Richer Go Banking Rates http://www.gobankingrates.com/personal-finance/31-ways-financial-planners-can-make-richer/ 2015-07-09 10:49:06 2015-07-09 10:49:06 View Edit Delete
358 2014-04-15 Cloud Computing Enables Businesses to Discover Their Entrepreneurial Spirit The Guardian http://www.theguardian.com/media-network/media-network-blog/2014/apr/15/cloud-computing-large-businesses-benefit 2014-04-17 12:20:48 2015-02-26 14:38:44 View Edit Delete
359 2014-03-24 H-P's Tech Revamping Begins to Pay Off Wall Street Journal http://online.wsj.com/news/articles/SB10001424052702303949704579459363665663476?mod=WSJ_qtnews_wsjlatest&mg=reno64-wsj 2014-04-17 13:04:20 2014-04-17 13:04:20 View Edit Delete
361 2014-03-21 The cloud continues to kick Oracle's butt -- but not just in technology CITEworld http://www.citeworld.com/article/2115351/business-money/cloud-continues-kick-oracles-butt.html 2014-04-17 15:45:04 2014-04-17 15:45:04 View Edit Delete
363 2013-08-16 CFOs moving past data privacy objections to cloud-based software TechTarget http://searchfinancialapplications.techtarget.com/news/2240204168/CFOs-moving-past-data-privacy-objections-to-cloud-based-software 2014-04-17 15:52:45 2014-04-17 15:52:45 View Edit Delete
362 2013-06-05 Oracle Customers Must ‘Consider All Available Options’ Wall Street Journal http://blogs.wsj.com/cio/2013/06/05/oracle-customers-must-consider-all-available-options/ 2014-04-17 15:48:38 2014-04-17 15:48:38 View Edit Delete
364 2013-03-13 Head of IT at Pandora urges IT to embrace cloud applications TechTarget http://searchfinancialapplications.techtarget.com/feature/Head-of-IT-at-Pandora-urges-IT-to-embrace-cloud-applications 2014-04-17 16:03:17 2014-04-17 16:03:17 View Edit Delete
360 2012-10-04 Corporations looking to the cloud to lower IT costs, replace legacy systems TechJournal http://www.techjournal.org/2012/10/corporations-looking-to-the-cloud-to-lower-it-costs-replace-legacy-systems/ 2014-04-17 13:57:57 2014-04-17 13:57:57 View Edit Delete
357 2009-02-20 Hello, Financial SaaS; Good-bye, IT BusinessFinance http://businessfinancemag.com/blog/hello-financial-saas-good-bye-it 2014-04-17 10:55:07 2014-04-17 12:19:55 View Edit Delete

Related Blogs

Related Books

Related Facts

Id Date Body Source Created Modified Actions
61 2014-04-22

Companies that successfully addressed their planning and forecasting issues saw an average share price growth of 116% over three years, 221% over five years, and 373% over ten years. 

 Cranfield School of Management 2014-04-22 09:47:56 2014-04-22 09:47:56 View Edit Delete
63 2014-04-21

The average corporation spends four months and 20-30% of senior executives’ and financial managers’ time on the budget.

 Beyond Budgeting Round Table 2014-04-22 10:08:01 2014-04-22 10:08:01 View Edit Delete
64 2014-04-20

Companies using spreadsheets for treasury reporting spend an average of 1.8 hours per day on manual and operational tasks, compared with 1.3 hours per day for those with a treasury platform. A few spreadsheet users (6%) spend more than five hours on reporting daily.

 ACT 2014-04-22 10:29:18 2014-04-22 10:29:18 View Edit Delete
65 2014-04-20

Forecasts and budgets are often innaccurate. Despite technological advances, most organizations use a patchwork of spreadsheet models to undertake their forecasting budgeting, with multiple hand-offs and revisions throughout the process. Inaccuracies arise due to lack of version control, transposition of numbers and unallocated numbers with aggregated data not equaling the sum of their parts. 

 Accenture 2014-04-22 10:44:16 2014-04-22 10:44:16 View Edit Delete
62 2014-04-18

The budget process for lower-quartile companies takes longer than six months. Similarily, $1 billion companies take, on average, 25,000 man days to complete their budget.

 Cranfield School of Management 2014-04-22 09:54:24 2014-04-22 10:30:57 View Edit Delete
52 2014-04-16

The acquisition strategy that brought the biggest benefits in 2013 to SaaS small busineses is customer/user referrals (17.2%)

 Groove HQ 2014-04-16 17:54:29 2014-04-16 17:54:29 View Edit Delete
54 2013-06-26

Only 6% of 300 CIO's and IT professionals said they would never move systems to the cloud.

 NTT Europe 2014-04-17 12:31:41 2014-04-17 12:31:41 View Edit Delete
55 2013-05-02

The top business process area that needs technology investment is to facilitate analysis and decision making (59%, up from 57% in 2012), followed by the ongoing monitoring of business performance (50%), and then collaboration and knowledge management (45%, down from 52% in 2012).

 Gartner 2014-04-17 16:46:07 2014-04-17 16:46:07 View Edit Delete
51 2013-03-05

34% of Asia Pacific IT industry executives plan to increase their budgets in SaaS and public cloud within 2013 and 2014.

 Gartner 2014-04-16 17:46:40 2014-04-16 17:52:15 View Edit Delete
53

48 percent of the treasurers and CFOs want SaaS technology to allow them to have better technology and tools.

 Kyriba 2014-04-16 17:58:23 2014-04-16 17:58:23 View Edit Delete

Related Leaders

Id Name Job Title Company Headshot Company Logo Bio Full Created Modified Actions
64 David Axon Managing Director of Strategy Accenture accenture-logo_140x60.jpg 2014-06-10 09:40:26 2014-06-10 09:40:26 View Edit Delete
65 Kevin O'Hare Chief Financial Officer American Internet Services AIS-logo_140x60.jpg 2014-06-10 14:18:16 2014-06-10 14:18:16 View Edit Delete
66 Chris Staines Head of Corporate Finance Grant Thornton gt-logo_140x60.jpg 2014-06-10 14:19:03 2014-06-10 14:19:03 View Edit Delete
68 Tami Gordon Senior Director of Financial Planning and Analytics Jazz Pharmaceuticals jazz-pharmaceuticals-inc-logo_140x60.jpg 2014-06-10 14:21:24 2014-06-10 14:21:24 View Edit Delete
72 John Berger Chief Financial Officer of IT Kaiser Permanente kaiser-permanente-logo_140x60.jpg 2014-06-10 15:26:07 2014-06-10 15:26:07 View Edit Delete
63 Gary Fuchs Chief Financial Officer Powerlinx Powerlinx-Logo-140x60.jpg 2014-06-09 17:23:55 2014-06-09 17:23:55 View Edit Delete
67 Raymond Low Vice President of Finance SciClone Pharmaceuticals sciclone-logo_140x60.jpg 2014-06-10 14:20:02 2014-06-10 14:20:02 View Edit Delete
71 Jonathan Berk Professor of Finance Stanford University stanford-university-logo_140x60.jpg 2014-06-10 14:24:17 2014-06-10 14:24:17 View Edit Delete
70 Rick Odom Senior Vice President, Finance Welch Allyn welch-allyn-logo_140x60.jpg 2014-06-10 14:23:34 2014-06-10 14:23:34 View Edit Delete

Related Media Coverages

Related Reports

Id Date Title Summary Author Body Image Url Created Modified Actions
47 Improve Your Ability To Embrace Business Agility (4 Study Bundle)

Download the entire series of four strategic briefs on improving the accuracy, value and efficiency or financial planning & budgeting.

 BPI Network

Improving the accuracy, value and efficiency of financial planning, forecasting and budgeting should be an important goal for any organization.  Research shows companies that are adept in these processes outperform their competition. Yet financial processes and systems frequently lack the agility and responsiveness to keep pace with changing business needs and developments.  Budgeting is often excessively time-consuming and arduous, while the final product is typically out-of-date on arrival.  Financial planning processes should, but often do not, motivate and drive organizational performance.

How can companies make financial planning and reporting processes more relevant in driving organizational excellence, efficiency and decision dexterity, while improving forecasting and budgeting accuracy? Download these four short strategic briefs published by the Business Performance Innovation (BPI) Network in association with Host Analytics that might spur new thinking and top up your knowledge of cloud-based Enterprise Performance Management (EPM):

  1. Become an Agile Organization – Gain a Competitive Edge Through On-Demand Budgeting and Forecasting
  2. Planning for Growth -- How FORTUNE’s Fastest-Growing Company Harnessed the Cloud for Corporate Agility
  3. From 4 Days to 4 Hours – How to Dramatically Streamline Your Board Reporting Process
  4. No More Spreadsheets – Top 5 Reasons to STOP Using Excel for Planning and Performance Management
 Improve_your_Ability136X176.jpg 2014-06-30 16:38:13 2014-07-17 15:36:02 View Edit Delete
46 From 4 Days To 4 Hours

Improving the accuracy, value and efficiency of financial planning, forecasting and budgeting should be an important goal for any organization.  Research shows companies that are adept in these processes outperform their competition. Yet financial processes and systems frequently lack the agility and responsiveness to keep pace with changing business needs and developments.  Budgeting is often excessively time-consuming and arduous, while the final product is typically out-of-date on arrival.  Financial planning processes should, but often do not, motivate and drive organizational performance.

 BPI Network

Preparing reports for your board of directors is a high-pressure exercise. You’re working under a deadline, with no room for error, yet you want to give the board a complete picture. Here are three ways to shave days off of the board reporting process.

 From_4_Days136X176.jpg https://bpinetwork-org.tradepub.com/c/pubRD.mpl?secure=1&sr=pp&_t=pp:&qf=w_bpin53&ch= 2014-06-30 16:36:35 2021-11-04 18:36:35 View Edit Delete
49 Predictability Through Planning Agility

This report investigates how organizations can make financial processes more relevant in driving organizational excellence, efficiency and informed decision-making, while improving forecast and budget accuracy. 

 Business Performance & Innovation (BPI) Network

Companies are dealing with more complexity than ever before. Competition and markets are no longer local but global in nature. Supply chains are far flung and require the precise orchestration of many moving parts. Businesses are confronting many more variables that can change at a moment’s notice. And economic uncertainty continues to hamper many firms. Achieving continued and accelerated growth requires business leaders to master complexity as part of their daily operations.

Improving the accuracy, value and efficiency of financial planning, forecasting and budgeting should be an important goal for any organization. Research shows that companies that are adept in these processes outperform their competition. Our report investigates how organizations can make financial processes more relevant in driving organizational excellence, efficiency and informed decision-making, while improving forecast and budget accuracy.  The report will look at the value and challenges of corporate forecasting and budgeting processes and discuss the right approaches for improving the performance management aspects of financial processes.  

 predictability-through-planning-agility-thumbnail.jpg 2014-07-29 12:08:30 2014-12-05 08:43:57 View Edit Delete

Related Sponsors

Id Name Image Summary Url Created Modified Actions
34 Host Analytics hostanalytics-logo.jpg https://www.hostanalytics.com/ 2014-04-17 09:49:33 2014-06-09 14:19:26 View Edit Delete
(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-05-22' 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` = 8110
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` = 8 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` = 8 AND `ArticlesProgram`.`article_id` = `Article`.`id`) ORDER BY `Article`.`date` DESC 10100
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` = 8 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` = 8 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` = 8 AND `EventsProgram`.`event_id` = `Event`.`id`) ORDER BY `Event`.`date_start` asc 110
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` = 8 AND `FactsProgram`.`fact_id` = `Fact`.`id`) ORDER BY `Fact`.`date` DESC 10100
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` = 8 AND `LeadersProgram`.`leader_id` = `Leader`.`id`) ORDER BY `Leader`.`company` ASC 990
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` = 8 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` = 8 AND `ProgramsReport`.`report_id` = `Report`.`id`) 330
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` = 8 AND `PartnersProgram`.`partner_id` = `Partner`.`id`) ORDER BY `PartnersProgram`.`postorder` ASC 000
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` = 8 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` = 8 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` = 8 AND `WhitepapersProgram`.`whitepaper_id` = `Whitepaper`.`id`) 220