| SQL | SELECT 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 < 1714195851 AND g.promote_end_date > 1714195851 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1714195851 AND g.real_promote_end_date > 1714195851 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 ('753') OR g.goods_id IN ('1487','1488','1533','3797','3805','3807','3816','3826','4470','5375','8164','18874') ) AND g.is_direct_pro = 1 AND g.goods_id IN ('3036','3034','3110','3111','3112','3202','3203','3210','3211','3212','3213','3614','3618','3619','3620','3807','3808','3809','3810','3811','3812','3813','3814','3827','3828','3829','3830','3831','3832','3835','3836','3834','3837','3975','3976','3979','3967','4176','4177','4204','4202','4205','4230','4236','4237','4277','4278','4279','4281','4282','4290','4293','4296','4298','4299','4401','4415','4418','4419','4420','4421','4550','4601','4602','4603','4610','4921','4923','4924','4925','4926','4928','4929','4930','4934','4936','4937','4973','4976','5150','5151','5152','5153','5375','5377','5381','5566','5567','5571','5572','5573','5575','5576','5577','5612','5613','5967','5968','5970','5971','5973','5974','6029','6030','6032','6033','6035','6036','6038','6039','6041','6042','6043','6769','6770','6772','6779','6780','6781','6795','6797','6798','6804','6805','7587','7627','7628','7629','7688','7689','7690','7692','7693','7694','7700','7701','7702','7703','7704','7705','7706','7707','7708','3777','7882','7958','7979','8002','8016','7914','7944','7943','7922','7921','8164','7877','7875','7861','7860','8184','8185','8186','8187','8188','8220','8223','8227','8229','8230','8231','8232','8233','8213','8217','8312','8314','8318','8319','8321','8327','8345','8443','8444','8445','8446','8448','8462','8463','8464','8921','8923','8926','8948','8950','9192','9193','9403','9406','9407','9408','9412','9414','9425','9426','9427','9428','9429','9430','9431','9432','9433','9434','9435','9436','9437','9438','9439','9440','9441','9442','9443','9457','9459','9462','9463','9464','9465','9466','9468','9469','9471','9594','9595','9596','9770','9771','9772','9773','9774','9775','9776','9777','9778','9780','9783','9787','9793','9797','9803','9806','9810','9815','9817','9820','9822','9823','9824','9827','9828','9829','9830','9831','9832','9833','9834','9835','9836','9837','9838','9839','9840','9841','9842','9843','9808','9853','10040','10042','10043','10044','10045','10046','10047','10048','10049','10050','10051','10052','10053','10054','10055','10056','10057','10058','10059','10060','10061','10062','10063','10064','10065','10066','10067','10068','10070','10071','10072','10073','10074','10075','10076','10077','10078','10079','10080','10110','10114','10115','10116','10117','10118','10119','10120','10122','10123','10124','10125','10126','10127','10128','10129','10130','10131','10133','10139','10140','10142','10144','10146','10148','10149','10156','10158','10162','10165','10168','10170','10171','10173','10174','10176','10179','10180','10182','10184','10302','10303','10307','10308','10310','10313','10314','10372','10465','10755','11370','11374','11380','11381','11383','11387','11390','11394','11395','11396','12913','12922','12923','12925','12932','15258','15260','15261','15264','15267','15274','15881','15882','16114','16164','16167','16168','16196','16202','16203','16330','16331','16332','16333','16334','16335','16338','16347','16349','16350','16351','16352','16353','16354','16355','16356','16357','16359','16457','16458','16459','16460','16475','16477','18247','18251','18253','18255','18256','18257','18259','18260','18261','18264','18689','18867','36521','36527') ORDER BY g.is_identity_c desc, salenum DESC |