Top blogs van

 Datumreeks
Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
 Blogs
query("SELECT site_naam, count(entry_id) as aantal_blogs, ROUND(SUM((IFNULL(aantal_reacties, 0)+IFNULL(incoming_links, 0)+shares_twitter+shares_facebook_totaal+shares_pinterest+shares_linkedin+shares_googleplus+IFNULL(shares_whatsapp, 0)+IFNULL(shares_email, 0)))/count(entry_id)) as gem_shares, SUM(IFNULL(aantal_reacties, 0)) as aantal_reacties, SUM(IFNULL(incoming_links, 0)) as incoming_links, SUM(shares_twitter) as shares_twitter, SUM(shares_linkedin) as shares_linkedin, SUM(shares_facebook_totaal) as shares_facebook_totaal, SUM(shares_googleplus) as shares_googleplus, SUM(shares_pinterest) as shares_pinterest, SUM(IFNULL(shares_email, 0)) as shares_email, SUM(IFNULL(shares_whatsapp, 0)) as shares_whatsapp, SUM((IFNULL(aantal_reacties, 0)+IFNULL(shares_twitter, 0)+IFNULL(shares_facebook_totaal, 0)+IFNULL(shares_pinterest, 0)+IFNULL(shares_linkedin, 0)+IFNULL(shares_googleplus, 0)+IFNULL(shares_whatsapp, 0)+IFNULL(shares_email, 0)+IFNULL(incoming_links, 0))) as shares FROM artikelen INNER JOIN sites ON artikelen.site_id=sites.site_id WHERE datum > $start AND datum < $eind GROUP BY sites.site_id ORDER BY SUM(shares_twitter+shares_facebook_totaal+shares_pinterest+shares_linkedin+shares_googleplus+IFNULL(shares_whatsapp, 0)+IFNULL(shares_email, 0)+IFNULL(incoming_links, 0)) DESC"); $rij = 1; while($row = $results->fetch_assoc()) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $rij++; } ?>
Blog
'.$row["site_naam"].''.number_format($row["shares"], 0, ",", ".").''.number_format($row["aantal_blogs"], 0, ",", ".").''.number_format($row["gem_shares"], 0, ",", ".").''.number_format($row["aantal_reacties"], 0, ",", ".").''.number_format($row["shares_twitter"], 0, ",", ".").''.number_format($row["shares_facebook_totaal"], 0, ",", ".").''.number_format($row["shares_linkedin"], 0, ",", ".").''.number_format($row["shares_googleplus"], 0, ",", ".").''.number_format($row["shares_pinterest"], 0, ",", ".").''.number_format($row["shares_email"], 0, ",", ".").''.number_format($row["shares_whatsapp"], 0, ",", ".").''.number_format($row["incoming_links"], 0, ",", ".").'