• Error type: MySQL Error
• Source, line: Parser::tws_shop_city[351]
• 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 s.id
                FROM MS8_tws_tmp_store2 tmp_store 
                    JOIN MS8_store s
                        ON tmp_store.id = s.id
                    LEFT JOIN MS8_key_value kv
                        ON ( s.status_key = kv.key_name AND kv.key_code = 'STORE_STATUS_KEY' )                    
                ORDER BY kv.pos, RAND(506)