ERROR -2array(4) { [0]=> array(1) { ["message"]=> string(17) "MySQL Query Error" } [1]=> array(1) { ["sql"]=> string(12059) "SELECT as sort_order, g.goods_id, g.goods_sn, g.goods_name, g.goods_name_style, 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,g.is_shipping, g.is_ship_in_24,CEILING(SUM(cm.comment_rank)/COUNT(cm.comment_rank)) AS goods_rank, COUNT(cm.comment_rank) AS rank_num FROM `g5wholesale7`.`ecs_goods` AS g LEFT JOIN `g5wholesale7`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' LEFT JOIN `g5wholesale7`.`ecs_comment` AS cm ON cm.id_value=g.goods_id AND cm.status=1 LEFT JOIN `g5wholesale7`.`ecs_goods_order_regional_recom` AS goc on g.goods_id=goc.goods_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('382') OR g.goods_id IN ('25919','86583','92696','111420','130648','138299','138348','138350','138719','140062','143724','147964','148312','148321','148325','148327','148993','148996','163660','164757','169296','169875','172336','172339','173330','174215','175132','175141','175682','177937','178531','180725','182298','183833','183836','185663','185664','185670','185673','185676','185809','186124','186149','186235','186308','186311','186651','187194','187723','188050','188051','188132','188227','191432','192540','192544','193418','194267','194269','194388','194391','194669','195787','195794','196934','198656','198658','198672','198674','198760','201706','201713','201714','201716','201718','201730','201733','201740','201852','201864','201873','201895','201899','202262','203121','203122','203773','204303','204978','204979','205566','205569','206425','207203','207675','209223','209226','209228','209231','209239','209242','209244','209272','209274','209276','209280','210702','210711','211237','211238','211866','211876','211883','212094','214834','214839','214841','214847','214972','214977','214981','214985','214988','215022','215023','215024','215027','215200','215205','215215','215226','215235','215458','215459','215462','215464','215469','215510','215916','215945','216158','216446','216453','216702','216703','216705','216708','216726','216727','216759','216814','217109','218075','218194','218198','219189','219195','219258','219527','220222','220243','221182','221185','221188','221191','221387','221391','221395','221627','221680','221768','221770','221772','222083','222087','222090','222094','222097','222099','222105','222142','222654','222658','223402','223405','223406','223408','223464','223466','223642','223724','223728','223730','223731','223735','223737','223739','223744','223766','223768','223769','223770','223888','223891','223893','223898','223901','223906','223909','223915','223919','223923','224139','224461','224464','224465','224467','224502','224503','225162','225165','225181','225228','225229','225230','225231','225232','225416','225423','225801','225807','225813','225815','225819','226218','226220','226411','226414','226416','226418','226493','226595','226628','226629','226630','226631','226633','226634','226635','226637','226639','226641','226644','226646','226648','226650','226651','226680','226706','226815','226943','226968','226972','227028','227030','227033','227035','227038','227043','227046','227047','227048','227050','227059','227061','227144','227147','227150','227168','227171','227172','227173','227315','227385','227388','227473','227479','227524','227578','227764','227769','227772','227778','227781','227784','227840','227904','227959','228216','228232','228257','228263','228272','228458','228527','228528','228530','228866','228887','228891','228938','228942','228947','228951','228979','228982','229015','229017','229103','229112','229269','229281','229289','229294','229300','229369','229373','229638','229663','229720','229725','229737','229743','229761','229767','229791','229811','229842','230215','230275','230287','230292','230407','230414','230467','230471','230484','230489','230613','230616','230755','230799','230827','231274','231386','231416','231546','231877','231932','231947','231967','232118','232173','232176','232225','232233','232333','232338','232343','232344','232348','232361','232366','232368','232906','232912','232918','233036','233061','233131','233135','233138','233144','233150','233154','233159','233164','233261','233277','233371','233379','233402','233427','233471','233477','233488','233493','233497','233536','233567','233587','233608','233612','233622','233733','233799','233803','233847','233851','234048','234053','234183','234207','234256','234260','234266','234270','234289','234316','234320','234326','234337','234348','234357','234529','234544','234751','234758','234763','234767','234774','234780','234783','234788','234791','234795','234963','235010','235051','235255','235262','235365','235553','235845','236138','236218','236279','236299','236391','236397','236402','236566','236568','236569','236793','236797','236799','236801','236831','236932','236949','236979','236982','236984','236986','236988','236991','236996','237005','237071','237080','237092','237103','237105','237110','237575','237883','237886','237889','238445','238486','238652','238871','238880','238885','238937','239122','239226','239236','239240','239244','239248','239644','239673','239680','239705','239709','240183','240185','240186','240187','240472','240899','240971','240982','241025','241458','241594','241605','242013','242822','243160','243166','243169','243171','243172','243174','243175','243178','243180','243183','243184','243215','243239','243243','243245','243263','243269','243271','243282','243377','243379','243381','243384','243390','243396','243436','243862','243926','244066','244094','244207','244724','244815','244849','244857','244864','244866','244868','244870','244874','244877','244882','244887','244890','244894','244898','245023','245082','245097','245107','245359','245362','245450','245452','245457','245464','245467','245907','245909','245918','246207','246210','246212','246343','246459','246460','246461','246462','246471','246474','246475','246497','246500','246504','246507','246514','246516','246537','246713','246717','246834','246838','246842','246846','246848','246851','246855','246864','246872','246874','246910','246919','247040','247050','247052','247053','247056','247060','247066','247134','247236','247241','247245','247248','247253','247255','247261','247265','247268','247275','247282','247285','247289','247290','247293','247297','247301','247303','247308','247312','247314','247319','247323','247327','247331','247342','247344','247353','247357','247364','247367','247374','247378','247383','247388','247393','247398','247406','247409','247413','247419','247423','247425','247429','247432','247434','247437','247438','247439','247440','247444','247445','247446','247448','247449','247509','247510','247514','247515','247536','247600','247605','247608','247611','247613','247618','247680','247695','247708','247792','247800','247829','247832','247834','247875','247936','247944','247956','247959','247961','247966','247967','247970','247972','248072','248081','248507','248508','248509','248510','248511','248512','248513','248515','248518','248522','248530','248545','248549','248555','248561','248563','248567','248570','248574','248576','248579','248582','248585','248589','248594','248600','248617','248632','248640','248684','248688','248696','248699','248722','248762','248765','248766','248771','248775','248843','248980','249072','249253','249280','249292','249296','249300','249307','249310','249314','249319','249324','249342','249346','249348','249351','249395','249397','249400','249405','249407','249408','249411','249414','249426','249429','249432','249437','249440','249441','249443','249446','249452','249453','249457','249460','249470','249474','249482','249488','249492','249496','249500','249504','249509','249532','249535','249538','249542','249544','249550','249558','249701','249729','249731','249740','249741','249742','249751','249758','249764','249765','249767','249771','249772','249775','249964','249970','249972','249974','249978','249981','249984','249987','249990','249995','250004','250021','250023','250025','250027','250029','250030','250031','250096','250098','250100','250103','250107','250109','250121','250124','250129','250133','250137','250142','250151','250159','250161','250165','250231','250233','250235','250238','250241','250243','250247','250255','250273','250292','250297','250447','250448','250449','250450','250452','250453','250454','250476','250478','250481','250482','250483','250485','250487','250489','250493','250501','250506','250599','250601','250607','250610','250611','250613','250617','250635','250641','250645','250651','250653','250654','250663','250665','250668','250670','250719','250721','250726','250728','250731','250737','250748','250752','250755','250834','250837','250838','250840','250841','250851','250853','250854','250857','250859','250864','250867','250870','250878','250882','250887','250895','250904','250908','250914','250929','250935','250942','250956','250973','250982','250984','250991','250996','250998','250999','251008','251011','251079','251334','251341','251343','251345','251347','251352','251361','251371','251378','251380','251629','251633','251637','251641','251647','251678','251854','251877','252076','252092','252113','252187','252190','252193','252205','252210','252264','252265','252267','252271','252275','252277','252287','252288','252293','252296','252300','252304','252693','252697','252701','252731','252742','252755','252766','252816','253062','253066','253067','253071','253072','253074','253076','253080','253082','253085','253087','253359','254119','254128','254133','254137','254694','254704','254758','254759','254761','254765','255408','255500','255507','255513','255759','256076','256077','256083','256085','256086','256101','256107','256124','256129','256141','256145','256321','256322','256324','256327','256328','256334','256341','256354','256360','256617','256621','256625','256627','256636','256654','256659','256662','256667','256671','256675','256680','256683','256701','256932','256936','256937','256939','256942','256946','256948','256952','256959','256967','256971','256976','256979','256982','256985','256988','257024','257090','257094','257108','257111','257112','257115','257117','257348','257352','257362','257454','257546','257552','257557','257571','257580','257605','257727','257974','257978','257981','257982','257990','258024','258628','258651','258655','258659','258662','260351','260514','260527','260528','260531','260538','260566','260857','261014','261077','261080','262534','262537','262541','262545','262565','262575','263487','263733','263825','263835','264446','264449','264450','264452','264459','264655','264661','264664','264692','264707','264710','264717','264729','265017','265033','265043','265047','265057','265069','265073','265076','265079','266600','266999','267001','268268','268451','268470','268479','269352','269358','270969','270973','270975','270985','271028','271228','271237','271252','271254','271260','271263','271268','271272','271364','271441','271470','272037','272090','272098','272253','272263','272438','272506','272986','273177','273226','273330','273333','273339','273435','273562','273604','273630','273968','274016','274017','274019','274020','274319','274321','274762','274777','274782','274785','275108','275111','275145','275184','275289','275300','275961','275991','276162','276164','276486','276755','276757','276794','276798','276822','276834','276845','276848','276947','277459','277486','279775','280377','280380','280718','282384','282465','282672','282967','283909','283911','283976','284275','284282','292761','295138','295363','297439','297440','297450','297454','297475','298266','299825','301348','301566','301570','301572','301575','301578','301612','302186','302395','302484') ) AND g.goods_number > 0 group by g.goods_id order by DESC sort_order DESC LIMIT 60" } [2]=> array(1) { ["error"]=> string(226) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as sort_order, g.goods_id, g.goods_sn, g.goods_name, g.goods_name_style, g.marke' at line 1" } [3]=> array(1) { ["errno"]=> int(1064) } }