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!
Deletions:
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;


Revision [19963]

The oldest known version of this page was created on 2008-05-20 17:03:01 by AjHill [reformatted code to be a little tidier]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki