Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'moldova' LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (32) | 2 | 2 | 1 | maybe slow |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (32) | 1 | 1 | 1 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (32) ORDER BY `Dataset`.`year` DESC | 40 | 40 | 2 | maybe slow |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 32 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id`, `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`countries_languages` AS `CountryLanguage` LEFT JOIN `score-1`.`languages` AS `Language` ON (`CountryLanguage`.`language_id` = `Language`.`id`) WHERE `CountryLanguage`.`country_id` = 32 | 1 | 1 | 0 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1 | 6 | 6 | 1 | maybe slow |
SELECT `Country`.`url_param`, `Country`.`name`, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = '1' AND `Country`.`is_published` = '1' ORDER BY `Country`.`weight` ASC | 9 | 9 | 4 | maybe slow |
SELECT Country.id,Country.keywords,Country.description,Country.name,Country.title,Country.logos,Country.data_translations,Country.show_pages,Country.parent_id,Country.svg_map, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE ((`Country`.`id` IS NULL) OR (`Country`.`url_param` = 'moldova')) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (32) | 2 | 2 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (32) | 1 | 1 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (32) ORDER BY `Dataset`.`year` DESC | 40 | 40 | 0 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 32 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards`, `Source`.`id`, `Source`.`url`, `Source`.`html`, `Source`.`source`, `Source`.`name`, `Source`.`type`, (url) AS `Source__source_path` FROM `score-1`.`datasets` AS `Dataset` LEFT JOIN `score-1`.`sources` AS `Source` ON (`Dataset`.`source_id` = `Source`.`id`) WHERE `country` = 32 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 0 | 0 | 4 | maybe slow |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 32 | 0 | 0 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name` FROM `score-1`.`data_streams` AS `DataStream` WHERE 1 = 1 ORDER BY `order` asc | 8 | 8 | 3 | maybe slow |
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = "moldova" LIMIT 1 | 1 | 1 | 1 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (32) ORDER BY `Year`.`year` DESC, `Year`.`data_stream_id` ASC | 2 | 2 | 0 | |
SELECT `Map`.`id`, `Map`.`country_id`, `Map`.`is_default`, `Map`.`type`, `Map`.`map`, `Map`.`note` FROM `score-1`.`maps` AS `Map` WHERE `Map`.`id` = 6 | 1 | 1 | 4 | maybe slow |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (32) ORDER BY `Dataset`.`year` DESC | 40 | 40 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 512 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 515 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 519 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 520 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 531 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 302 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 303 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 304 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 305 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 306 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 307 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 308 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 309 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 310 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 312 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 313 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 314 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 320 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 491 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 493 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 494 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 495 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 496 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 497 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 498 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 499 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 500 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 501 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 502 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 503 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 504 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 505 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 506 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 507 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 508 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 509 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 510 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 511 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 1 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 3 | 1 | 1 | 0 | |
SELECT `Language`.`code`, `Language`.`language`, `Language`.`name`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 32 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 1 | maybe slow |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 302 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `Comparative`.`id`, `Comparative`.`dataset_id`, `Comparative`.`comparative_dataset_id`, `Comparative`.`pct_match`, `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`comparatives` AS `Comparative` LEFT JOIN `score-1`.`datasets` AS `Dataset` ON (`Comparative`.`dataset_id` = `Dataset`.`id`) WHERE `Comparative`.`dataset_id` = 519 | 0 | 0 | 0 | |
SELECT `SimplePage`.`id`, `SimplePage`.`country_id`, `SimplePage`.`code`, `SimplePage`.`title`, `SimplePage`.`key`, `SimplePage`.`content`, `SimplePage`.`created`, `SimplePage`.`modified`, `SimplePage`.`is_active`, `SimplePage`.`keywords`, `SimplePage`.`description`, (`I18n__contentTranslation`.`content`) AS `SimplePage__i18n_contentTranslation`, (`I18n__titleTranslation`.`content`) AS `SimplePage__i18n_titleTranslation`, (`I18n__keywordsTranslation`.`content`) AS `SimplePage__i18n_keywordsTranslation`, (`I18n__descriptionTranslation`.`content`) AS `SimplePage__i18n_descriptionTranslation`, `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`simple_pages` AS `SimplePage` LEFT JOIN `score-1`.`countries` AS `Country` ON (`SimplePage`.`country_id` = `Country`.`id`) INNER JOIN `score-1`.`i18n` AS `I18n__contentTranslation` ON (`SimplePage`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'SimplePage' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__titleTranslation` ON (`SimplePage`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'SimplePage' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__keywordsTranslation` ON (`SimplePage`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'SimplePage' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__descriptionTranslation` ON (`SimplePage`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'SimplePage' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'en') WHERE `SimplePage`.`code` = "viz_info" AND `SimplePage`.`country_id` = 32 | 1 | 1 | 13 | maybe slow |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `score-1`.`i18n` AS `contentTranslation` WHERE `model` = 'SimplePage' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (25) | 3 | 3 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `score-1`.`i18n` AS `titleTranslation` WHERE `model` = 'SimplePage' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (25) | 3 | 3 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `score-1`.`i18n` AS `keywordsTranslation` WHERE `model` = 'SimplePage' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` = (25) | 3 | 3 | 0 | |
SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `score-1`.`i18n` AS `descriptionTranslation` WHERE `model` = 'SimplePage' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (25) | 3 | 3 | 0 | |
SELECT `SimplePage`.`id`, `SimplePage`.`country_id`, `SimplePage`.`code`, `SimplePage`.`title`, `SimplePage`.`key`, `SimplePage`.`content`, `SimplePage`.`created`, `SimplePage`.`modified`, `SimplePage`.`is_active`, `SimplePage`.`keywords`, `SimplePage`.`description`, (`I18n__contentTranslation`.`content`) AS `SimplePage__i18n_contentTranslation`, (`I18n__titleTranslation`.`content`) AS `SimplePage__i18n_titleTranslation`, (`I18n__keywordsTranslation`.`content`) AS `SimplePage__i18n_keywordsTranslation`, (`I18n__descriptionTranslation`.`content`) AS `SimplePage__i18n_descriptionTranslation`, `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`simple_pages` AS `SimplePage` LEFT JOIN `score-1`.`countries` AS `Country` ON (`SimplePage`.`country_id` = `Country`.`id`) INNER JOIN `score-1`.`i18n` AS `I18n__contentTranslation` ON (`SimplePage`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'SimplePage' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__titleTranslation` ON (`SimplePage`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'SimplePage' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__keywordsTranslation` ON (`SimplePage`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'SimplePage' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__descriptionTranslation` ON (`SimplePage`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'SimplePage' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'en') WHERE `SimplePage`.`code` = "viz_info" AND ((`SimplePage`.`country_id` = 0) OR (`SimplePage`.`country_id` IS NULL)) | 8 | 8 | 2 | maybe slow |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `score-1`.`i18n` AS `contentTranslation` WHERE `model` = 'SimplePage' AND `field` = 'content' AND `contentTranslation`.`foreign_key` IN (16, 17, 18, 19, 20, 21, 26, 48) | 26 | 26 | 1 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `score-1`.`i18n` AS `titleTranslation` WHERE `model` = 'SimplePage' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (16, 17, 18, 19, 20, 21, 26, 48) | 26 | 26 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `score-1`.`i18n` AS `keywordsTranslation` WHERE `model` = 'SimplePage' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` IN (16, 17, 18, 19, 20, 21, 26, 48) | 26 | 26 | 0 | |
SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `score-1`.`i18n` AS `descriptionTranslation` WHERE `model` = 'SimplePage' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (16, 17, 18, 19, 20, 21, 26, 48) | 26 | 26 | 0 | |