消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `tianlong`.`ecs_goods` AS g, `tianlong`.`ecs_order_info` AS o, `tianlong`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('318','306','328','1','10','32','33','316','317','34','35','8','15','16','19','21','22','324','325','9','24','25','231','31','26','11','36','37','40','14','58','60','63','59','330','3','121','124','125','126','127','232','305','122','168','169','170','171','172','123','201','202','205','319','307','308','310','312','326','309','331','4','235','314','315','236','304','2','64','74','295','66','83','84','88','90','297','5','243','291','288','292','289','293','290','287','244','284','281','285','282','279','286','283','280','241','268','265','272','269','266','273','270','267','271','242','278','275','276','277','274','237','259','320','321','323','263','261','322','260','240','262','264','258','238','252','256','253','257','254','255','239','249','246','250','247','251','248','245','7','6','298') OR g.goods_id IN ('328','1626','1645','1647','1649','1650','1651','1653','1654','1656','1658','1659','1660','1665','1666','1667','1671','1674','1675','1676','1677','1678','1679','1680','1681','1682','1683','1684','1685','1686','1687','1688','1689','1690','1691','1692','1693','1694','1695','1696','1697','1698','1699','1700','1703','1704','1712','1717','1719','1720','1721','1722','1723','1777','1778','1779','1780','1781','1782','1783','1784','1785','1792','1794','1796','1804','1810','1811','1812','1813','1814','1826','1833','1834','1835','1936','1959','1964','1976','2037','2039','2059','2060','2061','2062','2063','2064','2065','2066','2067','2068','2078','2079','2080','2081','2082','2083','2084','2085','2086','2087','2088','2089','2090','2091','2092','2093','2094','2095','2099','2100','2104','2105','2108','2109','2110','2112','2122','2123','2124','2125','2126','2127','2128','2129','2130','2131','2132','2133','2134','2135','2136','2137','2138','2139','2140','2141','2142','2143','2144','2145','2146','2147','2148','2149','2150','2155','2156','2157','2158','2194','2195','2196','2197','2203','2204','2205','2207','2212','2218','2219','2220','2222','2282','2283','2284','2285','2286','2287','2288','2289','2290','2291','2292','2293','2294','2295','2296','2297','2298','2299','2300','2301','2302','2303','2304','2306','2307','2308','2309','2310','2311','2312','2313','2314','2315','2316','2317','2318','2319','2320','2321','2322','2323','2324','2325','2326','2327','2328','2329','2330','2331','2332','2333','2334','2335','2336','2337','2338','2339','2340','2341','2342','2343','2383','2386','2404','2405','2407','2408','2762','2816','3132','3133','3134','3151','3152','3300','3302','3305','3354','3512','3727','3728','3730','3731','3732','3733','3734','3735','3736','3737','3753','3754') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 8
错误Table '.\tianlong\ecs_order_info' is marked as crashed and should be repaired
代码145