Playing with SQL is fun :)

A sample of 3 tables join query with self generated row_id

select(select count(*) from dbase_name.table1 join
(dbase_name.table2 join dbase_name.table3 on table2.id = table3.table2_id)
on table2.tbl2field = table1.id where table1." +field+ " like '%" + text_content + "%')
- count(*) + 1 as row_id,
t1.*, t2.* from (select * from dbase_name.table1 join
(dbase_name.table2 join dbase_name.table3 on table2.id = table3.table2_id)
on table2.tbl2field = table1.id where
table1." +field+ " like '%" + text_content + "%') as t1,
(select * from dbase_name.table1 join
(dbase_name.table2 join dbase_name.table3 on table2.id = table3.table2_id)
on table2.tbl2field = table1.id where
table1." +field+ " like '%" + text_content + "%') as t2
where t1.table2_id <= t2.table2_id group by t1.table2_id order by 1 ";