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.