Symfony Profiler

SELECT
  c0_.`id` AS id_0,
  c0_.`url` AS url_1,
  c0_.`code` AS code_2,
  c0_.`name` AS name_3,
  c0_.`alternate_name` AS alternate_name_4,
  c0_.`name_full` AS name_full_5,
  f1_.`id` AS id_6,
  f1_.`url` AS url_7,
  f1_.`unid` AS unid_8,
  f2_.`id` AS id_9,
  f1_.`url` AS url_10,
  f1_.`name` AS name_11,
  (
    SELECT
      COUNT(p3_.`star`) AS sclr_13
    FROM
      `product_reviews_cache` p3_
    WHERE
      p3_.`sku` = c0_.`code`
  ) AS sclr_12,
  (
    SELECT
      SUM(p4_.`star`) AS sclr_15
    FROM
      `product_reviews_cache` p4_
    WHERE
      p4_.`sku` = c0_.`code`
  ) AS sclr_14
FROM
  `collection` c0_
  INNER JOIN `factory` f1_ ON c0_.factory = f1_.id
  INNER JOIN `filters` f2_ ON f1_.filter = f2_.id
  INNER JOIN `list_country` l5_ ON f1_.country = l5_.id
  LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id
  LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id
WHERE
  f1_.filter IS NOT NULL
  AND c0_.factory <> ''
  AND f1_.`status` = ?
  AND f1_.`id` NOT IN (?)
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND c0_.`status` = ?
  AND c0_.`status` = ?
  AND f1_.`status` = ?
ORDER BY
  c0_.`id` ASC

SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = 1 AND f1_.`id` NOT IN (14) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = 1 AND c0_.`status` = 1 AND f1_.`status` = 1 ORDER BY c0_.`id` ASC;

