I want to query on these tables using table\_query(). How can I query on all the tables with date range from 2017-03-22 to 2017-03-24.  

Format of my BQ tables is (auctions\_other\_YYYYMMDDHHM)  

BQ tables are listed below:

> 
> 1.auctions\_other\_20170322104  
> 
>  2.auctions\_other\_20170322105  
> 
>  3.auctions\_other\_20170323206  
> 
>  4.auctions\_other\_20170323207  
> 
>  5.auctions\_other\_20170324108  
> 
>  6.auctions\_other\_20170324209 
> 
> 
> 

**I am using query:**

```
SELECT  * FROM
TABLE_QUERY(chocolate_raw, "table_id contains 'auctions_others_' and
table_id contains '20170322104' and  table_id contains '20170324209'
")
WHERE
  id='f3667fd6-8329-4124-a4a2-737e637a5e7d'

```

**Getting Error:** 

> 
> FROM clause with table wildcards matches no table
> 
> 
>