Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1 | 6 | 6 | 2 | 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 | 1 | 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` = 'use')) 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` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 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` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 2 | |
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` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 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` = 33 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 33 | 2 | 2 | 2 | |
SELECT `DataStream`.`id`, `DataStream`.`name` FROM `score-1`.`data_streams` AS `DataStream` WHERE 1 = 1 ORDER BY `order` asc | 8 | 8 | 1 | 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` = "use" 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` = (33) ORDER BY `Year`.`year` DESC, `Year`.`data_stream_id` ASC | 5 | 5 | 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` = 12 | 1 | 1 | 3 | maybe slow |
SELECT `Map`.`id`, `Map`.`country_id`, `Map`.`is_default`, `Map`.`type`, `Map`.`map`, `Map`.`note` FROM `score-1`.`maps` AS `Map` WHERE `Map`.`id` = 12 | 1 | 1 | 1 | |
SELECT `Map`.`id`, `Map`.`country_id`, `Map`.`is_default`, `Map`.`type`, `Map`.`map`, `Map`.`note` FROM `score-1`.`maps` AS `Map` WHERE `Map`.`id` = 12 | 1 | 1 | 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` = 12 | 1 | 1 | 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` = 12 | 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` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 1 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 555 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 569 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 570 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 571 | 1 | 1 | 1 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 575 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 619 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 620 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 621 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 622 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 333 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 364 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 365 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 366 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 367 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 368 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 369 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 370 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 371 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 372 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 373 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 374 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 385 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 389 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 323 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 348 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 349 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 350 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 351 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 352 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 353 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 355 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 356 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 357 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 391 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 392 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 393 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 394 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 409 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 410 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 411 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 412 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 413 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 414 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 415 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 416 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 417 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 418 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 419 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 420 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 421 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 422 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 423 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 424 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 425 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 426 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 460 | 1 | 1 | 0 | |
SELECT `Source`.`type`, `Source`.`url`, `Source`.`html`, `Source`.`name`, `Source`.`id` FROM `score-1`.`sources` AS `Source` WHERE `Source`.`id` = 461 | 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` = 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` = 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` = 2 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 2 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 2 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 2 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 2 | 1 | 1 | 0 | |
SELECT `DataStream`.`id`, `DataStream`.`name`, `DataStream`.`order` FROM `score-1`.`data_streams` AS `DataStream` WHERE `DataStream`.`id` = 2 | 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` = 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 `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` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 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` = 575 | 0 | 0 | 14 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 575 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 367 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 323 | 2 | 2 | 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` = 411 | 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` = 411 | 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` = 411 | 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` = 411 | 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` = 411 | 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` = 411 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 417 | 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` = 323 | 2 | 2 | 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` = 417 | 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` = 'ru') 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` = 'ru') 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` = 'ru') 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` = 'ru') WHERE `SimplePage`.`code` = "viz_info" AND `SimplePage`.`country_id` = 33 | 3 | 3 | 5 | 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 (40, 41, 42) | 9 | 9 | 1 | maybe slow |
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 (40, 41, 42) | 9 | 9 | 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 (40, 41, 42) | 9 | 9 | 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 (40, 41, 42) | 9 | 9 | 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` = 'ru') 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` = 'ru') 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` = 'ru') 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` = 'ru') WHERE `SimplePage`.`code` = "viz_info" AND ((`SimplePage`.`country_id` = 0) OR (`SimplePage`.`country_id` IS NULL)) | 8 | 8 | 5 | 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 | 7 | maybe slow |
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 | 1 | |
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 | 2 | maybe slow |
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 | 1 | |