oder man schaut einfach mal was die datenbank sagt
SELECT t1.*
FROM vms_gebuchte_werbung t1
LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid =1
LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
LEFT JOIN vms_reloads t2
ON (t1.tan = t2.tan AND (t2.uid = 1 OR t2.ip = "123.124.12.12") AND t2.bis >= 1276472475)
WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != 1 ORDER BY t1.verdienst DESC LIMIT 10
Geht der nicht probier mal den:
SELECT t1.*
FROM vms_gebuchte_werbung t1
LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = 1
LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
LEFT JOIN vms_reloads t2
ON (t1.tan = t2.tan AND (t2.uid = 1 OR t2.ip = "123.124.12.12") AND t2.bis >= 1276472475)
WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" ORDER BY t1.verdienst DESC LIMIT 10