CNI
This site uses cookies to deliver a better experience.
Proceeding with navigation, you consent to use our cookies. ACCEPT LEARN MORE ACCEPT
SELECT l.* FROM (SELECT DISTINCT(y.yref), y.ca_sales_hide, y.not_for_sale, y.pls_enquire, y.charter_hide, y.name, y.embed, y.embed_background, y.concept, y.project, y.pre_engineered, y.reduced_lead_time, y.virtual_tour, y.sistership, y.url, '' as type, y., y.yr_built, y.status_sale, y.status_charter, y.m_built, y.yr_refit, y., y., y., y.path, y.cover_align, b.bu_name, y.cmd_yacht, '1' as featured, y.instant_booking, y.exclusive, y.internal_charter, y.under_construction, y.new_for_sale, y.new_for_charter FROM cni_view_yacht y, c4_builder b, cni_yacht_features yf, cni_featured fd, cni_featured_price p WHERE AND fd.status = 1 AND NOW() BETWEEN p.from_date AND p.to_date AND yf.id_feature = '6' AND yf.id_yacht = y.yref AND b.bu_id = y.s_builder_c AND fd.id_yacht = y.yref AND fd.id = p.id_feature UNION SELECT DISTINCT(y.yref), y.ca_sales_hide, y.not_for_sale, y.pls_enquire, y.charter_hide, y.name, y.embed, y.embed_background, y.concept, y.project, y.pre_engineered, y.reduced_lead_time, y.virtual_tour, y.sistership, y.url, '' as type, y., y.yr_built, y.status_sale, y.status_charter, y.m_built, y.yr_refit, y., y., y., y.path, y.cover_align, b.bu_name, y.cmd_yacht, '0' as featured, y.instant_booking, y.exclusive, y.internal_charter, y.under_construction, y.new_for_sale, y.new_for_charter FROM cni_view_yacht y, cni_yacht_features yf, c4_builder b WHERE AND yf.id_feature = '6' AND yf.id_yacht = y.yref AND b.bu_id = y.s_builder_c) as l GROUP BY yref ORDER BY DESC, base_price DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' y.yr_built, y.status_sale, y.status_charter, y.m_built, y.yr_refit, y., y., y.,' at line 3