- 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 si964,MS8_store_info si1510, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE si964.info_id=964 AND si964.value_id IN (189016) AND fc.store_id=si964.store_id AND si1510.info_id=1510 AND si1510.value_id IN (148125) AND fc.store_id=si1510.store_id AND fc.info_id IN (889,1923,1000,998,1924,999,995,1926,996,1438, 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 fc1510, MS8_tws_filtercache fc
WHERE fc1510.info_id=1510 AND fc1510.value_id IN (148125,0) AND fc.store_id=fc1510.store_id AND fc.info_id = '964'
AND fc.topic_id IN(1644,3928,3929)
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 fc964, MS8_tws_filtercache fc
WHERE fc964.info_id=964 AND fc964.value_id IN (189016,0) AND fc.store_id=fc964.store_id AND fc.info_id = '1510'
AND fc.topic_id IN(1644,3928,3929)
AND fc.value_id > 0
GROUP BY fc.value_id