SqliteQuery:SELECT a.ID_NUM AS id,d.pic AS pic,b.DName AS name,a.fenleiID AS flid,b.DirID AS DirID FROM yb_dir AS a LEFT JOIN yb_dir_lg AS b ON a.ID_NUM=b.DirID AND b.Language=0
LEFT JOIN yb_fenlei AS e ON a.fenleiID=e.ID_NUM
LEFT JOIN (SELECT c.DirID,min(picPath) AS pic FROM yb_designPic AS c WHERE c.type IN (0,1) GROUP BY c.DirID ) AS d ON d.DirID=a.ID_NUM
WHERE a.fenleiID=3 and a.PID>0 and b.dirID= order by a.px asc
SqliteError:not an error
SqliteErrno:1
Message:near "order": syntax error