Differences

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

--- u9_databaser [2013-01-24 15:18]
Joakim Forsgren
+++ u9_databaser [2013-01-30 10:43]
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 |
 |       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
+*/
+</php>
+=== Sista frågan från genomgång ===
+<code SQL>
+SELECT *, COUNT(ChangeDate) as N, EMail as ThreadEMail FROM (
+SELECT lab5_Threads.*, ItemID, ChangeDate, EMail as ItemEMail FROM lab5_Users
+INNER JOIN  `lab5_Threads` USING(UserID)
+LEFT JOIN lab5_Items
+USING (ThreadID)
+ORDER BY ChangeDate DESC) as t1
+INNER JOIN lab5_Users USING(UserID)
+GROUP BY ThreadID
+ORDER BY ChangeDate DESC
+</code>