- 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_tws_filtercache fcd, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE fcd.info_id = 14 AND fcd.store_id = fc.store_id AND fcd.value_id = 1 AND fc.info_id IN (1499,2705, 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 = '14'
AND fc.topic_id IN(3046,3047,3048,3049,3050,3217,3218,3219,3220,3222,3244,3516,3754,3755,3765,3766,3767,3844,3981,4231,4305,4306,4307,4308,4309,4310,4311,4312,4313,4314,4316,4318,4319,4342,4343,4344,4345,4346,4347,4369,4375,4430,5076)
AND fc.value_id > 0
GROUP BY fc.value_id