(default) 30 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Territory`.`id`, `Territory`.`name` FROM `territories` AS `Territory` WHERE 1 = 1 ORDER BY `name` ASC 24240
2SELECT `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated`, `NewsArticle`.`id`, `NewsArticle`.`category`, `NewsArticle`.`template`, `NewsArticle`.`internal_ref`, `NewsArticle`.`image_id`, `NewsArticle`.`second_image_id`, `NewsArticle`.`third_image_id`, `NewsArticle`.`mobile_image_id`, `NewsArticle`.`created`, `NewsArticle`.`modified`, `NewsArticle`.`show_form`, `CliniciansArticle`.`id`, `CliniciansArticle`.`category`, `CliniciansArticle`.`template`, `CliniciansArticle`.`internal_ref`, `CliniciansArticle`.`image_id`, `CliniciansArticle`.`second_image_id`, `CliniciansArticle`.`third_image_id`, `CliniciansArticle`.`mobile_image_id`, `CliniciansArticle`.`created`, `CliniciansArticle`.`modified`, `CliniciansArticle`.`show_form`, `TechnicalArticle`.`id`, `TechnicalArticle`.`category`, `TechnicalArticle`.`template`, `TechnicalArticle`.`internal_ref`, `TechnicalArticle`.`image_id`, `TechnicalArticle`.`second_image_id`, `TechnicalArticle`.`third_image_id`, `TechnicalArticle`.`mobile_image_id`, `TechnicalArticle`.`created`, `TechnicalArticle`.`modified`, `TechnicalArticle`.`show_form`, `QuestionsArticle`.`id`, `QuestionsArticle`.`category`, `QuestionsArticle`.`template`, `QuestionsArticle`.`internal_ref`, `QuestionsArticle`.`image_id`, `QuestionsArticle`.`second_image_id`, `QuestionsArticle`.`third_image_id`, `QuestionsArticle`.`mobile_image_id`, `QuestionsArticle`.`created`, `QuestionsArticle`.`modified`, `QuestionsArticle`.`show_form`, `PractiseArticle`.`id`, `PractiseArticle`.`category`, `PractiseArticle`.`template`, `PractiseArticle`.`internal_ref`, `PractiseArticle`.`image_id`, `PractiseArticle`.`second_image_id`, `PractiseArticle`.`third_image_id`, `PractiseArticle`.`mobile_image_id`, `PractiseArticle`.`created`, `PractiseArticle`.`modified`, `PractiseArticle`.`show_form`, `GeneralArticle`.`id`, `GeneralArticle`.`category`, `GeneralArticle`.`template`, `GeneralArticle`.`internal_ref`, `GeneralArticle`.`image_id`, `GeneralArticle`.`second_image_id`, `GeneralArticle`.`third_image_id`, `GeneralArticle`.`mobile_image_id`, `GeneralArticle`.`created`, `GeneralArticle`.`modified`, `GeneralArticle`.`show_form`, `PodcastArticle`.`id`, `PodcastArticle`.`category`, `PodcastArticle`.`template`, `PodcastArticle`.`internal_ref`, `PodcastArticle`.`image_id`, `PodcastArticle`.`second_image_id`, `PodcastArticle`.`third_image_id`, `PodcastArticle`.`mobile_image_id`, `PodcastArticle`.`created`, `PodcastArticle`.`modified`, `PodcastArticle`.`show_form` FROM `editions` AS `Edition` LEFT JOIN `articles` AS `NewsArticle` ON (`NewsArticle`.`category` = "Latest news" AND `Edition`.`news_article_id` = `NewsArticle`.`id`) LEFT JOIN `articles` AS `CliniciansArticle` ON (`CliniciansArticle`.`category` = "Practitioners' view" AND `Edition`.`clinicians_article_id` = `CliniciansArticle`.`id`) LEFT JOIN `articles` AS `TechnicalArticle` ON (`TechnicalArticle`.`category` = "Technical update" AND `Edition`.`technical_article_id` = `TechnicalArticle`.`id`) LEFT JOIN `articles` AS `QuestionsArticle` ON (`QuestionsArticle`.`category` = "Your questions answered" AND `Edition`.`questions_article_id` = `QuestionsArticle`.`id`) LEFT JOIN `articles` AS `PractiseArticle` ON (`PractiseArticle`.`category` = "Practice management" AND `Edition`.`practise_article_id` = `PractiseArticle`.`id`) LEFT JOIN `articles` AS `GeneralArticle` ON (`GeneralArticle`.`category` = "General interest" AND `Edition`.`general_article_id` = `GeneralArticle`.`id`) LEFT JOIN `articles` AS `PodcastArticle` ON (`PodcastArticle`.`category` = "Latest podcast" AND `Edition`.`podcast_article_id` = `PodcastArticle`.`id`) WHERE `Edition`.`published` = 1 ORDER BY `Edition`.`created` desc 16160
3SELECT `Territory`.`id`, `Territory`.`name`, `Territory`.`language_id`, `Territory`.`code`, `Territory`.`created`, `Territory`.`modified`, `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id` FROM `territories` AS `Territory` JOIN `editions_territories` AS `EditionsTerritory` ON (`EditionsTerritory`.`edition_id` IN (97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 70, 50, 31, 19, 17, 12) AND `EditionsTerritory`.`territory_id` = `Territory`.`id`) 2442440
4SELECT `Territory`.`name` FROM `territories` AS `Territory` LEFT JOIN `languages` AS `Language` ON (`Territory`.`language_id` = `Language`.`id`) WHERE `Territory`.`id` IS NULL LIMIT 1000
5SELECT `Language`.`id`, `Language`.`name`, `Language`.`language_code`, `Language`.`created`, `Language`.`modified` FROM `languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1110
6SELECT `Territory`.`id`, `Territory`.`name`, `Territory`.`language_id`, `Territory`.`code`, `Territory`.`created`, `Territory`.`modified` FROM `territories` AS `Territory` WHERE `Territory`.`language_id` = (1) 660
7SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 28 ORDER BY `Edition`.`created` desc LIMIT 1110
8SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 26 ORDER BY `Edition`.`created` desc LIMIT 1110
9SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 4 ORDER BY `Edition`.`created` desc LIMIT 1110
10SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 25 ORDER BY `Edition`.`created` desc LIMIT 1110
11SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 12 ORDER BY `Edition`.`created` desc LIMIT 1110
12SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 3 ORDER BY `Edition`.`created` desc LIMIT 1110
13SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 31 ORDER BY `Edition`.`created` desc LIMIT 1110
14SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 5 ORDER BY `Edition`.`created` desc LIMIT 1110
15SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 2 ORDER BY `Edition`.`created` desc LIMIT 1110
16SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 13 ORDER BY `Edition`.`created` desc LIMIT 1110
17SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 14 ORDER BY `Edition`.`created` desc LIMIT 1110
18SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 15 ORDER BY `Edition`.`created` desc LIMIT 1110
19SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 16 ORDER BY `Edition`.`created` desc LIMIT 1110
20SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 29 ORDER BY `Edition`.`created` desc LIMIT 1110
21SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 17 ORDER BY `Edition`.`created` desc LIMIT 1110
22SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 18 ORDER BY `Edition`.`created` desc LIMIT 1110
23SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 19 ORDER BY `Edition`.`created` desc LIMIT 1110
24SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 20 ORDER BY `Edition`.`created` desc LIMIT 1110
25SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 21 ORDER BY `Edition`.`created` desc LIMIT 1110
26SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 27 ORDER BY `Edition`.`created` desc LIMIT 1110
27SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 22 ORDER BY `Edition`.`created` desc LIMIT 1110
28SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 23 ORDER BY `Edition`.`created` desc LIMIT 1110
29SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 24 ORDER BY `Edition`.`created` desc LIMIT 1110
30SELECT `EditionsTerritory`.`id`, `EditionsTerritory`.`edition_id`, `EditionsTerritory`.`territory_id`, `Edition`.`id`, `Edition`.`title`, `Edition`.`news_article_id`, `Edition`.`clinicians_article_id`, `Edition`.`technical_article_id`, `Edition`.`questions_article_id`, `Edition`.`practise_article_id`, `Edition`.`general_article_id`, `Edition`.`podcast_article_id`, `Edition`.`published`, `Edition`.`created`, `Edition`.`modified`, `Edition`.`migrated` FROM `editions_territories` AS `EditionsTerritory` LEFT JOIN `editions` AS `Edition` ON (`EditionsTerritory`.`edition_id` = `Edition`.`id`) WHERE `EditionsTerritory`.`territory_id` = 1 ORDER BY `Edition`.`created` desc LIMIT 1110
(webadmin) 4 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `territories`661
2DESCRIBE `languages`550
3SELECT `Territory`.`id`, `Territory`.`name` FROM `territories` AS `Territory` WHERE 1 = 1 ORDER BY `Territory`.`name` ASC 24240
4SELECT `Language`.`id`, `Language`.`name` FROM `languages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` ASC 16160