Google Spreadsheets QUERY+IMPORTRANGE?

Question

Google Sheets

Help me figure out why the formula
=QUERY(IMPORTRANGE("1uGo0hGJdx-GfX12rmuTaC1DdDF18MnJOLhb8Z2Msm5g","Transferred (copy)!A2:H"),"Select Col1,Col2,Col3 where Col1='test'")
Separated =IMPORTRANGE(" 1uGo0hGJdx-GfX12rmuTaC1DdDF18MnJOLhb8Z2Msm5g","Sent (copy)!A2:H") works correctly

Answer 1

The problem is that the Query looks at the data, and when ImportRange is called inside the Query, there is no data yet.
Try to make an intermediate table, where you first import, and then do what you need for the selected range

Answer 2

Must import. Try replacing where Col1='test'" with where Col1 like 'test'".