67 lines
9.5 KiB
Plaintext
67 lines
9.5 KiB
Plaintext
|
SELECT COUNT(*) 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(*) 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 id, name, node_type, tags, process_type, node FROM tb_process WHERE parent_id='1250448580720721920' AND deleted='0'
|
||
|
|
SELECT id, name, node_type, tags, process_type, node FROM tb_process WHERE 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='0' OR node_type='1') AND deleted='0' AND parent_id IS NULL ORDER BY id DESC
|
||
|
|
SELECT COUNT(*) FROM tb_flow WHERE deleted='0'
|
||
|
|
SELECT COUNT(*) 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 60000,20000
|
||
|
|
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', '{"process_details": []}', '44645931', 'ipcc 2013 gwp 100a', 'lci,lcia,contribution,sensitivity', '10078')
|
||
|
|
SELECT COUNT(*) AS total FROM tb_product_system 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='11' OR org_id='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') AS combined_records
|
||
|
|
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 > '2020-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(*) 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(*) 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(*) 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(*) 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(*) 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 '2022-01-01' AND '2023-01-01'
|
||
|
|
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'
|