561400 - Need mysql output from MDC

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Eric Shepherd [:sheppy]]

I need this query run on the MDC database:

select ar_last_page_id from archive where ar_title like "%JS_MarkGCThing%";

Trying to undelete a page that was deleted some time ago, and need its page ID. Can't find the page in the rather lengthy list of pages that have been deleted using the wiki's UI.

Comment 1

[Dave Miller [:justdave]]

mysql> select ar_last_page_id from archive where ar_title like "%JS_MarkGCThing%";
Empty set (0.02 sec)

Comment 2

[Eric Shepherd [:sheppy]]

Try this one:

select ar_last_page_id from archive where ar_title like "%JSAPI%";

Comment 3

[Dave Miller [:justdave]]

mysql> select ar_last_page_id from archive where ar_title like "%JSAPI%";
Empty set (0.02 sec)