1 | SELECT `Show`.`integration_id` FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE `Show`.`id` = 308 LIMIT 1 | | 1 | 1 | 1 |
2 | SELECT `Integration`.`id`, `Integration`.`tour_id`, `Integration`.`band_id`, `Integration`.`integration_id`, `Tour`.`id`, `Tour`.`tourName`, `Tour`.`headliner_id`, `Tour`.`festivalFlag`, `Band`.`id`, `Band`.`bandName`, `Band`.`webLink` FROM `do_integrations` AS `Integration` LEFT JOIN `do_tours` AS `Tour` ON (`Integration`.`tour_id` = `Tour`.`id`) LEFT JOIN `do_bands` AS `Band` ON (`Integration`.`band_id` = `Band`.`id`) WHERE `integration_id` = 53 | | 1 | 1 | 1 |
3 | SELECT *, month(date) as month, day(date) as day, year(date) as year FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE `Show`.`id` = 308 | | 1 | 1 | 1 |
4 | SELECT `Audio`.`id`, `Audio`.`type`, `Audio`.`show_id`, `Audio`.`taper_id`, `Audio`.`sourceUrl`, `source`.`id`, `source`.`type`, `source`.`show_id`, `source`.`taper_id`, `source`.`sourceUrl` FROM `do_sources` AS `Audio` JOIN `do_sources` AS `source` ON (`source`.`show_id` = 308 AND `source`.`taper_id` = `Audio`.`id`) WHERE `Audio`.`type` = 1 | | 0 | 0 | 1 |
5 | SELECT `Video`.`id`, `Video`.`type`, `Video`.`show_id`, `Video`.`taper_id`, `Video`.`sourceUrl`, `source`.`id`, `source`.`type`, `source`.`show_id`, `source`.`taper_id`, `source`.`sourceUrl` FROM `do_sources` AS `Video` JOIN `do_sources` AS `source` ON (`source`.`show_id` = 308 AND `source`.`taper_id` = `Video`.`id`) WHERE `Video`.`type` = 2 | | 0 | 0 | 0 |
6 | SELECT `Notes`.`id`, `Notes`.`noteText`, `Setlist`.`show_id`, `Setlist`.`song_id`, `Setlist`.`setlistOrder`, `Setlist`.`note_id`, `Setlist`.`creditUser`, `Setlist`.`accuracyMultiplier` FROM `do_notes` AS `Notes` JOIN `do_setlists` AS `Setlist` ON (`Setlist`.`show_id` = 308 AND `Setlist`.`note_id` = `Notes`.`id`) WHERE 1 = 1 ORDER BY `Setlist`.`setlistOrder` ASC | | 0 | 0 | 2 |
7 | SELECT `Songs`.`id`, `Songs`.`songName`, `Songs`.`albumID`, `Songs`.`trackNumber`, `Setlist`.`show_id`, `Setlist`.`song_id`, `Setlist`.`setlistOrder`, `Setlist`.`note_id`, `Setlist`.`creditUser`, `Setlist`.`accuracyMultiplier` FROM `do_songs` AS `Songs` JOIN `do_setlists` AS `Setlist` ON (`Setlist`.`show_id` = 308 AND `Setlist`.`song_id` = `Songs`.`id`) WHERE 1 = 1 ORDER BY `Setlist`.`setlistOrder` ASC | | 8 | 8 | 2 |
8 | SELECT `Show`.`id`, `Show`.`date` FROM `do_shows` AS `Show` LEFT JOIN `do_venues` AS `Venue` ON (`Show`.`venue_id` = `Venue`.`id`) WHERE year(date) = '1997' ORDER BY `date` ASC | | 68 | 68 | 1 |
9 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`h_link`, `Menu`.`type` FROM `do_menus` AS `Menu` WHERE 1 = 1 ORDER BY `id` ASC | | 40 | 40 | 1 |
10 | SELECT year(newsTime) as year, month(newsTime) as month, count(*) as count FROM `do_news` AS `News` WHERE 1 = 1 GROUP BY month, year ORDER BY `year` DESC, `month` DESC | | 31 | 31 | 1 |
11 | SELECT year(date) as year, count(*) as count FROM `do_shows` AS `Shows` WHERE 1 = 1 GROUP BY year(date) | | 13 | 13 | 1 |