'Bicameral instruments (clock stops if either House rises)' calculation style Work packages before Parliament

See the 'Bicameral instruments (clock stops if either House rises)' calculation on Parliamentary Time.

There are 0 work packages.

Calculation style identifier

https://id.parliament.uk/67qMXsUE

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 (COUNT(DISTINCT ?workPackage) AS ?count) WHERE {
        ?CalculationStyle a :CalculationStyle;
                   :name ?CalculationStyleName;
                   :calculationStyleHasWorkPackage ?workPackage.
  filter (?CalculationStyle in (id:67qMXsUE))
                optional {?workPackage :workPackageHasBusinessItem ?businessItem .
            ?businessItem :businessItemHasProcedureStep ?step;
                   :businessItemDate ?MadeAvailableDate.
            filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
  			?workPackage :workPackageHasWorkPackagedThing ?workPackagedThing.
  			?workPackagedThing :name ?workPackagedThingName. 
            ?workPackage :workPackageHasProcedure ?procedure.
          ?procedure :name ?procedureName.
      MINUS {  ?workPackage   :workPackageHasBusinessItem ?bi2.
  ?bi2 :businessItemHasProcedureStep ?stepId2.
     ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
        }

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 distinct ?CalculationStyle ?CalculationStyleName ?workPackage ?combinedDate ?workPackagedThing ?workPackagedThingName ?procedure ?procedureName (BOUND(?stepId3) AS ?hasCommitteeConcernsFlag)   
    (BOUND(?stepId4) AS ?hasMotionTabledFlag) WHERE {
               ?CalculationStyle a :CalculationStyle;
                          :name ?CalculationStyleName;
                          :calculationStyleHasWorkPackage ?workPackage.
         filter (?CalculationStyle in (id:67qMXsUE))
                       optional {   ?workPackage :workPackageHasBusinessItem ?businessItem .
                  ?businessItem :businessItemHasProcedureStep ?step;
                         :businessItemDate ?businessItemDate.
           filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
           optional {    ?workPackage :workPackageHasBusinessItem ?businessItem2 .
                  ?businessItem2 :businessItemHasProcedureStep ?step2;
                                 :businessItemDate ?businessItemDate2.
           filter (?step2 in (id:AmYrFxwO))}
         			?workPackage :workPackageHasWorkPackagedThing ?workPackagedThing.
         			?workPackagedThing :name ?workPackagedThingName. 
                   ?workPackage :workPackageHasProcedure ?procedure.
                 ?procedure :name ?procedureName.
              MINUS {  ?workPackage   :workPackageHasBusinessItem ?bi2.
         ?bi2 :businessItemHasProcedureStep ?stepId2.
            ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
     OPTIONAL {
       ?workPackage :workPackageHasBusinessItem ?bi3 .
       ?bi3 :businessItemHasProcedureStep ?stepId3 .
       ?stepId3 :procedureStepHasProcedureStepCollectionMembership/
                :procedureStepCollectionMembershipHasProcedureStepCollection id:7CBVQcZF
     }

OPTIONAL {
       ?workPackage :workPackageHasBusinessItem ?bi4 .
       ?bi4 :businessItemHasProcedureStep ?stepId4 .
       ?stepId4 :procedureStepHasProcedureStepCollectionMembership/
                :procedureStepCollectionMembershipHasProcedureStepCollection id:l3g2umNB
     }
       BIND(COALESCE(?businessItemDate, ?businessItemDate2) AS ?combinedDate)
        } Order by desc(?combinedDate) ?workPackagedThingName
       limit 20 offset 0