I have now switched my CSVI version from 5 to 6. In the 5.21.2 Version it was possible to select a category(options -> category) and export all products with all child products(they have no category assigned) included. In Version 6.6.3 this doesn't work anymore, just the parent products will be exported.
I saw this thread https://csvimproved.com/forum?view=topic&catid=44&id=32879&start=24
And there you state the following:
If you only want these couple of products in an export file, you can use the Product SKU filter. The combination you want isn't possible because for the system there is no relation between these child products and category.
The product sku filter does not work for me. Because I don't know the child products sku's before the export.
I can see why the SQL statement does not work. But wouldn't it be possible to include an Option to export also every child product to any parent product that will be exportet like in CSVI 5.