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.