Description | Unfortunately a query has failed [SELECT r.*,r.id AS id,r.cc_id AS r_cc_id,b.cv_value AS b_cv_value FROM cms_catalogue_fields f LEFT JOIN cms_catalogue_entries r ON (r.c_name=f.c_name) LEFT JOIN cms_catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN cms_catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN cms_catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN cms_catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id) JOIN cms_seo_meta_keywords m ON (m.meta_for_type='catalogue_entry' AND m.meta_for_id=r.id) JOIN cms_translate tm ON tm.id=m.meta_keyword AND tm.language='EN' WHERE tm.text_original='sentinel' AND r.c_name NOT LIKE '\_%' ORDER BY cv_value DESC/* 81c4f779da207 */ LIMIT 10] [Column 'cv_value' in order clause is ambiguous] (version: 10.0, PHP version: 5.6.30, URL: /composr/V10/site/index.php?page=search&type=results&all_defaults=0&content=sentinel&author=&days=-1&sort=title&direction=DESC&search_catalogue_entries=1) |
---|