SELECT clanky.nadpis, (

SELECT COUNT( * )
FROM `pocet_zobrazeni`
WHERE `clanky`.`id` = `pocet_zobrazeni`.`id_clanku`
GROUP BY `id_clanku`
) AS `pocet`
FROM clanky
ORDER BY pocet DESC