Program

Id
2  
Title
Grow Smart from the Start  
Subtitle
Planning for Profitable Growth Through Better Management of Core & IT Services  
Description
<p>For community banks and credit unions, it&rsquo;s a whole new world. The economy is finally growing again, but so are the risks and challenges. Interest rates remain near historic lows, but for how long? Spreads are tight and squeezing profitability. Compliance is a bigger, more costly challenge than ever&mdash;especially for smaller institutions. Competition from larger financial services companies and even new players has forced community institutions to think and act differently, particularly about how they cost-effectively use technology to engage and retain customers. Economies of scale are ever more important, making mergers and acquisitions a hot topic of discussion for everyone in the industry.</p> <p>Smarter growth needs to be the mantra for every institution. Rigorous control of non-interest expense, minimizing downstream risks and costs, becoming better positioned to optimize valuations and accretive value in any merger or acquisition&mdash;these are among the challenges bank and credit union executives and their boards must meet.</p> <a href="../../../thought-leadership/studies/56"><img style="margin-top: 20px; margin-bottom: 20px;" src="../../../img/thought-leadership-banners/GrowSmartFromTheStart-Report-Banner_600x150.jpg" alt="" width="100%" /></a> <p><strong>Grow Smart from the Start</strong> is a new thought leadership and research initiative by the Business Performance Innovation Network that examines critical issues and best practices in structuring relationships and contracts with core and IT services vendors to ensure more profitable and valued business outcomes for community financial institutions. <em>Grow Smart from the Start</em> builds on past BPI Network research, developed in partnership with Paladin fs. That research shows that community banks and credit unions have a major opportunity to reduce non-interest expense and improve the accretive value of mergers and acquisition by intelligently restructuring their contracts with core services and IT vendors.</p> <p>Grow Smart from the Start will include new research into this topic and other issues related to managing contracts and relationships with vendors to increase profitable growth, reduce risks, and affordably advance the digital capabilities of community financial institutions.&nbsp;&nbsp;</p>  
Date
2015-04-29  
Created
2013-08-28 14:41:40  
Modified
2016-02-26 14:24:01  
(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` = 2110
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` = 2 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` = 2 AND `ArticlesProgram`.`article_id` = `Article`.`id`) ORDER BY `Article`.`date` DESC 61610
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` = 2 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` = 2 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` = 2 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` = 2 AND `FactsProgram`.`fact_id` = `Fact`.`id`) ORDER BY `Fact`.`date` DESC 18180
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` = 2 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` = 2 AND `MediaCoverageProgram`.`media_coverage_id` = `MediaCoverage`.`id`) ORDER BY `MediaCoverage`.`date` DESC 11110
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` = 2 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` = 2 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` = 2 AND `ProgramsSponsor`.`sponsor_id` = `Sponsor`.`id`) 000
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` = 2 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` = 2 AND `WhitepapersProgram`.`whitepaper_id` = `Whitepaper`.`id`) 770