Unique variants in the STK11 gene

Information The variants shown are described using the NM_000455.4 transcript reference sequence.

Error: Query (Logged)
/variants/STK11/unique?search_var_status=%3D%22Marked%22%7C%3D%22Public%22 returned error in code block Custom_ViewList::viewList().
Query : SELECT SQL_CALC_FOUND_ROWS CONCAT(CAST(MIN(vog.id) AS UNSIGNED), IFNULL(CONCAT(":", CAST(MIN(vot.transcriptid) AS UNSIGNED)), "")) AS row_id, MIN(vot.id) AS votid, vot.transcriptid, vot.position_c_start, vot.position_c_start_intron, vot.position_c_end, vot.position_c_end_intron, CONCAT("c.", TRIM(BOTH "?" FROM TRIM(LEADING "c." FROM REPLACE(REPLACE(`VariantOnTranscript/DNA`, ")", ""), "(", "")))) AS vot_clean_dna_change, GROUP_CONCAT(DISTINCT et.name SEPARATOR ", ") AS vot_effect, GROUP_CONCAT(DISTINCT NULLIF(uo.name, "") SEPARATOR ", ") AS owned_by_, GROUP_CONCAT(DISTINCT CONCAT_WS(";", uo.id, uo.name, uo.email, uo.institute, IF(IFNULL(uo.department, "") = "", "-", uo.department), IF(IFNULL(uo.countryid, "") = "", "-", uo.countryid)) SEPARATOR ";;") AS __owner, GROUP_CONCAT(DISTINCT NULLIF(dsg.id, "") ORDER BY dsg.id ASC SEPARATOR ", ") AS var_statusid, GROUP_CONCAT(DISTINCT NULLIF(dsg.name, "") SEPARATOR ", ") AS var_status, COUNT(`VariantOnTranscript/DNA`) AS vot_reported, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/Exon`, "") SEPARATOR ";;") AS `VariantOnTranscript/Exon`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/DNA`, "") SEPARATOR ";;") AS `VariantOnTranscript/DNA`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/Protein`, "") SEPARATOR ";;") AS `VariantOnTranscript/Protein`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/Gene_Dosage`, "") SEPARATOR ";;") AS `VariantOnTranscript/Gene_Dosage`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/Co_ocurrence`, "") SEPARATOR ";;") AS `VariantOnTranscript/Co_ocurrence`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/RNA`, "") SEPARATOR ";;") AS `VariantOnTranscript/RNA`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnTranscript/Reference`, "") SEPARATOR ";;") AS `VariantOnTranscript/Reference`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnGenome/DNA`, "") SEPARATOR ";;") AS `VariantOnGenome/DNA`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnGenome/Reference`, "") SEPARATOR ";;") AS `VariantOnGenome/Reference`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnGenome/DBID`, "") SEPARATOR ";;") AS `VariantOnGenome/DBID`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnGenome/dbSNP`, "") SEPARATOR ";;") AS `VariantOnGenome/dbSNP`, GROUP_CONCAT(DISTINCT NULLIF(`VariantOnGenome/Remarks`, "") SEPARATOR ";;") AS `VariantOnGenome/Remarks` FROM lovd_variants_on_transcripts AS vot LEFT OUTER JOIN lovd_variant_effect AS et ON (vot.effectid = et.id) LEFT OUTER JOIN lovd_variants AS vog ON (vot.id = vog.id) LEFT OUTER JOIN lovd_alleles AS a ON (vog.allele = a.id) LEFT OUTER JOIN lovd_users AS uo ON (vog.owned_by = uo.id) LEFT OUTER JOIN lovd_data_status AS dsg ON (vog.statusid = dsg.id) WHERE (vog.statusid >= 7) AND (vot.transcriptid LIKE ?) GROUP BY `position_c_start`, `position_c_start_intron`, `position_c_end`, `position_c_end_intron`, vot_clean_dna_change ORDER BY position_c_start ASC, position_c_start_intron ASC, position_c_end ASC, position_c_end_intron ASC, `VariantOnTranscript/DNA` ASC LIMIT 0
Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

  Powered by LOVD v.3.0 Build 29
LOVD software ©2004-2023 Leiden University Medical Center 		There is an LOVD update available.