- 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 si111,MS8_store_info si844,MS8_store_info si1957,MS8_store_info si773,MS8_store_info si12,MS8_store_info si1163, MS8_tws_filtercache fc,
MS8_tws_tmp_filtergoods tmp
WHERE si111.info_id=111 AND si111.value_id IN (134327) AND fc.store_id=si111.store_id AND si844.info_id=844 AND si844.value_id IN (75069) AND fc.store_id=si844.store_id AND si1957.info_id=1957 AND si1957.value_id IN (191102) AND fc.store_id=si1957.store_id AND si773.info_id=773 AND si773.value_id IN (36658) AND fc.store_id=si773.store_id AND si12.info_id=12 AND si12.value_id IN (224030) AND fc.store_id=si12.store_id AND si1163.info_id=1163 AND si1163.value_id IN (129472) AND fc.store_id=si1163.store_id AND fc.store_id = tmp.id
GROUP BY fc.brand_id