- Error type:
MySQL Error
- Source, line:
Parser::tws_goods_topic[165]
- Error message:
Unknown column 'choice' in 'order clause'
SELECT DISTINCT store.id, store.brand_id, store.code_shop, store.meas, store.status_key,
store.clann, store.disc_group_id, store.how, store.pprice,
store.pprice_curr_id, store.rprice, store.rprice_curr_id, store.price,
store.price_curr_id, store.price2, store.price2_curr_id,
store.price3, store.price3_curr_id, store.relate_type,
store.relate_proc, store.proc_price2, store.proc_price3,
store.min_order, store.step_order, store.seo_psu, store.templ_key,
store.create_time, store.option_code, store.award_cnt, store.award_avg,
kv.value_txt AS store_status, store.state_key,
IF(store.price_curr_id>0, IF(curr.multiplex>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price), store.price) AS price_calc,
IF( LENGTH(info_value.seo_code)>0, info_value.seo_code, CONCAT('color', info_value.id) ) AS color
FROM MS8_tws_tmp_store tmp_store
JOIN MS8_store store
ON tmp_store.id = store.id
LEFT JOIN MS8_key_value kv
ON ( store.status_key = kv.key_name AND kv.key_code = 'STORE_STATUS_KEY' )
LEFT JOIN MS8_currency curr
ON store.price_curr_id = curr.id
LEFT JOIN MS8_store_info store_info
ON store_info.store_id = store.id AND store_info.info_id = '15'
LEFT JOIN MS8_info_value info_value
ON info_value.id = store_info.value_id
ORDER BY choice desc, store.rating DESC LIMIT 0, 30