Wieviele Queries sind nornal?

[Struppi]

Reicht das? :)

SELECT DISTINCT YEAR(date) AS year, MONTH(date) AS month , COUNT(DISTINCT pics_categories.id) AS num, (MAX(pics_entries.filename)>$newerAs) AS new FROM pics_categories LEFT JOIN pics_entries ON pics_entries.catid = pics_categories.id WHERE pics_categories.status & 0x01=0 GROUP BY year, month ORDER BY year DESC, month DESC, filename

  
Was sagt EXPLAIN dazu?  
  

> Fragen? :)  
  
Falls du damit meinst, dass wir jetzt Wissen das du weißt was du tust, nein.  
  
Struppi.

-- 
[Javascript ist toll](http://javascript.jstruebig.de/) (Perl auch!)