database

This pages is to save ideas on reading the DB directly, i.e. interesting queries

select p2.topic_id,post_subject from phpbb_posts_text p1, phpbb_posts

p2 where p1.post_id=p2.post_id AND post_text like '%//svn.sourceforge%';

echo "select dru5_node.nid,dru5_node.title,body,log from dru5_node_revisions,dru5_node where dru5_node_revisions.nid=dru5_node.nid limit 10" |mysql drupal > 1.txt