/* Query1 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query2 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	(test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query3 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	(test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query4 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	test__impl0_.f2 = 1 and test__impl0_.f3 >= 1 and (test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f2 asc, test__impl0_.f3 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query5 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	test__impl0_.f2 = 1 and test__impl0_.f3 >= 1 or (test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query6 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	(test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?
with
wcte1 as (
	select distinct t.recid
	from test t
		join test__c1 as w1 on (w1.parent__id = t.recid and (w1.word like UPPER(?)))
)

/* Query7 */
select 
	test__impl0_.recid as col0_0_ 
from
	test test__impl0_ 
where
	(test__impl0_.recid in (select recid from wcte1))
order by
	test__impl0_.f1 asc, test__impl0_.recid asc
 limit ?

