774985 - Provide a one off list of templates with no tags not marked for review

Status: RESOLVED FIXED

(developer.mozilla.org Graveyard :: Editing, defect, P1)

Description

[Trevor]

I have noticed several templates that have not been updated, but are not marked for review. Could you please generate a list of all templates with no tags and not marked for review.

Comment 1

[John Karahalis [:openjck]]

Thanks, Trevor.

Sheppy: Do we have a list of this already?

Comment 2

[Eric Shepherd [:sheppy]]

No. I don't know how to make one. :)

Comment 3

[John Karahalis [:openjck]]

Trevor: In comment 0, do you mean DekiScript templates that have not been converted to KumaScript?

Comment 4

[Trevor]

That is the goal yes.

Comment 5

[John Karahalis [:openjck]]

Thanks for the clarification, Trevor.

Sheppy: Do you know of an easy way to create a list like this or do you think you need some help from the dev team for that?

Comment 6

[Eric Shepherd [:sheppy]]

(In reply to John Karahalis [:openjck] from comment #5)
> Thanks for the clarification, Trevor.
> 
> Sheppy: Do you know of an easy way to create a list like this or do you
> think you need some help from the dev team for that?

I know of no way to do this without developer help.

Comment 7

[Trevor]

Created a list with some sorting here:
https://etherpad.mozilla.org/bug774985

Comment 8

[John Karahalis [:openjck]]

Whoa! Thank you, Trevor! I added this list to bug 765225.

Comment 9

[Les Orchard [:lorchard]]

This might be not-so-useful, but here's a list of templates from the prod DB with neither tags nor any review flags set:

select d.slug
from wiki_document d 
left join wiki_taggeddocument td on td.content_object_id=d.id 
left join wiki_reviewtaggedrevision tr on tr.content_object_id=d.current_revision_id
where d.is_template=1 
and td.id is null
and tr.id is null;

Template:NotFound
Template:domrefxref
Template:CSS_Reference:Background
Template:DiscussionList
Template:getChapters
Template:getChapter
Template:gekoRelease
Template:Js_inherits
Template:Ifconstant
Template:JSRef
Template:EventProperties
Template:CloseEventProperties
Template:WheelEventProperties
Template:expTrevorh
Template:expTrevorh2
Template:KeyboardEventProperties
Template:expTrevorh3
Template:unimplementedGeneric
Template:noscriptGeneric
Template:optionalGeneric
Template:notxpcomGeneric
Template:TBminversionGeneric
Template:QuickFiddle
Template:New_user_page
Template:Lang