title: mysql query dont gets all posts
body: <p>I have a MYSQL query who have to list all post i want it to post. But it dont do it. It shows posts when i have more then one post in the table "meaOrder" with the same "ordCode". But when i have only on post in meaOrder, i don't show it. What can i do? </p>
  
  <pre><code>SELECT koden, wish, rnamn, bild, pris, cname, onsktext 
                  FROM (
                  SELECT m.wishText as onsktext, m.meaOID as midn, m.ordcode as koden, w.wish as wish, r.meaName as rnamn, r.meaImg as bild, 
                          r.meaPrice as pris, k.catName as cname from cats k, meals r, wishes w,
                          meaOrder m
                      join orders c on c.ordNR=4401
                      WHERE  c.ordStatus=1 AND m.ordNR=c.ordNR AND m.meaID=r.meaID AND m.wishesID=w.id
                          AND r.catID=k.catID
                  ) T
                  GROUP BY koden, rnamn, bild, pris, cname
                  ORDER BY midn DESC
  </code></pre>
  
  <p>TABLE orders
  <a href="http://grab.by/m74E" rel="nofollow">http://grab.by/m74E</a></p>
  
  <p>TABLE meaOrder <a href="http://grab.by/m74Q" rel="nofollow">http://grab.by/m74Q</a></p>