SELECT itrader1.*
FROM itrader AS itrader1
WHERE (FROM_UNIXTIME(dateline) < NOW() - INTERVAL 5 DAY)
    AND itrader1.sc_reminder_sent = 0
    AND itrader1.dealurl != ''
    AND (SELECT rateid
            FROM itrader AS itrader2
            WHERE itrader2.userid = itrader1.rateduserid
            AND itrader2.rateduserid = itrader1.userid
            AND itrader2.dateline > itrader1.dateline
            AND itrader2.dealurl = itrader1.dealurl
            LIMIT 1) IS NULL
    AND (SELECT rateid
            FROM itrader AS itrader3
            WHERE itrader1.userid = itrader3.rateduserid
            AND itrader1.rateduserid = itrader3.userid
            AND itrader1.dateline > itrader3.dateline
            AND itrader1.dealurl = itrader3.dealurl
            LIMIT 1) IS NULL
ORDER BY itrader1.rateid DESC
LIMIT 10