[GENERAL] 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.