Benutzer:Nerd/Artikel

Bitte schön: Beide Listen erzeugt aus dem Dump vom 11. August. --SirJective 16:07, 6. Sep 2004 (CEST)

old

SELECT o1.old_namespace, o1.old_title
FROM (old AS o1)
LEFT JOIN (old AS o2)
ON (o1.old_namespace = o2.old_namespace
AND o1.old_title = o2.old_title
AND o1.old_timestamp > o2.old_timestamp)
WHERE o2.old_timestamp IS NULL
AND o1.old_namespace in (0,4)
AND o1.old_user_text = 'Nerd'
ORDER BY o1.old_namespace, o1.old_title;

0-9

1984_(Roman)

A

C

D

E

F

G

N-Z

O

P

R

v

O

W

cur

select cur_namespace, cur_title
from cur
where cur_namespace in (0, 4)
and cur_user_text = 'Nerd'
and cur_is_new <> 0
order by cur_namespace, cur_title;