| | |
|---|
| | | int size |
|---|
| | | ) { |
|---|
| | | StringBuilder sql = new StringBuilder(""" |
|---|
| | | select m.id, m.merchant_name, m.merchant_type, m.contact_name, m.contact_mobile, |
|---|
| | | select m.id, m.merchant_name, m.merchant_type, m.merchant_type_code, m.contact_name, m.contact_mobile, |
|---|
| | | m.logo_url, m.cover_url, m.address, m.is_recommend, m.sort_no, m.status, |
|---|
| | | m.created_at, |
|---|
| | | m.created_at, m.merchant_rights_config, |
|---|
| | | (select s.external_link_type from transport_car_wash_service s |
|---|
| | | where s.merchant_id = m.id and s.deleted = 0 order by s.id desc limit 1) as car_wash_external_link_type, |
|---|
| | | (select count(*) from merchant_product p where p.merchant_id = m.id and p.deleted = 0) as product_count, |
|---|
| | | (select count(*) from benefit_order o where o.merchant_id = m.id and o.deleted = 0) as order_count, |
|---|
| | | 0 as reservation_count |
|---|
