sql join query question (mysql)

Question

I have the following query, its only returning two records when i have three in the database- where am I going wrong?

SELECT items.id, items.link, items.title, items.image, lists.user 
FROM lists, items 
WHERE lists.user = '506161637' AND lists.item = items.id
GROUP BY lists.dated DESC LIMIT 0, 10000;

The data set of a join table is below but its only returning two records... Rows 19 and 17? maybe theres a better group function to use?

        id user item dated
  19 506161637 8 2009-11-19
  18 506161637 6 2009-11-19
  17 506161637 5 2009-11-18

Answer 1

Remove the GROUP BY clause in your statement. This is grouping the '2009-11-19' records together.

Answer 2

Items 19 and 18 have the same date and since you are grouping by that, they will combine and show the first record.