tess

select * FROM "advertises" AS "advertises"
INNER JOIN "agents" AS "agent" ON "advertises"."agent_id" = "agent"."id"
LEFT OUTER JOIN "office_agents" AS "agent->office_agent" ON "agent"."office_id" = "agent->office_agent"."id"
WHERE ("advertises"."listing_type" = 1) AND "advertises"."deletedAt" IS NULL
AND "advertises"."is_publish" = 1 AND "advertises"."is_superhighlight" = false
LIMIT 20 OFFSET 141030;