AR linking project Edit

Pages in an AR category not linked here:

Not all pages with in the USS Kelvin category should be linked to though.

Pages with the AR banner not in an AR category:

Pages with the XX banner that link to the AR page not in an AR category:

The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, pl.pl_title AS sel_title, pl.pl_namespace AS sel_ns FROM `pagelinks` AS pl, `templatelinks` as tl, `page` LEFT OUTER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND cl0.cl_to='Alternate_reality' LEFT OUTER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND cl1.cl_to='Alternate_reality_inhabitants' LEFT OUTER JOIN `categorylinks` AS cl2 ON `page`.page_id=cl2.cl_from AND cl2.cl_to='Starfleet_personnel_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl3 ON `page`.page_id=cl3.cl_from AND cl3.cl_to='Unnamed_Starfleet_personnel_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl4 ON `page`.page_id=cl4.cl_from AND cl4.cl_to='USS_Enterprise_(NCC-1701)_personnel_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl5 ON `page`.page_id=cl5.cl_from AND cl5.cl_to='USS_Enterprise_(NCC-1701-A)_personnel_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl6 ON `page`.page_id=cl6.cl_from AND cl6.cl_to='USS_Kelvin_personnel' LEFT OUTER JOIN `categorylinks` AS cl7 ON `page`.page_id=cl7.cl_from AND cl7.cl_to='Yorktown_personnel' LEFT OUTER JOIN `categorylinks` AS cl8 ON `page`.page_id=cl8.cl_from AND cl8.cl_to='Starfleet_Academy_personnel_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl9 ON `page`.page_id=cl9.cl_from AND cl9.cl_to='Conflicts_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl10 ON `page`.page_id=cl10.cl_from AND cl10.cl_to='Locations_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl11 ON `page`.page_id=cl11.cl_from AND cl11.cl_to='Spacecraft_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl12 ON `page`.page_id=cl12.cl_from AND cl12.cl_to='Shuttles_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl13 ON `page`.page_id=cl13.cl_from AND cl13.cl_to='Spacecraft_classes_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl14 ON `page`.page_id=cl14.cl_from AND cl14.cl_to='Starship_classes_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl15 ON `page`.page_id=cl15.cl_from AND cl15.cl_to='Federation_starship_classes_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl16 ON `page`.page_id=cl16.cl_from AND cl16.cl_to='Starships_(alternate_reality)' LEFT OUTER JOIN `categorylinks` AS cl17 ON `page`.page_id=cl17.cl_from AND cl17.cl_to='Federation_starships_(alternate_reality)' WHERE 1=1 AND cl0.cl_to IS NULL AND cl1.cl_to IS NULL AND cl2.cl_to IS NULL AND cl3.cl_to IS NULL AND cl4.cl_to IS NULL AND cl5.cl_to IS NULL AND cl6.cl_to IS NULL AND cl7.cl_to IS NULL AND cl8.cl_to IS NULL AND cl9.cl_to IS NULL AND cl10.cl_to IS NULL AND cl11.cl_to IS NULL AND cl12.cl_to IS NULL AND cl13.cl_to IS NULL AND cl14.cl_to IS NULL AND cl15.cl_to IS NULL AND cl16.cl_to IS NULL AND cl17.cl_to IS NULL AND `page`.page_is_redirect=0 AND `page`.page_id=pl.pl_from AND ( (pl.pl_namespace=0 AND pl.pl_title LIKE 'Alternate_reality')) AND `page`.page_id=tl.tl_from AND ((tl.tl_namespace=10 AND tl.tl_title='Multiple')) AND `page`.page_id NOT IN (SELECT `templatelinks`.tl_from FROM `templatelinks` WHERE ((`templatelinks`.tl_namespace=10 AND `templatelinks`.tl_title='Alt_disambiguation')) ) ORDER BY ASC LIMIT 150 OFFSET 0

Error message is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 150 OFFSET 0' at line 1 (geo-db-a-slave.query.consul)

Not all pages should be linked to though.

Please note that recent changes may not show up until the cache is purged. To purge the cache, click here.

Kelvin TimelineEdit

Should the "alternate reality" be rebranded "Kelvin timeline" in this wiki, or is that premature at this point? Sources: trekcore, etc. Cap'n Calhoun (talk) 21:51, June 27, 2016 (UTC)

See Forum:Alternate reality "official" name. -- sulfur (talk) 01:20, June 28, 2016 (UTC)

Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.