Продажа яхт

Поиск по яхтам

Все яхты

Ошибка SQL: Column 'list_set_category' in field list is ambiguous
SQL: [SELECT COALESCE(a.list_ref_link,a.list_uid_id) AS list_uid_id, a.list_lng_language, a.list_ref_link, list_set_category AS Name, a.list_ind_index, COALESCE(a.list_img_glyph, ru.list_img_glyph) AS list_img_glyph, a.list_chr_link, ( SELECT COUNT(boat_uid_id) FROM account_boat INNER JOIN reestr_join ON join_account=975 AND join_holder=8809 /* join_that_holder, категории яхт */ AND join_this=boat_uid_id AND join_this_table='account_boat' AND join_this_holder=5531 /* сами яхты */ AND join_that_table='account_list' WHERE boat_cnt_account=975 AND boat_hld_holder = 5531 AND boat_mbr_member=0 AND ( boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') OR boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ) AND boat_ref_link IS NULL AND boat_lng_language IS NULL AND (CASE WHEN NULL = 'new' THEN boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') WHEN NULL = 'brokerage' THEN boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ELSE ( boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') OR boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ) END) AND join_that=COALESCE(a.list_ref_link,a.list_uid_id) ) AS Amount FROM account_list a # основная языковая версия (русская) LEFT JOIN account_list AS `ru` ON ru.list_cnt_account=a.list_cnt_account AND ru.list_hld_holder=a.list_hld_holder AND ru.list_mbr_member=a.list_mbr_member AND ru.list_lng_language IS NULL AND ru.list_ref_link IS NULL AND ru.list_uid_id=a.list_ref_link WHERE a.list_cnt_account = 975 AND a.list_hld_holder=8809 AND a.list_mbr_member=0 AND COALESCE(a.list_chk_attribute,ru.list_chk_attribute) & get_azimut_boat_code('ru.azimutyachts.ua') AND NULL IS NULL # Проверяем что в категории есть лодки AND ( SELECT COUNT(boat_uid_id) FROM account_boat INNER JOIN reestr_join ON join_account=975 AND join_holder=8809 /* join_that_holder, категории яхт */ AND join_this=boat_uid_id AND join_this_table='account_boat' AND join_this_holder=5531 /* сами яхты */ AND join_that_table='account_list' WHERE boat_cnt_account=975 AND boat_hld_holder = 5531 AND boat_mbr_member=0 AND ( boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') OR boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ) AND boat_ref_link IS NULL AND boat_lng_language IS NULL AND (CASE WHEN NULL = 'new' THEN boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') WHEN NULL = 'brokerage' THEN boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ELSE ( boat_chk_stock & get_azimut_boat_code('ru.azimutyachts.ua') OR boat_chk_used & get_azimut_boat_code('ru.azimutyachts.ua') ) END) # Если стоит галочка выключить для стран не из СНГ, то проверяем страну (берётся из body), иначе TRUE AND IF(boat_enm_hide = 'YES', 0, TRUE) AND join_that=COALESCE(a.list_ref_link,a.list_uid_id)) > 0 AND a.list_lng_language IS NULL /* объединения нет, доп. язык тоже не выбран, берем основной (module:255234) */ AND a.list_chr_link LIKE ? ORDER BY list_ind_index LIMIT 1 /* module_id:255234 URN */]
Специальные предложения Спеціальні пропозиції Special Offers Yachten zum Verkauf Ưu đãi đặc biệt АРЕНДА ЯХТ YACHT CHARTER YACHT CHARTER YACHT CHARTER YACHT CHARTER