Custom SQL query: arithmetic operation fails when using parameter

[Apple]

There was a recent topic:

A question about limit and param (MySQL)

Hello everyone, I'm a little confused and would like to know something about how queries work when it comes to MySQL and params.. For what I know: LIMIT 1 is not an option, clearly understand why not. But, how is this working? [image] In this case I can set the limit of the query So: [image] [image] Is there a workaround somewhere I'm missing? I would like to use something like: ORDER BY RAND(:P1) LIMIT :P2; Thanks