Revision history for WantedPagesWorkaround
Revision [19964]
Last edited on 2008-05-20 17:05:52 by AjHill [reformatted code to be a little tidier]Additions:
select distinct wikka_links.to_tag as tag, count(wikka_links.from_tag) as count
from wikka_links left join wikka_pages on wikka_links.to_tag = wikka_pages.tag
where wikka_pages.tag is null group by wikka_links.to_tag order by count desc;
Ready to go!
from wikka_links left join wikka_pages on wikka_links.to_tag = wikka_pages.tag
where wikka_pages.tag is null group by wikka_links.to_tag order by count desc;
Ready to go!
