SELECT DISTINCT `P`.`individual_meta_data`,`PD`.`full_description`,`PD`.`short_description`,`PD`.`meta_description`,`PD`.`meta_keywords`,`PD`.`page_title`,`P`.`guarantees_crm`,`P`.`product_type`,`P`.`product_code`,`C`.`status` as categoryStatus,`C`.`services`,`C`.`category_id`,`CD`.`category`,`COM`.`company`,`CUR`.`price` AS `currency_rate`,IF(`HP`.`created_at`, MAX(`HP`.`created_at`), `P`.`timestamp`) AS `price_update_time`,`P`.`amount`,`P`.`city_id`,`P`.`brand_id`,`P`.`company_id`,`P`.`city_place`,`P`.`conditions`,`P`.`guarantee_id`,`P`.`type_of_sale`,`P`.`product_id`,`P`.`status`,`P`.`year`,`P`.`uniqueSale`,`P`.`is_confiscated`,`P`.`updated_timestamp`,`PC`.`category_id` AS `main_category`,`PD`.`leasingCount`,`PD`.`leasingPrice`,`PD`.`product`,`PP`.`currency`,`PP`.`discount_percent`,`PP`.`price`,`PP`.`recycling_price_rub`,((PP.price * COALESCE(CUR.price, 1)) * (1 - PP.discount_percent / 100) + PP.recycling_price_rub) AS total_price,CASE WHEN `GC`.`compare_id` IS NOT NULL THEN "Y" ELSE "N" END AS `compare`,CASE WHEN `GW`.`wishlist_id` IS NOT NULL THEN "Y" ELSE "N" END AS `wish`,IF(`CITY`.`city_id` IS NULL, 0, 1) as city_priority,CITY.address,(select count(*) from `cscart_product_stocks` where product_id = P.product_id) as stockCount,`B`.`brand`,`B`.`has_subsidy`,`C`.`guarantee_id` AS `category_guarantee_id`,`C`.`guarantee_type`,`C`.`id_path` FROM `cscart_products` AS `P` LEFT JOIN `cscart_guest__wishlist` AS `GW` ON `P`.`product_id` = `GW`.`product_id` AND `GW`.`guest_id` = 0 LEFT JOIN `cscart_guest__compare` AS `GC` ON `P`.`product_id` = `GC`.`product_id` AND `GC`.`guest_id` = 0 LEFT JOIN `cscart_product_stocks` AS `PST` ON `P`.`product_id` = `PST`.`product_id` LEFT JOIN `cscart_company_stocks` AS `CST` ON `PST`.`stock_id` = `CST`.`stock_id` LEFT JOIN `cscart_custom_city` AS `CITY` ON `CITY`.`fias_id` = `CST`.`fias_id` LEFT JOIN `cscart_product_prices_history` AS `HP` ON `HP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_companies` AS `COM` ON `COM`.`company_id` = `P`.`company_id` INNER JOIN `cscart_products_categories` AS `PC` ON `PC`.`product_id` = `P`.`product_id` AND `PC`.`link_type` = 'M' INNER JOIN `cscart_categories` AS `C` ON `C`.`category_id` = `PC`.`category_id` INNER JOIN `cscart_category_descriptions` AS `CD` ON `C`.`category_id` = `CD`.`category_id` LEFT JOIN `cscart_product_prices` AS `PP` ON `PP`.`product_id` = `P`.`product_id` LEFT JOIN `cscart_product_descriptions` AS `PD` ON `PD`.`product_id` = `P`.`product_id` AND `PD`.`lang_code` = 'ru' LEFT JOIN `cscart_currencies` AS `CUR` ON `PP`.`currency` = `CUR`.`currency_code` LEFT JOIN `cscart_brands` AS `B` ON `P`.`brand_id` = `B`.`brand_id` WHERE 1 AND `P`.`product_id` = 26725 AND `P`.`status` = 'A' AND `COM`.`status` = 'A' GROUP BY `P`.`product_id` ORDER BY city_priority DESC,updated_timestamp DESC 

Query is invalid

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7588.41"
    },
    "ordering_operation": {
      "using_filesort": false,
      "grouping_operation": {
        "using_filesort": false,
        "nested_loop": [
          {
            "table": {
              "table_name": "P",
              "access_type": "const",
              "possible_keys": [
                "PRIMARY",
                "status",
                "cscart_products_product_id_index",
                "idx_status"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.00",
                "eval_cost": "0.10",
                "prefix_cost": "0.00",
                "data_read_per_join": "7K"
              },
              "used_columns": [
                "product_id",
                "product_code",
                "product_type",
                "status",
                "company_id",
                "amount",
                "timestamp",
                "updated_timestamp",
                "guarantee_id",
                "conditions",
                "year",
                "city_place",
                "guarantees_crm",
                "city_id",
                "individual_meta_data",
                "brand_id",
                "uniqueSale",
                "is_confiscated",
                "type_of_sale"
              ]
            }
          },
          {
            "table": {
              "table_name": "COM",
              "access_type": "const",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "company_id"
              ],
              "key_length": "4",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.00",
                "eval_cost": "0.10",
                "prefix_cost": "0.00",
                "data_read_per_join": "7K"
              },
              "used_columns": [
                "company_id",
                "status",
                "company"
              ]
            }
          },
          {
            "table": {
              "table_name": "B",
              "access_type": "const",
              "possible_keys": [
                "PRIMARY"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "impossible_on_condition": true,
              "cost_info": {
                "read_cost": "0.00",
                "eval_cost": "0.10",
                "prefix_cost": "0.00",
                "data_read_per_join": "3K"
              },
              "used_columns": [
                "brand_id",
                "brand",
                "has_subsidy"
              ]
            }
          },
          {
            "table": {
              "table_name": "PC",
              "access_type": "ref",
              "possible_keys": [
                "PRIMARY",
                "link_type",
                "pt",
                "idx_pc_product_id_type"
              ],
              "key": "pt",
              "used_key_parts": [
                "product_id",
                "link_type"
              ],
              "key_length": "6",
              "ref": [
                "const",
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "using_index": true,
              "cost_info": {
                "read_cost": "0.25",
                "eval_cost": "0.10",
                "prefix_cost": "0.35",
                "data_read_per_join": "16"
              },
              "used_columns": [
                "product_id",
                "category_id",
                "link_type"
              ]
            }
          },
          {
            "table": {
              "table_name": "CD",
              "access_type": "ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "category_id"
              ],
              "key_length": "3",
              "ref": [
                "dev2.PC.category_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.25",
                "eval_cost": "0.10",
                "prefix_cost": "0.70",
                "data_read_per_join": "4K"
              },
              "used_columns": [
                "category_id",
                "category"
              ]
            }
          },
          {
            "table": {
              "table_name": "PP",
              "access_type": "ref",
              "possible_keys": [
                "usergroup",
                "product_id"
              ],
              "key": "usergroup",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.28",
                "eval_cost": "0.10",
                "prefix_cost": "1.08",
                "data_read_per_join": "248"
              },
              "used_columns": [
                "product_id",
                "price",
                "currency",
                "recycling_price_rub",
                "discount_percent"
              ]
            }
          },
          {
            "table": {
              "table_name": "PD",
              "access_type": "const",
              "possible_keys": [
                "PRIMARY",
                "product_id"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "product_id",
                "lang_code"
              ],
              "key_length": "9",
              "ref": [
                "const",
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.85",
                "eval_cost": "0.10",
                "prefix_cost": "2.03",
                "data_read_per_join": "4K"
              },
              "used_columns": [
                "product_id",
                "lang_code",
                "product",
                "short_description",
                "full_description",
                "meta_keywords",
                "meta_description",
                "page_title",
                "leasingCount",
                "leasingPrice"
              ]
            }
          },
          {
            "table": {
              "table_name": "CUR",
              "access_type": "eq_ref",
              "possible_keys": [
                "currency_code"
              ],
              "key": "currency_code",
              "used_key_parts": [
                "currency_code"
              ],
              "key_length": "12",
              "ref": [
                "dev2.PP.currency"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.25",
                "eval_cost": "0.10",
                "prefix_cost": "2.38",
                "data_read_per_join": "96"
              },
              "used_columns": [
                "currency_code",
                "price"
              ]
            }
          },
          {
            "table": {
              "table_name": "C",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY",
                "p_category_id"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "category_id"
              ],
              "key_length": "3",
              "ref": [
                "dev2.PC.category_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 1,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.62",
                "eval_cost": "0.10",
                "prefix_cost": "3.10",
                "data_read_per_join": "10K"
              },
              "used_columns": [
                "category_id",
                "id_path",
                "guarantee_id",
                "status",
                "services",
                "guarantee_type"
              ]
            }
          },
          {
            "table": {
              "table_name": "GW",
              "access_type": "ALL",
              "rows_examined_per_scan": 48,
              "rows_produced_per_join": 48,
              "filtered": "100.00",
              "using_join_buffer": "hash join",
              "cost_info": {
                "read_cost": "0.26",
                "eval_cost": "4.80",
                "prefix_cost": "8.15",
                "data_read_per_join": "768"
              },
              "used_columns": [
                "wishlist_id",
                "product_id",
                "guest_id"
              ],
              "attached_condition": "<if>(is_not_null_compl(GW), ((`dev2`.`GW`.`guest_id` = 0) and (26725 = `dev2`.`GW`.`product_id`)), true)"
            }
          },
          {
            "table": {
              "table_name": "GC",
              "access_type": "ALL",
              "rows_examined_per_scan": 88,
              "rows_produced_per_join": 4224,
              "filtered": "100.00",
              "using_join_buffer": "hash join",
              "cost_info": {
                "read_cost": "0.57",
                "eval_cost": "422.40",
                "prefix_cost": "431.12",
                "data_read_per_join": "66K"
              },
              "used_columns": [
                "compare_id",
                "guest_id",
                "product_id"
              ],
              "attached_condition": "<if>(is_not_null_compl(GC), ((`dev2`.`GC`.`guest_id` = 0) and (26725 = `dev2`.`GC`.`product_id`)), true)"
            }
          },
          {
            "table": {
              "table_name": "PST",
              "access_type": "ref",
              "possible_keys": [
                "cscart_product_stocks_pk"
              ],
              "key": "cscart_product_stocks_pk",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "4",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 4224,
              "filtered": "100.00",
              "using_index": true,
              "cost_info": {
                "read_cost": "2046.00",
                "eval_cost": "422.40",
                "prefix_cost": "2899.52",
                "data_read_per_join": "99K"
              },
              "used_columns": [
                "product_id",
                "stock_id"
              ]
            }
          },
          {
            "table": {
              "table_name": "CST",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "stock_id"
              ],
              "key_length": "4",
              "ref": [
                "dev2.PST.stock_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 4224,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "0.25",
                "eval_cost": "422.40",
                "prefix_cost": "3322.17",
                "data_read_per_join": "1M"
              },
              "used_columns": [
                "stock_id",
                "fias_id"
              ]
            }
          },
          {
            "table": {
              "table_name": "CITY",
              "access_type": "ref",
              "possible_keys": [
                "idx_custom_city_fias_id"
              ],
              "key": "idx_custom_city_fias_id",
              "used_key_parts": [
                "fias_id"
              ],
              "key_length": "386",
              "ref": [
                "dev2.CST.fias_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 4224,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "1056.00",
                "eval_cost": "422.40",
                "prefix_cost": "4800.57",
                "data_read_per_join": "21M"
              },
              "used_columns": [
                "city_id",
                "address",
                "fias_id"
              ]
            }
          },
          {
            "table": {
              "table_name": "HP",
              "access_type": "ref",
              "possible_keys": [
                "idx_hp_product_id"
              ],
              "key": "idx_hp_product_id",
              "used_key_parts": [
                "product_id"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 4224,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "2365.44",
                "eval_cost": "422.40",
                "prefix_cost": "7588.41",
                "data_read_per_join": "990K"
              },
              "used_columns": [
                "product_id",
                "created_at"
              ]
            }
          }
        ],
        "select_list_subqueries": [
          {
            "dependent": true,
            "cacheable": false,
            "query_block": {
              "select_id": 2,
              "cost_info": {
                "query_cost": "0.58"
              },
              "table": {
                "table_name": "cscart_product_stocks",
                "access_type": "ref",
                "possible_keys": [
                  "cscart_product_stocks_pk",
                  "product_stocks_company_stocks__fk"
                ],
                "key": "cscart_product_stocks_pk",
                "used_key_parts": [
                  "product_id"
                ],
                "key_length": "4",
                "ref": [
                  "const"
                ],
                "rows_examined_per_scan": 1,
                "rows_produced_per_join": 1,
                "filtered": "100.00",
                "using_index": true,
                "cost_info": {
                  "read_cost": "0.48",
                  "eval_cost": "0.10",
                  "prefix_cost": "0.58",
                  "data_read_per_join": "24"
                },
                "used_columns": [
                  "product_id"
                ],
                "attached_condition": "(`dev2`.`cscart_product_stocks`.`product_id` = '26725')"
              }
            }
          }
        ]
      }
    }
  }
}