67 lines
9.6 KiB
Plaintext
67 lines
9.6 KiB
Plaintext
|
select count( * ) as total from tb_process where (deleted = '0')
|
||
|
|
select tags from tb_process where product_system_id = '1298311160348545024' and deleted = 0
|
||
|
|
select id,ref_id,name,synonyms,category_id,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (process_type = 'unit_process' and process_source = '0')
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where id='1300755365750636544'
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (id = '9237375')
|
||
|
|
select count( * ) as total from tb_process where (name = '铸铁' and product_system_id = '1300754248748761088' and id <> '1300755365750636544' and deleted = '0')
|
||
|
|
select * from tb_process where ref_id = '49e7b885-8db7-3d63-8fce-5e32b8a71391' and process_type = 'unit_process' limit 1
|
||
|
|
select location_id from tb_process where (id = '3448019508185273680')
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (product_system_id = '1276473778162892800' and deleted = '0')
|
||
|
|
select count( * ) as total from tb_process where (parent_id = '1250448580720721920' and deleted = '0')
|
||
|
|
select p.id, p.name, p.node_type, p.tags, p.process_type, p.node from tb_process p where p.parent_id = '1250448580720721920' and deleted = '0'
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where id in ( '1176899308570542080' , '1176898365472899072' )
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (synonyms like '%欧元%')
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (synonyms like '%欧元%' and process_source = '0')
|
||
|
|
select id,ref_id,name,synonyms,category_id,description,process_type,default_allocation_method,infrastructure_process,quantitative_reference_id,dq_entry,dq_system_id,exchange_dq_system_id,social_dq_system_id,location_id,process_doc_id,currency_id,version,last_change,tags,library,product_system_id,process_source,reference_process_id,node,parent_id,node_type,deleted,create_time,update_time,create_user,extend,share from tb_process where (product_system_id = '1298206895525330944' and node_type in ('0','1') and deleted = '0' and parent_id is null) order by id desc
|
||
|
|
select count( * ) as total from tb_flow where deleted=0 and (deleted = '0')
|
||
|
|
select count( * ) as total from tb_flow where deleted=0
|
||
|
|
select id,ref_id,name,flow_type,cas_number,description,tags,library,synonyms,infrastructure_flow,formula,category_id,reference_flow_property_id,source,version,last_change,create_time,create_user,update_user,deleted,update_time,location_id,name_cn,synonyms_cn,is_system,extend from tb_flow where deleted=0 limit '20000'
|
||
|
|
select id,ref_id,name,flow_type,cas_number,description,tags,library,synonyms,infrastructure_flow,formula,category_id,reference_flow_property_id,source,version,last_change,create_time,create_user,update_user,deleted,update_time,location_id,name_cn,synonyms_cn,is_system,extend from tb_flow where deleted=0 limit '20000' offset '60000'
|
||
|
|
select count(*) as total from tb_calculation_task where (product_system_id = '1298311160348545024')
|
||
|
|
insert into tb_calculation_task ( id, status, product_system_id, final_demand, method_id, method_name, calculate_type, create_user ) values ( '1301153780011634688', '0', '1276473778162892800', '[{"processid":"1276522182217826304","processname":"【未知名称过程】","exchangeid":"1295414319390916608","flowid":"1295413954654240768","flowname":null,"flowpropertyid":"1972","flowpropertyname":null,"unitid":"1851","unitname":null,"amount":1.0}]', '44645931', 'ipcc 2013 gwp 100a', 'lci,lcia,contribution,sensitivity', '10078' )
|
||
|
|
select count(*) as total from tb_product_system p where create_user = '10043' and deleted = 0
|
||
|
|
select count( * ) as total from tb_product_system where (deleted = '0')
|
||
|
|
select id,ref_id,name,description,location_id,category_id,cutoff,reference_process_id,reference_exchange_id,target_amount,target_flow_property_factor_id,target_unit_id,model_info,project_type,create_user,create_time,update_time,deleted from tb_product_system where id='1298311160348545024'
|
||
|
|
select count( * ) as total from sys_user where deleted=0
|
||
|
|
select id from sys_user where org_id in ( '11' , '12' )
|
||
|
|
select id,product_system_id,form_id,data,extend from tb_form_data where (product_system_id = '1247208720564224000' and form_id = '4')
|
||
|
|
select id from tb_form_data where (form_id = '14' and product_system_id = '1299311046711840768')
|
||
|
|
select id, name, method_id, direction, reference_unit from tb_impact_category where method_id = '43262324' order by id
|
||
|
|
select sum(amount) as total from tb_lcia where task_id = '1298311273208877056' and impact_category_id = '43262501'
|
||
|
|
select count(*) from (select * from tb_parameter where create_user = '10028' and scope = 'global' union all select * from tb_parameter where process_id = '3448019511314224627' and create_user = '10028') total
|
||
|
|
select id,type,name,sort,template,script,script_url,extend from tb_product_system_form where id='14'
|
||
|
|
select id,name,sort,extend from tb_product_system_form where (type = 'cbam') order by sort asc
|
||
|
|
SELECT * FROM tb_process_doc WHERE valid_from > '2022-01-01';
|
||
|
|
SELECT * FROM tb_process_doc WHERE reviewer_id = 1212;
|
||
|
|
SELECT COUNT(*) FROM tb_process_doc WHERE project = 'asdfasdf';
|
||
|
|
SELECT * FROM tb_process_doc WHERE valid_from > '2019-01-01' AND valid_until < '2022-12-31';
|
||
|
|
SELECT * FROM tb_process_doc WHERE geography = '17 European plants';
|
||
|
|
SELECT * FROM tb_process_doc WHERE technology LIKE 'Acid-catalysed esterification of free-fatty acids.';
|
||
|
|
SELECT reviewer_id, COUNT(*) AS record_count FROM tb_process_doc GROUP BY reviewer_id;
|
||
|
|
SELECT * FROM tb_process_doc WHERE copyright = 1;
|
||
|
|
SELECT * FROM tb_process_doc WHERE data_generator_id = 1319;
|
||
|
|
SELECT dataset_owner_id, COUNT(*) AS record_count FROM tb_process_doc GROUP BY dataset_owner_id;
|
||
|
|
SELECT * FROM tb_process_doc WHERE data_documentor_id = 1217;
|
||
|
|
SELECT * FROM tb_process_doc WHERE publication_id = 1500;
|
||
|
|
SELECT * FROM tb_process_doc WHERE preceding_dataset = '6006a8fc-1a6c-55ee-a49d-fc9342f5d451';
|
||
|
|
SELECT * FROM tb_process_doc WHERE data_treatment LIKE '%Approximation%';
|
||
|
|
SELECT * FROM tb_process_doc WHERE data_collection_period LIKE '%2020-2021%';
|
||
|
|
SELECT * FROM tb_process WHERE deleted = 1;
|
||
|
|
SELECT * FROM tb_process WHERE update_time > '2024-10-15';
|
||
|
|
SELECT COUNT(*) FROM tb_process WHERE create_user = 10000;
|
||
|
|
SELECT * FROM tb_process WHERE category_id = 66;
|
||
|
|
SELECT location_id, COUNT(*) AS record_count FROM tb_process GROUP BY location_id;
|
||
|
|
SELECT * FROM tb_process WHERE dq_system_id = 129124;
|
||
|
|
SELECT * FROM tb_process WHERE tags LIKE '%10煤电%';
|
||
|
|
SELECT * FROM tb_process WHERE default_allocation_method = 'economic allocation';
|
||
|
|
SELECT process_type, COUNT(*) AS record_count FROM tb_process GROUP BY process_type;
|
||
|
|
SELECT * FROM tb_process WHERE name LIKE '%AAAAsadfasd%';
|
||
|
|
SELECT * FROM tb_process WHERE node_type = 2;
|
||
|
|
SELECT version, COUNT(*) AS record_count FROM tb_process GROUP BY version;
|
||
|
|
SELECT * FROM tb_process WHERE process_doc_id = 594641;
|
||
|
|
SELECT * FROM tb_process WHERE default_allocation_method = 'CAUSAL';
|
||
|
|
SELECT * FROM tb_process WHERE create_time BETWEEN '2023-06-01' AND '2023-06-15';
|
||
|
|
SELECT * FROM tb_process WHERE process_source = 1;
|
||
|
|
SELECT * FROM tb_process WHERE ref_id = 'd4730e0a-9bae-3fde-93e1-cac96735aa76';
|
||
|
|
SELECT * FROM tb_process WHERE infrastructure_process = 0;
|