Untitled
public text v1 · immutableShowing rows 0 - 8 (9 total, Query took 4.6116 sec)
SQL query:
SELECT offers.*
FROM offers
LEFT JOIN completions ON offers.offerid = completions.offerid
AND completions.userid =2
WHERE offers.active =1
AND completions.offerid IS NULL
ORDER BY offers.completions DESC
LIMIT 9
offers = 550 rows
completions = 3500 rows