Closed
Description
Query:
Promotions
.leftJoin(Campaigns, on = Promotions.campaignId eq Campaigns.campaignId)
.select()
.whereWithConditions { ... }
.limit(req.page.offset, req.page.limit)Generated SQL:
select count(*) from (
select *
from p_promotion
left join p_campaign on p_promotion.campaign_id = p_campaign.campaign_id
where ...
) tmp_count