What is the correct way to use data from cells in a Query Google Sheets query?

Question

Google Sheets

Tell me how to correctly use links to cells C1 and D1 in a query
Sample query

=QUERY(IMPORTRANGE("ключ"; "Лист!A:M");"
select Col2, Col5, Col6, Col7, Col8 
Where 
Col8 LIKE '"&(C1)&"'  
and NOT Col8 LIKE '"&ТЕКСТ(D1)&"' ")

Answer 1

see
https://docs.google.com/spreadsheets/d/1X2Vytl4p6Z...