Zeyi wrote:
I took the sub-current data from MediaWiki and import them to Oracle.
Which tool did you use for the import?
I found there are two same page_latest ID in the page table. Then when I tried to join Revision table and Page table together, this caused two same rev_id.
Which pages are those?
May I ask why I have two page_latest on page table, what it mean? If I want to put Revision table and Page table together, which should be the link point?
You shouldn't have that situation. And why are you merging page and revision, anyway?
thanks, Zeyi