Google Sheet Query match or contains or like?

[Joshua Davidson]

Hello, I hope I've found the right place to post this.  If not—if someone could kindly point me in the right direction, thanks!

I'm trying to figure out how to use a query URL in one sheet to point to another.

So far, I've got this working:

https://docs.google.com/spreadsheets/d/17c8P5AW3UscUWg5TIe0Wl1zpbtFtH94QnVABiJa-s2E/edit#gid=1145999028

But when I try to do this:

https://docs.google.com/spreadsheets/d/17c8P5AW3UscUWg5TIe0Wl1zpbtFtH94QnVABiJa-s2E/edit#gid=414291241

I can't get the expected result, which should look like this http://SWCT-SoldOutEarly.tk

My query is SELECT * WHERE D like '%/%', but it's not pulling up anything like it should.

To explain what the query is looking at, it's a database of cards and stats.  Column C is the card name, D is how many are in circulation.  It's either currently unknown like "?/5000" or in progress of selling out "1234/5000" or sold out "5000" and Column E will have an asterisk if that card is sold out.

If a card has an asterisk AND has an in-progress type number, then it's considered to have sold out early (hence the short URL, above).

What I'm looking for is a URL like this:

https://docs.google.com/spreadsheets/d/1kGOaqMf1b2qG1WRpIGON8OKRWdG1rIL-WuDjoU95J4U/gviz/tq?gid=925237019&tqx=out:html&tq=SELECT+*+WHERE+D+LIKE'%/%'+AND+E='*'

...but that actually works, haha.

[Joshua Davidson]

Weird, it just started working... I don't think I did anything...

Here is the proper encoded URL:

https://docs.google.com/spreadsheets/d/1kGOaqMf1b2qG1WRpIGON8OKRWdG1rIL-WuDjoU95J4U/gviz/tq?gid=925237019&tq=SELECT%20A%2CB%2CC%2CD%2CE%2CF%2CG%2CH%2CI%2CJ%2CK%2CL%2CM%2CN%20WHERE%20D%20like%20%27%25%2F%25%27%20AND%20E%3D%27*%27&tqx=out:html&0

[Joshua Davidson]

It's not working again...