2016-08-25, 17:18
Here's a little mySQL fiddle if it's of any use:
http://sqlfiddle.com/#!9/976283/5
It shows how you can generate the 'fauxDate' on the fly with a mySQL query - far simpler than I'd imagined!
Doing it this way would at least create the 'fauxDate' on the fly, then allow sorting to occur by Kodi.
It's not clear to me (but you will know) if you can manually sort the results first prior to creating objects (preferable), or if it the objects are created first then sorted, but at least you'd not be checking multiple fields at this point as the query will have done that work for you.
http://sqlfiddle.com/#!9/976283/5
It shows how you can generate the 'fauxDate' on the fly with a mySQL query - far simpler than I'd imagined!
Doing it this way would at least create the 'fauxDate' on the fly, then allow sorting to occur by Kodi.
It's not clear to me (but you will know) if you can manually sort the results first prior to creating objects (preferable), or if it the objects are created first then sorted, but at least you'd not be checking multiple fields at this point as the query will have done that work for you.