1 | SELECT `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 = 1 | | 15 | 15 | 0 |
2 | SELECT `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 8 | | 8 | 8 | 0 |
3 | SELECT `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`) | | 4 | 4 | 0 |
4 | SELECT `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`) | | 0 | 0 | 0 |
5 | SELECT `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`) | | 0 | 0 | 0 |
6 | SELECT `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 4 | | 4 | 4 | 0 |
7 | SELECT `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`) | | 0 | 0 | 0 |
8 | SELECT `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`) | | 0 | 0 | 0 |
9 | SELECT `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`) | | 0 | 0 | 0 |
10 | SELECT `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 3 | | 3 | 3 | 0 |
11 | SELECT `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`) | | 0 | 0 | 0 |
12 | SELECT `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`) | | 1 | 1 | 0 |
13 | SELECT `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-27' ORDER BY `Event`.`date_start` asc LIMIT 3 | | 0 | 0 | 0 |
14 | SELECT `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) | | 2 | 2 | 0 |
15 | SELECT `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) | | 0 | 0 | 0 |
16 | SELECT `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) | | 32 | 32 | 0 |
17 | SELECT `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`) | | 1 | 1 | 0 |
18 | SELECT `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`) | | 0 | 0 | 0 |
19 | SELECT `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`) | | 0 | 0 | 0 |
20 | SELECT `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`) | | 0 | 0 | 0 |
21 | SELECT COUNT(*) AS `count` FROM `bpinorg_dev`.`programs` AS `Program` WHERE `Program`.`id` = 13 | | 1 | 1 | 0 |
22 | SELECT `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` = 13 ORDER BY `date` DESC LIMIT 1 | | 1 | 1 | 0 |
23 | SELECT `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` = 13 AND `ArticlesProgram`.`article_id` = `Article`.`id`) ORDER BY `Article`.`date` DESC | | 34 | 34 | 0 |
24 | SELECT `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` = 13 AND `BlogsProgram`.`blog_id` = `Blog`.`id`) | | 2 | 2 | 0 |
25 | SELECT `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` = 13 AND `BooksProgram`.`book_id` = `Book`.`id`) | | 1 | 1 | 0 |
26 | SELECT `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` = 13 AND `EventsProgram`.`event_id` = `Event`.`id`) ORDER BY `Event`.`date_start` asc | | 0 | 0 | 0 |
27 | SELECT `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` = 13 AND `FactsProgram`.`fact_id` = `Fact`.`id`) ORDER BY `Fact`.`date` DESC | | 9 | 9 | 0 |
28 | SELECT `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` = 13 AND `LeadersProgram`.`leader_id` = `Leader`.`id`) ORDER BY `Leader`.`company` ASC | | 0 | 0 | 0 |
29 | SELECT `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` = 13 AND `MediaCoverageProgram`.`media_coverage_id` = `MediaCoverage`.`id`) ORDER BY `MediaCoverage`.`date` DESC | | 7 | 7 | 0 |
30 | SELECT `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` = 13 AND `ProgramsReport`.`report_id` = `Report`.`id`) | | 1 | 1 | 0 |
31 | SELECT `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` = 13 AND `PartnersProgram`.`partner_id` = `Partner`.`id`) ORDER BY `PartnersProgram`.`postorder` ASC | | 3 | 3 | 0 |
32 | SELECT `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` = 13 AND `ProgramsSponsor`.`sponsor_id` = `Sponsor`.`id`) | | 1 | 1 | 0 |
33 | SELECT `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` = 13 AND `ProgramsSponsor`.`sponsor_id` = `Support`.`id`) WHERE `category` = '3' | | 0 | 0 | 0 |
34 | SELECT `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` = 13 AND `WhitepapersProgram`.`whitepaper_id` = `Whitepaper`.`id`) | | 3 | 3 | 0 |