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
u9_databaser [2013-01-24 15:18]
Joakim Forsgren 		u9_databaser [2013-01-24 15:20]
Joakim Forsgren
Line 118: Line 118:
 |       35 | Testtråd    |     38 | 2012-02-28 09:18:24 |       35 |     78 | Hej           | 2012-02-28 09:18:53 | christoffer bergstrom |         38 |       1 | |       35 | Testtråd    |     38 | 2012-02-28 09:18:24 |       35 |     78 | Hej           | 2012-02-28 09:18:53 | christoffer bergstrom |         38 |       1 |
 |       36 | Lorem ipsum |      1 | 2013-01-24 13:10:11 |       36 |    110 | Praesent orn  | 2013-01-24 13:14:17 | Joakim Forsgren       |          1 |      32 | |       36 | Lorem ipsum |      1 | 2013-01-24 13:10:11 |       36 |    110 | Praesent orn  | 2013-01-24 13:14:17 | Joakim Forsgren       |          1 |      32 |
-+----------+-------------+--------+---------------------+----------+--------+---------------+---------------------+-----------------------+------------+---------+...</code> ++----------+-------------+--------+---------------------+----------+--------+---------------+---------------------+-----------------------+------------+---------+...</code><php> /* 
 +SELECT lab5_Threads.*,t1.*,COUNT(ItemID) as NumItem  
 +FROM  
 +( 
 +select  ThreadID,ItemID,SUBSTRING(Item,1,12) as sItem,CreateDate as LastItem,CONCAT(FirstName,' ',LastName) as ItemName,UserID as ItemUserID from lab5_Users  
 +INNER JOIN lab5_Items USING(UserID)  
 +ORDER BY CreateDate DESC 
 +) as t1  
 +RIGHT JOIN lab5_Threads USING(ThreadID) 
 +INNER JOIN lab5_Users ON lab5_Users.UserID=lab5_Threads.UserID 
 +GROUP BY lab5_Threads.ThreadID 
 +*/