- 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 si231,MS8_store_info si237, MS8_tws_filtercache fc,
MS8_tws_tmp_filtergoods tmp
WHERE si231.info_id=231 AND si231.value_id IN (92269) AND fc.store_id=si231.store_id AND si237.info_id=237 AND si237.value_id IN (9942) AND fc.store_id=si237.store_id AND fc.store_id = tmp.id
GROUP BY fc.brand_id
UNION ALL
SELECT fc.brand_id, COUNT(DISTINCT fc.store_id) num
FROM MS8_store_info si231,MS8_store_info si237, MS8_tws_filtercache fc
WHERE si231.info_id=231 AND si231.value_id IN (92269) AND fc.store_id=si231.store_id AND si237.info_id=237 AND si237.value_id IN (9942) AND fc.store_id=si237.store_id AND fc.topic_id IN(102,4859,4860,5037)
GROUP BY fc.brand_id