- 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 si1466,MS8_store_info si2860,MS8_store_info si1766, MS8_tws_filtercache fcd, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE si1466.info_id='1466' AND si1466.value_id IN (146392) AND fc.store_id=si1466.store_id AND si2860.info_id='2860' AND si2860.value_id IN (250940) AND fc.store_id=si2860.store_id AND si1766.info_id='1766' AND si1766.value_id IN (184005) AND fc.store_id=si1766.store_id AND fcd.info_id = 14 AND fcd.store_id = fc.store_id AND fcd.value_id = 1 AND fc.info_id IN (1465,1487, 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 fc1466,MS8_tws_filtercache fc2860,MS8_tws_filtercache fc14, MS8_tws_filtercache fc
WHERE fc1466.info_id=1466 AND fc1466.value_id IN (146392,0) AND fc.store_id=fc1466.store_id AND fc2860.info_id=2860 AND fc2860.value_id IN (250940,0) AND fc.store_id=fc2860.store_id AND fc14.info_id=14 AND fc14.value_id IN (1,0) AND fc.store_id=fc14.store_id AND fc.info_id = '1766'
AND fc.topic_id IN(3047,4231,4307,4308)
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 fc1766,MS8_tws_filtercache fc2860,MS8_tws_filtercache fc14, MS8_tws_filtercache fc
WHERE fc1766.info_id=1766 AND fc1766.value_id IN (184005,0) AND fc.store_id=fc1766.store_id AND fc2860.info_id=2860 AND fc2860.value_id IN (250940,0) AND fc.store_id=fc2860.store_id AND fc14.info_id=14 AND fc14.value_id IN (1,0) AND fc.store_id=fc14.store_id AND fc.info_id = '1466'
AND fc.topic_id IN(3047,4231,4307,4308)
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 fc1766,MS8_tws_filtercache fc1466,MS8_tws_filtercache fc14, MS8_tws_filtercache fc
WHERE fc1766.info_id=1766 AND fc1766.value_id IN (184005,0) AND fc.store_id=fc1766.store_id AND fc1466.info_id=1466 AND fc1466.value_id IN (146392,0) AND fc.store_id=fc1466.store_id AND fc14.info_id=14 AND fc14.value_id IN (1,0) AND fc.store_id=fc14.store_id AND fc.info_id = '2860'
AND fc.topic_id IN(3047,4231,4307,4308)
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 fc1766,MS8_tws_filtercache fc1466,MS8_tws_filtercache fc2860, MS8_tws_filtercache fc
WHERE fc1766.info_id=1766 AND fc1766.value_id IN (184005,0) AND fc.store_id=fc1766.store_id AND fc1466.info_id=1466 AND fc1466.value_id IN (146392,0) AND fc.store_id=fc1466.store_id AND fc2860.info_id=2860 AND fc2860.value_id IN (250940,0) AND fc.store_id=fc2860.store_id AND fc.info_id = '14'
AND fc.topic_id IN(3047,4231,4307,4308)
AND fc.value_id > 0
GROUP BY fc.value_id