Multiple querys

Hi everyone,

I have multiple query´s, and i´m trying to optimize my queries by
creating a temporary table x(contains the field id_product).

The queries that utilize the temp table x, must use the order of the rows at
x.
My problem: I have a query that do a limit and offset on table x. I would
like to this query obey the order of x.

I thought these solution: create a field order_id_product, to use order by
order_id_product on other queries.

Can anyone help me?

Thanks a lot.