EXPLAIN /*!50100 PARTITIONS*/
SELECT t0_.id AS id0, t0_.guid AS guid1, t0_.region_guid AS region_guid2, t0_.active AS active3, t0_.sort AS sort4, t0_.kladr_id AS kladr_id5, t0_.time_difference AS time_difference6, t0_.name AS name7, t0_.online_payment AS online_payment8, t0_.company AS company9, t0_.domain AS domain10, t0_.geoip_alias AS geoip_alias11, t0_.p_date_post AS p_date_post12, t0_.goods_find AS goods_find13, t0_.flag_holidays AS flag_holidays14, t0_.flag_credit AS flag_credit15, t0_.flag_online_trade AS flag_online_trade16, t0_.flag_show_on_selector AS flag_show_on_selector17, t0_.ya_metric_id AS ya_metric_id18, t0_.ya_market_id AS ya_market_id19, t0_.inflect_name AS inflect_name20, t0_.meta_title AS meta_title21, t0_.meta_keywords AS meta_keywords22, t0_.meta_description AS meta_description23, t0_.scale AS scale24, t0_.delivery_default AS delivery_default25, t0_.shipping_days AS shipping_days26, t0_.maximum_total AS maximum_total27, t0_.status_titles AS status_titles28, t1_.id AS id29, t1_.db_sort_field AS db_sort_field30, t1_.scode AS scode31, t1_.name AS name32, t1_.service_name AS service_name33, t1_.active AS active34, t1_.lat AS lat35, t1_.lng AS lng36, t1_.flag_store_shop AS flag_store_shop37, t1_.flag_store_shop_kbt AS flag_store_shop_kbt38, t1_.flag_credit AS flag_credit39, t1_.flag_no_self_delivery AS flag_no_self_delivery40, t1_.flag_no_self_delivery_kbt AS flag_no_self_delivery_kbt41, t1_.flag_on_site AS flag_on_site42, t1_.flag_ignore_update_remains AS flag_ignore_update_remains43, t1_.home_page AS home_page44, t1_.work_time AS work_time45, t1_.ip_addresses AS ip_addresses46, t1_.ws_address AS ws_address47, t1_.ws_dev_address AS ws_dev_address48, t1_.address AS address49, t1_.scheme_trans AS scheme_trans50, t1_.scheme_auto AS scheme_auto51, t1_.description AS description52, t1_.sort AS sort53, t2_.id AS id54, t2_.db_sort_field AS db_sort_field55, t2_.scode AS scode56, t2_.name AS name57, t2_.service_name AS service_name58, t2_.active AS active59, t2_.lat AS lat60, t2_.lng AS lng61, t2_.flag_store_shop AS flag_store_shop62, t2_.flag_store_shop_kbt AS flag_store_shop_kbt63, t2_.flag_credit AS flag_credit64, t2_.flag_no_self_delivery AS flag_no_self_delivery65, t2_.flag_no_self_delivery_kbt AS flag_no_self_delivery_kbt66, t2_.flag_on_site AS flag_on_site67, t2_.flag_ignore_update_remains AS flag_ignore_update_remains68, t2_.home_page AS home_page69, t2_.work_time AS work_time70, t2_.ip_addresses AS ip_addresses71, t2_.ws_address AS ws_address72, t2_.ws_dev_address AS ws_dev_address73, t2_.address AS address74, t2_.scheme_trans AS scheme_trans75, t2_.scheme_auto AS scheme_auto76, t2_.description AS description77, t2_.sort AS sort78, t3_.id AS id79, t3_.name AS name80, t3_.alias AS alias81, t3_.flag_action_block AS flag_action_block82, t3_.flag_callback_block AS flag_callback_block83, t3_.email_addresses AS email_addresses84, t3_.meta_title AS meta_title85, t3_.meta_keywords AS meta_keywords86, t3_.meta_description AS meta_description87, t4_.guid AS guid88, t4_.price_code AS price_code89, t4_.title AS title90, t5_.guid AS guid91, t5_.price_code AS price_code92, t5_.title AS title93, t0_.supplier_id AS supplier_id94, t0_.main_store_id AS main_store_id95, t0_.promo_id AS promo_id96, t0_.price_type_guid AS price_type_guid97, t0_.page_id AS page_id98, t1_.city_id AS city_id99, t2_.city_id AS city_id100, t3_.city_id AS city_id101, t3_.template_id AS template_id102 FROM t_cities t0_ LEFT JOIN t_shops t1_ ON t0_.id = t1_.city_id AND (t1_.active = 1) LEFT JOIN t_shops t2_ ON t0_.supplier_id = t2_.id AND (t2_.active = 1) LEFT JOIN t_shops t6_ ON t0_.main_store_id = t6_.id AND (t6_.active = 1) LEFT JOIN t_promo_page t3_ ON t0_.promo_id = t3_.id LEFT JOIN t_goods_price_types t4_ ON t0_.price_type_guid = t4_.guid LEFT JOIN t_city_price_type t7_ ON t0_.id = t7_.city_id LEFT JOIN t_goods_price_types t5_ ON t5_.guid = t7_.price_type_guid WHERE t0_.active = 1 ORDER BY t0_.sort ASC, t0_.name ASC, t1_.sort ASC\G