ERROR: DBIx::Class::Storage::DBI::__ANON__(): DBI Exception: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQL-40001) [for Statement "SELECT rank_by_popularity FROM (SELECT ID, DENSE_RANK() OVER (ORDER BY Popularity DESC) AS rank_by_popularity FROM Product WHERE department = 'Adult Sex Toys')p where ID = '7001349N' UNION ALL SELECT rank_by_popularity FROM (SELECT ID, DENSE_RANK() OVER (ORDER BY Popularity DESC) AS rank_by_popularity FROM Product WHERE category = 'Vibrators')p where ID = '7001349N'"] at C:/websites/http/dearladyus/modules/WMAG/Base.pm line 2156