Всего выполнено запросов: 18 шт. за 0.7269 сек. Развернуть Закрыть
Ошибка в SQL запросе: SELECT count(distinct p.id) AS count FROM mg_product p LEFT JOIN mg_category c ON c.id = p.cat_id LEFT JOIN mg_product_variant pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) AS varcount FROM mg_product_variant AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE ((p.cat_id IN ('88','90','200','201','202','223','204','205','206','207','208','224','209','210','211','212','213','214','215','216','217','218','219','220','221','222','91','348','349','350','351','352','353','354','355','95','97','337','338','181','98','197','198','199','99','303','304','305','306','307','308','309','310','311','313','314','315','316','317','318','319','312','31','226','228','230','232','285','289','362','290','291','324','325','326','329','328','327','340','234','360','343','339','342','357','361','186','323','286','287','288','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','53','54','55','56','57','58','59','60','61','62','63','64','65','331','66','67','68','69','70','71','72','73','74','75','336','76','77','78','79','80','81','82','83','84','85','358','359','101','102','104','105','106','108','116','166','109','112','107','117','168','121','110','111','113','119','120','188','190','193','189','191','192','194','195','225','227','229','231','233','235','122','167','100','346','164','237','239','238','240','241','242','243','244','247','248','249','250','257','258','245','263','264','246','252','259','255','256','262','260','266','253','265','261','251','254','165','269','270','271','272','273','274','275','281','276','277','280','282','283','279','278','284','169','170','175','176','178','179','185','172','133','134','135','139','136','137','138','140','141','142','143','144','145','146','147','320','321','322','150','148','149','151','152','153','184','154','155','156','157','158','159','160','161','341','162','163','171','173','174','180','182','183','123','124','126','130','131','125','356','128','132','187','127','196','292','293','294','295','296','298','300','299','301','302','297','129','93','103','344','345','118','0') or FIND_IN_SET(0,p.`inside_cat`))) AND p.activity = 1 AND IF(p.count <0, 1000000, IF(varcount, IF(p.count
Out of memory (Needed 4194288 bytes)

/home/virtwww/w_benzozapchas-com-ua_d0a4b2be/http/mg-core/models/catalog.php (line 221)

/home/virtwww/w_benzozapchas-com-ua_d0a4b2be/http/mg-core/controllers/catalog.php (line 171)

/home/virtwww/w_benzozapchas-com-ua_d0a4b2be/http/mg-core/lib/moguta.php (line 0)

/home/virtwww/w_benzozapchas-com-ua_d0a4b2be/http/mg-core/mg-start.php (line 0)

/home/virtwww/w_benzozapchas-com-ua_d0a4b2be/http/index.php (line 97)