• Error type: MySQL Error
• Source, line: Parser::tws_filters_blank[2191]
• 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 
                          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)>=1 AND IF(store.price_curr_id>0, IF(curr.division=1, store.price/curr.multiplex, store.price*curr.multiplex), store.price)<=2000000 AND store.status_key <> 'kAbsent'