XML : SQL Server : How to use XPATH in select query

I have a table in SQL Server which has a column with XML data type. For example, one value looks like

  <doc>    <q></q>    <p1>      <p2 dd="ert" ji="pp">            <p3>1</p3>          <p3>2</p3>          <p3>XYZ</p3>          <p3>3</p3>         </p2>         <p2 dd="ert" ji="pp">            <p3>4</p3>          <p3>5</p3>          <p3>ABC</p3>          <p3>6</p3>         </p2>    </p1>  <r></r>  <p1>      <p2 dd="ert" ji="pp">            <p3>7</p3>          <p3>8</p3>          <p3>ABC</p3>          <p3>9</p3>         </p2>         <p2 dd="ert" ji="pp">            <p3>10</p3>          <p3>11</p3>          <p3>XYZ</p3>          <p3>12</p3>         </p2>    </p1>  </doc>    

now, i would want to execute the following xpath

  ./doc//p1/p2/p3[contains(text(),'ABC') or contains(text(),'XYZ')]/preceding-sibling::p3    

so the result is

  1 2 4 5 7 8 10 11    

so i want to select all <p3> nodes that are siblings of the <p3> nodes with text ABC or XYZ. Also, these <p3> nodes must be within <p2> nodes that are themselves within <p1> nodes. As of now, i just select the column as it is and then use the xpath in python to get the nodes. Is there a way to get the required nodes using the SQL select query?