AW: [dbs] Problem mit 2 SELECTs

[ANGEL Harald]

> en bissl formatierung würde echt helfen
ok, du hast recht... also:

1:
SELECT news.headline, news.id, news.newskatID, news.headtext, news.online, news.fertig, news.gesperrt, news.datum, news.anzahl, news_kategorien.name, news_kategorien.farbe AS katfarbe, user.userid, user.nickname, user.farbe, Count( meinung_artikel.forumid ) AS newsposts, bilder.thumbURL, news_bilder.thumbURL
FROM (
  (
    (
      (
        news
        INNER JOIN news_kategorien ON news.newskatID = news_kategorien.id
      )
      INNER JOIN user ON news.autorID = user.userid
     )
     LEFT JOIN meinung_artikel ON news.id = meinung_artikel.forumid
   )
   LEFT JOIN bilder ON news.thumbID = bilder.id
)
LEFT JOIN news_bilder ON news.thumbID = news_bilder.id
GROUP BY news.headline, news.id, news.newskatID, news.headtext, news.online, news.fertig, news.gesperrt, news.datum, news.anzahl, news_kategorien.name, news_kategorien.farbe, user.userid, user.nickname, user.farbe
HAVING (
  news.online = 1 AND news.fertig = 1 AND news.gesperrt = 0
)
ORDER BY news.online_date DESC

2:
SELECT vote.newsid, Count( vote.vnote ) AS Anzahlvonvnote, Sum( vote.vnote ) AS Summevonvnote
FROM vote
GROUP BY vote.newsid
HAVING (
  (
    (
      vote.newsid
    ) = 730
  )
)


Wobei 730 = news.id aus dem ersten!
Harald