select
artical.id
,artical.status
,YEAR(artical.pdate) as y
,MONTH(artical.pdate) as m
,artical.nodate as nodate
,artical.author_id as author_id
,artical.ctype_id as ctype_id
,artical.catalogue_zh_tw as catalogue
,artical.title_zh_tw as title
,artical.title_tailo as title_tailo
,artical.srcs as srcs
,SubSTR(content.zh_tw, 1, 2000) as intro
from `artical`, content
where artical.status = 1 and artical.id = content.id and artical.author_id = '111'
order by artical.nodate.desc, artical.pdate desc
limit 20, 20
Unknown column 'artical.nodate.desc' in 'order clause' 台灣白話字文獻館-白話字數位典藏-王守勇
