Untitled query #6828

SQL

/*USE lvwiki_p;
SELECT p1.page_title, p2.page_title#LOCATE (p1.page_title, p2.page_title)#, p1.page_title, p2.page_title
FROM page as p1
join page as p2 on p1.page_namespace = p2.page_namespace
WHERE p1.page_title="Edgars2007/AWB" and p2.page_title="Edgars2007/AWBs" #and #p1.page_title like "p1.page_title"
and
#LOCATE (p2.page_title, p1.page_title)
ISNULL( LOCATE (p1.page_title, p2.page_title)) = 1

#p2.page_title LIKE CONCAT(p1.page_title,"s")

#exists (p2.page_title from page as p2 where p2.page_title=CONCAT(p1.page_title,"s") and )
and p1.page_namespace=2 and p1.page_is_redirect=0
AND p2.page_namespace=2 and p2.page_is_redirect=0*/
use lvwiki_p;
SELECT count(*) as Raksti
FROM revision AS t4
WHERE t4.rev_id IN (Select min(t45.rev_id)
From revision t45
inner join page p on t45.rev_page=p.page_id
where p.page_namespace=0 and p.page_is_redirect=0
group by t45.rev_page
having min(t45.rev_id)
order by min(t45.rev_id) desc
)
SQL

Checking query status...
