static getRevenueSitesDetail(accountId, params) {
        const order = _order.has(params.order) ? params.order : 'trans';
        const dir = _dir.has(params.dir) ? params.dir : 'desc';
        const order2 = order !== 'raw' && order !== 'unique' ? 'raw' : 'trans';

        let limit = Number(params.limit) || 20;
        let page = Number(params.page) || 1;

        // Ensure limit is sane.
        if (limit > 100) {
            limit = 100;
        } else if (limit < 1) {
            limit = 1;
        }

        // Ensure page is sane.
        if (page < 1) {
            page = 1;
        }

        // Create a UNION ALL of agg_aff_trans and agg_aff_hit as a derived table.
        const derived = AggAffTrans.query()
            .select(
                'landing_page',
                'count',
                'amount',
                AggAffTrans.raw('0 as `raw`'),
                AggAffTrans.raw('0 as `unique`')
            )
            .where({
                affiliate_id: accountId,
                site_id: params.id,
            })
            .andWhere('date', '>=', params.start)
            .andWhere('date', '<', params.end)
            .unionAll(
                AggAffHit.query()
                    .select(
                        'landing_page', 
                        AggAffHit.raw('0'), 
                        AggAffHit.raw('0'), 
                        'raw', 
                        'unique'
                    )
                    .where({
                        affiliate_id: accountId,
                        site_id: params.id,
                    })
                    .andWhere('date', '>=', params.start)
                    .andWhere('date', '<', params.end)
                    .andWhere('landing_page', '!=', 2) // exclude 'Payment Gateway'
            )
            .as('d');

        // Combine the derived table with agg_aff_lookup.
        const query = AggAffLookup.query()
            .alias('l')
            .select('l.value as landing_page', 's.title as site', 's.domain as domain')
            .sum('d.count as trans')
            .sum('d.amount as payout')
            .sum('d.raw as raw')
            .sum('d.unique as unique')
            .join('sites as s', 's.id', AggAffLookup.raw(params.id))
            .join(derived, 'd.landing_page', 'l.id');

        // Add search criteria, if supplied.
        if (params.keywords) {
            query.whereRaw('`l`.`value` LIKE ?', `${params.keywords}%`);
        }

        return query
            .groupBy('l.id')
            .orderBy(order, dir)
            .orderBy(order2, 'desc')
            .page(page - 1, limit)
            .then((data) => {
                for (const d of data.results) {
                    d.payout = Utils.currencyFormat(d.payout);
                    d.trans = d.trans > 999 ? Utils.numberFormat(d.trans) : String(d.trans);
                    d.raw = d.raw > 999 ? Utils.numberFormat(d.raw) : String(d.raw);
                    d.unique = d.unique > 999 ? Utils.numberFormat(d.unique) : String(d.unique);
                }

                return {
                    result_count: data.total,
                    page,
                    page_result_limit: limit,
                    start: params.start,
                    end: params.end,
                    details: data.results,
                };
            });
    }