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.restaurant_type_text LIKE '%bursinel%') OR comp.city LIKE '%bursinel%' ) AND comp.status = 'A' GROUP BY comp.company_id ORDER BY distance asc LIMIT 0, 12

Backtrace:

File:	/wwwdata/vhosts/provino.ch/httpdocs/core/fn.database.php
Line:	310
Function:	db_error
File:	/wwwdata/vhosts/provino.ch/httpdocs/core/fn.database.php
Line:	37
Function:	db_query
File:	/wwwdata/vhosts/provino.ch/httpdocs/core/fn.companies.php
Line:	476
Function:	db_get_array
File:	/wwwdata/vhosts/provino.ch/httpdocs/controllers/customer/companies.php
Line:	812
Function:	fn_get_companies
File:	/wwwdata/vhosts/provino.ch/httpdocs/core/fn.control.php
Line:	569
Function:	include
File:	/wwwdata/vhosts/provino.ch/httpdocs/core/fn.control.php
Line:	423
Function:	fn_run_controller
File:	/wwwdata/vhosts/provino.ch/httpdocs/index.php
Line:	32
Function:	fn_dispatch