- 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 si844,MS8_store_info si773,MS8_store_info si1365, MS8_tws_filtercache fc,
MS8_tws_tmp_filtergoods tmp
WHERE si844.info_id=844 AND si844.value_id IN (133516) AND fc.store_id=si844.store_id AND si773.info_id=773 AND si773.value_id IN (36657) AND fc.store_id=si773.store_id AND si1365.info_id=1365 AND si1365.value_id IN (134759) AND fc.store_id=si1365.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 si844,MS8_store_info si773,MS8_store_info si1365, MS8_tws_filtercache fc
WHERE si844.info_id=844 AND si844.value_id IN (133516) AND fc.store_id=si844.store_id AND si773.info_id=773 AND si773.value_id IN (36657) AND fc.store_id=si773.store_id AND si1365.info_id=1365 AND si1365.value_id IN (134759) AND fc.store_id=si1365.store_id AND fc.topic_id IN(49,1105,1106,1107,1110,1111,2296,2297,2298,2299,2300,2654,2755,3526,3924,3925,4665,5120,5121,5122)
GROUP BY fc.brand_id