SELECT
name,
location,
area,
rest_area,
type,
overview,
build_num,
ground_bearing,
load_weight,
if(is_con ]]>"1","是","否") is_con,
kva_compensate,
transformer,
transformer_capacity,
special_service,
investment_offer,
if(is_property]]>"1","是","否") is_property,
property_fee,
if(is_security]]>"1","是","否") is_security,
if(is_greening]]>"1","是","否") is_greening,
power_manage,
if(is_gc]]>"1","是","否") is_gc ,
if(is_pm]]>"1","是","否") is_pm ,
if(is_onestop_service]]>"1","是","否") is_onestop_service ,
service_content,
if(is_free_rent]]>"1","是","否") is_free_rent ,
if(is_preferential_policy]]>"1","是","否") is_preferential_policy ,
precondition,
manager_offer,
industry_direction,
industry_planning,
planning_company,
over_hundred_million_company,
listed_company
FROM ic_park WHERE del_flag = 0;
SELECT
name,
build_area,
rest_rent_area,
cell_location,
renting_category,
no_renting_categpry,
if(is_busstop]]>"1","是","否") is_busstop,
busstop_distance,
if(is_tram_station]]>"1","是","否") is_tram_station,
tram_station_distance,
if(is_bicycle_point]]>"1","是","否") is_bicycle_point ,
bicycle_point_distance,
if(is_cp]]>"1","是","否") is_cp,
cp_content,
if(is_logistics_center]]>"1","是","否") is_logistics_center,
if(is_hospital]]>"1","是","否") is_hospital,
if(is_start]]>"1","是","否") is_start,
if(is_power]]>"1","是","否") is_power,
if(is_water]]>"1","是","否") is_water,
if(is_drain]]>"1","是","否") is_drain,
if(is_load]]>"1","是","否") is_load,
if(is_newsletter]]>"1","是","否") is_newsletter,
if(is_gas]]>"1","是","否") is_gas,
if(is_heat]]>"1","是","否") is_heat,
if(is_cable_television]]>"1","是","否") is_cable_television,
tid,
sid
FROM ic_park WHERE del_flag = 0;
SELECT
*
FROM
ic_investment_info info
LEFT JOIN ic_investment_floor floor ON info.id = floor.investment_id
AND floor.del_flag = 0
LEFT JOIN ic_investment_intention intention ON info.id = intention.investment_id
AND intention.del_flag = 0
WHERE
info.del_flag = 0
SELECT *,street.name streetName FROM ic_rental_project project
left join ic_rental_project_company company on project.id = company.rental_id
left join s_street street on project.intention_street = street.id
where
project.del_flag = 0
and company.del_flag = 0
;
SELECT *
FROM serviceleague_organ
where
del_flag = 0
SELECT *
FROM serviceleague_serve
where
del_flag = 0
SELECT *
FROM ac_activity_detail
where
del_flag = 0
SELECT *
FROM ac_activity_registration
where
del_flag = 0
SELECT *,
(
SELECT
count(id)
FROM
ac_activity_registration
WHERE
activity_id = detail.id
) reg_num,
(
SELECT
count(id)
FROM
ac_activity_registration
WHERE
activity_id = detail.id
AND sign_state = 0
AND review_state != 3
) sign_num
FROM ac_activity_detail detail
where
del_flag = 0
SELECT *
FROM q_questionnaire qn
left join q_question qq on qn.id = qq.questionnaire_id
where
qn.del_flag = 0
and qq.del_flag = 0
SELECT *
FROM ac_activity_feedback
where
del_flag = 0
SELECT *
FROM project_declaration
where
del_flag = 0
SELECT
*,
c.company_name name,
cc.contact,
cc.phone
FROM project_application d
left join y_company c on d.company_id = c.id and c.del_flag = 0
left join y_company_contact cc on cc.company_id = c.id and cc.del_flag = 0
where
d.del_flag = 0
SELECT DISTINCT
building.NO,
street.NAME street_name,
park.NAME park_name,
building.area,
building.rent_area,
building.remain_area,
IF
( LENGTH( trim( floor.contract_start ) ) 0, NULL, floor.contract_start ) contract_start,
IF
( LENGTH( trim( floor.contract_end ) ) 0, NULL, floor.contract_end ) contract_end,
park.build_area park_area,
( park.build_area - park.rest_rent_area ) park_rent_area,
park.rest_rent_area park_remain_area
FROM
ic_building building
LEFT JOIN ic_park park ON park.id = building.park_id
AND park.del_flag = 0
LEFT JOIN s_street street ON street.id = park.street_id
AND street.del_flag = 0
LEFT JOIN ic_contract_floor floor ON floor.building_id = building.id
AND floor.del_flag = 0
WHERE
building.del_flag = 0
ORDER BY
building.NO
SELECT *
FROM
z_policy
where type = "country"
SELECT *
FROM
z_policy
where type = "province"
SELECT *
FROM
z_policy
where type = "city"
SELECT *
FROM
z_policy
where type = "district"