¼º°¡´ë°¡¿î  |  ´ÙÀ̾  |  »óÆР |  Å©¸®½ºÅ»¼º±¸  |  ºÎÈ°Àý  |  Äڷγª19  |  
ÀüüīÅ×°í¸®º¸±â ¹öÆ°
 
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,6) = '050104' or substring(goods_mcategory1,1,6) = '050104' or substring(goods_mcategory2,1,6) = '050104' or substring(goods_mcategory3,1,6) = '050104' or substring(goods_mcategory4,1,6) = '050104' or substring(goods_mcategory5,1,6) = '050104' ) and goods_grant <= 0 order by register_date desc limit 300, 30
Mysql_Error : Column 'register_date' in order clause is ambiguous
Mysql Error Num : 1052

=============================================================================