SELECT
  f0_.`id` AS id_0,
  f0_.`name` AS name_1,
  f0_.`alt_name` AS alt_name_2,
  f0_.`left_menu` AS left_menu_3,
  f0_.`sort` AS sort_4,
  f0_.`important` AS important_5,
  f0_.`old_command` AS old_command_6,
  f0_.`old_id` AS old_id_7,
  f0_.`sub_key` AS sub_key_8,
  f0_.`parent_key` AS parent_key_9,
  f0_.`rank` AS rank_10,
  f0_.`icon` AS icon_11,
  f0_.`icon_url` AS icon_url_12,
  f0_.`logo` AS logo_13,
  f0_.`logo_url` AS logo_url_14,
  f0_.`created_at` AS created_at_15,
  f0_.`updated_at` AS updated_at_16,
  l1_.`id` AS id_17,
  l1_.`source` AS source_18,
  l1_.`ru` AS ru_19,
  l1_.`en` AS en_20,
  l1_.`it` AS it_21,
  l1_.`es` AS es_22,
  l1_.`fr` AS fr_23,
  l1_.`de` AS de_24,
  l1_.`pl` AS pl_25,
  l1_.`pt` AS pt_26,
  l1_.`nl` AS nl_27,
  l1_.`fi` AS fi_28,
  l1_.`ua` AS ua_29,
  l1_.`sv` AS sv_30,
  l1_.`no` AS no_31,
  l1_.`da` AS da_32,
  l1_.`cn` AS cn_33,
  l1_.`zh` AS zh_34,
  l1_.`created_at` AS created_at_35,
  l1_.`updated_at` AS updated_at_36,
  f2_.`id` AS id_37,
  f2_.`name` AS name_38,
  f2_.`alt_name` AS alt_name_39,
  f2_.`name_single_source` AS name_single_source_40,
  f2_.`name_single_ru` AS name_single_ru_41,
  f2_.`name_single_en` AS name_single_en_42,
  f2_.`name_single_it` AS name_single_it_43,
  f2_.`name_single_es` AS name_single_es_44,
  f2_.`name_single_fr` AS name_single_fr_45,
  f2_.`name_single_de` AS name_single_de_46,
  f2_.`name_single_pl` AS name_single_pl_47,
  f2_.`name_single_pt` AS name_single_pt_48,
  f2_.`name_single_nl` AS name_single_nl_49,
  f2_.`name_single_fi` AS name_single_fi_50,
  f2_.`name_single_ua` AS name_single_ua_51,
  f2_.`name_single_sv` AS name_single_sv_52,
  f2_.`name_single_no` AS name_single_no_53,
  f2_.`name_single_da` AS name_single_da_54,
  f2_.`name_single_usa` AS name_single_usa_55,
  f2_.`name_single_cn` AS name_single_cn_56,
  f2_.`name_single_zh` AS name_single_zh_57,
  f2_.`name_many_source` AS name_many_source_58,
  f2_.`name_many_ru` AS name_many_ru_59,
  f2_.`name_many_en` AS name_many_en_60,
  f2_.`name_many_it` AS name_many_it_61,
  f2_.`name_many_es` AS name_many_es_62,
  f2_.`name_many_fr` AS name_many_fr_63,
  f2_.`name_many_de` AS name_many_de_64,
  f2_.`name_many_pl` AS name_many_pl_65,
  f2_.`name_many_pt` AS name_many_pt_66,
  f2_.`name_many_nl` AS name_many_nl_67,
  f2_.`name_many_fi` AS name_many_fi_68,
  f2_.`name_many_ua` AS name_many_ua_69,
  f2_.`name_many_sv` AS name_many_sv_70,
  f2_.`name_many_no` AS name_many_no_71,
  f2_.`name_many_da` AS name_many_da_72,
  f2_.`name_many_usa` AS name_many_usa_73,
  f2_.`name_many_cn` AS name_many_cn_74,
  f2_.`name_many_zh` AS name_many_zh_75,
  f2_.`name_menu_source` AS name_menu_source_76,
  f2_.`name_menu_ru` AS name_menu_ru_77,
  f2_.`name_menu_en` AS name_menu_en_78,
  f2_.`name_menu_it` AS name_menu_it_79,
  f2_.`name_menu_es` AS name_menu_es_80,
  f2_.`name_menu_fr` AS name_menu_fr_81,
  f2_.`name_menu_de` AS name_menu_de_82,
  f2_.`name_menu_pl` AS name_menu_pl_83,
  f2_.`name_menu_pt` AS name_menu_pt_84,
  f2_.`name_menu_nl` AS name_menu_nl_85,
  f2_.`name_menu_fi` AS name_menu_fi_86,
  f2_.`name_menu_ua` AS name_menu_ua_87,
  f2_.`name_menu_sv` AS name_menu_sv_88,
  f2_.`name_menu_no` AS name_menu_no_89,
  f2_.`name_menu_da` AS name_menu_da_90,
  f2_.`name_menu_usa` AS name_menu_usa_91,
  f2_.`name_menu_cn` AS name_menu_cn_92,
  f2_.`name_menu_zh` AS name_menu_zh_93,
  f2_.`description_source` AS description_source_94,
  f2_.`description_ru` AS description_ru_95,
  f2_.`description_en` AS description_en_96,
  f2_.`description_it` AS description_it_97,
  f2_.`description_es` AS description_es_98,
  f2_.`description_fr` AS description_fr_99,
  f2_.`description_de` AS description_de_100,
  f2_.`description_pl` AS description_pl_101,
  f2_.`description_pt` AS description_pt_102,
  f2_.`description_nl` AS description_nl_103,
  f2_.`description_fi` AS description_fi_104,
  f2_.`description_ua` AS description_ua_105,
  f2_.`description_sv` AS description_sv_106,
  f2_.`description_no` AS description_no_107,
  f2_.`description_da` AS description_da_108,
  f2_.`description_usa` AS description_usa_109,
  f2_.`description_cn` AS description_cn_110,
  f2_.`description_zh` AS description_zh_111,
  f2_.`keywords_source` AS keywords_source_112,
  f2_.`keywords_ru` AS keywords_ru_113,
  f2_.`keywords_en` AS keywords_en_114,
  f2_.`keywords_it` AS keywords_it_115,
  f2_.`keywords_es` AS keywords_es_116,
  f2_.`keywords_fr` AS keywords_fr_117,
  f2_.`keywords_de` AS keywords_de_118,
  f2_.`keywords_pl` AS keywords_pl_119,
  f2_.`keywords_pt` AS keywords_pt_120,
  f2_.`keywords_nl` AS keywords_nl_121,
  f2_.`keywords_fi` AS keywords_fi_122,
  f2_.`keywords_ua` AS keywords_ua_123,
  f2_.`keywords_sv` AS keywords_sv_124,
  f2_.`keywords_no` AS keywords_no_125,
  f2_.`keywords_da` AS keywords_da_126,
  f2_.`keywords_usa` AS keywords_usa_127,
  f2_.`keywords_cn` AS keywords_cn_128,
  f2_.`keywords_zh` AS keywords_zh_129,
  f2_.`html_source` AS html_source_130,
  f2_.`html_ru` AS html_ru_131,
  f2_.`html_en` AS html_en_132,
  f2_.`html_it` AS html_it_133,
  f2_.`html_es` AS html_es_134,
  f2_.`html_fr` AS html_fr_135,
  f2_.`html_de` AS html_de_136,
  f2_.`html_pl` AS html_pl_137,
  f2_.`html_pt` AS html_pt_138,
  f2_.`html_nl` AS html_nl_139,
  f2_.`html_fi` AS html_fi_140,
  f2_.`html_ua` AS html_ua_141,
  f2_.`html_sv` AS html_sv_142,
  f2_.`html_no` AS html_no_143,
  f2_.`html_da` AS html_da_144,
  f2_.`html_usa` AS html_usa_145,
  f2_.`html_cn` AS html_cn_146,
  f2_.`html_zh` AS html_zh_147,
  f3_.`id` AS id_148,
  f3_.`alt_name` AS alt_name_149,
  f3_.`count` AS count_150,
  f3_.`hide` AS hide_151,
  f3_.`hide_all` AS hide_all_152,
  f3_.`is_enable` AS is_enable_153,
  f3_.`show_footer` AS show_footer_154,
  f3_.`show_menu` AS show_menu_155,
  f3_.`show_menu_advanced` AS show_menu_advanced_156,
  f3_.`hex_code` AS hex_code_157,
  f3_.`code` AS code_158,
  f3_.`phone_code` AS phone_code_159,
  f3_.`link` AS link_160,
  f4_.`id` AS id_161,
  f4_.`unid` AS unid_162,
  f4_.`name` AS name_163,
  f4_.`name_inv` AS name_inv_164,
  f4_.`url` AS url_165,
  f4_.`alternate_name` AS alternate_name_166,
  f4_.`description_ru` AS description_ru_167,
  f4_.`description_en` AS description_en_168,
  f4_.`description_it` AS description_it_169,
  f4_.`description_es` AS description_es_170,
  f4_.`description_fr` AS description_fr_171,
  f4_.`description_de` AS description_de_172,
  f4_.`description_pt` AS description_pt_173,
  f4_.`description_pl` AS description_pl_174,
  f4_.`description_nl` AS description_nl_175,
  f4_.`description_fi` AS description_fi_176,
  f4_.`description_ua` AS description_ua_177,
  f4_.`description_sv` AS description_sv_178,
  f4_.`description_no` AS description_no_179,
  f4_.`description_da` AS description_da_180,
  f4_.`description_zh` AS description_zh_181,
  f4_.`delivery_time` AS delivery_time_182,
  f4_.`not_regular` AS not_regular_183,
  f4_.`suspended` AS suspended_184,
  f4_.`status` AS status_185,
  f4_.`type` AS type_186,
  f4_.`discount` AS discount_187,
  f4_.`discount_date_start` AS discount_date_start_188,
  f4_.`discount_date_end` AS discount_date_end_189,
  f4_.`transcription` AS transcription_190,
  f4_.`cost_delivery` AS cost_delivery_191,
  f4_.`create_date` AS create_date_192,
  f4_.`is_accepted` AS is_accepted_193,
  f4_.`accepted_at` AS accepted_at_194,
  f4_.`accept_state` AS accept_state_195,
  f4_.`description_edit` AS description_edit_196,
  f4_.`stated_at` AS stated_at_197,
  f4_.`state` AS state_198,
  f4_.`description_state` AS description_state_199,
  f4_.`video` AS video_200,
  f4_.`parser_address` AS parser_address_201,
  f4_.`accessible` AS accessible_202,
  f4_.`sound` AS sound_203,
  f4_.`test_access` AS test_access_204,
  f4_.`total_ideas` AS total_ideas_205,
  f4_.`votes_submit` AS votes_submit_206,
  f4_.`votes_stars` AS votes_stars_207,
  f4_.`brand_link` AS brand_link_208,
  f4_.`brand_logo` AS brand_logo_209,
  f4_.`no_send_portl_message` AS no_send_portl_message_210,
  f5_.`id` AS id_211,
  f5_.`alt_name` AS alt_name_212,
  f5_.`left_menu` AS left_menu_213,
  f5_.`sort` AS sort_214,
  f5_.`is_enable` AS is_enable_215,
  f5_.`show_footer` AS show_footer_216,
  f5_.`show_menu` AS show_menu_217,
  f5_.`show_menu_advanced` AS show_menu_advanced_218,
  a6_.`id` AS id_219,
  a6_.`code` AS code_220,
  a6_.`name` AS name_221,
  a6_.`alternate_name` AS alternate_name_222,
  a6_.`urla` AS urla_223,
  a6_.`file` AS file_224,
  a6_.`size_x` AS size_x_225,
  a6_.`size_y` AS size_y_226,
  a6_.`size_gb_x` AS size_gb_x_227,
  a6_.`size_gb_y` AS size_gb_y_228,
  a6_.`size_tessera` AS size_tessera_229,
  a6_.`file_size1_x` AS file_size1_x_230,
  a6_.`file_size1_y` AS file_size1_y_231,
  a6_.`file_size2_x` AS file_size2_x_232,
  a6_.`file_size2_y` AS file_size2_y_233,
  a6_.`file_size3_x` AS file_size3_x_234,
  a6_.`file_size3_y` AS file_size3_y_235,
  a6_.`file_size500_x` AS file_size500_x_236,
  a6_.`file_size500_y` AS file_size500_y_237,
  a6_.`file_size740_x` AS file_size740_x_238,
  a6_.`file_size740_y` AS file_size740_y_239,
  a6_.`file_size8_x` AS file_size8_x_240,
  a6_.`file_size8_y` AS file_size8_y_241,
  a6_.`pallet` AS pallet_242,
  a6_.`pallet_ft` AS pallet_ft_243,
  a6_.`type_constraint` AS type_constraint_244,
  a6_.`multiple_pallet` AS multiple_pallet_245,
  a6_.`min_order` AS min_order_246,
  a6_.`price_euro` AS price_euro_247,
  a6_.`price_mq_euro` AS price_mq_euro_248,
  a6_.`price_euro_de` AS price_euro_de_249,
  a6_.`price_mq_euro_de` AS price_mq_euro_de_250,
  a6_.`price_euro_at` AS price_euro_at_251,
  a6_.`price_mq_euro_at` AS price_mq_euro_at_252,
  a6_.`price_euro_fi` AS price_euro_fi_253,
  a6_.`price_mq_euro_fi` AS price_mq_euro_fi_254,
  a6_.`price_euro_fr` AS price_euro_fr_255,
  a6_.`price_mq_euro_fr` AS price_mq_euro_fr_256,
  a6_.`price_euro_it` AS price_euro_it_257,
  a6_.`price_mq_euro_it` AS price_mq_euro_it_258,
  a6_.`price_euro_be` AS price_euro_be_259,
  a6_.`price_mq_euro_be` AS price_mq_euro_be_260,
  a6_.`price_euro_ie` AS price_euro_ie_261,
  a6_.`price_mq_euro_ie` AS price_mq_euro_ie_262,
  a6_.`price_euro_nl` AS price_euro_nl_263,
  a6_.`price_mq_euro_nl` AS price_mq_euro_nl_264,
  a6_.`price_euro_es` AS price_euro_es_265,
  a6_.`price_mq_euro_es` AS price_mq_euro_es_266,
  a6_.`price_rub` AS price_rub_267,
  a6_.`price_rue` AS price_rue_268,
  a6_.`price_mq_rub` AS price_mq_rub_269,
  a6_.`price_mq_rue` AS price_mq_rue_270,
  a6_.`price_gbp` AS price_gbp_271,
  a6_.`price_gbe` AS price_gbe_272,
  a6_.`price_mq_gbp` AS price_mq_gbp_273,
  a6_.`price_mq_gbe` AS price_mq_gbe_274,
  a6_.`price_usd` AS price_usd_275,
  a6_.`price_use` AS price_use_276,
  a6_.`price_fq_usd` AS price_fq_usd_277,
  a6_.`price_fq_use` AS price_fq_use_278,
  a6_.`price_mq_usd` AS price_mq_usd_279,
  a6_.`price_mq_use` AS price_mq_use_280,
  a6_.`price_chf` AS price_chf_281,
  a6_.`price_che` AS price_che_282,
  a6_.`price_mq_chf` AS price_mq_chf_283,
  a6_.`price_mq_che` AS price_mq_che_284,
  a6_.`price_sek` AS price_sek_285,
  a6_.`price_see` AS price_see_286,
  a6_.`price_mq_sek` AS price_mq_sek_287,
  a6_.`price_mq_see` AS price_mq_see_288,
  a6_.`price_dkk` AS price_dkk_289,
  a6_.`price_dke` AS price_dke_290,
  a6_.`price_mq_dkk` AS price_mq_dkk_291,
  a6_.`price_mq_dke` AS price_mq_dke_292,
  a6_.`price_nok` AS price_nok_293,
  a6_.`price_noe` AS price_noe_294,
  a6_.`price_mq_nok` AS price_mq_nok_295,
  a6_.`price_mq_noe` AS price_mq_noe_296,
  a6_.`price_pln` AS price_pln_297,
  a6_.`price_ple` AS price_ple_298,
  a6_.`price_mq_pln` AS price_mq_pln_299,
  a6_.`price_mq_ple` AS price_mq_ple_300,
  a6_.`price_cad` AS price_cad_301,
  a6_.`price_cae` AS price_cae_302,
  a6_.`price_fq_cad` AS price_fq_cad_303,
  a6_.`price_fq_cae` AS price_fq_cae_304,
  a6_.`price_mq_cad` AS price_mq_cad_305,
  a6_.`price_mq_cae` AS price_mq_cae_306,
  a6_.`thick` AS thick_307,
  a6_.`weight` AS weight_308,
  a6_.`packaging_count` AS packaging_count_309,
  a6_.`packaging_count_ft` AS packaging_count_ft_310,
  a6_.`packaging_count_pc` AS packaging_count_pc_311,
  a6_.`m2one_ps` AS m2one_ps_312,
  a6_.`description_ru` AS description_ru_313,
  a6_.`description_en` AS description_en_314,
  a6_.`description_it` AS description_it_315,
  a6_.`description_es` AS description_es_316,
  a6_.`description_fr` AS description_fr_317,
  a6_.`description_de` AS description_de_318,
  a6_.`description_pt` AS description_pt_319,
  a6_.`description_pl` AS description_pl_320,
  a6_.`description_nl` AS description_nl_321,
  a6_.`description_fi` AS description_fi_322,
  a6_.`description_ua` AS description_ua_323,
  a6_.`description_sv` AS description_sv_324,
  a6_.`description_no` AS description_no_325,
  a6_.`description_da` AS description_da_326,
  a6_.`description_cn` AS description_cn_327,
  a6_.`scheme` AS scheme_328,
  a6_.`sale_date` AS sale_date_329,
  a6_.`thin_granite` AS thin_granite_330,
  a6_.`glazed_granite` AS glazed_granite_331,
  a6_.`pei` AS pei_332,
  a6_.`is_grouped` AS is_grouped_333,
  a6_.`is_rotate` AS is_rotate_334,
  a6_.`price_prx` AS price_prx_335,
  a6_.`background_white` AS background_white_336,
  a6_.`border_grey` AS border_grey_337,
  a6_.`is_edit` AS is_edit_338,
  a6_.`edited_at` AS edited_at_339,
  a6_.`comment` AS comment_340,
  a6_.`file_edit` AS file_edit_341,
  a6_.`image_setting` AS image_setting_342,
  a6_.`file_w` AS file_w_343,
  a6_.`file_h` AS file_h_344,
  a6_.`file_w4000` AS file_w4000_345,
  a6_.`file_h4000` AS file_h4000_346,
  a6_.`size_z` AS size_z_347,
  a6_.`size_gb_z` AS size_gb_z_348,
  a6_.`repeat_number` AS repeat_number_349,
  a6_.`size_big` AS size_big_350,
  a6_.`delivery_suspended` AS delivery_suspended_351,
  a6_.`poddon_x` AS poddon_x_352,
  a6_.`poddon_y` AS poddon_y_353,
  a6_.`poddon_z` AS poddon_z_354,
  a6_.`module` AS module_355,
  a6_.`tessera_size_x` AS tessera_size_x_356,
  a6_.`tessera_size_y` AS tessera_size_y_357,
  a6_.`tessera_size_z` AS tessera_size_z_358,
  a6_.`poddon_count` AS poddon_count_359,
  a6_.`poddon_weight` AS poddon_weight_360,
  a6_.`added_to_cart` AS added_to_cart_361,
  a6_.`sold_out` AS sold_out_362,
  a6_.`sold_out_vol` AS sold_out_vol_363,
  a6_.`swimming_pool` AS swimming_pool_364,
  a6_.`can_select_substrate` AS can_select_substrate_365,
  a6_.`designer` AS designer_366,
  a6_.`designer_id` AS designer_id_367,
  a6_.`mosaic_effect` AS mosaic_effect_368,
  a6_.`not_sample` AS not_sample_369,
  a6_.`express_sample` AS express_sample_370,
  a6_.`description_edit` AS description_edit_371,
  a6_.`comment_scheme_image` AS comment_scheme_image_372,
  a6_.`variant_image` AS variant_image_373,
  a6_.`square` AS square_374,
  a6_.`fix_big_size` AS fix_big_size_375,
  a6_.`overflow_sink` AS overflow_sink_376,
  a6_.`drain_size_sink` AS drain_size_sink_377,
  a6_.`faucet_hole_sink` AS faucet_hole_sink_378,
  a6_.`rotate` AS rotate_379,
  a6_.`dyed_in_mass` AS dyed_in_mass_380,
  a6_.`durability_class` AS durability_class_381,
  a6_.`is_comment_ru` AS is_comment_ru_382,
  a6_.`file_rotation` AS file_rotation_383,
  a6_.`created_at` AS created_at_384,
  a6_.`updated_at` AS updated_at_385,
  l7_.`id` AS id_386,
  l7_.`source` AS source_387,
  l7_.`ru` AS ru_388,
  l7_.`en` AS en_389,
  l7_.`it` AS it_390,
  l7_.`es` AS es_391,
  l7_.`fr` AS fr_392,
  l7_.`de` AS de_393,
  l7_.`pl` AS pl_394,
  l7_.`pt` AS pt_395,
  l7_.`nl` AS nl_396,
  l7_.`fi` AS fi_397,
  l7_.`ua` AS ua_398,
  l7_.`sv` AS sv_399,
  l7_.`no` AS no_400,
  l7_.`da` AS da_401,
  l7_.`cn` AS cn_402,
  l7_.`zh` AS zh_403,
  l7_.`created_at` AS created_at_404,
  l7_.`updated_at` AS updated_at_405,
  f8_.`id` AS id_406,
  f8_.`name` AS name_407,
  f8_.`alt_name` AS alt_name_408,
  f8_.`left_menu` AS left_menu_409,
  f8_.`sort` AS sort_410,
  f8_.`important` AS important_411,
  f8_.`old_command` AS old_command_412,
  f8_.`old_id` AS old_id_413,
  f8_.`sub_key` AS sub_key_414,
  f8_.`parent_key` AS parent_key_415,
  f8_.`rank` AS rank_416,
  f8_.`icon` AS icon_417,
  f8_.`icon_url` AS icon_url_418,
  f8_.`logo` AS logo_419,
  f8_.`logo_url` AS logo_url_420,
  f8_.`created_at` AS created_at_421,
  f8_.`updated_at` AS updated_at_422,
  l9_.`id` AS id_423,
  l9_.`source` AS source_424,
  l9_.`ru` AS ru_425,
  l9_.`en` AS en_426,
  l9_.`it` AS it_427,
  l9_.`es` AS es_428,
  l9_.`fr` AS fr_429,
  l9_.`de` AS de_430,
  l9_.`pl` AS pl_431,
  l9_.`pt` AS pt_432,
  l9_.`nl` AS nl_433,
  l9_.`fi` AS fi_434,
  l9_.`ua` AS ua_435,
  l9_.`sv` AS sv_436,
  l9_.`no` AS no_437,
  l9_.`da` AS da_438,
  l9_.`usa` AS usa_439,
  l9_.`cn` AS cn_440,
  l9_.`zh` AS zh_441,
  l9_.`created_at` AS created_at_442,
  l9_.`updated_at` AS updated_at_443,
  l10_.`id` AS id_444,
  l10_.`source` AS source_445,
  l10_.`ru` AS ru_446,
  l10_.`en` AS en_447,
  l10_.`it` AS it_448,
  l10_.`es` AS es_449,
  l10_.`fr` AS fr_450,
  l10_.`de` AS de_451,
  l10_.`pl` AS pl_452,
  l10_.`pt` AS pt_453,
  l10_.`nl` AS nl_454,
  l10_.`fi` AS fi_455,
  l10_.`ua` AS ua_456,
  l10_.`sv` AS sv_457,
  l10_.`no` AS no_458,
  l10_.`da` AS da_459,
  l10_.`usa` AS usa_460,
  l10_.`cn` AS cn_461,
  l10_.`zh` AS zh_462,
  l10_.`created_at` AS created_at_463,
  l10_.`updated_at` AS updated_at_464,
  f0_.page_id AS page_id_465,
  f0_.param_id AS param_id_466,
  f0_.group_id AS group_id_467,
  f0_.brand AS brand_468,
  f0_.country_id AS country_id_469,
  f0_.parent_id AS parent_id_470,
  l1_.publication_id AS publication_id_471,
  l1_.filter_id AS filter_id_472,
  l1_.exh_id AS exh_id_473,
  f4_.user_id AS user_id_474,
  f4_.country AS country_475,
  f4_.filter AS filter_476,
  f5_.parent_id AS parent_id_477,
  a6_.collection AS collection_478,
  a6_.newCollection AS newCollection_479,
  a6_.type AS type_480,
  a6_.measure AS measure_481,
  a6_.surface AS surface_482,
  a6_.pr_status AS pr_status_483,
  a6_.category_price AS category_price_484,
  a6_.edge_type AS edge_type_485,
  a6_.using AS using_486,
  a6_.shape AS shape_487,
  a6_.material AS material_488,
  a6_.delivery AS delivery_489,
  a6_.sliding AS sliding_490,
  a6_.off_shade AS off_shade_491,
  a6_.style AS style_492,
  a6_.repeat_draw AS repeat_draw_493,
  a6_.measurement_size AS measurement_size_494,
  a6_.installation_type AS installation_type_495,
  a6_.meth_laying AS meth_laying_496,
  a6_.draw AS draw_497,
  l7_.blog_show_id AS blog_show_id_498,
  l7_.blog_hide_single_id AS blog_hide_single_id_499,
  l7_.static_page_status_show_id AS static_page_status_show_id_500,
  l7_.static_page_comment_show_id AS static_page_comment_show_id_501,
  l7_.filter_html_show_id AS filter_html_show_id_502,
  l7_.exh_show_id AS exh_show_id_503,
  l7_.exh_hide_single_id AS exh_hide_single_id_504,
  f8_.page_id AS page_id_505,
  f8_.param_id AS param_id_506,
  f8_.group_id AS group_id_507,
  f8_.brand AS brand_508,
  f8_.country_id AS country_id_509,
  f8_.parent_id AS parent_id_510,
  l9_.static_page_unid_id AS static_page_unid_id_511,
  l9_.vacancy_question_link_id AS vacancy_question_link_id_512,
  l9_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_513,
  l9_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_514,
  l9_.exh_image_alt AS exh_image_alt_515,
  l9_.filter_group_name AS filter_group_name_516,
  l9_.filter_tooltip AS filter_tooltip_517,
  l9_.calendar_text AS calendar_text_518,
  l9_.filter_key_adwords AS filter_key_adwords_519,
  l9_.filter_title_adwords AS filter_title_adwords_520,
  l9_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_521,
  l9_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_522,
  l9_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_523,
  l9_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_524,
  l9_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_525,
  l9_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_526,
  l9_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_527,
  l9_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_528,
  l10_.static_page_unid_id AS static_page_unid_id_529,
  l10_.vacancy_question_link_id AS vacancy_question_link_id_530,
  l10_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_531,
  l10_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_532,
  l10_.exh_image_alt AS exh_image_alt_533,
  l10_.filter_group_name AS filter_group_name_534,
  l10_.filter_tooltip AS filter_tooltip_535,
  l10_.calendar_text AS calendar_text_536,
  l10_.filter_key_adwords AS filter_key_adwords_537,
  l10_.filter_title_adwords AS filter_title_adwords_538,
  l10_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_539,
  l10_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_540,
  l10_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_541,
  l10_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_542,
  l10_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_543,
  l10_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_544,
  l10_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_545,
  l10_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_546
