An exception occurred in shop's script

  • Error type: MySQL Error
  • Source, line: Parser::tws_goods_topic[165]
  • Error message: Unknown column 'hit' 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 hit desc, store.rating DESC LIMIT 0, 30