testHomeSELECT * FROM Nav WHERE locationtype = 1 and [navlevel] = 1 AND subDomainId ='' and (deactivated = 0 or deactivated = '' or deactivated is null) and siteid = order by dorderSELECT * FROM Nav WHERE locationtype = 2 and [navlevel] = 1 AND subDomainId ='' and (deactivated = 0 or deactivated = '' or deactivated is null) and siteid = order by dorderSELECT * FROM Nav WHERE locationtype = 3 and [navlevel] = 1 AND subDomainId ='' and (deactivated = 0 or deactivated = '' or deactivated is null) and siteid = order by dorderSELECT * FROM Nav WHERE locationtype = 0 and [navlevel] = 1 AND subDomainId ='' and (deactivated = 0 or deactivated = '' or deactivated is null) and siteid = order by dorder