SELECT * FROM gas_reports WHERE company_id = AND module_key = 'gas_sectors' AND report_year = LIMIT 1 INSERT INTO gas_reports ( company_id, module_key, report_year, created_by, updated_by ) VALUES ( , 'gas_sectors', , , ) SELECT * FROM gas_reports WHERE company_id = AND module_key = 'gas_sectors' AND report_year = LIMIT 1 SELECT is_completed, company_id, report_year FROM gas_reports WHERE id = LIMIT 1 UPDATE gas_reports SET period_type = , total_sale_kwh = , resellers_kwh = , endconsumers_kwh = , grosscustomers_count = , grosscustomers_total_kwh = , updated_by = WHERE id = UPDATE gas_reports SET sector_private_households_kwh = , sector_agriculture_kwh = , sector_industry_kwh = , sector_services_kwh = , sector_district_heating_kwh = , sector_other_kwh = , sector_fuel_kwh = , sector_wkk_kwh = , updated_by = WHERE id = UPDATE gas_reports SET canton_zh_kwh = , canton_be_kwh = , canton_lu_kwh = , canton_ur_kwh = , canton_sz_kwh = , canton_ow_kwh = , canton_nw_kwh = , canton_gl_kwh = , canton_zg_kwh = , canton_fr_kwh = , canton_so_kwh = , canton_bs_kwh = , canton_bl_kwh = , canton_sh_kwh = , canton_ar_kwh = , canton_ai_kwh = , canton_sg_kwh = , canton_gr_kwh = , canton_ag_kwh = , canton_tg_kwh = , canton_ti_kwh = , canton_vd_kwh = , canton_vs_kwh = , canton_ne_kwh = , canton_ge_kwh = , canton_ju_kwh = , canton_abroad_kwh = , updated_by = WHERE id = UPDATE gas_reports SET biogas_import_total_kwh = , biogas_import_lbg_kwh = , biogas_import_network_kwh = , biogas_import_certificate_kwh = , deviation_comment = , is_completed = , completed_at = NOW()NULL, status = 'submitted''draft', updated_by = WHERE id = SELECT company_id, report_year FROM gas_reports WHERE id = LIMIT 1 UPDATE gas_reports SET period_type = , endconsumers_kwh = , updated_by = WHERE id =