- 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 si1918,MS8_store_info si13, MS8_tws_filtercache fcd, MS8_tws_filtercache fc USE INDEX(store_info_value),
MS8_tws_tmp_filtergoods tmp
WHERE si1918.info_id='1918' AND si1918.value_id IN (188931) AND fc.store_id=si1918.store_id AND si13.info_id='13' AND si13.value_id IN (75009,76536) AND fc.store_id=si13.store_id AND fcd.info_id = 14 AND fcd.store_id = fc.store_id AND fcd.value_id = 1 AND fc.info_id IN (1066,1930,1933,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 fc1918,MS8_tws_filtercache fc14, MS8_tws_filtercache fc
WHERE fc1918.info_id=1918 AND fc1918.value_id IN (188931,0) AND fc.store_id=fc1918.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 = '13'
AND fc.topic_id IN(3701,3968,4139,4140,4141,4293)
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 fc1918,MS8_tws_filtercache fc14, MS8_tws_filtercache fc
WHERE fc1918.info_id=1918 AND fc1918.value_id IN (188931,0) AND fc.store_id=fc1918.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 = '13'
AND fc.topic_id IN(3701,3968,4139,4140,4141,4293)
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 fc14, MS8_tws_filtercache fc
WHERE fc13.info_id=13 AND fc13.value_id IN (75009,76536,0) AND fc.store_id=fc13.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 = '1918'
AND fc.topic_id IN(3701,3968,4139,4140,4141,4293)
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 fc1918, MS8_tws_filtercache fc
WHERE fc13.info_id=13 AND fc13.value_id IN (75009,76536,0) AND fc.store_id=fc13.store_id AND fc1918.info_id=1918 AND fc1918.value_id IN (188931,0) AND fc.store_id=fc1918.store_id AND fc.info_id = '14'
AND fc.topic_id IN(3701,3968,4139,4140,4141,4293)
AND fc.value_id > 0
GROUP BY fc.value_id