- Error type:
MySQL Error
- Source, line:
Parser::tws_filters_new[1178]
- Error message:
Table 'admin_velikiutf.MS8_tws_filtercache' doesn't exist
SELECT fc.brand_id, COUNT(DISTINCT fc.store_id) num
FROM MS8_store_info si13,MS8_store_info si847,MS8_store_info si845,MS8_store_info si875,MS8_store_info si12, MS8_tws_filtercache fc,
MS8_tws_tmp_filtergoods tmp
WHERE si13.info_id=13 AND si13.value_id IN (74826) AND fc.store_id=si13.store_id AND si847.info_id=847 AND si847.value_id IN (101438) AND fc.store_id=si847.store_id AND si845.info_id=845 AND si845.value_id IN (75073) AND fc.store_id=si845.store_id AND si875.info_id=875 AND si875.value_id IN (98011) AND fc.store_id=si875.store_id AND si12.info_id=12 AND si12.value_id IN (224030) AND fc.store_id=si12.store_id AND fc.store_id = tmp.id
GROUP BY fc.brand_id