There is no export as SQL option As CMS I use Wordpress. I want to export a whole category (windows 8) so I run the SQL command :

SELECT * FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
WHERE (wp_term_taxonomy.term_id = 15
   AND wp_term_taxonomy.taxonomy = 'category'
   AND wp_posts.post_type = 'post'
   AND wp_posts.post_status = 'publish');


I get the tables but then I cannot export as SQL (there is no option) - strange. Is there a way to export only selected tables as SQL?
I get this effect only when applying a query.

A table, view, or other direct structure seems to export into SQL fine. 

The SQL option seems is not available to a query result set, very sadly.