$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)";