- Error type:
MySQL Error
- Source, line:
Parser::tws_shop_topic[3179]
- Error message:
Deadlock found when trying to get lock; try restarting transaction
CREATE TEMPORARY TABLE MS8_tws_tmp_store (id INT UNSIGNED NOT NULL) ENGINE=MyISAM
AS SELECT DISTINCT store.id FROM MS8_store store
LEFT JOIN MS8_currency curr ON store.price_curr_id = curr.id
LEFT JOIN MS8_topic_store topic_store ON topic_store.store_id = store.id JOIN MS8_tws_tmp_subtopics AS subtopics
ON subtopics.id = topic_store.topic_id
JOIN MS8_store_info store_info844 ON store_info844.store_id=store.id AND store_info844.value_id IN(75070) JOIN MS8_store_info store_info13 ON store_info13.store_id=store.id AND store_info13.value_id IN(74826) JOIN MS8_store_info store_info111 ON store_info111.store_id=store.id AND store_info111.value_id IN(75064) JOIN MS8_store_info store_info845 ON store_info845.store_id=store.id AND store_info845.value_id IN(75074,75076) JOIN MS8_store_info store_info873 ON store_info873.store_id=store.id AND store_info873.value_id IN(94445) WHERE store.no_visible=0 AND store.kind_key='kDefault' AND IF(store.price_curr_id>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price)>=7000 AND IF(store.price_curr_id>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price)<=9000 AND store.status_key <> 'kAbsent'