- Error type:
MySQL Error
- Source, line:
Parser::tws_filters_new[518]
- 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_store_info si13, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE si13.info_id='13' AND si13.value_id IN (74876) AND fc.store_id=si13.store_id AND fc.info_id IN (1344,1345,1858,1348,1347,1856,1857,1913,111,844,847,1957,1958,773,845,873,875,1365,1346,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 = '13'
AND fc.topic_id IN(2889,3614,3615,3620,3621,3622,3623,3624,4925,5408)
AND fc.value_id > 0
GROUP BY fc.value_id