[obe]

select a.*, count(*) as ncomments from artiklar a left join comments c on c.pid=a.pid group by a.pid order by a.pid desc

??