系统繁忙,点击返回
消息MySQL Query ErrorSQLSELECT g.goods_id,g.cat_id, g.goods_name, g.goods_name_style, g.click_count, g.goods_number, g.market_price,g.consignor_id, g.is_new, g.is_best, g.is_hot, g.is_limit, g.is_shipping, g.shop_price AS org_price, g.mappoint,g.is_act_field,g.is_seckill_act_field, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price,g.is_promote,g.is_real_promote, g.promote_price,g.real_promote_price, CASE WHEN g.promote_price != '' AND g.promote_start_date < 1711702981 AND g.promote_end_date > 1711702981 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1711702981 AND g.real_promote_end_date > 1711702981 THEN g.real_promote_price ELSE shop_price END AS shop_p, g.goods_type, g.promote_start_date, g.promote_end_date,g.real_promote_start_date, g.real_promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, g.supplier_id FROM `haoduobaduo`.`ecs_goods` AS g LEFT JOIN `haoduobaduo`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('1700','841','846','843','844','1589','2206','1539','1445','1588','723','746','747','748','749','750','1616','724','751','752','753','755','760','759','725','765','764','766','768','2262','2154','2263','2264','767','2049','2114','2047','2050','2048','2051','1612','1597','1603','1708','1613','1707','1611','1614','1623','2324','2327','2325','2326','1701','1705','1703','1706','1704','1702','2235','2236','2239','2243','2237','2240','2238','2242','2397','722','1327','733','734','1308','1320','1318','736','1460','737','739','1312','1316','1267','1615','1274','1323','1331','2170','1277','2132','1335','2205','1628','1282','2135','1287','1443','1291','1297','2151','2217','2256','1301','1598','1313','2161','1609','1317','1268','1321','1332','2203','1279','735','1336','1568','1285','1432','1288','1444','1292','1298','2218','2115','1304','2155','1309','2159','1600','1314','1270','1322','1276','1330','1334','1280','1337','866','1286','1441','1290','2213','1217','1293','2216','1299','2187','1307','1275','1571','2153') OR g.goods_id IN ('171','185','346','377','403','410','950','951','952','971','989','997','1020','1021','1062','1071','1073','1172','1173','1191','1322','1334','1335','1337','1338','1339','1340','1341','1342','1343','1345','1348','1349','1350','1372','1394','1395','1396','1397','1398','1401','1402','1403','1407','1408','1409','1413','1427','1428','1449','1462','1463','1480','1481','1484','1485','1486','1487','1488','1501','1505','1506','1507','1508','1509','1510','1511','1514','1515','1532','1533','1541','1567','1571','1572','1626','1627','1631','1632','1637','1638','1645','1646','1647','1648','1651','1652','1653','1654','1655','1662','1732','1733','1735','1736','1737','1738','1754','1755','1756','1757','1919','1920','1960','1973','2023','2024','2025','2026','2047','2049','2053','2054','2055','2056','2175','2176','2177','2178','2184','2185','2186','2187','2204','2211','2244','2246','2248','2307','2411','2435','2436','2437','2438','2439','2461','2462','2464','2465','2468','2469','2535','2677','3045','3046','3047','3048','3053','3059','3092','3148','3149','3287','3288','3289','3290','3291','3292','3302','3305','3434','3438','3613','3614','3615','3616','3617','3618','3619','3620','3635','3636','3637','3638','3639','3649','3688','3797','3798','3799','3800','3801','3802','3803','3804','3805','3806','3807','3808','3809','3810','3811','3812','3813','3814','3815','3816','3817','3818','3819','3820','3821','3822','3823','3824','3825','3826','3827','3828','3829','3830','3831','3832','3834','3835','3836','3837','3838','3848','3849','3851','3852','3853','3854','3855','3856','3886','3899','3900','3901','3902','3903','3904','3905','3906','3907','3920','3921','3922','3923','3924','3925','3926','3927','3929','3930','3931','3932','3967','3968','3969','3970','3971','3972','3973','3974','3975','3976','3977','3978','3979','3980','3981','4037','4040','4041','4042','4043','4044','4045','4046','4047','4051','4052','4053','4054','4055','4056','4057','4058','4060','4061','4062','4063','4064','4065','4066','4067','4068','4069','4070','4071','4072','4073','4074','4075','4076','4077','4079','4080','4081','4082','4083','4084','4085','4086','4087','4088','4089','4090','4091','4092','4093','4094','4095','4097','4098','4099','4100','4101','4102','4103','4104','4105','4125','4160','4161','4162','4163','4164','4165','4166','4202','4204','4205','4207','4211','4212','4213','4214','4217','4226','4230','4235','4236','4237','4281','4284','4289','4290','4291','4292','4293','4294','4295','4296','4298','4299','4300','4301','4302','4303','4304','4305','4306','4307','4308','4309','4310','4311','4312','4313','4356','4372','4375','4376','4378','4392','4396','4397','4399','4403','4404','4405','4406','4407','4408','4413','4414','4415','4417','4418','4419','4420','4421','4427','4428','4429','4430','4431','4432','4433','4440','4441','4442','4443','4448','4452','4454','4455','4459','4465','4466','4467','4468','4470','4471','4472','4473','4474','4477','4479','4486','4488','4490','4491','4492','4498','4500','4501','4502','4503','4504','4505','4506','4508','4509','4510','4511','4512','4514','4516','4517','4519','4523','4526','4530','4532','4533','4534','4551','4562','4564','4565','4566','4567','4568','4569','4570','4573','4608','4738','4740','4742','4744','4747','4749','4751','4752','4754','4755','4757','4758','4760','4761','4762','4763','4867','4869','4870','4913','4914','4915','4916','4917','4918','4922','4923','4924','4928','4929','4930','4931','4937','4938','4943','4945','4946','4973','4974','4976','4978','5008','5009','5011','5012','5030','5031','5032','5033','5034','5035','5058','5060','5062','5066','5071','5072','5073','5074','5075','5076','5077','5078','5079','5080','5081','5082','5083','5084','5085','5086','5087','5088','5089','5090','5091','5092','5093','5094','5095','5096','5097','5098','5099','5100','5101','5102','5103','5104','5105','5106','5107','5108','5109','5110','5111','5112','5113','5114','5136','5137','5138','5139','5140','5141','5142','5143','5144','5145','5152','5375','5377','5381','5384','5388','5392','5480','5483','5484','5496','5497','5498','5499','5500','5501','5502','5613','5750','5758','5789','5791','5792','5793','5794','5796','5797','5798','5799','6326','6468','6784','6786','6788','6791','6996','6997','6999','7000','7001','7002','7004','7005','7006','7007','7008','7009','7010','7156','7157','7162','7183','7240','7519','7520','7521','7522','7523','7524','7525','7526','7527','7528','7529','7530','7531','7532','7533','7534','7587','7627','7628','7629','7692','7693','7694','7753','7860','7861','7862','7863','7864','7875','7877','7882','7914','7915','7921','7929','7943','8163','8164','8185','8186','8187','8188','8192','8193','8194','8195','8206','8207','8208','8209','8210','8211','8212','8213','8214','8215','8216','8217','8218','8219','8221','8222','8224','8225','8226','8228','8230','8231','8232','8233','8301','8320','8430','8433','8434','8443','8444','8445','8446','8448','8449','8451','8452','8454','8455','8465','8467','8468','8470','8471','8473','8474','8476','8477','8478','8479','8480','8481','8482','8484','8489','8490','8492','8493','8495','8496','8497','8500','8501','8502','8664','8692','8700','8704','8707','8710','8742','8743','8745','8746','8748','8750','8882','8883','8884','8885','8886','8887','8889','8890','8891','8892','8893','8894','8895','8896','8897','8898','8899','8900','8901','8902','8903','8905','8906','8907','8908','8909','8910','8911','8912','8913','8914','8915','8916','8917','8918','8919','8920','8921','8922','8923','8924','8925','8926','8927','8928','8931','8932','8933','8934','8935','8936','8948','8950','9037','9038','9039','9040','9041','9042','9043','9044','9090','9091','9092','9093','9094','9095','9096','9097','9098','9099','9100','9102','9119','9123','9127','9129','9131','9133','9134','9135','9136','9137','9139','9145','9146','9147','9148','9149','9150','9151','9152','9153','9154','9155','9156','9157','9158','9159','9160','9161','9163','9164','9165','9179','9180','9181','9183','9184','9185','9187','9188','9189','9190','9192','9193','9196','9197','9199','9200','9201','9209','9296','9316','9381','9382','9383','9384','9403','9406','9407','9408','9409','9410','9411','9412','9414','9415','9418','9420','9421','9422','9423','9424','9425','9426','9427','9428','9429','9430','9431','9432','9433','9434','9435','9436','9437','9438','9439','9440','9441','9442','9443','9445','9447','9448','9449','9450','9451','9452','9453','9454','9455','9456','9457','9458','9459','9460','9461','9462','9463','9464','9465','9466','9467','9468','9469','9470','9471','9472','9473','9474','9476','9477','9478','9479','9480','9481','9482','9483','9492','9493','9494','9495','9496','9497','9498','9514','9515','9530','9531','9532','9533','9534','9535','9536','9584','9585','9587','9588','9589','9590','9591','9592','9595','9623','9624','9625','9626','9655','9656','9657','9658','9659','9664','9667','9674','9675','9692','9704','9705','9706','9707','9708','9724','9770','9821','9825','9826','9844','9845','9846','9847','10118','10245','10246','10356','10358','10359','10362','10366','10393','10541','10583','10763','10764','10765','10766','10767','11368','11369','11370','11371','11373','11374','11377','11378','11380','11381','11383','11385','11386','11387','11388','11389','11390','11392','11393','11394','11395','11396','11409','11410','11411','11412','11413','11415','11522','11524','11525','11527','11528','11531','11792','11793','11796','12837','12838','12839','12847','12848','12896','12897','12898','12899','12900','12901','12908','12909','12910','12911','15158','15160','15161','15252','15253','15277','15284','15321','15462','15492','15578','15580','15585','15596','15600','15621','15626','15629','15636','15663','15776','15777','16092','16093','16094','16095','16112','16113','16114','16115','16116','16117','16118','16155','16156','16162','16164','16165','16166','16167','16168','16169','16170','16171','16172','16173','16174','16175','16176','16177','16179','16180','16181','16182','16183','16184','16185','16186','16187','16188','16189','16190','16191','16193','16194','16195','16196','16197','16198','16199','16200','16201','16202','16203','16204','16232','16233','16295','16374','16375','16376','16377','17444','17449','17450','17452','17458','17462','17463','18867','18868','18874','18875','37415') )AND g.brand_id=313 AND g.is_direct_pro = 1 ORDER BY g.is_identity_c desc, salenum DESC错误Unknown column 'salenum' in 'order clause'代码1054