- Error type:
MySQL Error
- Source, line:
Parser::tws_filters_new[568]
- Error message:
Table 'admin_velikiutf.MS8_tws_filtercache' doesn't exist
SELECT fc.value_id AS id, COUNT(DISTINCT fc.store_id) num
FROM MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE fc.info_id IN (844,845,111,875,873,847,773,1365,12,1163,2709, 0)
AND fc.store_id = tmp.id
AND fc.value_id > 0
GROUP BY fc.value_id
UNION ALL
SELECT fc.value_id AS id, COUNT(DISTINCT fc.store_id) num
FROM MS8_tws_filtercache fc
WHERE fc.info_id = '841'
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)
AND fc.value_id > 0
GROUP BY fc.value_id