Datenbank - Fehler: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT l.link_id, l.name, l.url, l.plz, l.city, l.description, l.keywords, l.link_type, l.image, l.date_entry, l.clicks, l.pagerank, l.land, SUM(v.points) /( COUNT(v.link_id)+0.0000001) AS avg_points, COUNT(v.link_id) AS votes FROM el20_links AS l LEFT JOIN el20_votes AS v ON (l.link_id = v.link_id) WHERE l.parent_cat_id = 4 AND (l.link_type = 1 OR l.link_type = 2 OR l.link_type = 4) AND activated = 1 AND deactivated = 0 GROUP BY l.link_id ORDER BY l.link_type DESC, pagerank DESC LIMIT 0, 10