Changes

Missing Local ID

682 bytes added, 20:42, 11 April 2015
no edit summary
WHERE
(accident.accident_localid IS NULL OR
accidentinfoversion.accident_localid IS NULLOR length(trim(accident.accident_localid)) = 0 ORlength(trim(accidentinfoversion.accident_localid)) = 0) AND
accidentinfoversion.link_only = '0'
ORDER BY
hazardinfoversion.link_only = '0' AND
(hazardinfoversion.hazard_localid IS NULL OR
hazard.hazard_localid IS NULL ORlength(trim(hazardinfoversion.hazard_localid))= 0 ORlength(trim(hazard.hazard_localid)) = 0 )
ORDER BY
hazard.hazard_localid ASC
WHERE
(hazreducinfoversion.hazreduc_localid IS NULL OR
hazreduc.hazreduc_localid IS NULLORlength(trim(hazreducinfoversion.hazreduc_localid)) = 0 ORlength(trim(hazreduc.hazreduc_localid)) = 0 ) AND
hazreducinfoversion.link_only = '0'
ORDER BY
WHERE
(locationinfoversion.location_localid IS NULL OR
location.location_localid IS NULLOR length(trim(locationinfoversion.location_localid)) = 0 ORlength(trim(location.location_localid)) = 0) AND
locationinfoversion.link_only = '0'
ORDER BY
WHERE
(mreinfoversion.mre_localid IS NULL OR
mre.mre_localid IS NULLOR length(trim(mreinfoversion.mre_localid)) = 0 ORlength(trim(mre.mre_localid)) = 0) AND
mreinfoversion.link_only = '0'
ORDER BY
WHERE
(qainfoversion.qa_localid IS NULL OR
qa.qa_localid IS NULLORlength(trim(qainfoversion.qa_localid)) = 0 ORlength(trim(qa.qa_localid))= 0) AND
qainfoversion.link_only = '0'
ORDER BY
WHERE
(victiminfoversion.victim_localid IS NULL OR
victim.victim_localid IS NULLORlength(trim(victiminfoversion.victim_localid))= 0 ORlength(trim(victim.victim_localid))= 0) AND
victiminfoversion.link_only = '0'
ORDER BY
6,632
edits