达梦数据库select ca count atthumb id as thumb countfrom cms article ca9left join app thumb at on caarticle id = attype id and attype = 2 and atstatus = 1Bwherecadel flag = 0group by caarticle id order by c

This query selects all columns from the "cms_article" table and also counts the number of thumbs up for each article by joining the "app_thumb" table. It then filters out any deleted articles and orders the results by the creation date in descending order.

The query may contain errors or syntax issues as it is not clear what the intended output should be. Additionally, the alias "thumb id" in the COUNT function is not valid syntax. A valid alias for the count function would be "thumb_count" or similar