¼º°¡´ë°¡¿î  |  ´ÙÀ̾  |  »óÆР |  Å©¸®½ºÅ»¼º±¸  |  ºÎÈ°Àý  |  Äڷγª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) = '051701' or substring(goods_mcategory1,1,6) = '051701' or substring(goods_mcategory2,1,6) = '051701' or substring(goods_mcategory3,1,6) = '051701' or substring(goods_mcategory4,1,6) = '051701' or substring(goods_mcategory5,1,6) = '051701' ) 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

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