« MODx Parse Error »

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Got error 28 from storage engine »
      SQL:  SELECT SQL_CALC_FOUND_ROWS p.id, p.id AS idpr, p.alias, c.parent, p.xml_desc, p.nameR as name, imgNum as img, p.`descR` as `desc`, IF((p.`altR` = ""),p.nameR,p.`altR`) as `alt`, IF((p.`imgTitleR` = ""),p.nameR,p.`imgTitleR`) as imgTitle, p.deniedOrder, IF(ISNULL(cMain.alias),"product",cMain.alias) as `mainCatAlias`, IF(1=1,(opt.price + 830),(((opt.price + opt.PPDisc))*1*if(isnull(opt.mlt),1,opt.mlt)+if(isnull(opt.plus),0,opt.plus)+600+830)) as price, if(opt.old_price>0,opt.old_price*1*if(isnull(opt.mlt),1,opt.mlt)+if(isnull(opt.plus),0,opt.plus)+600+830,0) as old_price FROM `alpha_fl_product_cat` AS a LEFT JOIN `alpha_fl_category` as c ON c.id=a.idcat LEFT JOIN `alpha_fl_product` AS p ON p.id= a.idpr LEFT JOIN `alpha_fl_category` AS cMain ON cMain.id=p.id_main_category LEFT JOIN `alpha_fl_partner_product` AS pp ON pp.id_product = p.id LEFT JOIN `alpha_fl_product_sequ` AS s ON (s.idcat=a.idcat OR s.idcat=c.parent) AND s.idpr=a.idpr LEFT OUTER JOIN ( SELECT a.id, IF(ISNULL(pr_price.price), a.price, pr_price.price) AS price, a.old_price, ( select exp(sum(log(`value`))) as coefMlt FROM `alpha_fl_coef` as fc WHERE fc.id_pr = a.id AND "2024-03-29 0:0:1" BETWEEN CONCAT(YEAR("2024-03-29 0:0:1"), '-', fc.date_begin, ' 00:00:00' ) AND concat(YEAR("2024-03-29 0:0:1") , '-', fc.date_end, ' 23:59:59') AND fc.`type`=0 AND fc.disabled=0 ) as Mlt,( select sum(`value`) as Plus FROM `alpha_fl_coef` as fc WHERE fc.id_pr=a.id AND "2024-03-29 0:0:1" BETWEEN CONCAT(YEAR("2024-03-29 0:0:1") , '-', fc.date_begin, ' 00:00:00' ) AND concat(YEAR("2024-03-29 0:0:1") , '-',fc.date_end, ' 23:59:59') AND fc.`type`=1 AND fc.disabled=0 ) as Plus, IF(ISNULL(pr_price.price),a.price,pr_price.price)/100*if(ISNULL((SELECT alpha_fl_partner_product.margin FROM alpha_fl_partner_product WHERE alpha_fl_partner_product.id_product=a.id)),0,(SELECT alpha_fl_partner_product.margin FROM alpha_fl_partner_product WHERE alpha_fl_partner_product.id_product=a.id)) as PPDisc FROM `alpha_fl_view_product` as a LEFT OUTER JOIN ( SELECT p.id, MIN(IF(!ISNULL(opc.price),opc.price,IF(!ISNULL(opr.price),opr.price,IF(!ISNULL(opct.price), opct.price, IF(!ISNULL(opb.price),opb.price,po.price))))) AS price FROM alpha_fl_product as p LEFT JOIN alpha_fl_product_opt as po ON p.id=po.idpr LEFT JOIN alpha_fl_option_price as opc ON opc.id_option=po.id AND opc.id_city=-1 LEFT JOIN alpha_fl_option_price as opr ON opr.id_option=po.id AND opr.id_region=-1 LEFT JOIN alpha_fl_option_price as opct ON opct.id_option=po.id AND opct.id_country=-1 LEFT JOIN alpha_fl_option_price as opb ON opb.id_option=po.id AND opb.id_city=0 AND opb.id_region=0 AND opb.id_country=0 WHERE 1 = 1 GROUP BY p.id ) AS pr_price ON pr_price.id=a.id ) opt ON opt.id=a.idpr LEFT OUTER JOIN (SELECT COUNT(cpr.id) AS currentPromositeCount, prc.idpr FROM alpha_fl_category_promosite AS cpr LEFT JOIN alpha_fl_product_cat AS prc ON prc.idcat=cpr.id_category WHERE cpr.id_promosite="46" GROUP BY prc.idpr) as cpr ON cpr.idpr=p.id LEFT OUTER JOIN (SELECT COUNT(cpr.id) AS allPromositeCount, prc.idpr FROM alpha_fl_category_promosite AS cpr LEFT JOIN alpha_fl_product_cat AS prc ON prc.idcat=cpr.id_category GROUP BY prc.idpr) as allcpr ON allcpr.idpr=p.id WHERE p.id_partner = "0" AND (c.id=24 OR c.parent=24) AND p.disabled = 0 AND c.public=1 AND (ISNULL(allcpr.allPromositeCount) || allcpr.allPromositeCount = 0 || (allcpr.allPromositeCount > 0 && cpr.currentPromositeCount > 0)) GROUP BY p.id ORDER BY p.deniedOrder, p.nameR LIMIT 0,999
      [Copy SQL to ClipBoard]
 
Parser timing
  MySQL: 2.3312 s(30 Requests)
  PHP: 1.0704 s 
  Total: 3.4016 s