DB ERROR
=============================================================================
Mysql_Query : select *,(case when goods_stock > 0 then 1 else 0 end) as stock_view,a.uid as uid from morning_goods_table as a left join morning_category_table as b on a.goods_category = b.category_id where goods_class = '0' and a.approval_date > '0' and goods_mcategory_del != '15000000' and ( ( replace(goods_name, ' ', '') like '%占쏙옙占싱어리%' ) or ( replace(goods_advance, ' ', '') like '%占쏙옙占싱어리%' ) or ( replace(goods_keyword, ' ', '') like '%占쏙옙占싱어리%' ) or ( replace(goods_brand, ' ', '') like '%占쏙옙占싱어리%' ) or ( replace(goods_company, ' ', '') like '%占쏙옙占싱어리%' ) ) and ( substring(goods_category,1,4) = '0203' or substring(goods_mcategory1,1,4) = '0203' or substring(goods_mcategory2,1,4) = '0203' or substring(goods_mcategory3,1,4) = '0203' or substring(goods_mcategory4,1,4) = '0203' or substring(goods_mcategory5,1,4) = '0203' ) and goods_grant <= 0 order by register_date desc limit 0, 30
Mysql_Error : Column 'register_date' in order clause is ambiguous
Mysql Error Num : 1052
=============================================================================
|
