Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
mysql_info [2009-10-15 12:36]
Joakim Forsgren 		mysql_info [2010-03-22 08:47]
Joakim Forsgren
Line 1: Line 1:
 ====== Mysql info ====== ====== Mysql info ======
 Gick igen en SQL-fråga Gick igen en SQL-fråga
-<code mysql>+<code>
 SELECT *,COUNT(ItemID) as Number FROM Threads LEFT JOIN Items USING(ThreadID) GROUP BY (ThreadID) SELECT *,COUNT(ItemID) as Number FROM Threads LEFT JOIN Items USING(ThreadID) GROUP BY (ThreadID)