select * from `netk_member` as nm join `netk_info_car_se` as nics join `netk_info_car` as nic where nm.`uid`=nic.`uid` and nic.`no`=nics.`pno` and nic.`view`='yes' and nic.`sell_type`='ing' and nic.`kind`='car' and (nm.name like '%넷케이%' or replace(nm.`hphone`, '-', '') like '%넷케이%' or nic.`number` like '%넷케이%' or nic.`no`='넷케이' or nic.`category_txt` like '%넷케이%' or nic.`subject` like '%넷케이%') group by nic.`no` order by udate desc limit 0, 10
에러메세지
ERROR CODE 1052 : Column \'udate\' in order clause is ambiguous