Quote Originally Posted by OldNGrey View Post
A problem arises with the differences between MariaDB and MySQL and the many optional SQL Modes set by the user/administrator.
MySQL allows the ANY_VALUE setting to get around the GROUP BY clause when ONLY_FULL_GROUP_BY setting is used but the ANY_VALUE setting does not exist in MariaDB. [ I've learned a lot in the past few weeks.]
In the past I removed the ANY_VALUE on comments to allow the export to run on MariaDB. This caused duplicate records for "1 Order per row" when multiple comments existed against an order.

In test I can now get "1 Order per row" without duplicates even if comments are included.
I'm also parsing more so quotation marks in fields do not break the csv export.
That's interesting to note. Thanks for the information!

Best Regards, Noi