• Error type: MySQL Error
• Source, line: Parser::tws_shop_topic[3186]
• 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_tws_search_new tws_search ON tws_search.store_id = store.id JOIN MS8_store_info store_info844 ON store_info844.store_id=store.id AND store_info844.value_id IN(75069) JOIN MS8_store_info store_info1383 ON store_info1383.store_id=store.id AND store_info1383.value_id IN(142424) WHERE store.no_visible=0 AND store.kind_key='kDefault' AND store.status_key <> 'kAbsent' AND ( tws_search.store_id = 'спортивні окуляри' OR tws_search.code_shop LIKE '% спортивні окуляри%' OR tws_search.code_prov LIKE '% спортивні окуляри%' OR tws_search.code_made LIKE '% спортивні окуляри%' OR tws_search.name LIKE '% спортивні%' OR tws_search.brand LIKE '% спортивні%' OR tws_search.category LIKE '% спортивні%' OR tws_search.info LIKE '% спортивні%' OR tws_search.name LIKE '% окуляр%' OR tws_search.brand LIKE '% окуляр%' OR tws_search.category LIKE '% окуляр%' OR tws_search.info LIKE '% окуляр%' ) AND store.review <> ''