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.