Multiple selects in one query

I am trying to use your plugin to write a SQL query that sets a variable using a select count(*) command and then performs an IF/THEN statement using the variable as the comparison (=0, >0)

I keep getting errors and am wondering if your plugin supports this complex a query?

I’m pretty sure I’m using the query syntax correctly because I run the query to assign the variable separately and do get an expected value.

Thanks,
Chris