$sql="SELECT domainsponsor_results.domain, domainsponsor_results.stored, domainsponsor_results.visitors as dvisitors, domainsponsor_results.total_revenue as drevenue,
google_results.landing as gvisitors, google_results.revenue as grevenue,
sedo_results.uniques as svisitors, sedo_results.earnings as srevenue,
trafficz_results.clicks as tvisitors, trafficz_results.total as trevenue
FROM domainsponsor_results
LEFT JOIN google_results USING (stored, domain)
LEFT JOIN sedo_results USING (stored, domain)
LEFT JOIN trafficz_results USING (stored, domain)";