消息MySQL Query Error
SQLSELECT IFNULL(o.num,0) AS salenum, g.goods_id, g.goods_name, g.click_count, g.goods_number, g.goods_name_style, g.add_time, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img FROM `yequu`.`qt_goods` AS g LEFT JOIN `yequu`.`qt_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' LEFT JOIN (SELECT SUM(og.`goods_number`) AS num,og.goods_id FROM ecs_order_goods AS og, ecs_order_info AS oi WHERE oi.pay_status = 2 AND oi.order_status >= 1 AND oi.order_id = og.order_id GROUP BY og.goods_id) AS o ON o.goods_id = g.goods_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('5','20','174','175','193','120','176','131','19','177','190','191','199','212','17','172','173','69','18','56','115','194','118','196','197','198') OR g.goods_id IN ('325','327','329','330','334','337','340','343','345','346','347','350','353','355','357','359','362','363','365','367','370','372','374','376','380','383','385','389','391','395','396','398','400','402','404','406','408','411','414','417','418','419','420','421','422','423','424','428','438','440','442','445','448','451','452','453','454','455','456','457','459','531','532','533','534','539','540','541','543','544','547','548','550','551','553','555','557','560','561','563','571','574','576','578','581','583','585','591','593','597','601','604','606','607','610','613','614','615','637','640','643','645','647','649','651','653','655','658','659','660','661','662','663','664','666','671','672','674','675','676','678','681','683','685','689','691','693','695','699','701','703','706','707','710','712','714','716','717','719','720','723','725','728','730','737','738','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','761','763','765','767','770','772','773','825','827','829','831','833','834','874','877','878','880','881','883','884','885','886','888','890','895','897','898','900','903','906','907','909','910','913','916','917','918','921','923','924','925','926','927','928','930','1130','1137','1139','1140','1141','1142','1147','1150','1153','1154','1156','1159','1162','1163','1164','1169','1170','1172','1173','1174','1176','1178','1181','1184','1186','1188','1218','1230','1231','1232','1233','1234','1235','1236','1274','1277','1280','1281','1283','1285','1288','1290','1291','1338','1339','1342','1366','1371','1373','1376','1377','1383','1384','1385','1386','1387','1390','1399','1424','1426','1441','1442','1443','1444','1445','1446','1449','1450','1454','1455','1456','1457','1458','1460','1462','1464','1465','1466','1467','1469','1470','1471','1505','1506','1508','1509','1510','1511','1645','1646','1647','1648','1649','1650','1651','1657','1658','1659','1660','1661','1662','1663','1666','1668','1670','1674','1676','1677','1678','1679','1682','1683','1684','1685','1709','1712','1714','1716','1743','1744','1745','1746','1747','1748','1757','1758','1759','1760','1761','1762','1763','1765','1813','1814','1816','1818','1820','1875','1876','1877','1878','1882','1890','1891','1893','1895','1896','1899','1900','1902','1904','1906','1907','1909','1910','1911','1913','1915','1917','1918','1921','1925','1928','1932','1933','1935','1939','1941','1942','1944','1945','1947','1948','1949','1950','1951','1952','1953','1954','1955','1956','1957','1958','1959','1960','1961','1962','1963','1964','1965','1966','1967','1968','1969','1970','1971','1972','1973','1974','1975','1980','1989','1993','1995','1997','1999','2000','2001','2002','2003','2005','2007','2009','2011','2012','2017','2019','2021','2023','2024','2041','2042','2043','2044','2045','2046','2047','2048','2049','2050','2051','2052','2053','2054','2055','2056','2058','2065','2066','2067','2068','2069','2070','2071','2072','2073','2074','2075','2076','2077','2078','2079','2080','2081','2082','2083','2085','2086','2087','2088','2089','2090','2091','2092','2093','2094','2095','2096','2097','2098','2099','2100','2101','2102','2103','2104','2105','2106','2107','2108','2109','2110','2111','2112','2113','2114','2115','2116','2117','2118','2119','2120','2121','2122','2123','2124','2127','2128','2129','2131','2132','2133','2135','2136','2271','2272','2273','2274','2275','2276','2277','2278','2317','2319','2321','2322','2324','2326','2328','2329','2331','2332','2334','2338','2339','2340','2341','2342','2343','2345','2346','2347','2349','2350','2351','2352','2354','2356','2357','2364','2365','2367','2368','2369','2370','2374','2376','2377','2378','2379','2382','2383','2386','2392','2395','2396','2398','2405','2411','2414','2415','2417','2418','2419','2421','2422','2425','2454','2463','2465','2466','2468','2471','2473','2475','2477','2478','2479','2480','2482','2483','2485','2487','2488','2489','2491','2493','2497','2498','2499','2500','2501','2502','2503','2504','2505','2506','2507','2508','2509','2510','2511','2512','2513','2514','2515','2516','2517','2518','2519','2520','2521','2522','2523','2524','2525','2526','2527','2528','2529','2530','2531','2532','2533','2534','2535','2536','2537','2538','2539','2540','2541','2542','2543','2544','2545','2546','2547','2548','2549','2550','2551','2552','2553','2554','2555','2556','2557','2558','2559','2560','2561','2562','2563','2564','2565','2566','2567','2568','2569','2570','2571','2572','2574','2575','2576','2577','2579','2581','2584','2587','2591','2594','2600','2602','2603','2604','2605','2606','2609','2611','2612','2614','2615','2616','2618','2619','2620','2622','2623','2625','2626','2628','2629','2631','2632','2634','2635','2636','2637','2639','2640','2641','2643','2644','2645','2646','2648','2649','2651','2653','2654','2655','2657','2658','2660','2661','2662','2666','2667','2669','2670','2672','2674','2675','2676','2677','2679','2680','2682','2683','2684','2687','2689','2690','2692','2696','2702','2704','2711','2712','2713','2714','2726','2727','2728','2729','2730','2731','2732','2733','2734','2735','2736','2738','2741','2742','2743','2748','2749','2751','2754','2755','2756','2757','2758','2759','2760','2761','2764','2765','2766','2767','2768','2769','2770','2771','2772','2773','2774','2775','2776','2777','2778','2779','2780','2782','2783','2788','2790','2793','2794','2795','2796','2797','2798','2799','2801','2802','2803','2804','2805','2806','2807','2809','2810','2812','2815','2816','2819','2820','2822','2823','2825','2826','2829','2832','2833','2834','2839','2840','2841','2842','2843','2844','2845','2846','2847','2848','2849','2850','2851','2852','2853','2855','2856','2857','2858','2859','2860','2861','2862','2863','2864','2865','2866','2867','2868','2869','2870','2871','2872','2873','2874','2875','2876','2877','2878','2879','2880','2881','2882','2883','2884','2885','2886','2888','2899','2976') )AND g.brand_id=185 ORDER BY salenum DESC LIMIT 24
错误Table 'yequu.ecs_order_goods' doesn't exist
代码1146