Route from Legislative consent memorandum lodged by a Member including a draft legislative consent motion (Scottish Parliament) to SP AA OR as part of the Legislative Consent Motion - Scottish Parliament procedure

From: Legislative consent memorandum lodged by a Member including a draft legislative consent motion (Scottish Parliament)

To: SP AA OR

Procedure: Legislative Consent Motion - Scottish Parliament

Route identifier

https://id.parliament.uk/cGxSHeU7

SPARQL queries used by this page

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
      PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
      PREFIX : <https://id.parliament.uk/schema/>
      PREFIX id: <https://id.parliament.uk/>
      select * where {
       ?Route a :ProcedureRoute;
              :procedureRouteHasProcedure ?Procedure.
        ?Procedure :name ?procedureName.
        Optional {  ?Route :startDate ?StartDate. }
        Optional {?Route :endDate ?EndDate.}
        ?Route :procedureRouteIsFromProcedureStep ?FromStep. 
        ?FromStep :name ?FromStepName;
                  :procedureStepHasProcedureStepType ?FromStepType. 
        ?FromStepType :name ?FromStepTypeName. 
        Optional {?FromStep :procedureStepInLegislature ?FromSteplegislature.
                ?FromSteplegislature :name ?FromSteplegislatureName.}
                Optional {?FromStep:procedureStepHasHouse ?FromStepCommonsId
                filter (?FromStepCommonsId IN (id:1AFu55Hs))}
                Optional {?FromStep :procedureStepHasHouse ?FromStepLordsId.
                  filter (?FromStepLordsId IN (id:WkUWUBMx))}
                ?Route :procedureRouteIsToProcedureStep ?ToStep. 
              ?ToStep :name ?ToStepName;
                        :procedureStepHasProcedureStepType ?ToStepType.
              ?ToStepType :name ?ToStepTypeName. 
              Optional {?ToStep :procedureStepInLegislature ?ToSteplegislature.
                ?ToSteplegislature :name ?ToSteplegislatureName.}
                Optional {?ToStep:procedureStepHasHouse ?ToStepCommonsId
                filter (?ToStepCommonsId IN (id:1AFu55Hs))}
                Optional {?ToStep :procedureStepHasHouse ?ToStepLordsId.
                  filter (?ToStepLordsId IN (id:WkUWUBMx))}
        filter (?Route IN (id:cGxSHeU7))
      } order by ?procedureName ?FromStepName ?ToStepName