SQLite Forum

Duplicated rows (and missing rows) when SELECTing with ORDER BY
Login
In cases like your why not scramble the data and see if the problem remain there so you can publish it ?

Example:
====
id, name, age, nationality
1, DUDE, 24, UK
2, CARL, 12, SP
====

Scramble to (for numbers not unique use randon):
====
id, f2, f3, f4
1, f21, 8902, f41 
2, f22, 1092, f42 
====