Program

Id
30  
Title
Powering PDF Users in Banking and Finance  
Subtitle
 
Description
It&rsquo;s all-digital all the time, and this means everyone needs to be a digital content creator, especially in document-heavy banking and finance industries. With social distancing, customers are trafficking in digital information throughout the day. This means employees need to be able to whip up, mark up and share documents as easily, and perhaps more frequently, as handing out documents to customers in an office setting. Printed paper has no place anymore.<br /><br />Yet only a handful of banking and finance employees within a company are PDF power users today. Sky-high software licensing costs and a steep learning curve keep many at bay. Free versions only frustrate users. <br /><br />In today&rsquo;s digital world, banking and finance companies should re-visit their digital document strategy with designs on opening it up to more people. The upside: It&rsquo;s a good time to make sweeping changes, consolidate software, cut costs. Solutions abound that are affordable and user-friendly and can ignite a cadre of power users. <br /><br />Doing More with Digital<br />Let&rsquo;s face it: Fewer and fewer people walk into banks or meet face-to-face with financial advisors. This trend is only going to continue in the age of social distancing. Banking and finance professionals need to be able to communicate effectively and efficiently with customers in a digital way. They need the ability to create and work with documents easily. It&rsquo;s an important piece in a financial company&rsquo;s digital transformation.<br /><br />Corralling Costs<br />In good times, the idea of ripping and replacing software to save some money seemed like a waste of time. But now cutting costs amid dwindling sales and shrinking budgets is absolutely paramount. Everything can and should be scrutinized, including digital content tools. Are you overpaying? Underutilizing? And, most importantly, can you do more for less? <br /><br />Serving Paperless Customers<br />The BPI Network is conducting a survey on banking and finance companies going paperless while empowering employees and saving money in the process. The goal is to identify demand for power PDF users, as well as ways to better support them and increase their ranks. The survey will also seek insight into emerging customer behaviors in regards to digital content within banking and finance industries.  
Date
2020-06-02  
Created
2020-06-02 20:11:57  
Modified
2020-06-02 21:00:15  
(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-06-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` = 30110
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` = 30 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` = 30 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` = 30 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` = 30 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` = 30 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` = 30 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` = 30 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` = 30 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` = 30 AND `ProgramsReport`.`report_id` = `Report`.`id`) 110
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` = 30 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` = 30 AND `ProgramsSponsor`.`sponsor_id` = `Sponsor`.`id`) 220
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` = 30 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` = 30 AND `WhitepapersProgram`.`whitepaper_id` = `Whitepaper`.`id`) 000