- 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_store_info si1358,MS8_store_info si1752, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE si13.info_id='13' AND si13.value_id IN (184587) AND fc.store_id=si13.store_id AND si1358.info_id='1358' AND si1358.value_id IN (134276) AND fc.store_id=si1358.store_id AND si1752.info_id='1752' AND si1752.value_id IN (184576) AND fc.store_id=si1752.store_id AND fc.info_id IN (1749,1359,1768,1750,1751,1163, 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 fc1358,MS8_tws_filtercache fc1752, MS8_tws_filtercache fc
WHERE fc1358.info_id=1358 AND fc1358.value_id IN (134276,0) AND fc.store_id=fc1358.store_id AND fc1752.info_id=1752 AND fc1752.value_id IN (184576,0) AND fc.store_id=fc1752.store_id AND fc.info_id = '13'
AND fc.topic_id IN(3466,3595,3596,3597,3598,3599,3600,3601,3602)
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 fc13,MS8_tws_filtercache fc1752, MS8_tws_filtercache fc
WHERE fc13.info_id=13 AND fc13.value_id IN (184587,0) AND fc.store_id=fc13.store_id AND fc1752.info_id=1752 AND fc1752.value_id IN (184576,0) AND fc.store_id=fc1752.store_id AND fc.info_id = '1358'
AND fc.topic_id IN(3466,3595,3596,3597,3598,3599,3600,3601,3602)
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 fc13,MS8_tws_filtercache fc1358, MS8_tws_filtercache fc
WHERE fc13.info_id=13 AND fc13.value_id IN (184587,0) AND fc.store_id=fc13.store_id AND fc1358.info_id=1358 AND fc1358.value_id IN (134276,0) AND fc.store_id=fc1358.store_id AND fc.info_id = '1752'
AND fc.topic_id IN(3466,3595,3596,3597,3598,3599,3600,3601,3602)
AND fc.value_id > 0
GROUP BY fc.value_id