torusModel: set sql: SELECT TOP 1 p.id, p.category, p.code, p.name_el, p.name_url, p.itemtype, p.stock, p.availablefrom, p.availablein /*, p.price, p.oldprice, p.wholesale, p.oldwholesale */ , CAST(price * 1 AS money) AS price , CAST(oldprice * 1 AS money) AS oldprice , p.discount, p.embed , p.photo, p.photos, p.partNumber, p.partnumber2, p.specs_el, p.text_el, p.extrainfo , p.layout AS productLayout , c.category_el AS catname, c.path_el AS catPath, c.series AS catseries , c.path_el AS catpath_el, c.path_en AS catpath_en , CAST(CASE WHEN LEFT(ISNULL(c.series,'')+' ', 4)='0017' THEN 1 ELSE 0 END AS bit) AS nwpart , CASE WHEN category_url LIKE 'mobile-accessories%' AND NOT category_url LIKE 'mobile-accessories-mobile-phones' THEN 1 ELSE 0 END AS mobaccessories , brands.brand_el AS brandName, pm.models AS modelid, pst.value_el AS pStatus , pqu.value_el AS pQuality, pgu.value_el AS pGuarantee , c0.catspecs /* , ISNULL(mp.photo,'') AS masterphoto, ISNULL(mp.name_url,'') AS masterurl */ FROM products p INNER JOIN categories c ON p.category=c.id LEFT JOIN brands ON p.brand=brands.id LEFT JOIN productsModels pm ON p.id=pm.products LEFT JOIN arrays pst ON (ISNULL(p.productStatus,0)=pst.id AND pst.grp='productStatus') LEFT JOIN arrays pqu ON (ISNULL(p.productQuality,0)=pqu.id AND pqu.grp='productQuality') LEFT JOIN arrays pgu ON (ISNULL(p.guarantee,0)=pgu.id AND pgu.grp='guarantee') LEFT JOIN ( SELECT series, specs_el AS catspecs FROM categories WHERE ISNULL(parent,0)=0 ) c0 ON LEFT(c.series,4)=c0.series /* LEFT JOIN ( SELECT category, model, photo, name_url FROM products WHERE itemtype='MASTER' ) mp ON p.category=mp.category AND p.model=mp.model */ WHERE p.visible=1 AND (p.stock>0 OR LEFT(ISNULL(c.series,'')+' ', 4)='0017' OR availablein=80) AND (p.price>0 OR LEFT(ISNULL(c.series,'')+' ', 4)='0017') AND p.id=51702 AND NOT code IN ('6.999.037', '6.999.038')
Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.