I have a mysql plugin that will return the results set in a specified order. Part of the result set includes a foreign key, and I want to join that key, while ensuring that the order remains the same. If I do something like this: SID = F.Id's internal join of the sphends F. F. F, choose Fitil, where query = 'test; Filter = type, 2; Sort = atriosak: static '; It seems that I am getting my results back so that Sphinx gives them returns. Is this a quote from mysql, or has I been assured that no involved order will change? If you need a guaranteed command in the result of a query, use ORDER BY Do some more willpower thinking. To give some information on this, several database execution steps are split in a way that can vary depending on the execution of the query, the available CPU volume, and optimization Just like the database can be estimated. If a query runs in parallel on many threads, the results may vary. If the plan changes, the results may vary if ...