Hello Abraham,

1) Ohana extension has changed version and DB schema recently so i should have a look at your Joomla backend to understand if you have still the old version and you are creating a data source with JSitemap already supporting the new version. In such case the data source settings must be downgraded to the old version of Ohana if you can't update it of course. If needed you should still have my email address i think.

2) It's wrong, you don't need to deal with the raw SQL query to filter K2 by categories, follow this forum thread to use quickly the filter in the interface and specifcy a comma separated list of categories to include: http://storejextensions.org/forum/view/10-jsitemap/1304-re-exclude-single-k2-item.html

Regards,
John