MAKE 2 select inside 1 procedure MYSQL with wordpress

Got 2 tables, 1 include type of cars, one list all cars.

I want to get LIMIT, COUNT and variable to put on the select select to get the good results.

In other words :

1 select returns 200 types, i want ot ge tonly the 20 first types. THEN, I want total rows of all cars including the 20 first types

example : 20 first types includes 50 cars

So it needs to return 50 rows

then next query will return all cars rows from types 21 to 40 ..