[[SQL("web7_db1"|"select concat('<a href="http://forum.mobbing-gegner.de/viewtopic.php?p=',b.post_id,'">',b.post_subject,'</a>') from phpbb_posts a,phpbb_posts b where a.post_id =b.post_id and b.post_text like '%wahrheit%' order by b.post_subject; ;")]]  
----
Die Postings von Tom.
[[SQL("web7_db1"|"select post_text from phpbb_posts where post_username = 'Tom'")]]

[[GoogleADS1]]

10 Texte der Postings
[[SQL("web7_db1"|select posts_text from phpbb_posts limit 10;")]]

[[GoogleADS1]]

20 Beitärge von Tom
[[SQL("web7_db1"|"select username,t.post_text  from phpbb_posts_text t,phpbb_users u, phpbb_posts p where p.poster_id=u.user_id and p.post_id=t.post_id and u.user_id=50 limit 20 ;")]]

Mobbing/SqlTest (last edited 2010-10-24 10:57:16 by DetlevLengsfeld)