Database error: Unknown column 'distance' in 'order clause' (1054)
Invalid query: SELECT comp.company_id, comp.lang_code, comp.email, comp.company, comp.timestamp, comp.status, comp.country, comp.seekda_id, comp.state, comp.city, comp.address, comp.zipcode, comp.phone, comp.restaurant_types, comp.lat, comp.lng, comp.reservation_system, comp.restaurant_type_text, comp.logos, comp.gallery_positions, seo_names.name as seo_name FROM cscart_companies comp LEFT JOIN cscart_seo_names seo_names ON seo_names.object_id = comp.company_id AND seo_names.type = 'm' AND seo_names.dispatch = '' AND seo_names.lang_code = 'FR' WHERE 1 AND comp.status = 'A' AND comp.city LIKE '%cossonay%' GROUP BY comp.company_id ORDER BY distance asc LIMIT 0, 7


Backtrace:
File:/wwwdata/vhosts/proresto.ch/httpdocs/core/fn.database.php
Line:310
Function:db_error
File:/wwwdata/vhosts/proresto.ch/httpdocs/core/fn.database.php
Line:37
Function:db_query
File:/wwwdata/vhosts/proresto.ch/httpdocs/core/fn.companies.php
Line:429
Function:db_get_array
File:/wwwdata/vhosts/proresto.ch/httpdocs/controllers/customer/companies.php
Line:787
Function:fn_get_companies
File:/wwwdata/vhosts/proresto.ch/httpdocs/core/fn.control.php
Line:567
Function:include
File:/wwwdata/vhosts/proresto.ch/httpdocs/core/fn.control.php
Line:422
Function:fn_run_controller
File:/wwwdata/vhosts/proresto.ch/httpdocs/index.php
Line:32
Function:fn_dispatch