FROM
  `filters` f0_
  LEFT JOIN `locale_url` l1_ ON f0_.id = l1_.filter_id
  LEFT JOIN `filter_pages` f2_ ON f0_.page_id = f2_.id
  LEFT JOIN `filter_params` f3_ ON f0_.param_id = f3_.id
  LEFT JOIN `factory` f4_ ON f0_.brand = f4_.id
  LEFT JOIN `user` u11_ ON f4_.user_id = u11_.id
  LEFT JOIN `filter_groups` f5_ ON f0_.group_id = f5_.id
  LEFT JOIN article_filters a12_ ON f0_.id = a12_.filter_id
  LEFT JOIN `article` a6_ ON a6_.id = a12_.article_id
  LEFT JOIN `locale_bool` l7_ ON f0_.id = l7_.filter_html_show_id
  LEFT JOIN `filters` f8_ ON f0_.country_id = f8_.id
  LEFT JOIN `locale_text` l9_ ON f0_.id = l9_.filter_name_for_meta_title_id
  LEFT JOIN `locale_text` l10_ ON f0_.id = l10_.filter_name_for_meta_descr_id
WHERE
  f0_.`alt_name` IN (?)
ORDER BY
  f5_.`sort` ASC,
  f0_.`sort` ASC

SELECT f0_.`id` AS id_0, f0_.`name` AS name_1, f0_.`alt_name` AS alt_name_2, f0_.`left_menu` AS left_menu_3, f0_.`sort` AS sort_4, f0_.`important` AS important_5, f0_.`old_command` AS old_command_6, f0_.`old_id` AS old_id_7, f0_.`sub_key` AS sub_key_8, f0_.`parent_key` AS parent_key_9, f0_.`rank` AS rank_10, f0_.`icon` AS icon_11, f0_.`icon_url` AS icon_url_12, f0_.`logo` AS logo_13, f0_.`logo_url` AS logo_url_14, f0_.`created_at` AS created_at_15, f0_.`updated_at` AS updated_at_16, l1_.`id` AS id_17, l1_.`source` AS source_18, l1_.`ru` AS ru_19, l1_.`en` AS en_20, l1_.`it` AS it_21, l1_.`es` AS es_22, l1_.`fr` AS fr_23, l1_.`de` AS de_24, l1_.`pl` AS pl_25, l1_.`pt` AS pt_26, l1_.`nl` AS nl_27, l1_.`fi` AS fi_28, l1_.`ua` AS ua_29, l1_.`sv` AS sv_30, l1_.`no` AS no_31, l1_.`da` AS da_32, l1_.`cn` AS cn_33, l1_.`zh` AS zh_34, l1_.`created_at` AS created_at_35, l1_.`updated_at` AS updated_at_36, f2_.`id` AS id_37, f2_.`name` AS name_38, f2_.`alt_name` AS alt_name_39, f2_.`name_single_source` AS name_single_source_40, f2_.`name_single_ru` AS name_single_ru_41, f2_.`name_single_en` AS name_single_en_42, f2_.`name_single_it` AS name_single_it_43, f2_.`name_single_es` AS name_single_es_44, f2_.`name_single_fr` AS name_single_fr_45, f2_.`name_single_de` AS name_single_de_46, f2_.`name_single_pl` AS name_single_pl_47, f2_.`name_single_pt` AS name_single_pt_48, f2_.`name_single_nl` AS name_single_nl_49, f2_.`name_single_fi` AS name_single_fi_50, f2_.`name_single_ua` AS name_single_ua_51, f2_.`name_single_sv` AS name_single_sv_52, f2_.`name_single_no` AS name_single_no_53, f2_.`name_single_da` AS name_single_da_54, f2_.`name_single_usa` AS name_single_usa_55, f2_.`name_single_cn` AS name_single_cn_56, f2_.`name_single_zh` AS name_single_zh_57, f2_.`name_many_source` AS name_many_source_58, f2_.`name_many_ru` AS name_many_ru_59, f2_.`name_many_en` AS name_many_en_60, f2_.`name_many_it` AS name_many_it_61, f2_.`name_many_es` AS name_many_es_62, f2_.`name_many_fr` AS name_many_fr_63, f2_.`name_many_de` AS name_many_de_64, f2_.`name_many_pl` AS name_many_pl_65, f2_.`name_many_pt` AS name_many_pt_66, f2_.`name_many_nl` AS name_many_nl_67, f2_.`name_many_fi` AS name_many_fi_68, f2_.`name_many_ua` AS name_many_ua_69, f2_.`name_many_sv` AS name_many_sv_70, f2_.`name_many_no` AS name_many_no_71, f2_.`name_many_da` AS name_many_da_72, f2_.`name_many_usa` AS name_many_usa_73, f2_.`name_many_cn` AS name_many_cn_74, f2_.`name_many_zh` AS name_many_zh_75, f2_.`name_menu_source` AS name_menu_source_76, f2_.`name_menu_ru` AS name_menu_ru_77, f2_.`name_menu_en` AS name_menu_en_78, f2_.`name_menu_it` AS name_menu_it_79, f2_.`name_menu_es` AS name_menu_es_80, f2_.`name_menu_fr` AS name_menu_fr_81, f2_.`name_menu_de` AS name_menu_de_82, f2_.`name_menu_pl` AS name_menu_pl_83, f2_.`name_menu_pt` AS name_menu_pt_84, f2_.`name_menu_nl` AS name_menu_nl_85, f2_.`name_menu_fi` AS name_menu_fi_86, f2_.`name_menu_ua` AS name_menu_ua_87, f2_.`name_menu_sv` AS name_menu_sv_88, f2_.`name_menu_no` AS name_menu_no_89, f2_.`name_menu_da` AS name_menu_da_90, f2_.`name_menu_usa` AS name_menu_usa_91, f2_.`name_menu_cn` AS name_menu_cn_92, f2_.`name_menu_zh` AS name_menu_zh_93, f2_.`description_source` AS description_source_94, f2_.`description_ru` AS description_ru_95, f2_.`description_en` AS description_en_96, f2_.`description_it` AS description_it_97, f2_.`description_es` AS description_es_98, f2_.`description_fr` AS description_fr_99, f2_.`description_de` AS description_de_100, f2_.`description_pl` AS description_pl_101, f2_.`description_pt` AS description_pt_102, f2_.`description_nl` AS description_nl_103, f2_.`description_fi` AS description_fi_104, f2_.`description_ua` AS description_ua_105, f2_.`description_sv` AS description_sv_106, f2_.`description_no` AS description_no_107, f2_.`description_da` AS description_da_108, f2_.`description_usa` AS description_usa_109, f2_.`description_cn` AS description_cn_110, f2_.`description_zh` AS description_zh_111, f2_.`keywords_source` AS keywords_source_112, f2_.`keywords_ru` AS keywords_ru_113, f2_.`keywords_en` AS keywords_en_114, f2_.`keywords_it` AS keywords_it_115, f2_.`keywords_es` AS keywords_es_116, f2_.`keywords_fr` AS keywords_fr_117, f2_.`keywords_de` AS keywords_de_118, f2_.`keywords_pl` AS keywords_pl_119, f2_.`keywords_pt` AS keywords_pt_120, f2_.`keywords_nl` AS keywords_nl_121, f2_.`keywords_fi` AS keywords_fi_122, f2_.`keywords_ua` AS keywords_ua_123, f2_.`keywords_sv` AS keywords_sv_124, f2_.`keywords_no` AS keywords_no_125, f2_.`keywords_da` AS keywords_da_126, f2_.`keywords_usa` AS keywords_usa_127, f2_.`keywords_cn` AS keywords_cn_128, f2_.`keywords_zh` AS keywords_zh_129, f2_.`html_source` AS html_source_130, f2_.`html_ru` AS html_ru_131, f2_.`html_en` AS html_en_132, f2_.`html_it` AS html_it_133, f2_.`html_es` AS html_es_134, f2_.`html_fr` AS html_fr_135, f2_.`html_de` AS html_de_136, f2_.`html_pl` AS html_pl_137, f2_.`html_pt` AS html_pt_138, f2_.`html_nl` AS html_nl_139, f2_.`html_fi` AS html_fi_140, f2_.`html_ua` AS html_ua_141, f2_.`html_sv` AS html_sv_142, f2_.`html_no` AS html_no_143, f2_.`html_da` AS html_da_144, f2_.`html_usa` AS html_usa_145, f2_.`html_cn` AS html_cn_146, f2_.`html_zh` AS html_zh_147, f3_.`id` AS id_148, f3_.`alt_name` AS alt_name_149, f3_.`count` AS count_150, f3_.`hide` AS hide_151, f3_.`hide_all` AS hide_all_152, f3_.`is_enable` AS is_enable_153, f3_.`show_footer` AS show_footer_154, f3_.`show_menu` AS show_menu_155, f3_.`show_menu_advanced` AS show_menu_advanced_156, f3_.`hex_code` AS hex_code_157, f3_.`code` AS code_158, f3_.`phone_code` AS phone_code_159, f3_.`link` AS link_160, f4_.`id` AS id_161, f4_.`unid` AS unid_162, f4_.`name` AS name_163, f4_.`name_inv` AS name_inv_164, f4_.`url` AS url_165, f4_.`alternate_name` AS alternate_name_166, f4_.`description_ru` AS description_ru_167, f4_.`description_en` AS description_en_168, f4_.`description_it` AS description_it_169, f4_.`description_es` AS description_es_170, f4_.`description_fr` AS description_fr_171, f4_.`description_de` AS description_de_172, f4_.`description_pt` AS description_pt_173, f4_.`description_pl` AS description_pl_174, f4_.`description_nl` AS description_nl_175, f4_.`description_fi` AS description_fi_176, f4_.`description_ua` AS description_ua_177, f4_.`description_sv` AS description_sv_178, f4_.`description_no` AS description_no_179, f4_.`description_da` AS description_da_180, f4_.`description_zh` AS description_zh_181, f4_.`delivery_time` AS delivery_time_182, f4_.`not_regular` AS not_regular_183, f4_.`suspended` AS suspended_184, f4_.`status` AS status_185, f4_.`type` AS type_186, f4_.`discount` AS discount_187, f4_.`discount_date_start` AS discount_date_start_188, f4_.`discount_date_end` AS discount_date_end_189, f4_.`transcription` AS transcription_190, f4_.`cost_delivery` AS cost_delivery_191, f4_.`create_date` AS create_date_192, f4_.`is_accepted` AS is_accepted_193, f4_.`accepted_at` AS accepted_at_194, f4_.`accept_state` AS accept_state_195, f4_.`description_edit` AS description_edit_196, f4_.`stated_at` AS stated_at_197, f4_.`state` AS state_198, f4_.`description_state` AS description_state_199, f4_.`video` AS video_200, f4_.`parser_address` AS parser_address_201, f4_.`accessible` AS accessible_202, f4_.`sound` AS sound_203, f4_.`test_access` AS test_access_204, f4_.`total_ideas` AS total_ideas_205, f4_.`votes_submit` AS votes_submit_206, f4_.`votes_stars` AS votes_stars_207, f4_.`brand_link` AS brand_link_208, f4_.`brand_logo` AS brand_logo_209, f4_.`no_send_portl_message` AS no_send_portl_message_210, f5_.`id` AS id_211, f5_.`alt_name` AS alt_name_212, f5_.`left_menu` AS left_menu_213, f5_.`sort` AS sort_214, f5_.`is_enable` AS is_enable_215, f5_.`show_footer` AS show_footer_216, f5_.`show_menu` AS show_menu_217, f5_.`show_menu_advanced` AS show_menu_advanced_218, a6_.`id` AS id_219, a6_.`code` AS code_220, a6_.`name` AS name_221, a6_.`alternate_name` AS alternate_name_222, a6_.`urla` AS urla_223, a6_.`file` AS file_224, a6_.`size_x` AS size_x_225, a6_.`size_y` AS size_y_226, a6_.`size_gb_x` AS size_gb_x_227, a6_.`size_gb_y` AS size_gb_y_228, a6_.`size_tessera` AS size_tessera_229, a6_.`file_size1_x` AS file_size1_x_230, a6_.`file_size1_y` AS file_size1_y_231, a6_.`file_size2_x` AS file_size2_x_232, a6_.`file_size2_y` AS file_size2_y_233, a6_.`file_size3_x` AS file_size3_x_234, a6_.`file_size3_y` AS file_size3_y_235, a6_.`file_size500_x` AS file_size500_x_236, a6_.`file_size500_y` AS file_size500_y_237, a6_.`file_size740_x` AS file_size740_x_238, a6_.`file_size740_y` AS file_size740_y_239, a6_.`file_size8_x` AS file_size8_x_240, a6_.`file_size8_y` AS file_size8_y_241, a6_.`pallet` AS pallet_242, a6_.`pallet_ft` AS pallet_ft_243, a6_.`type_constraint` AS type_constraint_244, a6_.`multiple_pallet` AS multiple_pallet_245, a6_.`min_order` AS min_order_246, a6_.`price_euro` AS price_euro_247, a6_.`price_mq_euro` AS price_mq_euro_248, a6_.`price_euro_de` AS price_euro_de_249, a6_.`price_mq_euro_de` AS price_mq_euro_de_250, a6_.`price_euro_at` AS price_euro_at_251, a6_.`price_mq_euro_at` AS price_mq_euro_at_252, a6_.`price_euro_fi` AS price_euro_fi_253, a6_.`price_mq_euro_fi` AS price_mq_euro_fi_254, a6_.`price_euro_fr` AS price_euro_fr_255, a6_.`price_mq_euro_fr` AS price_mq_euro_fr_256, a6_.`price_euro_it` AS price_euro_it_257, a6_.`price_mq_euro_it` AS price_mq_euro_it_258, a6_.`price_euro_be` AS price_euro_be_259, a6_.`price_mq_euro_be` AS price_mq_euro_be_260, a6_.`price_euro_ie` AS price_euro_ie_261, a6_.`price_mq_euro_ie` AS price_mq_euro_ie_262, a6_.`price_euro_nl` AS price_euro_nl_263, a6_.`price_mq_euro_nl` AS price_mq_euro_nl_264, a6_.`price_euro_es` AS price_euro_es_265, a6_.`price_mq_euro_es` AS price_mq_euro_es_266, a6_.`price_rub` AS price_rub_267, a6_.`price_rue` AS price_rue_268, a6_.`price_mq_rub` AS price_mq_rub_269, a6_.`price_mq_rue` AS price_mq_rue_270, a6_.`price_gbp` AS price_gbp_271, a6_.`price_gbe` AS price_gbe_272, a6_.`price_mq_gbp` AS price_mq_gbp_273, a6_.`price_mq_gbe` AS price_mq_gbe_274, a6_.`price_usd` AS price_usd_275, a6_.`price_use` AS price_use_276, a6_.`price_fq_usd` AS price_fq_usd_277, a6_.`price_fq_use` AS price_fq_use_278, a6_.`price_mq_usd` AS price_mq_usd_279, a6_.`price_mq_use` AS price_mq_use_280, a6_.`price_chf` AS price_chf_281, a6_.`price_che` AS price_che_282, a6_.`price_mq_chf` AS price_mq_chf_283, a6_.`price_mq_che` AS price_mq_che_284, a6_.`price_sek` AS price_sek_285, a6_.`price_see` AS price_see_286, a6_.`price_mq_sek` AS price_mq_sek_287, a6_.`price_mq_see` AS price_mq_see_288, a6_.`price_dkk` AS price_dkk_289, a6_.`price_dke` AS price_dke_290, a6_.`price_mq_dkk` AS price_mq_dkk_291, a6_.`price_mq_dke` AS price_mq_dke_292, a6_.`price_nok` AS price_nok_293, a6_.`price_noe` AS price_noe_294, a6_.`price_mq_nok` AS price_mq_nok_295, a6_.`price_mq_noe` AS price_mq_noe_296, a6_.`price_pln` AS price_pln_297, a6_.`price_ple` AS price_ple_298, a6_.`price_mq_pln` AS price_mq_pln_299, a6_.`price_mq_ple` AS price_mq_ple_300, a6_.`price_cad` AS price_cad_301, a6_.`price_cae` AS price_cae_302, a6_.`price_fq_cad` AS price_fq_cad_303, a6_.`price_fq_cae` AS price_fq_cae_304, a6_.`price_mq_cad` AS price_mq_cad_305, a6_.`price_mq_cae` AS price_mq_cae_306, a6_.`thick` AS thick_307, a6_.`weight` AS weight_308, a6_.`packaging_count` AS packaging_count_309, a6_.`packaging_count_ft` AS packaging_count_ft_310, a6_.`packaging_count_pc` AS packaging_count_pc_311, a6_.`m2one_ps` AS m2one_ps_312, a6_.`description_ru` AS description_ru_313, a6_.`description_en` AS description_en_314, a6_.`description_it` AS description_it_315, a6_.`description_es` AS description_es_316, a6_.`description_fr` AS description_fr_317, a6_.`description_de` AS description_de_318, a6_.`description_pt` AS description_pt_319, a6_.`description_pl` AS description_pl_320, a6_.`description_nl` AS description_nl_321, a6_.`description_fi` AS description_fi_322, a6_.`description_ua` AS description_ua_323, a6_.`description_sv` AS description_sv_324, a6_.`description_no` AS description_no_325, a6_.`description_da` AS description_da_326, a6_.`description_cn` AS description_cn_327, a6_.`scheme` AS scheme_328, a6_.`sale_date` AS sale_date_329, a6_.`thin_granite` AS thin_granite_330, a6_.`glazed_granite` AS glazed_granite_331, a6_.`pei` AS pei_332, a6_.`is_grouped` AS is_grouped_333, a6_.`is_rotate` AS is_rotate_334, a6_.`price_prx` AS price_prx_335, a6_.`background_white` AS background_white_336, a6_.`border_grey` AS border_grey_337, a6_.`is_edit` AS is_edit_338, a6_.`edited_at` AS edited_at_339, a6_.`comment` AS comment_340, a6_.`file_edit` AS file_edit_341, a6_.`image_setting` AS image_setting_342, a6_.`file_w` AS file_w_343, a6_.`file_h` AS file_h_344, a6_.`file_w4000` AS file_w4000_345, a6_.`file_h4000` AS file_h4000_346, a6_.`size_z` AS size_z_347, a6_.`size_gb_z` AS size_gb_z_348, a6_.`repeat_number` AS repeat_number_349, a6_.`size_big` AS size_big_350, a6_.`delivery_suspended` AS delivery_suspended_351, a6_.`poddon_x` AS poddon_x_352, a6_.`poddon_y` AS poddon_y_353, a6_.`poddon_z` AS poddon_z_354, a6_.`module` AS module_355, a6_.`tessera_size_x` AS tessera_size_x_356, a6_.`tessera_size_y` AS tessera_size_y_357, a6_.`tessera_size_z` AS tessera_size_z_358, a6_.`poddon_count` AS poddon_count_359, a6_.`poddon_weight` AS poddon_weight_360, a6_.`added_to_cart` AS added_to_cart_361, a6_.`sold_out` AS sold_out_362, a6_.`sold_out_vol` AS sold_out_vol_363, a6_.`swimming_pool` AS swimming_pool_364, a6_.`can_select_substrate` AS can_select_substrate_365, a6_.`designer` AS designer_366, a6_.`designer_id` AS designer_id_367, a6_.`mosaic_effect` AS mosaic_effect_368, a6_.`not_sample` AS not_sample_369, a6_.`express_sample` AS express_sample_370, a6_.`description_edit` AS description_edit_371, a6_.`comment_scheme_image` AS comment_scheme_image_372, a6_.`variant_image` AS variant_image_373, a6_.`square` AS square_374, a6_.`fix_big_size` AS fix_big_size_375, a6_.`overflow_sink` AS overflow_sink_376, a6_.`drain_size_sink` AS drain_size_sink_377, a6_.`faucet_hole_sink` AS faucet_hole_sink_378, a6_.`rotate` AS rotate_379, a6_.`dyed_in_mass` AS dyed_in_mass_380, a6_.`durability_class` AS durability_class_381, a6_.`is_comment_ru` AS is_comment_ru_382, a6_.`file_rotation` AS file_rotation_383, a6_.`created_at` AS created_at_384, a6_.`updated_at` AS updated_at_385, l7_.`id` AS id_386, l7_.`source` AS source_387, l7_.`ru` AS ru_388, l7_.`en` AS en_389, l7_.`it` AS it_390, l7_.`es` AS es_391, l7_.`fr` AS fr_392, l7_.`de` AS de_393, l7_.`pl` AS pl_394, l7_.`pt` AS pt_395, l7_.`nl` AS nl_396, l7_.`fi` AS fi_397, l7_.`ua` AS ua_398, l7_.`sv` AS sv_399, l7_.`no` AS no_400, l7_.`da` AS da_401, l7_.`cn` AS cn_402, l7_.`zh` AS zh_403, l7_.`created_at` AS created_at_404, l7_.`updated_at` AS updated_at_405, f8_.`id` AS id_406, f8_.`name` AS name_407, f8_.`alt_name` AS alt_name_408, f8_.`left_menu` AS left_menu_409, f8_.`sort` AS sort_410, f8_.`important` AS important_411, f8_.`old_command` AS old_command_412, f8_.`old_id` AS old_id_413, f8_.`sub_key` AS sub_key_414, f8_.`parent_key` AS parent_key_415, f8_.`rank` AS rank_416, f8_.`icon` AS icon_417, f8_.`icon_url` AS icon_url_418, f8_.`logo` AS logo_419, f8_.`logo_url` AS logo_url_420, f8_.`created_at` AS created_at_421, f8_.`updated_at` AS updated_at_422, l9_.`id` AS id_423, l9_.`source` AS source_424, l9_.`ru` AS ru_425, l9_.`en` AS en_426, l9_.`it` AS it_427, l9_.`es` AS es_428, l9_.`fr` AS fr_429, l9_.`de` AS de_430, l9_.`pl` AS pl_431, l9_.`pt` AS pt_432, l9_.`nl` AS nl_433, l9_.`fi` AS fi_434, l9_.`ua` AS ua_435, l9_.`sv` AS sv_436, l9_.`no` AS no_437, l9_.`da` AS da_438, l9_.`usa` AS usa_439, l9_.`cn` AS cn_440, l9_.`zh` AS zh_441, l9_.`created_at` AS created_at_442, l9_.`updated_at` AS updated_at_443, l10_.`id` AS id_444, l10_.`source` AS source_445, l10_.`ru` AS ru_446, l10_.`en` AS en_447, l10_.`it` AS it_448, l10_.`es` AS es_449, l10_.`fr` AS fr_450, l10_.`de` AS de_451, l10_.`pl` AS pl_452, l10_.`pt` AS pt_453, l10_.`nl` AS nl_454, l10_.`fi` AS fi_455, l10_.`ua` AS ua_456, l10_.`sv` AS sv_457, l10_.`no` AS no_458, l10_.`da` AS da_459, l10_.`usa` AS usa_460, l10_.`cn` AS cn_461, l10_.`zh` AS zh_462, l10_.`created_at` AS created_at_463, l10_.`updated_at` AS updated_at_464, f0_.page_id AS page_id_465, f0_.param_id AS param_id_466, f0_.group_id AS group_id_467, f0_.brand AS brand_468, f0_.country_id AS country_id_469, f0_.parent_id AS parent_id_470, l1_.publication_id AS publication_id_471, l1_.filter_id AS filter_id_472, l1_.exh_id AS exh_id_473, f4_.user_id AS user_id_474, f4_.country AS country_475, f4_.filter AS filter_476, f5_.parent_id AS parent_id_477, a6_.collection AS collection_478, a6_.newCollection AS newCollection_479, a6_.type AS type_480, a6_.measure AS measure_481, a6_.surface AS surface_482, a6_.pr_status AS pr_status_483, a6_.category_price AS category_price_484, a6_.edge_type AS edge_type_485, a6_.using AS using_486, a6_.shape AS shape_487, a6_.material AS material_488, a6_.delivery AS delivery_489, a6_.sliding AS sliding_490, a6_.off_shade AS off_shade_491, a6_.style AS style_492, a6_.repeat_draw AS repeat_draw_493, a6_.measurement_size AS measurement_size_494, a6_.installation_type AS installation_type_495, a6_.meth_laying AS meth_laying_496, a6_.draw AS draw_497, l7_.blog_show_id AS blog_show_id_498, l7_.blog_hide_single_id AS blog_hide_single_id_499, l7_.static_page_status_show_id AS static_page_status_show_id_500, l7_.static_page_comment_show_id AS static_page_comment_show_id_501, l7_.filter_html_show_id AS filter_html_show_id_502, l7_.exh_show_id AS exh_show_id_503, l7_.exh_hide_single_id AS exh_hide_single_id_504, f8_.page_id AS page_id_505, f8_.param_id AS param_id_506, f8_.group_id AS group_id_507, f8_.brand AS brand_508, f8_.country_id AS country_id_509, f8_.parent_id AS parent_id_510, l9_.static_page_unid_id AS static_page_unid_id_511, l9_.vacancy_question_link_id AS vacancy_question_link_id_512, l9_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_513, l9_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_514, l9_.exh_image_alt AS exh_image_alt_515, l9_.filter_group_name AS filter_group_name_516, l9_.filter_tooltip AS filter_tooltip_517, l9_.calendar_text AS calendar_text_518, l9_.filter_key_adwords AS filter_key_adwords_519, l9_.filter_title_adwords AS filter_title_adwords_520, l9_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_521, l9_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_522, l9_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_523, l9_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_524, l9_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_525, l9_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_526, l9_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_527, l9_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_528, l10_.static_page_unid_id AS static_page_unid_id_529, l10_.vacancy_question_link_id AS vacancy_question_link_id_530, l10_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_531, l10_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_532, l10_.exh_image_alt AS exh_image_alt_533, l10_.filter_group_name AS filter_group_name_534, l10_.filter_tooltip AS filter_tooltip_535, l10_.calendar_text AS calendar_text_536, l10_.filter_key_adwords AS filter_key_adwords_537, l10_.filter_title_adwords AS filter_title_adwords_538, l10_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_539, l10_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_540, l10_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_541, l10_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_542, l10_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_543, l10_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_544, l10_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_545, l10_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_546 FROM `filters` f0_ LEFT JOIN `locale_url` l1_ ON f0_.id = l1_.filter_id LEFT JOIN `filter_pages` f2_ ON f0_.page_id = f2_.id LEFT JOIN `filter_params` f3_ ON f0_.param_id = f3_.id LEFT JOIN `factory` f4_ ON f0_.brand = f4_.id LEFT JOIN `user` u11_ ON f4_.user_id = u11_.id LEFT JOIN `filter_groups` f5_ ON f0_.group_id = f5_.id LEFT JOIN article_filters a12_ ON f0_.id = a12_.filter_id LEFT JOIN `article` a6_ ON a6_.id = a12_.article_id LEFT JOIN `locale_bool` l7_ ON f0_.id = l7_.filter_html_show_id LEFT JOIN `filters` f8_ ON f0_.country_id = f8_.id LEFT JOIN `locale_text` l9_ ON f0_.id = l9_.filter_name_for_meta_title_id LEFT JOIN `locale_text` l10_ ON f0_.id = l10_.filter_name_for_meta_descr_id WHERE f0_.`alt_name` IN ('release_year_2020') ORDER BY f5_.`sort` ASC, f0_.`sort` ASC;