Random record issue, SQLite and MySQL incompatibility

[Teodor]

You can’t use dynamic column names or sorting order based on parameters in your custom queries.
Same topic discussed here: Creating Custom SQL Queries