SELECT t1.* FROM vms_gebuchte_werbung t1 LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = 327046 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 = 327046 OR t2.ip = "84.130.111.143") AND t2.bis >= 1228245152) 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 != 327046 ORDER BY t1.verdienst DESC LIMIT 20Unerlaubte Mischung von Sortierreihenfolgen (latin1_german1_ci, IMPLICIT) und (latin1_swedish_ci, IMPLICIT) für Operation 'locate'