Changes

Missing Local ID

288 bytes added, 09:38, 12 February 2014
no edit summary
ORDER BY
location.location_localid ASC
</pre>
'''MRE'''
<pre>
SELECT
mreinfoversion.mre_localid,
mre.mre_localid
FROM
mreinfoversion
Inner Join mre ON mreinfoversion.mre_guid = mre.mre_guid
WHERE
(mreinfoversion.mre_localid IS NULL OR
mre.mre_localid IS NULL) AND
mreinfoversion.link_only = '0'
ORDER BY
mre.mre_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
6,632
edits