Here's a handy SQL query to generate a list of all published articles in a Joomla website, with section names and categories.
First log-in to your MySQL using PhpMyAdmin, select your Joomla database, click on the "SQL" tab on the right and paste in the following:
SELECT a.title as title, b.title as section, c.title as category FROM jos_content as a LEFT JOIN jos_sections as b ON a.sectionid = b.id LEFT JOIN jos_categories AS c ON a.catid = c.id WHERE a.state=1 ORDER BY c.ordering, b.ordering, a.ordering
This will generate a table of "Article Title", "Section Name", and "Category Name" ordered by section, category and article ordering.
Then you can export the results out to a CSV for import in to your favourite editor — phpMyAdmin should have an export button under the table.
The same query should work using the command prompt.
Enjoy!
