SQL: [SELECT /* 975,432753 */ 'all' AS alldisplay, 'page only' AS pagedisplay, COALESCE(a.boat_ref_link, a.boat_uid_id) AS boat_uid_id, a.boat_cnt_account AS boat_cnt_account, a.boat_hld_holder AS boat_hld_holder, a.boat_mbr_member AS boat_mbr_member, a.boat_chr_link AS boat_chr_link, a.boat_lng_language AS boat_lng_language, a.boat_ref_link AS boat_ref_link, a.boat_ind_index AS boat_ind_index, boat_chr_name, boat_chr_article, @naming := CONCAT_WS(', ', IFNULL(boat_chr_name, ''), IFNULL(boat_chr_nick, '')) AS boat_chr_naming, COALESCE(a.boat_img_image4, a.boat_img_image, a.boat_img_image5) AS boat_img_image, a.boat_chk_export AS boat_chk_export, a.boat_int_length AS boat_int_length, a.boat_int_length2 AS boat_int_length2, a.boat_int_length3 AS boat_int_length3, a.boat_int_breadth AS boat_int_breadth, a.boat_int_breadth2 AS boat_int_breadth2, a.boat_int_depth AS boat_int_depth, a.boat_int_draft AS boat_int_draft, a.boat_int_draft2 AS boat_int_draft2, a.boat_int_waterline AS boat_int_waterline, boat_set_keel, a.boat_int_displacement AS boat_int_displacement, a.boat_int_displacement2 AS boat_int_displacement2, a.boat_int_water AS boat_int_water, a.boat_int_fuel AS boat_int_fuel, a.boat_int_tank AS boat_int_tank, a.boat_int_tank2 AS boat_int_tank2, a.boat_int_tank3 AS boat_int_tank3, a.boat_int_speed AS boat_int_speed, a.boat_int_maxspeed AS boat_int_maxspeed, ROUND(a.boat_int_range, 0) AS boat_int_range, a.boat_chr_tonnage AS boat_chr_tonnage, a.boat_lnk_manager AS boat_lnk_manager, IF('azimutyachts.ru' = 'azimutyachts.ua', 29625, IFNULL(NULLIF(a.boat_lnk_master, 0), 27707)) AS boat_lnk_master, a.boat_lnk_shipyard AS boat_lnk_shipyard, a.boat_rom_views AS boat_rom_views, boat_set_engine, boat_set_gearbox, boat_set_material, boat_set_exterior, boat_set_interior, boat_set_concept, a.boat_int_passenger AS boat_int_passenger, boat_set_cabines, boat_set_berths, boat_set_wc, boat_set_country, boat_set_clear4 AS Clear, a.boat_cur_cost7 AS boat_cur_cost7, a.boat_val_cost7 AS boat_val_cost7, a.boat_cur_cost8 AS boat_cur_cost8, a.boat_val_cost8 AS boat_val_cost8, boat_set_builder, boat_txt_text, a.boat_txt_text AS boat_txt_text_ru, boat_txt_text2, a.boat_txt_text2 AS boat_txt_text2_ru, boat_txt_text3, boat_txt_text4, boat_txt_text5, boat_txt_descr, boat_txt_keywords, boat_chr_title, (CASE WHEN a.boat_int_hours = 0 OR a.boat_int_hours IS NULL THEN '' ELSE a.boat_int_hours END) AS boat_int_hours, @max_length := GREATEST(COALESCE(a.boat_int_length, 0), COALESCE(a.boat_int_length2, 0), COALESCE(a.boat_int_length3, 0)) AS boat_int_maxlength, GREATEST(COALESCE(a.boat_int_breadth, 0), COALESCE(a.boat_int_breadth2, 0)) AS boat_int_maxbreadth, (CASE WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'EUR' THEN '€' WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'USD' THEN '$' WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'RUR' THEN '₽' END) AS UnitValuta, (CASE WHEN a.boat_enm_request = 'YES' THEN '' WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'EUR' THEN 'EUR' WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'USD' THEN 'USD' WHEN COALESCE(IF(NULLIF(a.boat_cur_cost7,0), a.boat_val_cost7, NULL),IF(NULLIF(a.boat_cur_cost8,0), a.boat_val_cost8, NULL)) = 'RUR' THEN 'RUB' ELSE 'EUR' END) AS Valuta, ROUND(a.boat_cur_cost7) AS boat_dec_cost, ROUND(a.boat_cur_cost8) AS boat_dec_oldcost, ROUND(IF(IFNULL(a.boat_cur_cost7, 0) != 0, get_eur_cost(a.boat_cur_cost7, a.boat_val_cost7), get_eur_cost(a.boat_cur_cost8, a.boat_val_cost8)), 0) AS boat_dec_eurprice, REGEXP_REPLACE(REGEXP_REPLACE(boat_set_material, '(?i)Carbon fiber', 'Carbon'), '(?i)Aluminum', 'Alu') AS boat_set_shortmaterial, @baseYachtText := IFNULL( IF(NULL IS NOT NULL, ( SELECT COALESCE(NULLIF(lang.boat_txt_text4, ''), NULLIF(lang.boat_txt_text7, '')) FROM account_boat lang WHERE lang.boat_ref_link = a.boat_uid_id AND lang.boat_lng_language = NULL ), COALESCE(NULLIF(a.boat_txt_text4, ''), NULLIF(a.boat_txt_text7, '')) ), '' ) AS boat_txt_baseyachttext, @yachtText := IF(IFNULL(NULL,'ru') = 'uk' AND get_clean_text(@baseYachtText) = '', IFNULL( ( SELECT COALESCE(NULLIF(en.boat_txt_text4, ''), NULLIF(en.boat_txt_text7, '')) FROM account_boat en WHERE en.boat_ref_link = a.boat_uid_id AND en.boat_lng_language = 'en' ), '' ), @baseYachtText ) AS boat_txt_yachttext, IF(get_clean_text(@yachtText) = '', 'hide', '') AS text_display, (CASE WHEN a.boat_enm_request = 'YES' THEN (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'Цена по запросу' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'Ціна за запитом' ELSE 'Price on request' END) ELSE '' END) AS boat_request, @year := (CASE WHEN NULLIF(NULLIF(a.boat_int_year, 0), '') IS NOT NULL AND NULLIF(NULLIF(a.boat_int_month, 0), '') IS NULL THEN a.boat_int_year WHEN NULLIF(NULLIF(a.boat_int_year, 0), '') IS NOT NULL AND NULLIF(NULLIF(a.boat_int_month, 0), '') IS NOT NULL THEN CONCAT_WS('/', (CASE WHEN a.boat_int_month < 4 THEN '1Q' WHEN a.boat_int_month < 7 THEN '2Q' WHEN a.boat_int_month < 10 THEN '3Q' ELSE '4Q' END), a.boat_int_year ) WHEN NULLIF(NULLIF(a.boat_int_year, 0), '') IS NULL AND NULLIF(NULLIF(a.boat_int_timeline, 0), '') IS NOT NULL THEN CONCAT_WS('/', (CASE WHEN DATE_FORMAT(DATE_ADD(NOW(), INTERVAL a.boat_int_timeline MONTH), '%m') < 4 THEN '1Q' WHEN DATE_FORMAT(DATE_ADD(NOW(), INTERVAL a.boat_int_timeline MONTH), '%m') < 7 THEN '2Q' WHEN DATE_FORMAT(DATE_ADD(NOW(), INTERVAL a.boat_int_timeline MONTH), '%m') < 10 THEN '3Q' ELSE '4Q' END), DATE_FORMAT(DATE_ADD(NOW(), INTERVAL a.boat_int_timeline MONTH), '%Y') ) ELSE NULL END) AS boat_int_year, @year_refit := CONCAT_WS(' | ', @year, NULLIF(NULLIF(a.boat_int_refit, 0), '')) AS boat_chr_yearrefit, @net_year := (CASE WHEN NULLIF(NULLIF(a.boat_int_year, 0), '') IS NOT NULL THEN a.boat_int_year WHEN NULLIF(NULLIF(a.boat_int_timeline, 0), '') IS NOT NULL THEN DATE_FORMAT(DATE_ADD(NOW(), INTERVAL a.boat_int_timeline MONTH), '%Y') ELSE NULL END) AS boat_int_netyear, IF(IFNULL(boat_chr_nick, '') = '', (CASE WHEN a.boat_chk_stock & 1 AND @max_length >= 25 AND @net_year > YEAR(NOW()) THEN (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'Новая яхта в постройке' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'Нова яхта на стадії будівництва' ELSE 'New yacht under construction' END) WHEN a.boat_chk_stock & 1 AND (@max_length < 25 OR @net_year <= YEAR(NOW())) THEN (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'Новая яхта' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'Нова яхта' ELSE 'New Yacht' END) ELSE CONCAT_WS(' ', IF(IFNULL(a.boat_enm_type, 'MOTOR') = 'SAIL', 'S/Y', 'M/Y'), (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'По запросу' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'За запитом' ELSE 'On Request' END) ) END), CONCAT(IF(IFNULL(a.boat_enm_type, 'MOTOR') = 'SAIL', 'S/Y', 'M/Y'), ' ', boat_chr_nick) ) AS boat_nickname, IF(a.boat_chk_stock & 1 AND a.boat_chk_build & 4, 'sale-build', 'sale') AS boat_type, IF(a.boat_chk_main & 1 OR a.boat_chk_enlarge & 1 OR (a.boat_chk_stock & 1 AND a.boat_chk_build & 4 AND a.boat_chk_enlarge & 1), 'badge-yacht', '' ) AS badge_class, (CASE WHEN a.boat_chk_main & 1 THEN 'badge-exclusive' WHEN (a.boat_chk_stock & 1 AND a.boat_chk_build & 4 AND a.boat_chk_enlarge & 1) THEN 'badge-nearest' WHEN a.boat_chk_enlarge & 1 THEN 'badge-featured' ELSE '' END) AS badge_type_class, (CASE WHEN a.boat_chk_stock & 1 AND NOT(a.boat_chk_build & 4) THEN 'in_new' WHEN a.boat_chk_build & 4 THEN 'in_build' WHEN a.boat_chk_used & 1 THEN 'in_brokerage' ELSE 'in_brokerage' END) AS yacht_type, ( SELECT GROUP_CONCAT(reestr_join.join_that) FROM reestr_join WHERE join_account=975 AND join_holder=8809 AND join_this=a.boat_uid_id AND join_this_table='account_boat' AND join_this_holder=5531 AND join_that_table='account_list' ) AS categories_id_group, IF((a.boat_chk_stock & 65536 OR a.boat_chk_used & 65536), 'boat-charter', 'boat-sale') AS boat_type_class, IF(IFNULL(a.boat_enm_sale,'NO') = 'YES' AND IFNULL(a.boat_enm_reseved,'NO') <> 'YES', 'sold', '') AS sold_class, IF(IFNULL(a.boat_enm_reseved,'NO') = 'YES', 'out-of-market', '') AS out_market_class, IF(a.boat_chk_enlarge & 1, 'top-offer', '') AS offer_class, IF(NOT((a.boat_chk_used & 1) OR (a.boat_chk_stock & 1)), 'removed', '') AS removed_class, IF(a.boat_chk_build & 2 OR IFNULL(a.boat_enm_flag, 'NO') = 'YES', 'request-popup', '') AS request_popup_class, IF(FIND_IN_SET('104901', (SELECT GROUP_CONCAT(join_sdg.join_that) FROM reestr_join AS join_sdg WHERE join_sdg.join_account = 975 AND join_sdg.join_holder = 8809 AND join_sdg.join_this_holder = 5531 AND join_sdg.join_that_table = 'account_list' AND join_sdg.join_this_table = 'account_boat' AND join_sdg.join_this = COALESCE(a.boat_ref_link, a.boat_uid_id) ) ), 'steel-aluminum', 'grp' ) AS boat_chr_categoryshort, IF(NULLIF(NULL, '') IS NULL AND NULLIF(NULL, '') IS NULL AND NULLIF(NULL, '') IS NULL, (CASE WHEN (a.boat_chk_main & 1 OR (a.boat_chk_enlarge & 1 AND a.boat_chk_main & 1) ) THEN 0 WHEN (a.boat_chk_enlarge & 1 OR (a.boat_chk_stock & 1 AND a.boat_chk_build & 4 AND a.boat_chk_enlarge & 1) ) THEN 1 ELSE 2 END), IF(a.boat_chk_main & 1 OR a.boat_chk_enlarge & 1 OR (a.boat_chk_stock & 1 AND a.boat_chk_build & 4 AND a.boat_chk_enlarge & 1), 0, 1 ) ) AS boat_sort_featured, IF(a.boat_chk_used & 1, (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'Цена' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'Цiна' ELSE 'Asking price' END), (CASE WHEN IFNULL(NULL,'ru') = 'ru' THEN 'Цена' WHEN IFNULL(NULL,'ru') = 'uk' THEN 'Цiна' ELSE 'Price' END) ) AS price_caption, IF((IFNULL(a.boat_enm_sale,'NO') = 'YES' AND IFNULL(a.boat_enm_reseved,'NO') <> 'YES') OR IFNULL(a.boat_enm_reseved,'NO') = 'YES', 1, 0 ) AS boat_sort_irrelevant, IF(NULLIF(NULL, '') IS NULL, 1, IFNULL( LOCATE( CONVERT(CONCAT('|', REGEXP_SUBSTR(@naming, get_azimut_combination_regexp(NULL)), '|') USING cp1251), CONVERT(CONCAT('|', get_azimut_combination_regexp(NULL), '|') USING cp1251) ), 999999 ) ) AS boat_sort_search, (CASE WHEN ( (a.boat_chk_attribute & 1) OR NOT((a.boat_chk_used & 1) OR (a.boat_chk_stock & 1)) OR IFNULL(a.boat_enm_redirect,'NO') = 'YES' ) THEN 410 ELSE NULL END) AS boat_sys_httpcode FROM account_boat a # Список категорий LEFT JOIN account_list AS category ON category.list_cnt_account=975 AND category.list_hld_holder=8809 AND category.list_mbr_member=0 AND category.list_lng_language IS NULL AND category.list_ref_link IS NULL AND category.list_chr_link=NULL # Категории по параметрам LEFT JOIN account_attribute AS category_length ON category_length.attribute_cnt_account=975 AND category_length.attribute_hld_holder=18749 AND category_length.attribute_mbr_member=0 AND category_length.attribute_lng_language IS NULL AND category_length.attribute_ref_link IS NULL AND NULLIF(category_length.attribute_chk_property, 0) IS NOT NULL AND category_length.attribute_chr_link=NULL # Линковка между категориями и лодками LEFT JOIN reestr_join AS category_join ON category_join.join_account=975 AND category_join.join_holder=8809 AND category_join.join_this_holder=5531 AND category_join.join_that_table='account_list' AND category_join.join_this_table='account_boat' AND category_join.join_this = boat_uid_id AND category_join.join_that = COALESCE(category.list_ref_link, category.list_uid_id) # Если в URL есть страна, то ищем страну на русском LEFT JOIN account_list country_ru ON country_ru.list_cnt_account=975 AND country_ru.list_hld_holder=17478 AND country_ru.list_mbr_member=0 AND country_ru.list_lng_language IS NULL AND IFNULL(country_ru.list_enm_show, 'NO') = 'NO' AND country_ru.list_chr_href = NULL # Страна на текущем языке, кроме русского LEFT JOIN account_list country_lang ON country_lang.list_cnt_account=975 AND country_lang.list_hld_holder=17478 AND country_lang.list_mbr_member=0 AND country_lang.list_lng_language = NULL AND IFNULL(country_lang.list_enm_show, 'NO') = 'NO' AND country_lang.list_ref_link = country_ru.list_uid_id WHERE a.boat_cnt_account = 975 AND a.boat_hld_holder = 5531 AND a.boat_mbr_member = 0 AND # Если стоит галочка выключить для стран не из СНГ, то проверяем страну (берётся из body), иначе TRUE IF(IFNULL(a.boat_enm_hide,'NO') = 'YES', 0, TRUE) AND a.boat_lng_language IS NULL /* объединения нет, доп. язык тоже не выбран, берем основной (module:432753) */ AND a.boat_chr_link LIKE ? ORDER BY boat_sort_irrelevant , boat_sort_search , boat_sort_featured , boat_int_maxlength DESC LIMIT 1 /* module_id:432753 URN */]
Cookies
Мы используем файлы cookie для улучшения вашего пользовательского опыта и анализа трафика сайта. Нажимая «Принять», вы соглашаетесь с использованием файлов cookie в соответствии с нашей Политикой обработки персональных данных.