title: Unique-Query function not pulling all Unique Rows
body: <p>So I've been searching for days.  I am running a spreadsheet to track game stats for a video game League.  I need to break the players down into their specific roles, and show their stats for only the weeks they played those roles.</p>
  <p>Got the stats working but having a problem pulling all the players' names.  I was using a UNIQUE(QUERY) function to pull the names from each week's games, but I noticed that not all the players were being pulled even if they matched the criteria.  What did I do wrong?</p>
  <p>Here's a copy of the spreadsheet for you all to comment on: <a href="https://docs.google.com/spreadsheets/d/18C-edA8uvyVLnozBLqOhOba4_ukzyhtXKFIno-XXsKU/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/18C-edA8uvyVLnozBLqOhOba4_ukzyhtXKFIno-XXsKU/edit?usp=sharing</a></p>
  <p>Formula in question is most easily seen on the &quot;THE ADCs&quot; tab, E11.</p>
  <p>The specific Formula Array is as follows:</p>
  <p>=UNIQUE(QUERY({Week1_Stats!$B4:$AH,Week2_Stats!$B4:$AH,Week3_Stats!$B4:$AH,Week4_Stats!$B4:$AH,Week5_Stats!$B4:$AH,Week6_Stats!$B4:$AH,Week7_Stats!$B4:$AH,Week8_Stats!$B4:$AH,Week9_Stats!$B4:$AH,Week10_Stats!$B4:$AH},&quot;Select Col2 Where Col3 ='ADC' and Col5 &gt; .5 Order by Col5 Desc Limit 10&quot;))</p>