Leader

Id
152  
Name
Jonathan Gill  
Job Title
IT Director  
Company
Watchfinder & Co  
Headshot
BPI-Headshot-Jonathan Gill.jpg  
Company Logo
BPI_Logo-Watchfinder.jpg  
Bio Full
<p>Jonathan Gill has spent the last twenty years working in the IT sector, specialising in complex IT systems for the education, health, engineering, accountancy and retail industries. His experience with web front-end systems dates back to 1999, but his core focus is on developing bespoke information management systems.</p> <p>His most recent work has been for Watchfinder &amp; Co., a Sunday Times Virgin Fast Track Hot 100 &lsquo;Ones to Watch&rsquo; company, building the company&rsquo;s entire IT infrastructure to support rapid growth and maintain a stock roster of over &pound;18,000,000 of high-value luxury items across multiple locations while catering to over seven&nbsp;million website visitors each month.<br /><br />Follow Jonathan on Twitter to get his latest and greatest insights!&nbsp;<span class="s1"><a href="https://twitter.com/JonathanGillUK">@<span class="s2">JonathanGillUK</span></a></span><span class="s3">&nbsp;</span></p>  
Created
2015-08-24 08:17:05  
Modified
2015-08-26 07:52:50  
(default) 24 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`.`leaders` AS `Leader` WHERE `Leader`.`id` = 152110
22SELECT `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`, `InnovatorProfile`.`id`, `InnovatorProfile`.`linkedin_url`, `InnovatorProfile`.`summary_bio`, `InnovatorProfile`.`answer_1`, `InnovatorProfile`.`answer_2`, `InnovatorProfile`.`answer_3`, `InnovatorProfile`.`answer_4`, `InnovatorProfile`.`answer_5`, `InnovatorProfile`.`leader_id`, `InnovatorProfile`.`modifier` FROM `bpinorg_dev`.`leaders` AS `Leader` LEFT JOIN `bpinorg_dev`.`innovator_profiles` AS `InnovatorProfile` ON (`InnovatorProfile`.`leader_id` = `Leader`.`id`) WHERE `Leader`.`id` = 152 ORDER BY `Leader`.`company` ASC LIMIT 1110
23SELECT `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`, `LeadersProgram`.`id`, `LeadersProgram`.`leader_id`, `LeadersProgram`.`program_id` FROM `bpinorg_dev`.`programs` AS `Program` JOIN `bpinorg_dev`.`leaders_programs` AS `LeadersProgram` ON (`LeadersProgram`.`leader_id` = 152 AND `LeadersProgram`.`program_id` = `Program`.`id`) 110
24SELECT `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`, `ArticlesLeader`.`id`, `ArticlesLeader`.`article_id`, `ArticlesLeader`.`leader_id` FROM `bpinorg_dev`.`articles` AS `Article` JOIN `bpinorg_dev`.`articles_leaders` AS `ArticlesLeader` ON (`ArticlesLeader`.`leader_id` = 152 AND `ArticlesLeader`.`article_id` = `Article`.`id`) 000