Service sowie Dienstleistungs Betriebe und Firmen in Brandenburg
Hier finden Sie Gewerbe und Service Dienstleistungs Tipps für Brandenburg mit Regio Map.
Navigation: Startseite Brandenburg
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
Hier finden Sie Gewerbe und Service Dienstleistungs Tipps für Brandenburg mit Regio Map.